Top Items report
The Top Items report is located in the Report Catalog. This report allows you to view and rank SKUs by sales metrics including transactions, net sales, discount, and quantity.
Tip: You must have an Account Group selected or applied to your user to view all of the reports.
Filters
You’ll be able to target specific data within your report by using the available filters on top. These filters include:
Count
Allows you to control how many results return in your ranking, with 50 being the default.
Metric
Allows you to control the metric on which the results are being ranked. You can choose between Total Net Sales, Total Discount, and Total Quantity, with Total Net Sales being the default.
Date Range
Allows you to filter based on the transaction date. You can select start and end dates, with the default selections spanning the last six months.
Currency Type
Allows you to filter based on the currency type of the location where the transaction occurred. USD is the default unless your brand does not have any USD locations.
MORE FILTERS
Click MORE FILTERS to open a drawer from which you can choose additional filters to apply to the report, including Location, Segment, Transaction Type, Order Mode, Revenue Center, and SKU.
Although you may be able to see all of these filters, they may not all apply based on the configuration of your brand data.
If your user has a group and/or location applied in the Account menu, the data is filtered to show only data for that specific group and/or location. When these filters are applied to the report you are viewing, they appear in the More Filters section.
Once the desired filters are in place, click Update to update the report.
Report table
You can target specific data within your report by using the available filters on top. These filters include:
SKU — Shows the SKU number associated with the product.
SKU Name — Shows the name associated with the product.
Total Net Sales — Shows the total amount minus voids and discounts.
Total Discount — Shows the total amount of item level discount applied to transactions. Order level discounts are not included.
Total Quantity — Shows the total quantity of the product that has been sold.
Note: Click EXPORT in the top right corner to download the table results as a CSV. You can temporarily rearrange table columns by holding click on the column header and dragging to the left or right. These changes pass through to the export and reset when you reload the page.