You can analyze detailed product-level sales performance by accessing the Product Sales Report, which shows revenue, units sold, and profitability for individual products across time periods and locations. This granular sales analysis helps retail operators identify best-selling products, evaluate pricing effectiveness, and make informed merchandising decisions based on actual product performance data.
Using the Product Sales Report helps retail operators optimize product assortment, identify products deserving increased inventory investment, and phase out poor performers to improve overall category profitability and turnover.
Find related articles at the bottom of this page
The Product Sales Report is the top recommended report to review how a particular product (or style) is performing. See your current available stock, order quantities, sales quantities for year-to-date and month-to-date, pricing and GP information.
📋
Note: Notes about the Product Sales Report:
- The maximum date range is 12 months
- The date range selected only affects sales results
- Stock value is always reported at the current value at the time of running the report
To access the Product Sales Report
- Navigate to: Reports > Product Performance > Product Sales Report
- Use the Search Fields to match your criteria for the report
- Use the Refine Search and Refine by Attributes sections to filter your data
- Click Search
- To export the data click the Export to Excel or Export to CSV button
Filters
Most of the filters are self-explanatory, however see below for details on the more advanced fields.
| Filter | Details |
|
Date From
Date To
| These filters are used to enter a date range for the report. Note this data is for a maximum of 12 months and for the Sales data only |
|
PLU
|
The PLU field accepts multiple Supplier SKU, Manufacturer SKU and Product ID codes separated by a comma e.g. 124001, SSRA943
|
|
Exclude all products with zero stock available
|
Will exclude products if they have zero stock even if sales have occurred during the selected Date From/To range
|
|
Display Product Attributes in Results
|
Attributes can be limited to just the default attributes (Colour, Size, Brand and Season) or all attributes including those created via Settings > Product Attributes (Custom 1, Custom 2 and Custom 3 are not included in the report)
|
Tip: Click column headings to sort into ascending or descending order. Ensure to scroll to the right to view more column detail.
Return to Top
Want more information? Find related articles here:
Related Articles
Inventory Management: