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