In this article, you will find out how to manage Qty Sold by Product by Day report on Sellercloud. This report summarizes quantity sold by product by day in the specified date range.
There are numerous filters to include the data you want in your report. Most filters offer single-choice and multiple-choice fields.
In Sellercloud, to access this report:
- Go to Reports > Sales > Qty Sold by Product.
- Chose your filters > Click Run Report.
Note: After clicking Run Report to show these transactions, you can see each specific filter you applied. If a filter is not shown, you left it blank or chose All.
The table below defines each of the filters.
|Company||Include only the orders from one or more companies, or include orders from all companies.|
|Company Groups*||Include only the orders from one group of companies, or include orders from all companies.
*Only shown if you enabled the company group setting and grouped companies together. Learn how.
|Channel||Include only the orders from one or more sales channels, or include orders from all channels.|
|Start Date and End Date||If you choose a custom date range, choose the starting and ending dates. If you chose a default date range, these will auto-populate.|
|Filter by||Have orders, and their associated activity, reflected in one of three ways:
|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.|
Include only the products belonging to one vendor, or include all products.
Note: For dropship orders, this will be the vendor that the products were actually purchased from.
|Purchaser||Include only the products belonging to one or more purchasers, or include all products.|
|Product Type||Include only the products belonging to one product type, or include all product types.|
|SKU||Note: For shadow products, this filter is dependent on the Use Original ProductID (shadow) setting.
|Exclude Dropship Inventory||If checked, the filter excludes information about dropship inventory in the report.|
|Use Original ProductID (shadow)||If checked, the filter uses the original orders’ shadow SKUs. If unchecked, the filter uses the orders’ parent SKUs.|
The Grid Data
Take a look at a sample grid report:
|SHIP DATE||Shows the date when the product is set for shipping.|
|SKU||The unique number of the product.|
|PRODUCT NAME||Shows the name of the product.|
|ORDERS||Shows the number of orders for that particular product.|
|QTY SOLD||The number of products sold.|
|TOTAL SALES||The total amount of sales for that product.|
|AVAILABLE QTY||Shows the number of units available for sale for that product.|
|RESERVED QTY||Shows the number of units reserved for that product.|
|PHYSICAL QTY||Shows the number of total inventory that the product has in all warehouses.|
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. You can even create custom bar graphs and pie charts; for example, to show daily sales trends for a selected date range.
Take a look at a sample spreadsheet report.
|Ship Date||Shows the date when the product is set for shipping.|
|Order Date||Shows the date when the product was ordered.|
|SKU||The unique number of the product.|
|ASIN||Amazon Standard Identification Number (ASIN) is a ten-digit alphanumeric code that identifies products on Amazon.|
|Product Name||Shows the name of the product.|
|Orders||Shows the number of orders for that particular product.|
|Qty Sold||The number of products sold.|
|SubTotal||The total amount of the items before any discounts, tax, shipping, etc.|
|Additional Charges||The total amount of any additional charges.|
|Discounts||The total amount of discounts.|
|Total Sales||The total sum of sales per day for that particular product.|
|Available Qty||Shows the number of units available for sale for that product.|
|Reserved Qty||Shows the number of units reserved for that product.|
|Physical Qty||Shows the total inventory that the product has in all warehouses.|
|Package Weight||Shows information about the weight of the package.|