The Product Sales Report is extremely flexible when it comes to filtering and multi-selection of locations and integrations. It contains more diverse metrics and options to get a good read on your sales numbers. Not to mention it's faster. So much faster, especially for larger accounts, so you can get on with your day.
Sales are automatically imported from your point of sale provider when you first connect Thrive Inventory by Shopventory!
NOTE: If you have a lot of history, it may take some time to pull everything in. For customers with several years worth of history, it may even take a few days.
There are more preset dates to select from and with our additional columns, you'll be able to 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.
The product sales report is broken down at the product/variant level.
To get going, choose a date or date range to run the report for. You can manipulate the Filters and Display options before or after choosing the date/range.
With the "Filters" button you'll be able to 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 of the items.
The "Display" button will allow you to customize the columns of the report. The available columns include:
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 Sales = Gross 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 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. To be clear, 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.
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, be sure to check your lot costs for that product.
Still have questions? We are here to help!
Start a chat with us by clicking the chat bubble at the bottom-right of this page.