The Inventory Export flow exports an item’s “Quantity Available” from NetSuite to the corresponding item in Shopify on a batch basis. An item is picked up for export only when there is an actual change in the “Quantity Available” field for that item.
For information on inventory settings, refer to Inventory Settings.
- The item itself is not exported but must be created and configured via Item Export (available in the standard (previously "premium") and premium (previously "enterprise") editions) or manually in both systems.
- To know more about how to configure the Multi-location feature and to track inventory by location, see Support for Shopify’s Multi-location inventory.
Refer to this example:
The Item details in Shopify indicate an inventory section as shown in this example. The Inventory Policy displays ‘Shopify tracks this product’s inventory’.
The Product Variant ID field creates the link between the NetSuite and Shopify items. To import the Product Variant ID of a Shopify product into NetSuite, run the data flow Shopify product ID to NetSuite item (mass update).
For more information about how the Shopify Item ID Map works, please watch this video: https://youtu.be/iG6hPZac4es
Go to NetSuite and locate the inventory item. In the eTail subsection, select Shopify from the eTail Channel pick list.
Go to Transactions and Adjust the Inventory. In this example, the inventory is adjusted by value ‘10’.
Go to the Integrator and trigger the NetSuite inventory to Shopify inventory (add or update) data flow manually. The flow can also be configured to run at scheduled intervals.
The flow is in progress
The flow is completed successfully.
Note: Be sure that the flow uses Internal ID only as the Sort By field.
The Inventory quantity is incremented (by ten) in the Shopify Web Store as shown in this example.
Click on the Product to view the details.
Ignore products in NetSuite that are tagged as “discontinued”
If you want to ignore the inventory level for the products in NetSuite that are tagged as “discontinued” or unpick the unpublished duplicate item SKUs from Shopify, perform the following:
- Ensure the product is archived and no sales channel is set in Shopify.
- In the integration app, go to Settings > Inventory and disable the Sync Inventory levels for both published and unpublished Shopify items.
You can use the above process for both Shopify product ID to NetSuite item (mass update) and NetSuite inventory to Shopify inventory (add or update) data flows.