All Collections
Getting Started with BigCommerce
How to categorize SKUs into your Big Commerce Categories on Zentail
How to categorize SKUs into your Big Commerce Categories on Zentail

How to download your BigCommerce category mappings and then upload those categories into Zentail for multiple BigCommerce categories

Michael Goldmeier avatar
Written by Michael Goldmeier
Updated over a week ago

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

  1. Select the SKU you would like to categorize.

  2. Click EDIT, navigate to CATEGORY & DESCRIPTION.

  3. Use the browse icon or search icon to add BigCommerce categories via keyword, or you can just enter in the BigCommerce category ID. 

  4. Click the + icon.

  5. 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:

  1. Go to the Export page on Zentail and drop down the Onboarding section

  2. Select the BigCommerce channel dropdown.

  3. Select the Category Mappings report.

  4. 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.

Did this answer your question?