After you have created Categories in your Quick Shopping Cart®, you can use this Microsoft Excel® spreadsheet to make bulk changes and assign products to one or more category or subcategory.
You can use this spreadsheet to select and modify categories for products. Action and Category are the only fields that can be edited. To assign a product to multiple categories, simply add that product on a new line and select a different Product Category.
NOTE: To add, delete or modify products you must use the Products spreadsheet.
Action — Options are Keep, Add, or Remove.
Part Number — The product's part number. This number must be unique from all products.
Title — The product's title in the catalog. The Title cannot be updated in this spreadsheet.
Category — The Category with which the product is associated. The listed categories are the ones you set up in your catalog.
After you have made edits, you need to import the spreadsheet to update your store.
You must publish your Website for the storefront to reflect your changes.