Inventory Quantities Are Incorrect in Symphony

Overview

You may notice that inventory is overstated, i.e. quantities for certain products are incorrect in Symphony Manage (different from the number of available products in the warehouse), which might be caused by inventory synchronization issues between Manage and the warehouse.

Solution

Submit a ticket to Symphony Support, providing the IDs for the affected products and the correct number of items in stock.

You can check the product ID in Symphony Manage under Fulfillment > Inventory Management or you can export the report: Audit - Product Inventory Levels (id 370).

<supportagent>

  1. Using Postman, run the following API call using the POST method for each product ID reported by the brand to sync the inventory values:
    https://manage.symphonycommerce.com/org/partner/api/v1/audit/run-warehouse-inventory-audit-job-for-product?productId=<product ID>&applyInventoryAudit=true
  2. Connect to the database and check that the item quantities were updated:
    select p.id,p.productClusterId,wp.onHandQty,p.name
    from Product p, WarehouseSkuMapping w, WarehousePoolInventory wp
    where w.stockKeepingUnitId=wp.stockKeepingUnitId
    and w.stockKeepingUnitId=p.stockKeepingUnitId
    and wp.poolName='DEFAULT'
    and p.id in (<Product IDs separated by comma>) order by p.id;

    If you need to check the sum of all affected product quantities, use the following query:
    select sum(inventory) from Product where id in (<Product IDs separated by comma>)
  3. If the product is still displayed as out of stock on the brand's website:
    1. Navigate to Catalog > Products
    2. Find and open the required item.
    3. Expand the Categories section and check to which category the product is assigned.
    4. Sync the items in the category as described in the article New or Updated Product Is Not Reflected on Website.

</supportagent>


Testing

Check that the number of items in Symphony matches the actual quantity of products in the warehouse under Fulfillment > Inventory Management or you can export the following report Audit - Product Inventory Levels (id 370).

Comments

0 comments

Article is closed for comments.