Overview
This article provides a brief overview of Sellercloud’s Qty Sold Reports, which allow you to track the quantities of products sold within a selected date range. These reports offer useful insights, along with customizable filters and sorting options to help you manage your data more effectively.
There are five reports of this type:
- Qty Sold By Channel Summary
- Qty Sold By Channel Detail.
- Qty Sold By Product
- Qty Sold By Product By Day
- Qty Sold By Warehouse.
Quantity Sold Reports
An important characteristic feature of these reports is that they can show you different data depending on how you set up their Date Type filter. Setting the Date Type filter correctly is key to generating the reports accurately. You can set this filter up based on:
- Order Date – The date the order was placed. Running reports by order date shows information about orders placed on your selected date or within the selected date range.
- Ship Date – The date the order was shipped. Reports run by ship date show information about orders shipped on your selected date or within your selected date range.
Qty Sold By Channel Summary
Qty Sold By Channel Summary summarizes the product quantity sold per channel and total sales amount for a specific period. It also shows the currently available and on-order product quantities. You can see:
- Product Information: Product Name, SKU, ASIN, UPC, Product Group, and Company.
- Current Inventory Information: On Order and Available Quantity.
The inventory information in the report always reflects your current inventory, regardless of the selected date range. - Sales Information: Average Selling Price, Total Sales, and Total Discounts.
- Per Channel Sales Information: Quantity Sold By Channel Columns.
The Qty Sold By Channel Detail report is similar as it also shows the quantity sold per channel while summarizing the Sales amount across all channels. However, Qty Sold by Channel Summary includes more product details and different sales information.
Qty Sold By Channel Detail
Qty Sold By Channel Detail provides an itemized display of the product quantity sold per channel for a specific period while also showing the units sold per product, the total number of orders, and the grand total. You can see the following:
- Product Information: Product Name, SKU, and ASIN,
- Sales Information: Total Units, Total Orders, and Total Sales.
- Per Channel Sales Information: Total Units, Orders, and Sales amounts by Channel Columns.
The Qty Sold By Channel Summary report is similar as it also shows the quantity sold per channel while summarizing the Sales amount across all channels. However, the Qty Sold By Channel Detail provides more detailed per-channel information in the form of sales amounts and number of orders, in addition to the same units per channel information that is displayed in the Qty Sold by Channel Summary.
Qty Sold By Product
Qty Sold By Product lists products and summarizes the quantity sold of each in a specific period, with additional sales information. It also shows your current inventory and extensive product details. You can see:
- Order and Sales information: Orders, Quantity Sold, Sales, Subtotal, Shipping Cost, and Commission.
- Current Inventory information: On Order, Available Quantity, Reserved Quantity, and Physical Quantity.
The inventory information in the report always reflects your current inventory, regardless of the selected date range. - Product information: Product Name, Product Type, SKU, ASIN, Manufacturer, Manufacturer SKU, Vendor, Purchaser, Condition, and Package Weight.
Qty Sold By Product By Day
Qty Sold By Product By Day summarizes the quantity sold by product daily for a specific period. It also includes additional sales information and your current inventory. You can see:
- Order and Sales information: Order Date or Ship Date, Orders, Quantity Sold, Subtotal, Additional Charges, Discounts, and Total Sales.
- Current Inventory information: Available Quantity, Reserved Quantity, and Physical Quantity.
The inventory information in the report always reflects your current inventory, regardless of the selected date range. - Product information: Product Name, SKU, and ASIN.
Qty Sold By Warehouse
Qty Sold By Warehouse shows you how many product units you have shipped of each product from each of your warehouses in a specific date range. It also provides information about the currently available and on-order inventory. You can see the following:
- Product Information: Product Name, SKU, ASIN, and Manufacturer.
- Sales Information: Total Quantity Sold.
- Current Inventory Information: On Order and Available Quantity
The inventory information in the report always reflects your current inventory, regardless of the selected date range. - Per Warehouse Sales Information: Product Quantity Sold Per Warehouse.