You must create your categories before you can assign products using a spreadsheet
- Products > Categories > Manage Products - Navigate to Products > Categories, select a category and click "Manage Products" then you can use the blue link to Add/Remove/Manage products in that category.
- Products > Products List > Bulk Actions - From your Product List, you can search/filter/multi-select products then use Bulk Actions > Assign to Category
- Products > Products List > View Product > Categories - on the Product Edit screen there is a "Categories" section. You can use this to assign the product to different categories.
The import CSV to put products into categories has just two columns: sku and _category.
Under the _category header, enter the main category and any sub-categories within, separated by a / slash. See the examples below:
|glass-votive||Shop/Candles and Scents/Votives|
|silver-frame||Shop/Frames and Wall Art|
If you want to assign products to more than one category, you must use the Category IDs, not Category Names/Paths.
To assign products to a category you need to know your category IDs.
Use our Category Export tool located in Products > Categories> Bulk Actions to export a CSV of all of your categories and their IDs
The import CSV to put products into categories requires just two columns: sku and category_ids. List all category ids to which you want to assign a product (SKU), comma separated without spaces.
This operation will replace your data, not append to it.
When running this operation any existing product category assignment will be overwritten. You must list out all the categories that the product will belong to in the CSV file you are uploading. Failure to do so will make it so your products are only assigned to the categories in the latest CSV file you are uploading.
Use the Import tool located in Products > Product List to upload your CSV.
- Only assign Visible products to categories.
- Avoid assigning disabled products to categories.
- Only assign products to the "Lowest" level of a category hierarchy. You do not need to assign it to each step. (Example, Mens > Apparel > Shirts > T-Shirts - only assign the product to the "T-Shirts" category as the parent categories will inherit products from the child categories.
Updated over 1 year ago