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.
Auto-enable Shopify locations using the Inventory Export flow
The NetSuite inventory to Shopify inventory (add or update) flow (Inventory Export flow) can automatically enable Shopify locations on a product or variant while syncing inventory. This occurs even when the inventory quantity for a location is 0.
This behavior is useful when you want every managed Shopify location enabled for an item, even if inventory is currently unavailable. For example, in order-on-demand workflows, inventory may be replenished at a location only after a customer places an order.
Prerequisites
The Inventory Export flow automatically enables a Shopify location only when both of the following conditions are met:
- The location appears in the Results of the NetSuite saved search used by the Inventory Export flow for the item.
- The location is mapped to a Shopify location in the integration app under Settings > Inventory.
When these conditions are met, the Inventory Export flow:
- Enables the mapped Shopify location on the corresponding Shopify product or variant.
- Synchronizes the inventory quantity, including a quantity of 0.
Note: This behavior is specific to the NetSuite inventory to Shopify inventory (add or update) (Inventory Export) flow. The following flows do not control which Shopify locations are enabled when creating or updating Shopify products:
- NetSuite item to Shopify product (add or update)
- NetSuite matrix item to Shopify product (add or update)
Troubleshoot locations that aren't automatically enabled
If a Shopify location isn't automatically enabled for an item, verify the following:
1. Verify the location is configured on the NetSuite item
Ensure the location is assigned to the item record in NetSuite.
If the location isn't configured on the item, it won't appear in the saved search results, and the Inventory Export flow won't synchronize it.
2. Verify the saved search returns the location
Open the saved search used by the Inventory Export flow and filter it for the affected item.
Confirm that the location appears in the Results.
If it doesn't:
- Add the appropriate location join, if required.
- Include the per-location inventory quantity column in the saved search.
3. Verify the location mapping
In the integration app, navigate to Settings > Inventory and confirm that the NetSuite location is mapped to the correct Shopify location.
If the location isn't mapped, the Inventory Export flow won't enable or synchronize that Shopify location.
Next steps
After verifying the item configuration, saved search, and location mapping, re-run the Inventory Export flow.
If all prerequisites are met, the Shopify product or variant will have the location enabled, even when the inventory quantity is 0.
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.