Troubleshooting issues with Inventory Sync for Shopify

Scenario: 

An item has a calculated quantity (OITW.U_CFX_ATP) <- inventory tab of Item Master Data

The item has all Shopify Meta Data populated 

OITW.U_ShopifyInventoryId

OITW.U_ShopifyID

OITW.U_ShopifyInvLevelId

Expected Result:

Calculated Inventory should sync in near real time to Shopify based on the calculated value

Module affected: 

Shopify Inventory

Log Locations: 

Wholesale store: C:/ProgramData/CFX/shopify/moodwhole/logs/shop_inv_mood_whole.log

Retail Store: C:/ProgramData/CFX/shopify/moodprod/logs/shop_inv_mood_prod.log

B1 Details:
Warehouse 01 is the retail store

Warehouse 02 is the wholesale store

ALL Inventory calculations are sourced from Warehouse 01

The individual warehouses are only used to set specific Shopify Meta data for the individual stores.

This allows the inventory in Warehouse 01 to be reported to all of their currently active Shopify sites from the same "source of truth"

What to check:

1. does the item have all Shopify UDF data filled in?

   a. Check the Shopify fields listed above in the Inventory data tab.

   b. If no data is found, ask the customer to check and see if the item is setup correctly on Shopify

   c. if data IS present but the inventory is still not matching on Shopify

       delete the data from the affected warehouse row and set the "Force Sync" dropdown to "Yes"

       this will retrieve the latest data for the item from Shopify and attempt to update the inventory.

   d. wait approx. 1 minute and refresh the item master data screen

       when completed the data should reappear in the fields

       the"Force Sync" dropdown will switch back to "No"

   e. have the customer validate that the stock now matches.

   f. if at any point during this process you are not able to proceed to the next step, assign the ticket to the development                 team and notify the customer of the escalation.

2. Does the item have a "MinStock" value set?

   a. on Item Master in a UDF called "MinStock" check if a value has been set that is greater than zero

   b. if the calculated inventory is less than this amount the value in the U_CFX_ATP field of inventory data should be 0.

   c. Shopify inventory should also be 0.

   d. if the values do not match - assign ticket to the development team to escalate.

Recent Fixes put in place

04/15/2025 - LF

   Added a new process to the inventory data sync that will identify obsolete or incorrect meta data in SAP Business one.

   The new process identifies if Shopify does NOT return inventory data for a matching item.

   It will automatically remove the Meta Data from Item Master and attempt to refresh the data from Shopify.

   We have found that this tends to resolve the issue automatically and may reduce or eliminate this problem going forward.

if there are any questions at all about this process or if more info is required reach out to the development team for direction.