When using the CSV import tools to import product into your cart system, there are special rules to follow for the product Category Assignments.
The column header is called category_path.
The values are text only, with no HTML.
When specifying that a product should be assigned to multiple categories, the category path must be separated by a pipe symbol (|).
E.g.: Furniture|Chairs|Teak
Note: The pipe symbol is created by using the Shift & Back slash key on your keyboard.
When specifying that a product should be assigned to a child category, the category path must be separated by a forward slash (/).
E.g.: Clothing/Boys
Note: In this sample, Clothing is a parent category, and Boys is a child category of Clothing. (Toddlers and Girls are also children of Clothing.)
When specifying that a product should be assigned to a child category and multiple categories, the category path must be separated by a forward slash (/) and the pipe symbol.
E.g.: Furniture|Furniture/Chairs|Clothing/Boys
In this example the product would be assigned to these three categories
Furniture
Chairs
Boys (a child of the parent category “Clothing”)
For the above reasons, do not include either a forward slash or a pipe symbol in your category names. The system will interpret these as location assignments.
When you use an apostrophe (‘) in a category name (E.g. Children’s Books), you will need to code this with a leading back slash (\).
E.g.: Children\’s Books