Ergonode PIM¶
Ergonode is the Product Information Management (PIM) system used by Zwerfkei to master all product catalogue data. It is used as a SaaS solution and serves as the single source of truth for products, variants, categories, attributes and images.
Architecture Decision
The decision to adopt Ergonode as the PIM platform is documented in ADR-0008 — PIM: Ergonode.
What Is Managed in Ergonode¶
| Data Type | Description |
|---|---|
| Categories | Hierarchical product categorisation tree. |
| Attribute Groups | Logical groupings of product attributes (e.g. "Dimensions", "Material"). |
| Attribute Types | Typed product properties: text, number, select, multi-select, boolean, image, etc. |
| Attribute Options | Selectable values for select and multi-select attributes. |
| Products | Product records with SKU, title, descriptions and attribute values. |
| Product Variants | Variant-level data (SKU, attribute values specific to the variant). |
| Product Images | Original product and variant images. |
Integration with Zwerfkei Backend¶
Ergonode PIM ──(API)──► Zwerfkei Backend (sync job) ──► MySQL Database
A scheduled sync job in the Zwerfkei Backend polls the Ergonode API for updated products, categories and attributes. Changed records are upserted into the Zwerfkei database.
Image handling
Only original images are stored in Ergonode. Image variants (thumbnails, resized versions) are generated by the CMS. Do not reference Ergonode image URLs directly in the frontend.
Data ownership
Ergonode is the master for all catalogue data. Changes to product data must always be made in Ergonode, not directly in the Zwerfkei database.
Setup & Entity Relationship Diagram¶
The Ergonode product domain ERD and setup documentation lives in the zwerfkei-backend repository:
Source Data: NextWebShop¶
The NextWebShop OneDrive directory (maintained by Olaf) contains product data files, import sheets and related assets used during the migration to the new platform.
Attribute Mapping (Deprecated)¶
Deprecated
This section is deprecated and kept for reference only. It may be removed in the future. See Attribute Mapping below for the current source.
The mapping-pim-attributes spreadsheet maps the Zwerfkei product attributes to Ergonode PIM attribute definitions. It is the reference for which attributes exist, their types, and how they correspond between the legacy platform and the new PIM setup.
Open mapping-pim-attributes (Excel)
Attribute Mapping¶
The current attribute and category mapping files are maintained in the zwerfkei Bitbucket repository, under pim_export/ on the feature/pim-export-articles branch:
| File | Description |
|---|---|
mapping-pim-attributes_new.csv |
Maps Zwerfkei product attributes to Ergonode PIM attribute definitions. |
mapping-extend-template-sections.csv |
Maps attribute (extend template) sections used in the PIM export. |
productcategorieen.csv |
Maps product categories between the legacy platform and Ergonode. |
Open mapping-pim-attributes_new.csv Open mapping-extend-template-sections.csv Open productcategorieen.csv