Categories can also be assigned via ad-hoc imports and feeds. This cane be done by mapping the 'Categorisation' attribute in the import mapping dialog and choosing the relevant options.
Separate rows or single cells
Categories can be stored in the import file in one of two ways:
- 'Each value is stored in a separate row' indicates that each category to be applied to the product is stored in a separate row, with the product ID present on each row in the spreadsheet
- 'All values are stored in a single cell, joined with a separator' indicates that all categories to be assigned to a product are stored in the same spreadsheet cell with a separator between each category. The separator used to indicate different categories must be different to the separator used to indicate the category path. E.g. Shoes-Boots-Ladies,Sale-Ladies-Boots or Shoes_Boots_Ladies/Sale_Ladies_Boots
Leaf label is the category node label. When specifying this on the mapping options, the import file should contain only the leaf labels of the categories to be assigned.
Full label path
Full label path is the entire category tree path (labels, not codes) to the category leaf you want to assign. The separator can be any normal separator such as a comma, forwards or backwards slash, pipe or hyphen.
Node code is the category node code. When specifying this on the mapping options, the import file should contain only the leaf codes of the categories to be assigned.
Full node paths
Full node path is the entire category tree path (codes, not labels) to the category leaf you want to assign. The separator can be any normal separator such as a comma, forwards or backwards slash, pipe or hyphen.
Specifying category trees
If the file contains categories from multiple trees, but only categories from one particular tree should be applied, this can be specified in the final mapping option. A specific tree or 'any class_tree' can be selected.