The BigCommerce - NetSuite integration app keeps BigCommerce stock levels current from NetSuite with two scheduled flows: one for inventory items and one for kit items. This article explains what each flow exports, how quantities are calculated across locations, the settings that control them, and the flow that syncs BigCommerce product IDs to NetSuite items. It's for integrator.io users who manage inventory in NetSuite and sell in BigCommerce.
Sync inventory items
The NetSuite Inventory to BigCommerce Inventory Add/Update flow exports each item's Quantity Available from NetSuite to the matching item in BigCommerce, and links the BigCommerce product ID to the NetSuite item. It runs on a schedule.
- The flow exports only Quantity Available. It doesn't export the item record. To export items, see Sync items from NetSuite to BigCommerce.
- In the Starter edition, which doesn't include the item flow, you create and configure items manually in both NetSuite and BigCommerce.
- If you use NetSuite multi-location inventory, the flow adds up Quantity Available across all configured inventory locations and sends the total to BigCommerce. You can't sync a separate quantity per location.
- When the flow is in delta mode and Always sync inventory levels for entire catalog is turned off, you can choose a start date when you run it. For details, see Choose a start date for a delta flow.
These settings are under Settings > Inventory:
- NetSuite Saved Search for syncing inventory levels: The saved search that the inventory flow uses. To load the latest saved searches, refresh the list.
- NetSuite locations to pick inventory from: The NetSuite inventory locations to read quantities from and export to BigCommerce.
- Always sync inventory levels for entire catalog: When it's on, each run of the inventory flow syncs inventory levels for all NetSuite items linked to your BigCommerce store.
To run the flow, go to Flows > Inventory in the integration app, and select Run for the flow. The Dashboard shows the status of the run, and the stock level in BigCommerce is updated when the run completes.
Sync kit items
The NetSuite Kit Inventory to BigCommerce Inventory Add/Update flow exports the available quantity of NetSuite kit items to BigCommerce. When a kit item is created or updated in NetSuite, the integration app exports it as a product in BigCommerce.
A kit is sold as one unit but is made up of several member items from your inventory. NetSuite doesn't track inventory on the kit itself, only on its member items, so the kit record doesn't show an available quantity. The integration app calculates it from the member items. For example, if a dining set kit contains 4 plates, 4 bowls, and 2 mugs, and you have 10 plates, 12 bowls, and 8 mugs, the kit quantity sent to BigCommerce is 2.
To create a kit item in NetSuite, go to Lists > Accounting > Items > New, and select Kit/Package.
The kit flow has these settings, also under Settings > Inventory:
- NetSuite saved search for syncing inventory for Kit Items: The saved search that selects the kit items to export. To load the latest saved searches, refresh the list.
- Calculate Kit Inventory per Location: When it's on, the integration app calculates the sellable kit quantity at each location from the member items' quantities there, and sends the sum across locations. When it's off, the integration app first adds up each member item's quantity across all locations, and then calculates the kit quantity from those totals.
To run the flow, go to Flows > Inventory, and select Run for NetSuite Kit Inventory to BigCommerce Inventory Add/Update.
Sync BigCommerce product IDs to NetSuite items
The BigCommerce Product Id to NetSuite Item Mass Update flow, in Flows > Inventory, updates NetSuite items with the BigCommerce product IDs of the matching products. It syncs a high volume of products and their variants at the same time.