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 Import / Export page on Zentail.
  2. Select the BigCommerce channel dropdown.
  3. Select the Category Mappings report.
  4. Start Generating 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.
: This is a view- and export- only column! 

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 Quick Edit 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/Export feature. It's that simple, and should cut out room for potential mistakes!

Alternate Option - Custom CSV Template

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 / Export page to import your csv. 

Related Readings:

How do I sell on Google Shopping and how does it work?

Did this answer your question?