How to assign categories to products in import file
1. Assigning one category
If you would like to assign a category to the product then a full path to the product category should be defined in the 'Category' cell.
For example we have the following category structure:
Root category 1
Sub-category 1
Sub-category 2
Sub-sub-category 3
and if we would like to assign a product to the sub-category 2 we have to describe a full path to this category like this:
...,"Root category 1///Sub-category 2",...
A sub-category separator is '///' by default but it can be changed on the first import step.
2. Assigning multiple categories
In some cases you may want to assign multiple categories to a product. It can be done by enumerating all category paths in the 'Category' cell. But these category paths should be separated with a multi-category values separator defined on the extension settings page. It is ':::' by default.
For example we would like to assign a product to "Root category 1" and "Sub-sub-category 3". Therefore we have to describe it in the file like this:
...,"Root category 1:::Root category 1///Sub-category 2///Sub-sub-category 3",...
Notes
1. The 'CSV Product Import' extension can create new categories from the category path but it does not support import of all category fields. If you need to import many categories we recommend you to consider the "CSV Category Import" extension.
2. You should not import categories for multiple languages because new categories will be created. If you would like to specify category titles in secondary languages then it should be done manually or by importing categories with the "CSV Category Import" extension.
If you would like to assign a category to the product then a full path to the product category should be defined in the 'Category' cell.
For example we have the following category structure:
Root category 1
Sub-category 1
Sub-category 2
Sub-sub-category 3
and if we would like to assign a product to the sub-category 2 we have to describe a full path to this category like this:
...,"Root category 1///Sub-category 2",...
A sub-category separator is '///' by default but it can be changed on the first import step.
2. Assigning multiple categories
In some cases you may want to assign multiple categories to a product. It can be done by enumerating all category paths in the 'Category' cell. But these category paths should be separated with a multi-category values separator defined on the extension settings page. It is ':::' by default.
For example we would like to assign a product to "Root category 1" and "Sub-sub-category 3". Therefore we have to describe it in the file like this:
...,"Root category 1:::Root category 1///Sub-category 2///Sub-sub-category 3",...
Notes
1. The 'CSV Product Import' extension can create new categories from the category path but it does not support import of all category fields. If you need to import many categories we recommend you to consider the "CSV Category Import" extension.
2. You should not import categories for multiple languages because new categories will be created. If you would like to specify category titles in secondary languages then it should be done manually or by importing categories with the "CSV Category Import" extension.