Product Sales Report
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.
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.