---
title: Product Sales Report
description: The Product Sales Report provides detailed sales information for each product, including quantity sold, base price, selling price, margin, cost, and refund history. This report is designed for detailed product-level analysis.
---

[Skip to content](https://knowledge.techpos.ca/en/knowledge/product-sales-report#main-content)

[Customer portal](https://knowledge.techpos.ca/portal?hsLang=en)

![TECHPOS\_Full-Logo\_Brand-Colorsmaller](https://knowledge.techpos.ca/hs-fs/hubfs/TECHPOS_Full-Logo_Brand-Colorsmaller.png?width=500&height=125&name=TECHPOS_Full-Logo_Brand-Colorsmaller.png)

Open main navigation

Close main navigation

- [Customer portal](https://knowledge.techpos.ca/portal)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://knowledge.techpos.ca/en/knowledge?hsLang=en)
2. [Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en)
3. [Sales Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#sales-reports)

# Product Sales Report

## The Product Sales Report provides detailed sales information for each product, including quantity sold, base price, selling price, margin, cost, and refund history. This report is designed for detailed product-level analysis.

**Navigation Steps:** Go to Menu \> Reports \> Product Sales

**1. Report Filters**

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

![](https://techposdev.blob.core.windows.net/newfeatureimages/AgGridProductSalesReport1.png)

**Filter Options**

- **Begin Date / End Date**
  
  Choose a custom range for sales activity.

- **Branch**
  
  Choose the store branch, default is current branch, support multiple selection.

- **Category / Sub Category**
  
  Narrow results to a specific product group.

- **Weight (g)**
  
  Filter cannabis items by weight (e.g., 1g, 3.5g, 7g, 28g).

- **Brand Name Filter**
  
  Enter a brand name to limit results

- **Supplier Filter**
  
  Filter products by supplier.

- **Product Search**
  
  Search by product name, SKU, or UPC.
  
  (Requires at least 3 characters to start searching.)

**Actions**

- **VIEW REPORT** - Generates the full report with tables & charts.

- **DOWNLOAD REPORT** – Exports results in CSV format.

**Notes on Data**

- Only completed and refunded products are included.
- Tax is excluded from product-level sales figures.
- Refunded products appear as: 
    - One row for the original sale
    - One row for the refund (shown with negative values)
- Summary totals exclude: 
    - Refund tax
    - Refund deposits
- Discounts and gross sales reflect sales only (not refunds).

**2. Summary Section**

Once the report loads, a summary bar shows totals for the selected time period

(Including Overall and the Summary by Category)

![](https://techposdev.blob.core.windows.net/newfeatureimages/AgGridProductSalesReport2.png)

**Summary by Category Data Grid**

Columns include:

- Category
- HST
- Discount
- Deposit Amount
- Gross Sales

Filters and sorting are available for each column.

**3. Sales Charts**

Scroll down to view detailed time-based charts:

![](https://techposdev.blob.core.windows.net/newfeatureimages/AgGridProductSalesReport3.png)

**Hourly Plots**

- Net Sales
- Average Transaction Amount
- Net Number of Transactions

 These charts help visualize peak sales hours and transaction trends.

**4. Product Sales Detail Grid**

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

![](https://techposdev.blob.core.windows.net/newfeatureimages/AgGridProductSalesReport4.png)![](https://techposdev.blob.core.windows.net/newfeatureimages/AgGridProductSalesReport5.png)

**Columns**

- Branch Name
- Date
- Product Name
- Status (Completed / Refunded)
- Quantity (negative qty for refunds)
- Recent PO#
- Discount $
- Deposit Amount
- Gross Sales (positive or negative)
- Weight
- Total Base Price
- Total Selling Price
- Profit Margin
- Cannabis Name
- Lot#
- Refund Reason
- Note

Refund rows always contain negative values for quantity and sales.

**5. Data Grid (Sorting, Filtering, Search)**

**a. Sorting**

Click column headers to sort ascending or descending.

**b. Filtering**

Each column has:

- A search box (text match)
- A filter button (conditions such as equals, contains, greater than)

Examples:

- Filter Status = Refunded
- Search “Pineapple” in Product Name
- Filter Gross Sales \< 0 to see losses/refunds only

**c. Resizing & Reordering**

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

**6. Exporting Data**

Click **Download Report** to export a CSV file containing:

- Product-level sales rows
- Refund rows
- Category summary (if applicable)
- All filtered results

Exports respect:

- Date range
- Branch
- Category
- Brand
- Search terms
- Weight / supplier filters

**7. Tips for Effective Use**

- Use Product Search or Brand Filter when you know the specific SKU you’re investigating.
- Use Status filter to isolate refunded items.
- Use Weight + Category filters for cannabis compliance reporting.
- Export the CSV for deeper analysis

- [Line of Products](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#main-content)

    - [Express Checkout](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#express-checkout)
    - [E-Commerce](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#e-commerce)
    - [Digital Signage](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#digital-signage)
    - [Cannabis Analytics](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#cannabis-analytics)
    - [Auto Tag](https://knowledge.techpos.ca/en/knowledge/line-of-products?hsLang=en#auto-tag)
- [Getting Started](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#main-content)

    - [Hardware Setup](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#hardware-setup)
    - [Online Menu Setup](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#online-menu-setup)
    - [Integrations](https://knowledge.techpos.ca/en/knowledge/getting-started?hsLang=en#integrations)
- [Business Insights](https://knowledge.techpos.ca/en/knowledge/business-insights?hsLang=en)
- [Point of Sale](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#main-content)

    - [POS Sales Configuration Options](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#pos-sales-configuration-options)
    - [Opening & Closing The Cash Register](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#opening-closing-the-cash-register)
    - [Processing In-Store Transactions](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#processing-in-store-transactions)
    - [Managing Members](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#managing-members)
    - [Refunds](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#refunds)
    - [Store Credit](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#store-credit)
    - [Discounts](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#discounts)
    - [Payment](https://knowledge.techpos.ca/en/knowledge/point-of-sale?hsLang=en#payment)
- [Inventory](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#main-content)

    - [Products](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#products)
    - [Categories](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#categories)
    - [Purchase Orders](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#purchase-orders)
    - [Warehouse](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#warehouse)
    - [Bulk Transfer](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#bulk-transfer)
    - [Product Hub](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#product-hub)
    - [Inventory Audit](https://knowledge.techpos.ca/en/knowledge/inventory?hsLang=en#inventory-audit)
- [Vendor](https://knowledge.techpos.ca/en/knowledge/vendor?hsLang=en)
- [Users](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#main-content)

    - [Member](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#member)
    - [Employee](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#employee)
    - [User Role](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#user-role)
    - [Member Group/Tiered Membership](https://knowledge.techpos.ca/en/knowledge/users?hsLang=en#member-group-tiered-membership)
- [Admin](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#main-content)

    - [Cash Register](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#cash-register)
    - [Safe Management](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#safe-management)
    - [Shifts](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#shifts)
    - [Schedules](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#schedules)
    - [Orders](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#orders)
    - [Marketing](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#marketing)
    - [Settings](https://knowledge.techpos.ca/en/knowledge/admin?hsLang=en#settings)
- [Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#main-content)

    - [Sales Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#sales-reports)
    - [Cash Management](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#cash-management)
    - [Employee](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#employee)
    - [Inventory](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#inventory)
    - [Consolidated Reports](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#consolidated-reports)
    - [Members](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#members)
    - [Compliance](https://knowledge.techpos.ca/en/knowledge/reports?hsLang=en#compliance)
- [Pricing](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#main-content)

    - [Tax Setting](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#tax-setting)
    - [Campaigns](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#campaigns)
    - [Combo](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#combo)
    - [Customized Discount](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#customized-discount)
    - [Bulk Price Update](https://knowledge.techpos.ca/en/knowledge/pricing?hsLang=en#bulk-price-update)
- [Web Menu](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#main-content)

    - [Store Rules List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#store-rules-list)
    - [Menu (Categories) List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#menu-categories-list)
    - [Carousel List](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#carousel-list)
    - [UI Setting](https://knowledge.techpos.ca/en/knowledge/web-menu?hsLang=en#ui-setting)
- [Integrations](https://knowledge.techpos.ca/en/knowledge/integrations?hsLang=en#main-content)

    - [E-Commerce](https://knowledge.techpos.ca/en/knowledge/integrations?hsLang=en#e-commerce)
- [Compliance Report](https://knowledge.techpos.ca/en/knowledge/compliance-report?hsLang=en)
- [FAQs](https://knowledge.techpos.ca/en/knowledge/faqs?hsLang=en)
- [New Features](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#main-content)

    - [July 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#july-2025)
    - [June 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#june-2025)
    - [May 2025](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#may-2025)
    - [February 2026](https://knowledge.techpos.ca/en/knowledge/new-features?hsLang=en#february-2026)
- [PAT](https://knowledge.techpos.ca/en/knowledge/pat?hsLang=en#main-content)

    - [Product Auto Tags](https://knowledge.techpos.ca/en/knowledge/pat?hsLang=en#product-auto-tags)

[![Chill listening crop-3](https://knowledge.techpos.ca/hs-fs/hubfs/Logo-2021.png?width=175&height=55&name=Logo-2021.png "Chill listening crop-3")](http://techpos.ca)

Knowledge Base

Copyright © 2026, TechPOS International Corp.