Inventory Sync Issue/Discrepancy

Inventory Sync Issue/Discrepancy

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

  1. Make sure that Synchronization With WMS - Inventory is turned on in the MerchantsEdit Setup page.
    1. If the page shows Automatic, This means the warehouse system controls this step, not Extensiv Integration Manager. Skip to Step 3.
  2. On Merchant page, check the Last Inventory Run field. 
    1. If Last Inventory Run shows N/A, it means that Inventory Script has never been triggered before. Please refer to the Step 1 above. 
    2. The Status field shows the last Inventory Downloading result. 

  3. To check if Integration Manager downloads correct inventory levels from your WMS/OMS, please go to MerchantLocations & Products page.
    1. Click a specific warehouse (or Default) to see levels for that warehouse and when they were last loaded
    2. 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).

  1. Make sure that Inventory Upload Service is also turned on. 
  2. 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.)
  3. Check the Push Inventory Using Alias field. If you are using the wrong product aliases, inventory sync will be rejected by order source. (Click here for more information regarding Aliases Setup)
    1. Products that do not contain the chosen alias will be ignored during inventory sync.
  4. 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 

  1. Go to Merchants > Locations & Products. Select the specific warehouse you have connected to the cart in question.
  2. Search for the specific SKU. Make sure you only receive one result and that it has been recently updated.
    1. 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.
    2. 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

  1. Go to Carts > Select Your Cart > View Product 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.
  2. Browse or Search to the page with the product SKU in question to verify when we last synced inventory with our cart.
    1. 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.
    2. If the Sync time says Never, make sure the SKU in your WMS or the alias you have selected match exactly.
    3. 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 WMS/OMS Specific Issues

If listed, select your WMS to read more details:



    • Related Articles

    • Amazon Inventory Sync Issue

      Review these steps if your Amazon inventory is not up to date. Review Inventory Setup in Extensiv Integration Manager This guide will walk you through all the Integration Manager settings to ensure everything is properly enabled. As part of this ...
    • Extensiv Order Manager OMS Inventory Not Syncing (Sync Per Order Manager Sales Channel Mode)

      Problem Products inventory levels in Extensiv Integration Manager do not match with quantities in Extensiv Order Manager. Integration Manager is not pulling proper inventory levels from Order Manager. Solution Note: Order Manager only provides ...
    • Inventory Sync

      Inventory sync is a feature that allows Extensiv Integration Manager to update an order source with the exact quantity that is available for each product. This lets a shopping cart know when an item is sold out or when the warehouse has new inventory ...
    • Zoho Inventory Integration Overview

      This documentation is for Zoho Inventory as an Order Source. If you are looking to load orders into Zoho Inventory instead, see this Zoho Inventory OMS Guide. Increase your sales and keep track of every unit with our powerful stock management, order ...
    • Zoho Inventory OMS Integration Overview

      This documentation is for Zoho Inventory as an Order Destination. If you are looking pick up orders from Zoho Inventory instead, see this Zoho Inventory Overview Guide. Increase your sales and keep track of every unit with our powerful stock ...