The Sell-Through Report provides a way to see how fast your products are selling by comparing the amount of inventory received against what's actually sold in the selected time period.
Make purchasing decisions, pricing adjustments, and uncovering dead inventory based on the numbers, instead of your gut.
NOTE: Our Purchase Orders, PAR Levels, Alerts, Product Sales Report, and Dead Inventory Report will also help with those issues.
Running the Report
From the Reports sections in Thrive, click Sell-Through Report.
Select the date range you want to run the report for. Use the filters to pinpoint the products you care about most.
When you’re ready to see the results, click “Generate” or “Schedule.”
Since the report processes a lot of information, the results can be emailed to you directly.
The columns in this report include:
The current retail price.
A range of costs applied to the units in stock.
(Price - Cost) ÷ Cost, converted to a percentage, where Cost is the average Cost/unit
Units in stock at the end of the specified date range
Total cost of the units in stock
In Stock x List Price
The sum of (Price - Cost) for each unit in stock with a cost
Total number of units sold, before refunds
Number of units refunded
Number of units restocked after being refunded
Sold - Refunded
Net Sold ÷ (Net Sold + In Stock at end of the period)
Total line item discounts -- does not include transaction-level discounts
Total collected for item modifiers
Total sales including modifiers and discounts - does not include tax or refunds
Total line item refunds
Gross Sales - Refunds
Total cost of goods sold, including modifiers (before refunds)
Total cost of goods of refunded units
Gross COGS - Refunded COGS
Gross Sales - Gross COGS
Gross Profit ÷ Gross Sales
Total profit lost to refunds
Gross Profit - Refunded Profit
Net Profit ÷ Net Sales
NOTE: The columns in bold are enabled automatically. To enable the fields in italics, click “edit” next to Table Columns.
Calculating the Sell-Through %
The Sell-Through % is calculated as:
Total number of items sold
Total number of items sold + In Stock at the end of the period
Downloading your Report
To start processing your report, click the "Generate" button. Choose whether or not you want an email notification sent to your inbox, and then hit “Save” and the report will start processing in the background.
The report can also be scheduled by clicking the “Schedule” button. For more information about retrieving your report, click this article on Saved/Scheduled Reporting.
This report is only available from Thrive as a CSV, but once you download and open the report, you can export it as a PDF.
Things to Note:
At this time, this report cannot span more than a month.
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.