Inventory by Product Detail

Overview

This article will teach you about Sellercloud’s Inventory by Product Detail report. This report shows the quantity and value of your inventory per day and per warehouse for specific periods. In other words, you can see how much you have of any product and how much it is worth in each of your warehouses, broken down daily for a time range you select.

The report displays a row for each warehouse storing a product. If you have a product in two warehouses, you will see two rows for the product.

You can see information about:

  • Products name, SKU, UPC, product type, and brand. 
  • Inventory warehouses, bins, last received date, and physical, reserved, and available quantity.
  • Value – cost, total value, site price, and list price.
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:

  1. Navigate to Reports > Inventory > Inventory By Product Detail.
  2. Set up the Default and Custom filters to have the report show precisely what you need.
  3. 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.
  4. To manage the columns in the report, click the three dots icon on the top right and select Customize Columns. You can:
    1. Reorder columns by dragging them up or down in the list;
    2. Hide columns by clicking the Trash icons;
    3. Add columns by clicking Add column.
  5. To sort the data differently, use the Sort by menu.
  6. To save your filtering and sorting options, click Save view, type a Name and click Save.
  7. 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.

Default Filters
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.

  • If you select As of Date, you will see product inventory info starting from the date you specify.
  • If you select Date Range, you will see product inventory info from that specific date range.
  • If you select Real Time, you will see product inventory info from today.
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.
Custom Filters
FILTER DESCRIPTION
Brand Include only items from one or more brands.
Company Group Include only items belonging to one or more company groups.
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 no inventory.
Exclude negative inventory in totals Exclude negative inventory info from calculations.
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.
Report Data
COLUMN DESCRIPTION
Date Shows the date for which the inventory info is calculated.
SKU Shows the unique Stock Keeping Unit (SKU) code assigned to the product.
Product Name Shows the name of the product from the product summary.
Name Shows the product’s brand.
Warehouse Shows the warehouse‘s name.
Physical Shows the total inventory of a product that is available across warehouses, including items that are ordered but not shipped yet.
Available Shows the inventory that is available for sale, excluding reserved and non-sellable quantities.
Note: If a warehouse is not sellable, you will see 0.
Reserved Shows the inventory that has been occupied by created orders or manually reserved for channels.
Note: If a warehouse is not sellable, you will see 0.
Last Received Shows the date on which the product was last received in the warehouse.
Value Shows the total value of the product inventory in a specific warehouse. The value is based on the product’s cost multiplied by the physical quantity.
Product Type Shows the category a product falls under.
UPC Shows the product’s Universal Product Code (UPC).
Bin Name Shows bins storing the product.
Cost Shows the cost value of the item from the product summary. The cost used in this report is based on the Client Setting Order Profit & Loss Calculated Using on the date specified:

  • Average cost – Cost of units continually averaged.
  • Last Cost – Cost of an item on the last purchase order in which it was received.
  • Site Cost – Current value in the Product Summary’s Site Cost field.
Site Price Shows the default product price used for the website and sales channels.
List Price Shows the Standard/List Price on the product page.

Was this article helpful?

Related Articles