The “NetSuite Kit Inventory to BigCommerce Inventory Add/Update” data flow exports Kit inventory (quantity) from NetSuite to BigCommerce. Whenever a Kit inventory item is created or updated in NetSuite, the Integration App exports the details of that item as a product on BigCommerce. The Integration App also provides options to set up the Integration App before running the pre-built data flow.
Understanding kit inventory
Kit inventory lets you create an item for sale that contains a collection of other items that can or cannot be sold individually. Whenever you sell a kit, inventory items are deducted from inventory.
A kit is a unit composed of items from your inventory. A kit is sold as one unit but has several member components. The price of a kit is not dependent on its components' prices and can be assigned several price levels.
Note: Kit item inventory is not tracked by the kit, it is tracked by individual component items associated with the kit inventory. This means the Kit item record cannot display an available quantity for these items.
To create a Kit Item record in NetSuite, go to Lists > Accounting > Items > New and click Kit/Package.
Example of a kit inventory item
NetSuite Kit items are a special type of item which are composed of 1 or more component items. The Parent kit item does not have any inventory on them. The component item, each can be sold individually and has inventory associated with them.
A Dining Set (Kit) has 4 plates, 4 bowls, and 2 mugs. The inventory of the Kit item is determined by calculating inventory on each of the individual items. In the above example, if there are a total of 10 plates, 12 bowls, and 8 mugs, then the total saleable kit quantity is only 2.
Kit Inventory calculation based on Location
Kit Calculation is done at each location and then computed across locations. Component inventory is summed across inventory locations and then Kit Calculation is done on the totals. The resulting calculation for kit inventory is exported to BigCommerce.
Working with the Kit Inventory data flow
Set up the kit item in NetSuite and then open the Integration App. The Integration App 'settings' section displays the data flow groups/data flows. To run the data flow from this section, click Run.
The dashboard shows the status of the data flow. Once the flow is successful (takes few minutes to complete), validate that the NetSuite record is exported to Walmart.
- NetSuite saved search for syncing inventory for Kit Items: Select appropriate saved search. Refresh to fetch the latest values for the saved search. The following screen displays the saved search and its associated criteria in NetSuite:
- Calculate Kit Inventory per Location: If enabled, the Integration App will first calculate a sellable inventory of kit per location using the quantity of each member item, and then will send the sum of all the sellable quantities across all the locations. If disabled, the Integration App will first calculate the total inventory for each member item across all the locations, and then will calculate inventory for a kit.