Skip to content
  • There are no suggestions because the search field is empty.

Top Selling Products Report

Top Selling Products report lists the highest-selling products to date, by product name, SKU and category including sales quantity to help identify best-performing items.

Navigation

      • Business Insight > Top Selling Products > View Full Report
      • Reports > Sales Section > Top Selling Product

1. Report Filters

Use the filter panel to define which products you want to include in the report.

Filter Options

      • End Date: Choose a custom End Date for sales activity.
      • Branch: Choose the store branch. Default is current branch; supports multiple selection.
      • Type: All / Cannabis / Non-Cannabis
      • Category: Filter product by Category
      • Group By: Select the date range grouping: Daily, Weekly, or Monthly

Actions

      • VIEW REPORT – Generates the full report with tables & charts.
      • DOWNLOAD REPORT – Exports results in CSV format.

Notes on Data

      • How “Total Sold” is Calculated
        Total Sold = Sum of all quantities sold for that product within the selected branchfilters, and date range.
        Includes:
        • Completed sales
        • All valid order types included in the system’s reporting logic
        Excludes:
        • Voided transactions
        • Refunded quantities (if configured in backend rules)
      • Ranking is driven by Total Sold, not profit.
      • The report is quantity-based, not revenue-based.
      • Results depend on:
        • Branch configuration
        • Transaction status rules
        • Product categorization accuracy

 

2. Top Selling Products Detail Grid

This is the main section of the report, listing all product-level transactions.

Columns

      • Product Name
      • SKU
      • Category
      • Total Sold

3. Data Grid

Resizing & Reordering

      • Drag the right edge of the column to resize
      • Drag headers left/right to reorder

4. Exporting Data

Click Download Report to export a CSV that includes:

      • ProductId
      • TotalSold
      • ProductName
      • SKU
      • CategoryId
      • CategoryName
      • IsCannabis

5. Tips for Effective Use

To get the most value from the Top Selling Products Report, consider the following best practices:

Use consistent time checkpoints

Run the report on the same day each week or month (for example, every Monday or on the 1st of each month). This makes trends easier to compare over time and avoids misleading spikes.

Compare branches, not just totals

Switch between branches to spot:

      • Local best-sellers
      • Underperforming locations
      • Inventory imbalance between stores

This is especially useful for stock transfers and targeted promotions.