Importing Product Categories

In addition to creating categories in the control panel, they can also be created with the use of a CSV file when importing products. Below are some guidelines on creating and assigning categories.

 

Creating or updating categories via the API? For information on creating and editing category information via the API, see our API documentation.

Creating Categories

A category is created when it is listed in the Category column when importing a product. If it is listed by itself, it will be created as a top-level category.

CSV showing an example category

File imports are case-sensitive — if you list a category with different capitalization, it will create two different categories (e.g. "Cats" and "cats").

CSV showing categories are case sensitive

If your product category contains a / character, use \/ instead to avoid creating subcategories. For example, if you want to create a category labeled Sweaters/Hoodies, it should be formatted as Sweaters\/Hoodies.

CSV showing how a category should be formatted if it contains a /

 

Need an example? You may find it useful to reference a sample template. Click the following link to save the file to your computer.

Multiple Categories

If your product belongs to multiple categories, they should be separated with a semi-colon (;) without a space.

  • Example: Womens;Sale

CSV showing the format for multiple categories

Subcategories

If your product belongs to a subcategory, list both the parent category and the subcategory, separated by a forward slash (/).

  • Example: Accessories/Watches
  • Example: Accessories/Watches; Accessories/Jewelry (for a product in two subcategories of the same parent)
  • Example: Accessories/Watches; Accessories/Jewelry; Sale/Accessories (for a product in two subcategories of different parents)

Listing the subcategory by itself will create an additional top-level category by that name.

CSV showing format for subcategories

Additional Resources

Was this article helpful?