Solution: Inventory not syncing for recently activated items | Shopify Integration App

The Celigo Shopify IA stands out as a premier integration solution for businesses, offering a wide range of features. However, despite its capabilities, there was a specific edge case causing Inventory Mismatches for many customers.

Consider this scenario: An item exists in NetSuite with some sellable inventory but hasn't been synced / listed for sale on the Shopify site via the Celigo integration. Now the business decides to sell this item online, fills in the etail fields, and the Shopify Integration app’s NetSuite Item to Shopify Product sync flow creates/syncs the item to the corresponding Shopify Account.. The flow create’s the Celigo Shopify item ID map on the item record with the Shopify Item ID References for future updates.

What about the inventory that is already present?

Traditionally, inventory sync triggers on a delta basis (using the Last Quantity Available Change field as date filter) for items with inventory adjustments since the last flow run. 

The Inventory of such products in this context will not be synced by the flow, as the Last Quantity Available Change timestamp of these items is prior to the last run of the flow.Previously, the solution was to either wait for a future adjustment or handle it manually this one time.

Not anymore. To handle this edge case, we have come up with a solution introducing a custom Date field called CeligoItemID-CreatedAt on the item record in NetSuite, which would be set  with the timestamp when there is a new Celigo Shopify Item id map record created. 

To handle this timestamp update, we have built a NetSuite to NetSuite custom real-time flow, that triggers whenever a new item ID mapping is created in NetSuite and updates the timestamp on this custom field for that particular item.

Now, we updated the Inventory Sync flow to include this new custom field under “Date fields to use in delta search”, along with the Last Quantity Available Change, and these records are promptly picked up by the system in the next run, ensuring seamless inventory synchronisation.