Inventory by Product Detail

Updated 1 month ago

This report itemizes inventory and value per warehouse by product as of a specified date and time (based on the time the service runs, which is once per night, and shown in the Timestamp column of the report when it is exported to Excel). 

The report displays a separate row for each product for each warehouse. If a product has inventory in three warehouses, there will be three rows for the product.

Inventory quantity and value is stored for every day up to 180 days. Before that period, SellerCloud only keeps a record for the first and last day of each month. If you select a date prior to 180 days, the report will take you back to the first day of the month. 
  • Value is based on the Item Cost of the product on the specified date. 
    • While there are 3 item costs available to use - Average, Last, and Site - the cost saved to the report is what the Client Setting Order Profit & Loss Calculated Using:________ was set to on the date specified.
  • By default, when the Warehouse filter is set to "All Warehouses," the report will include dropship warehouses. To exclude those warehouses from the report and total, click the Do not Include Dropship Warehouses setting.


How did we do?