Top Item Reports

The Top Items Report helps you identify your best-performing products based on key business metrics. It gives you quick insights into which items are driving sales, maintaining strong inventory turnover, and generating the most profit — so you can make smarter decisions about purchasing, pricing, and promotions.

This report can be grouped and filtered to view performance by Category, Department, or Subcategory, making it easy to analyze trends across different product segments.

Navigate to Console → Reports → Inventory Reports → Top Items Report

Before running the report, you can configure the following filters and controls:

• Date Range: Select the time frame for your report/choose from preset options like Current Month and Previous Month, or set a custom date range.
• Group By: Decide how you’d like to organize your data. You can group by Category, Department, or Subcategory. To view results at the individual item level, simply clear the grouping.
  
• Rank By: Determine how your top items are ranked. Options include:
  • Total Sales (default)
  • Quantity Sold
  • Quantity on Hand
  • Sell-Through %
  • Quantity in PO
  • Profit %
    
• Location: Filter the report to show data for one or multiple store locations.
• Show Top: Choose how many top items to display per group. Options include 10, 25, 50, or All. The default setting is Top 10.

The Top Items Report presents item-level or grouped data in a tabular format.

Each row represents an item, with key details shown in the following columns:

• Rank: Displays the item’s position within its group based on the selected “Rank By” metric.
• Item ID: The unique product identifier
• Description: The product name or description
• UPC: The item’s Universal Product Code.
• Qty Sold: Total number of units sold during the selected report period.
• Total Sales: The total sales amount during the selected report period.
• Qty on Hand: The current quantity of the item available in inventory.
• Sell-Through %: Measures how much inventory has been sold.
• Qty on PO: The total quantity currently on open Purchase Orders. Status may include Approved, Sent, Partially Received, or Modified.
• Profit %: The profit margin percentage.

Note: Aggregated values for percentage columns (e.g., Sell-Through %, Profit %) may appear blank when data is summarized across groups.

User can also export the report from this screen.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more