When selling on your own BigCommerce webstore, you likely have a set of custom categories for your products. To push SKUs from Zentail to BigCommerce, you need to assign those categories within Zentail. This article shows you how you can assign your SKUs to your custom BigCommerce categories through the Zentail user interface or by using the import / export feature.
You can assign your SKUs to more than one BigCommerce category.
Using the Zentail User Interface
Select the SKU you would like to categorize.
Click EDIT, navigate to CATEGORY & DESCRIPTION.
Use the browse icon or search icon to add BigCommerce categories via keyword, or you can just enter in the BigCommerce category ID.
Click the + icon.
You can add as many categories as you need.
Obtaining your BigCommerce Category Mappings
To manage BigCommerce categories in both Quick Edit and through Zentail's Import/Export feature, you should download a mapping of the numeric category_id values that correspond to your BigCommerce Categories:
Go to the Export page on Zentail and drop down the Onboarding section
Select the BigCommerce channel dropdown.
Select the Category Mappings report.
Click download to start generating the report.
In Quick Edit
To add BigCommerce categories in Quick Edit, use the column <Your Store Name> (BigCommerce) Add Category. Then, you can enter in the numeric category_ids values from your BigCommerce Category Mapping Report to add the SKU to that category.
Conversely, to remove BigCommerce categories in Quick Edit, use the column <Your Store Name> (BigCommerce) Remove Category. Enter the numeric category_id value from your BigCommerce Category Mapping Report to remove that SKU from that category.
To see all the numeric IDs of the categories your SKU is in, use the column <Your Store Name> (BigCommerce) Category Ids.
Through an Import
Preferred Option - Via QuickEdit
To ensure that the correct headers are used for a correct data import, it is helpful to first build out your report in QuickEdit by adding the appropriate or desired headers. From here, download the report, fill in the desired data with the appropriate numeric category id value, and re-upload via the Import page. It's that simple, and should cut out room for potential mistakes!
Alternate Option - Custom CSV Template
Adding/Removing Individual Categories
To add and remove categories through an import, (the same columns that are used in Quick Edit!) use <Your Store Name> (BigCommerce) Add Category and <Your Store Name> (BigCommerce) Remove Category. You can always check the exact column wording in our data dictionary if you are unsure of the specific column headers.
Create a csv with those columns and then use the numeric category id values in the Add Category column to add the SKU to that category, or the Remove Category column to remove the SKU from that category.
Then go to the Import page to import your csv.
Using Category Ids
This is appropriate for when you want to set all categories for a SKU at the same time. You may want to overwrite or disregard any other categories that were already on the SKU. Use <Your Store Name> (BigCommerce) Category Ids to set your category IDs via import.