This report shows the total physical inventory and value by product per warehouse as of a specific date or during a range of dates.
To access this report in Sellercloud, click Reports > Inventory Reports > Inventory by Warehouse Detail.
Take a look at a sample grid report for several products in three warehouses as of today:

From here, you drill down even further into the Inventory by Product Detail report by clicking on a SKU.
For the report showing total physical, reserved, and available inventory and value by warehouse, see the Inventory by Warehouse Summary.
Choose your filters
There are numerous filters to include the data you want in your report. (Most filters offer single-choice and multiple-choice fields. See a generic example of both.)

After clicking Run Report to show product inventory by warehouse, you can see each specific filter you applied. If a filter is not shown, you left it blank or chose All. Here’s a common report filter.
The table below defines each of the filters.
FILTER | DESCRIPTION |
Company | Include only the products from one or more companies, or include products from all companies. |
Company Groups* | Include only the products from one group of companies, or include products from all companies.
*Only shown if you enabled the company group setting and grouped companies together. Learn how. |
As of Date or Start Date and End Date | Based on the Date Type filter selected, enter either:
|
Date Type | Show product inventory in one of 2 ways:
|
Warehouse | Include only the products from one or more warehouses, or include products in all warehouses.
Note: If you choose “All Warehouses,” the report will include products in dropship warehouses, unless you select Do Not Include Inventory from Dropship Warehouses, below. |
Purchaser (Buyer) | Include only the products belonging to one or more purchasers, or include all products. |
Product Group | Include only the products belonging to one or more product groups, or include all products. |
Vendor | Include only the products belonging to one vendor, or include all products. |
Manufacturer | Include only the products belonging to one manufacturer, or include all products. |
Brand | Include only the products belonging to one brand, or include all products. |
Product Status | Include only products that have Active or Inactive statuses, or include all products. |
SKU | Important! For shadow products, this filter is dependent on the Group Products by Parent SKU setting, below. If checked, the report filters for parent SKUs only; if unchecked, the report filters for all SKUs (parent and child).
|
Group Products by Parent SKU | For shadow products, show only the parent SKU. Child SKUs will be included in the warehouse quantity, total, and value, but will not be shown.
Important! This filter affects the SKU filter for shadow products:
|
Do Not Include Products with Zero Inventory | Exclude products that have no physical inventory across all warehouses. |
Do Not Include Inventory from Dropship Warehouses | Exclude inventory in warehouses set as DropShip in the Warehouses’ settings. |
About the grid data
Take a look at the sample grid report for several products in three warehouses as of today:

You can export this report to a spreadsheet with additional data by clicking the Export to Excel icon. For spreadsheet details, see About the spreadsheet data.
The table below defines each of the columns:
COLUMN | DESCRIPTION |
Date* | The physical inventory and value on that date.
*Only appears if you filtered the grid report by Date Range. Filtering by As of Date will hide this field since the data is for one date only. |
SKU | Click on a SKU to open the Inventory by Product Detail report. |
Total | Total quantity of products across all warehouse(s). |
Cost | Cost value of the item from the product summary.
The cost used in this report will be based on a choice in the Client Setting Order Profit & Loss Calculated Using on the date specified. Three costs are available in this Client Setting:
|
Value | Total value of the physical inventory across all warehouses. Value is based on the product’s cost multiplied by the physical quantity. |
About the spreadsheet data
Exported spreadsheets include more data than the grid report. Spreadsheets also let you manipulate data, such as filter within a column, sort with advanced parameters, etc.
Take a look at the sample spreadsheet report for several products in three warehouses as of today:

The table below defines each of its columns:
COLUMN | DESCRIPTION |
Date* | The physical inventory and value on that date.
*Only appears if you filtered the grid report by Date Range. Filtering by As of Date will hide this field since the data is for one date only. |
SKU | Unique stock keeping unit (SKU) code assigned to the product. |
Product Name | Name of the product from the product summary. |
ASIN | Amazon Standard Identification Number. Used to connect a product to a listing. |
Brand | Product brand. |
Manufacturer | Product manufacturer. |
Vendor | Product supplier. |
Purchaser | Product buyer. |
Product Status | Status of product (Active, Inactive, or All). |
Total | Total quantity of products across all warehouse(s). |
Cost | Cost value of the item from the product summary.
The cost used in this report will be based on a choice in the Client Setting Order Profit & Loss Calculated Using on the date specified. Three costs are available in this Client Setting:
|
Value | Total value of the physical inventory across all warehouses. Value is based on the product’s cost multiplied by the physical quantity. |
Location Notes | Text note about the product’s location in a warehouse. |