Inventory Sync Issue/Discrepancy
2.4 min read
|Problem
Some or all of your inventory records are not syncing from your backend WMS/OMS system to your shopping cart.
Solution
Quantity Available
First, understand that Integration Manager always compares inventory using Quantity Available and not Quantity On Hand. Quantity Available is the quantity that is sellable at any given moment, so it excludes inventory allocated to an order that has already loaded but not yet shipped.
When comparing inventory levels between systems, be sure to compare the Available Quantity.
Check Merchant Settings
- Make sure that Synchronization With WMS - Inventory is turned on in the Merchants > Edit Setup page.
- If the page shows Automatic, This means the warehouse system controls this step, not Extensiv Integration Manager. Skip to Step 3.
- If Last Inventory Run shows N/A, it means that Inventory Script has never been triggered before. Please refer to the Step 1 above.
- The Status field shows the last Inventory Downloading result.
-
- Click a specific warehouse (or Default) to see levels for that warehouse and when they were last loaded
- Click Add/View Products to see a summary of all warehouses. This page does not show the specific time each inventory record was loaded.
Check Cart Settings
Go to the Carts > Select Your Cart > Edit Setup page in Integration Manager and check the following settings (per cart).
- Make sure that Inventory Upload Service is also turned on.
- Make sure that Sync Inventory With Warehouse is set to the correct Warehouse. (The warehouses list will be automatically downloaded after Integration Manager successfully syncs with your WMS/OMS.)
- Products that do not contain the chosen alias will be ignored during inventory sync.
- Set Minimum Inventory Level to 0 if necessary. This will make sure we always post the full inventory amount to your cart.
Review Specific SKUs
Check SKU coming from WMS/OMS
- Go to Merchants > Locations & Products. Select the specific warehouse you have connected to the cart in question.
- If you get no results then you have an issue with your product codes matching up. Make sure your WMS has the correct SKUs loaded.
- If you get multiple results it means you have more than one product with the same alias code. An alias code must uniquely reference one product only. Make sure your WMS only has a single entry for each product.
Check Cart Sync
- Not all carts support this level of detail. If the page is blank, login to your cart to make sure the SKU in your cart matches the SKU in your warehouse, or that it matches the alias code you are setup to use.
- If the Inventory Enabled field says NO, Integration Manager can not sync inventory to your cart for this item. If you would like us to sync inventory for this product, you must enable Inventory Tracking for this item in your shopping cart. Please reach out to your shopping cart support for details on how to do this.
- If the Sync time says Never, make sure the SKU in your WMS or the alias you have selected match exactly.
- If the SKU does not exist in this list, make sure the SKU in your cart matches with the SKU in your WMS or the alias you have selected. (Click here for more information regarding Aliases Setup)
Check Inventory
- Go to the Alerts tab of Integration Manager.
- Look for any ‘Inventory Download’ or ‘Inventory Upload’ alerts.
- Click on any of these to see more specific information.
If you are unsure about how to resolve the error message, please contact Integration Management Support.