Overview
This article will teach you about Sellercloud’s Inventory by Warehouse Detail report. This report shows the total physical inventory and value of products in each separate warehouse for a specific time period.
You can see the following information:
- Products – name, brand, SKU, ASIN, and status.
- Purchasing – manufacturer, vendor, and purchaser.
- Inventory – in each individual warehouse.
- Price – value and cost.
For key points about Sellercloud’s Inventory reports, see the Inventory Value Reports Overview.
For answers to general questions about using Sellercloud’s Financial Reporting Suite, see the Reports FAQ.
Access and Customize the Report
To use the report, follow these steps:
- Navigate to Reports > Inventory > Inventory By Warehouse Detail.
- Set up the Default and Custom filters to have the report show precisely what you need.
- Click Search. Each filter you apply gets highlighted in a different color. If a filter is gray or not displayed at all, it’s not active.
- To manage the columns in the report, click the three dots icon on the top right and select Customize Columns. You can:
- To sort the data differently, use the Sort by menu.
- To save your filtering and sorting options, click Save view, type a Name and click Save.
- To export the full report to a spreadsheet, click Actions on the bottom right and select Export to Excel. Spreadsheets include all columns, including those hidden in the report.
Filter and Column Definitions
Click the drop-downs below for filter and column descriptions.
FILTER | DESCRIPTION |
Company | Include only the inventory info from one or more companies. |
Date Type | Select from As of Date, Date Range, and Real Time to change how the date filters work.
|
As Of Date | Include only inventory info from a specific date. |
Date Range | Select a preset time range from Yesterday to Last Year. |
Custom Date Range | Enter the Start and End dates. For a single date, choose the same Start and End date. |
FILTER | DESCRIPTION |
Brand | Include only items from one or more brands. |
Company Groups | Include only items belonging to a group of companies. |
Do Not Include Inventory from Dropship Warehouses | Include or exclude inventory info from dropship warehouses. |
Do Not Include Warehouses with Zero Inventory | Include or exclude warehouses with zero inventory. |
Exclude negative inventory in totals | Include inventory info only for items produced by a specific manufacturer. |
Group Products by Parent SKU | Whether to group together products by a parent SKU or not. |
Manufacturer | Include only the products from one or more manufacturers. |
Product Groups | Include only the products from one or more product groups. |
Product Status | Include only products that have Active or Inactive statuses. |
Purchaser | Include only products bought by one or more purchasers. |
SKU | Include only specific SKUs. |
Vendor | Include only the products from one or more vendors. |
Warehouses | Include inventory info only for specific warehouses. |
COLUMN | DESCRIPTION |
Date | Shows the date for which the inventory info is calculated. Note: Only available in the report’s web interface. |
Company | Shows the company selling the product. Note: Only available in the report’s web interface. |
SKU | Shows the SKU code assigned to the product. |
Product Name | Shows the name of the product from the product summary. |
Product Type | Shows the product’s type. Note: Only available when you export the report to a spreadsheet. |
Product Status | Shows the product’s Active or Inactive status. |
ASIN | Shows the Amazon Standard Identification Number (ASIN). |
UPC | Shows the Universal Product Code (UPC) assigned to the product. |
Brand | The product’s brand. |
Manufacturer | Shows the product’s manufacturer. Note: Only available when you export the report to a spreadsheet. |
Vendor | Shows the product’s vendor. |
Purchaser | Shows the contact email address of the purchaser. |
All Warehouse Columns | One column for each warehouse. |
Total | Shows the total quantity of products across all warehouses. |
Cost | Shows the 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:
|
Cost Type | Shows the cost type for the products. The cost type is determined based on the Client Setting Order Profit & Loss Calculated Using. Note: Only available when you export the report to a spreadsheet. |
Value | Shows the total value of the product’s inventory in a specific warehouse. The value is based on the product’s cost multiplied by the physical quantity. |
Location Notes | Shows the location notes of the products. Note: Only available when you export the report to a spreadsheet. |