This article explains what transformations are, how they work, and when to use them.
Overview
Transformations allow modifying the item list based on item data such as ref codes and attribute values. They can add or remove items from the item list before pricing is calculated.
Transformations are part of the task configuration workflow. Tasks run from top to bottom, with pricing always being the last step.
Example task order:
- Transformation
- Packaging
- Pricing
When to use transformations
Transformations are useful when:
- Items need to appear on the item list but are visually controlled through features and options
- Accessories are triggered by a feature but need to be added as separate commercial items
- Cabinet parts (side panels, back panels, doors, shelves) need to be listed individually
- Avoiding data duplication when using Core Library for visuals but needing commercial items in the catalog
- Items have SKU's that don't follow a logical pattern within features and options
How transformations work
Transformations evaluate items on the item list and, based on conditions (ref codes and attribute values), add or remove items.
Important: Items defined in transformations must exist in the catalog. Core Library items cannot be added to the item list directly – they provide only visuals. Commercial items must be created in the catalog and linked through transformations.
Transformation file structure
The transformation file can be exported by clicking three dots next to the catalog name and selecting Export Transformation option.
The transformation file is exported as a CSV with the following columns:
| Column | Description |
| Item ref code | The ref code of the item to match |
| Item attribute ref code | The attribute to check |
| Item attribute value | The value to match |
| Added item ref code | The item to add |
| Added item quantity | Number of items to add |
| Remove item | true or false |
| Added item attributes | Attributes to pass to the added item |
The example of exported CSV file is attached to this article below.
Example: Adding cabinet parts
A cabinet needs to list its individual parts (side panels, back panel, door, drawer box, shelves) on the item list.
Transformation rule:
| Item ref code | Added item | Quantity | Attributes |
| B15R_2 | side_panel | 2 | height, depth |
| B15R_2 | back_panel | 1 | height, width |
| B15R_2 | door | 1 | width, height |
| B15R_2 | drawer_box | 1 | width, depth |
| B15R_2 | shelf | 2 | width, depth |