📋 This article covers the updated Product Sales Report. If you have questions about the transition, see New Reports Experience — What's Changed.
The Product Sales Report breaks down sales data at the product and variant level, giving you a detailed view of gross and net sales, COGS, profit, and margins across your locations and channels.
The last 90 days of sales are automatically imported from your point of sale provider when you first connect Thrive. If you need sales data from further back, please contact Customer Care.
Running the Report
Select a date range to run the report. You can apply filters before or after selecting your dates.
Preset date ranges available: Today, Yesterday, Last 7 Days, Month to Date, Last Month, Year to Date, Last Year
Use the Filters button to narrow results by:
Locations
Sales Channels
Categories
Vendors
Invoice Type (Regular or Wholesale)
Search for specific products to refine your search even more!
Summary Tiles
The tiles at the top of the report provide a quick snapshot of your results for the selected date range.
Quantity Sold — Total units sold.
Refunded — Total units returned.
Net Product Sales ($) — Gross product sales minus refunds. Excludes tax, shipping, and transaction fees.
Gross Profit Margin (%) — (Gross Profit ÷ Gross Sales) × 100. Example: $600 gross profit on $1,000 gross sales = 60% margin.
Net COGS ($) — Gross COGS minus Refunded COGS.
Net Profit ($) — Net Product Sales minus Net COGS. Includes adjustments to individual line items; excludes order-level fees.
Columns
The report displays the following columns. Use the Manage Column button to show or hide columns.
Column | Definition |
Product | Product name |
Variant | Variant name, if applicable |
Sold | Total units sold before refunds |
Refunded | Units returned |
Net Sold | Sold minus Refunded |
Gross Sales | Total sales including modifiers and discounts; excludes tax and refunds |
Refunds | Total value of line-item refunds |
Net Product Sales | Gross Sales minus Refunds |
Restocked | Units returned to inventory after refund |
Discounts | Total line-item discounts; excludes transaction-level discounts |
Modifiers | Total collected for item modifiers |
SKU | Product SKU |
Barcode | Product barcode |
Categories | Assigned categories |
Vendors | Assigned vendors |
Gross COGS | Total cost of goods sold including modifiers, before refunds |
Gross Profit | Gross Sales minus Gross COGS |
Gross Margin | Gross Profit ÷ Gross Sales |
Net COGS | Gross COGS minus Refunded COGS |
Net Profit | Gross Profit minus Refunded Profit |
Net Margin | Net Profit ÷ Net Product Sales |
Refunded COGS | Cost of goods for refunded units |
Refunded Profit | Total profit lost to refunds |
Exporting & Scheduling
Click the Download button to export the report. Available options:
PDF — Full report as a PDF
CSV — Full report as a CSV
Summary PDF — Column totals only
Summary CSV — Column totals only
To schedule reports, click the Actions button>Schedule Report.
Gift Cards
When a gift card is sold, it appears as a $0 sale. When redeemed, the sale is attributed to the products purchased — keeping your sales reports accurate and consistent with GAAP accounting standards.
Things to Note
Click any column header to re-sort the report.
COGS pulls from lot costs. If a margin looks off, check your lot costs.
Gross Margin and Net Margin calculations include items without a cost entered.
Reports spanning more than a month cannot be scheduled.