The Shopify products to item ID map (add/update) flow is the critical dependency for the entire integration. It queries all Shopify products and their variants using the GraphQL products query and writes three IDs back to each matching NetSuite item record:
-
Shopify Product ID: the GID of the Shopify product
-
Shopify Variant ID: the legacy numeric ID of the Shopify variant
-
Shopify Inventory Item ID: the GID of the Shopify inventory item
These IDs are written to the eTail tab on the NetSuite item record via the customsearch_celigo_shopify_item_id_map saved search lookup (matched by SKU).
Why run this flow first
Every flow in the integration that moves data between NetSuite items and Shopify products depends on the Shopify Variant ID being populated on the NetSuite item record:
-
Order flows: Line item lookup uses the Variant ID to find the correct Shopify variant for each order line.
-
Inventory sync: Uses the Inventory Item ID to set inventory levels at the correct Shopify location.
-
Product sync: Uses the Product ID to determine whether to create or update a Shopify product.
-
Inventory transfers: Requires the Shopify Product ID, Variant ID, and Inventory Item ID for all transfer line items.
When to run this flow
-
Initial setup: Run once before enabling any order, inventory, or product flow.
-
After bulk product creation in Shopify: Run after creating new products in Shopify to populate their IDs on the corresponding NetSuite items.
-
Ongoing schedule: Schedule daily or based on your product creation cadence to keep the ID mapping current.
Note
-
The flow only picks up Shopify products that have been updated at the variant level since the last run. If a new NetSuite item is created and its corresponding Shopify product has not had any variant-level changes, it will not be picked up until you either adjust the flow's delta timestamp or run a full sync by clearing the export's last modified date.
-
For stores with products that have more than 100 variants, the Shopify real-time webhook cannot process all variant IDs efficiently. Use scheduled runs of this flow instead of relying on the webhook for high-variant products.
Verifying the mapping
To verify that the item ID map has run successfully for a specific item:
-
In NetSuite, open the Item record for the item.
-
Click eTail.
-
Confirm the Shopify Product ID and Shopify Variant ID (and Inventory Item ID for inventory sync) fields are populated.
If these fields are empty, the item has not been mapped. Check that:
-
The item's SKU in NetSuite matches the SKU on the Shopify variant exactly (case-sensitive).
-
The Shopify product is published and active (not a draft).
-
The flow's delta timestamp includes the period when the Shopify product was last updated.