This report is used to display product sales made between your selected date range by order and payment status. It includes the average unit price a product was sold at, the quantity of units sold and the total value amount sold of this product.
The grid will display results using up to the following 6 columns. (depending if the B2B module is activated)
- Product Title - The name of the product for which the following results relate to.
- B2B Quantity - The number of orders which were made by B2B customers.
- Average B2B Price - The average B2B price of the product for which the total is calculated by.
- Quantity - The number of orders which were made by B2C customers.
- Average Unit Price - The average price of the product for which the total is calculated by.
- Total Amount - The total value of the products purchased during your selected date range. Multiplies average product price for B2B and B2B sales with the quantity ordered.
Date Selection
Offers a range of quick pick date ranges to select a report for. e.g. 7 days, last 30 days etc.
Start Date
A simple date picker to select the start date of the date range
End Date
A simple date picker to select the end date of the date range
Order status
Select from 7 different status folders to show sales from. NEW ORDERS, IN PROGRESS, READY TO SHIP, SHIPPED, COMPLETED, CANCELLED, DENIED. You can select to display orders from all 7 at once. Results for product sales will be displayed from the status folder they are currently held in.
Payment status
Select one or all of the following 4, ALL, DECLINED, WAITING or FULL PAID. This will show the product sales under each payment status.
Ordered by
If you have the B2B function enabled, you can select which group of customers have purchased these products. i.e. you can filter results to display only B2B sales or only B2C sales..
Product based sales reports