Help

Tutorial

How to create a "Product Sales Breakdown" report

Auctiva Commerce allows you to create a report that displays a detailed view of product sales. This report can be used to assess which products are performing better than others. This tutorial will show you how to create a "Product Sales Breakdown" report.

What is a "Product Sales Breakdown" report?

The "Sales Breakdown" report displays the top performing products by quantity, amount and vendor. This report also displays the SKU associated with each product. You can define a time period for this report by any start and end date, too.

How to create a "Product Sales Breakdown" report

Creating a "Product Sales Breakdown" report will display only products that have been ordered at least once within the time period expressed for the report.

Step 1. Create the report.
  • Go to Reports> Products> Product Sales Breakdown. The "Product Sales Breakdown" report will load.
  • From: Select this checkbox to activate this field. Choose the start date for the report by clicking on the calendar provided. If you do not select this checkbox, the data will represent all dates prior to any expressed date in the "To" field.
  • To: Select this checkbox to activate this field. Choose the ending date for the report by clicking on the calendar provided. If you do not select this checkbox, the data will represent all dates after any expressed date in the "From" field.
  • Vendor: Select a vendor to limit the report data to the selected vendor in this field. The "Any" choice will return all vendors, including products that are not assigned to a vendor.
  • Sort By: Select which field will be used to sort the report.
  • Click the Go button when you are finished editing the above fields. The appropriate data will display.
  • Name: This column displays the name of the product.
  • Sku: This column displays the Stock Keeping Unit (SKU) of the products in the report.
  • Vendor: This column displays the vendor associated with the product.
  • Quantity: This column displays the quantity of this product that has been ordered within the expressed time period.
  • Amount: This column displays the total amount charged for the product within the expressed time period. This is not the order amount.  This value does not include shipping, handling, tax, other charges and discounts. It's strictly the price of the product multiplied by the quantity ordered.
  • Total Quantity: This field displays the total quantity of products ordered in the report.
  • Total Amount: This field displays the grand total of all the Amount fields in the report.

This completes the task of creating a "Product Sales Breakdown" report.

Tags

◄ Back to Help

Customer Support

If you have been unable to find the answer you were looking for using our Help documentation, please file a customer support request. We have customer support professionals ready to help you 24 hours a day, Monday - Friday (excluding major holidays.)