The BigCommerce Product Categories to NetSuite Add/Update flow in the Product section allows you to import categories along with its hierarchy from BigCommerce to NetSuite.  When you run this flow, the Integration App picks all the categories and their hierarchy listed in the Product Categories section from your BigCommerce account.

This information from BigCommerce is then transferred to NetSuite in the Celigo BigCommerce Product Category List custom record as demonstrated in the following image:

You can also use the following setting in Advanced Setting to configure how the categories and its hierarchy information is displayed in NetSuite:

Add BigCommerce Categories in NetSuite as
Let’s select the way categories information is displayed in the NetSuite custom record. For example, the following information demonstrates how the Men’s -> Shoes -> Sports Shoes category information is displayed in NetSuite when you select:

• Level 1: Level 2: Level n - Men’s: Shoes: Sport Shoes
• Level n: Level 2: Level 1 - Sport Shoes: Shoes: Men’s
• Level n (Level1: Level n-1) - Sport Shoes (Men’s: Shoes)

Note: Once you change and save the drop-down value and run the flow again, the display of categories information in NetSuite is accordingly updated as per your selection.

Item export with categories

In addition to importing categories from BigCommerce to NetSuite, you can also use this feature to assign categories with its hierarchy to the items being imported into BigCommerce from NetSuite when you run the NetSuite Item to BigCommerce Product Add/Update flow in the Product section.  

The BigCommerce Categories field under the eTail tab for an item record store the category-specific information. The following screen demonstrates the same:

Multiple BigCommerce Stores | Leading Practice

For existing customers, who are using multiple stores in BigCommerce, you are requested to perform the below procedure only once.

1. In NetSuite, in the global search bar, search for Celigo BigCommerce Item Export Search saved search and click Edit.

2. In NetSuite, under Criteria > Standard, add BigCommerce Item Category:BigCommerce Store id as the new filter. For example, you may want to set the filter as BigCommerce Item Category:BigCommerce Store id is 3457834.

Leading Practice

If you deal with multiple BigCommerce stores and have categories with the same name in two or more stores, it is recommended that you prefix the store's name before each category.

To prefix the store name to a category name:

1. Go to Settings > Integration Flows > Product > BigComemrce Product Categories to NetSuite Add/Update.
2. Click the Field Mappings icon.
3. In the mapping screen, click the Gear icon of the Name field.
4. Under Settings, select Multi-Field. The {{name}} handlebar will appear in the Expression text area.
5. Prefix the store name. For example, StoreName - {{name}}.