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.
If you are looking for more information on the old Sales Report, click here!
The product sales report is broken down at 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.
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 included 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 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 Profit for products sold. This figure does not include adjustments that apply to the sale but not individual line items, such as transaction fees.
Net Profit = Total Net Profit for products sold. This figure does not include adjustments that apply to the sale but not individual line items, 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 you. 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 column heading to re-sort the entire report.
The formulas for Gross Margin and Net Margins (profit / revenue) includes sales without a cost entered.
NOTE: If a profit margin is lower than expected, be sure to check your lot costs for that product.
The (old) Sales Report
Sales are imported from your point of sale provider when you first connect Thrive Inventory by Shopventory! 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.
Click the following links for more information on:
You'll notice a handful of Summary Boxes at the top of this report. These are meant to give you a quick overview of the numbers calculated from the the report, so you can have that information at your fingers tips and spot and red-flags faster. Be sure to hover over the info bubble to get important information pertaining to that summary box:
The columns in this report include:
Total Revenue (this number may appear higher than net sales. Transaction level discounts not included)
Costs of goods sold (COGS)
Total Profit (including a profit margin %)
Profit Margin (%) will be it's own column when exported as a CSV
Things to Note:
Sales totals are broken down by each Variant.
To view Cost History or Inventory History, you must have only one location selected (if you have more than one Shopventory location). Once only one location is selected the number of units sold and costs of good sold will be clickable.
The "Gross Profit" figure for Square POS accounts for fees, so it may be lower than the sum of the "Total Profit" column in the Itemized table.
Profit reports are generated from the time of Thrive Inventory's installation going forward. Thrive Inventory will not assume that current Cost values apply retroactively, so profits are not available for any day prior to installation. You can backfill historical costs manually, however. Learn more
Anytime you see a chart in Thrive Inventory, just hover over the chart with your mouse to see the information contained in that graphic.
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.