Category Association
This may be used as an Import or an Export.
The file looks like this:
Export
Use the filters to narrow your selection, then click 'Export'. This will generate a file that will include all Customisations for products that match your filters.
Import
Make changes to the file and import it to update Products; this will update Category associations.
When exported, the file will include every Category association belonging to a Product; this may mean a single SKU code could be repeated over multiple rows. The file is split into multiple columns, with each part of the Category hierarchy having its own column.
On import, if the specific Category does not exist (text match), one will be created.
Then, if an association does not exist between the specificed SKU and Category, one will be created.
It is possible to create Categories in bulk using this import; be wary of typos, e.g. 'Sofa' and 'Sofas'
| Field | Purpose |
|
Code |
A SKU Code of the Product
There is no need to link every Variant of a Product; just one will do |
| Category1 |
The top level Category of this heirarchy |
| Category2 |
The second level Category of this heirarchy
Optional - if left blank, the product will only be added at the previous Category level |
| Category3 |
The third level Category of this heirarchy
Optional - if left blank, the product will only be added at the previous Category level |
| Category4 |
The fourth level Category of this heirarchy
Optional - if left blank, the product will only be added at the previous Category level |
Mapping
You will need to map your data before it can be imported. Included below is the optimal mapping/spreadsheet structure.
Mistakes made here may have serious impact on your Product database.
If you check the box 'remove existing Categories', this will wipe all pre-existing associations from Products in your upload file.
Removing existing associations is dangerous, and may have a serious impact on your Product Database
