The Product Sales Report is extremely flexible regarding filtering and multi-selection of locations and integrations. It contains more diverse metrics and options to get a good read on your sales numbers.
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.
There are more preset dates to select from, and with our additional columns, you can really "see" the math on how everything was calculated on the report.
For more information about retrieving your report, click this article on Saved/Scheduled Reporting.
Report Summary
The product sales report is broken down at the product/variant level.
Start by selecting a date or date range to run the report. You can manipulate the Filters and Display options before or after choosing the date/range.
With the "Filters" button, you can pick which Locations, Integrations, Categories, or Vendors the report will show. As a default, when you first run the report, we will show results for all items.
The Summary Boxes are the multi-colored boxes at the top of the report that provide a synopsis of certain aspects of the report. Included in this report are:
Quantity Sold = Total number of units sold.
Refunded = Number of units returned.
Net Product Sales ($) = Total Net sales for products sold. Tax, shipping fees, and transaction fees are excluded from this number.
Gross Profit Margin (%) = (Gross Profit ÷ Gross Sales) x 100
Net Cost of Goods Sold ($) = Gross COGS - Refunded COGS
Net Profit ($) = Total Net Profit for products sold. This figure includes adjustments to individual line items. That does not include adjustments that affect the entire order, such as transaction fees.
The "Display" button will allow you to customize the report's columns. The available columns include:
Product
Variant
Categories*
Vendors*
SKU*
Barcode*
Sold = total number of units sold before refunds
Refunded = number of units refunded
Restocked* = number of units restocked after being refunded
Net Sold* = Sold - Refunded
Discounts* = Total line item discounts (does not include transaction-level discounts)
Modifiers* = Total collected for item modifiers
Gross Sales = Total sales including modifiers and discounts (does not include tax or refunds)
Refunds = Total line item refunds
Net Product Sales = Gross product sales - refunds
Gross COGS* = Total cost of goods sold, including modifiers (before refunds)
Refunded COGS* = total cost of goods of refunded units
Net COGS = Gross COGS - Refunded COGS
Gross Profit* = Gross Sales - Gross COGS
Gross Margin* = Gross Profit ÷ Gross Sales
Refunded Profit* = Total profit lost to refunds
Net Profit = Gross Profit - Refunded Profit
Net Margin = Net Profit ÷ Net Sales
*able to toggle on with the Display button
The Summary Boxes are the multi-colored boxes at the top of the report that provide a synopsis of certain aspects of the report. Included in this report are:
Quantity Sold = Total number of units sold.
Refunded = Number of units returned.
Net Product Sales ($) = Total Net sales for products sold. Tax, shipping fees, and transaction fees are excluded from this number.
Gross Profit Margin (%) = (Gross Profit ÷ Gross Sales) x 100
Net Cost of Goods Sold ($) = Gross COGS - Refunded COGS
Net Profit ($) = Total Net Profit for products sold. This figure includes adjustments to individual line items. That does not include adjustments that affect the entire order, such as transaction fees.
Downloading your Report
To save your report (or schedule it to run for you), click the "Actions" button. Options to "Schedule this Report" or download as a PDF or CSV will be available. For more information on saving and scheduling reports, click here:
Things to Note:
At the bottom left corner of the page, you'll be able to navigate through pages using bottom the arrow buttons.
Show more products per page by selecting a new option on the bottom-right of the page.
Click on the column heading to re-sort the entire report.
COGS pulls from the lot costs of the product.
The formulas for Gross Margin and Net Margins (profit ÷ revenue) include sales without a cost entered.
NOTE: If a profit margin is lower than expected, check your lot costs for that product.