Articles in this section

Sync product categories from BigCommerce to NetSuite

Dev Chidipi
Updated

The BigCommerce Product Categories to NetSuite Add/Update flow imports your BigCommerce product categories, with their hierarchy, into NetSuite. You then assign those categories to NetSuite items, and the item flow sends them to BigCommerce with each product. Sync categories before you sync items. This article is for integrator.io users who manage the BigCommerce catalog from NetSuite.

Import categories into NetSuite

  1. In the integration app, go to Flows > Product.
  2. Select Run for BigCommerce Product Categories to NetSuite Add/Update.

The flow imports every category and its hierarchy from Product Categories in your BigCommerce store into the Celigo BigCommerce Product Category List custom record in NetSuite.

Choose how categories appear in NetSuite

The Add BigCommerce Categories in NetSuite as setting, in Settings > Product > Product, controls how each category's hierarchy is written in NetSuite. For example, for the category path Mens > Shoes > Sport Shoes:

Value Category in NetSuite
Level 1: Level 2: Level n Mens: Shoes: Sport Shoes
Level n: Level 2: Level 1 Sport Shoes: Shoes: Mens
Level n (Level1: Level n-1) Sport Shoes (Mens: Shoes)

After you change the value, save it and run the flow again to update the categories in NetSuite.

Assign categories to items

To send categories to BigCommerce with an item, select them in BIGCOMMERCE ITEM CATEGORY on the item record, under eTail > BigCommerce in NetSuite. When the NetSuite Item to BigCommerce Product Add/Update flow runs:

  • If the NetSuite item has categories, they replace the item's categories in BigCommerce.
  • If the NetSuite item has no categories, the item's existing categories in BigCommerce are kept.

Use categories with several BigCommerce stores

If you connect several BigCommerce stores, filter the item export by store so each store gets its own categories. Do this once.

  1. Run the BigCommerce Product Categories to NetSuite Add/Update flow at least once for each store.
  2. In NetSuite, find the Celigo BigCommerce Item Export Search saved search with the global search, and select Edit.
  3. Under Criteria > Standard, add the filter BigCommerce Item Category: BigCommerce Store id, set to the store's ID, for example is 3457834.

The BigCommerce Store and BigCommerce Store id fields on the Celigo BigCommerce Item Categories record identify the store each category belongs to.

If two or more stores have categories with the same name, add the store name in front of each category name:

  1. In the integration app, go to Flows > Product, and select Mapping for BigCommerce Product Categories to NetSuite Add/Update.
  2. Select Settings for the Name mapping.
  3. For Field mapping type, select Multi-Field. The Expression shows {{name}}.
  4. Add the store name in front of it, for example StoreName - {{name}}, and then save.