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.
Notes:
- 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.
Important:
- The Shopify product ID to NetSuite item (mass update) flow currently does not provide a filter to exclude Draft status items. There is no available node or setting within the flow to specifically filter out Draft items, and this status is not included in the retry data or filter selection options.
- The Shopify product ID to NetSuite item (mass update) flow will capture and sync inventory only for products in Shopify that have been updated at the variant level. If no variant-level changes are detected, those products will not be included in the flow run.
- You can configure mappings on the Post Shopify IDs to NetSuite items import in the Shopify product details to NetSuite item ID map record (update) real-time flow to align the flow behavior with your business requirements. Mappings configured in the Shopify product ID to NetSuite item mass update flow are independent of the real-time flow and are not applied automatically. If required, configure mappings separately in each flow.
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).
Note
The real-time flow (Shopify product details to NetSuite item ID map record (update)) for writing back product_id and inventory_item_id to NetSuite is constrained by Shopify webhooks, which support a maximum of 100 variants. For products with more than 100 variants, users must trigger or schedule the mass ID update flow to sync IDs efficiently.
The Shopify product details to NetSuite item ID map record (update) flow auto-triggers when you run the NetSuite item to Shopify product (add or update) flow.
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.
- Be informed that the NetSuite SmartConnector will adjust the inventory in Shopify only when there’s a discrepancy in the inventory in NetSuite and Shopify. However, if the inventory quantities in both systems are aligned, the inventory flow process will update the inventory displayed in the product user interface (UI) solely upon detecting a change in quantity.
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.
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.