The Inventory Report shows a snapshot of your inventory at any given point in time. As long as Thrive was installed at the time selected, the report can show exactly what was on the shelves.
The Inventory Report reflects total value using lot cost rather than default cost, to ensure totals are as accurate as possible.
📋 This article covers the updated Inventory Report. If you have questions about the transition, see New Reports Experience — What's Changed.
Running the Report
Select a point in time to generate the report. Choose from a preset or enter a custom date and time.
Preset options: Now, Yesterday, Last Month, Last Year
Use the Filters button to narrow results by:
Locations
Active — Active or Inactive
Stock — In Stock or Out of Stock
Date Created — Today, Yesterday, Last 7 Days, Last 30 Days, Last 4 Weeks, This Week, Last Week, This Month, Last Month, This Year, Last Year, or Custom Range (select a start and end date)
Categories
Vendors
Pro Tip: Filters and the Search field affect the numbers shown in the Summary Tiles. Make sure your filters reflect the full scope you want before referencing tile totals.
Summary Tiles
The tiles at the top of the report provide a quick snapshot of your inventory at the selected point in time.
Total Value — Total cost of all units currently in stock.
Potential Revenue — In Stock × List Price across all products.
Potential Profit — Sum of (List Price − Cost) for each unit in stock with a cost entered.
Quantity in Stock — Sum of all in-stock quantities.
Columns
Use the Manage Column button to show or hide columns.
Column | Definition |
Product | Product name |
Variant | Variant name, if applicable |
Location | Location where inventory is held |
Categories | Assigned categories |
Vendors | Assigned vendors |
SKU | Product SKU |
Barcode | Product barcode |
In Stock | Units in stock at the specified time |
List Price | Current retail price |
Potential Revenue | In Stock × List Price |
Cost/Unit | Range of costs applied to units currently in stock |
Total Value | Total cost of units in stock |
Potential Profit | Sum of (List Price − Cost) for each unit in stock with a cost entered |
Profit Margin | (List Price − Cost) ÷ List Price, expressed as a percentage of the current lot |
Markup | (List Price − Cost) ÷ Cost, expressed as a percentage of the current lot |
Note on Cost/Unit ranges: Products received at varying costs display as a range in the Cost/Unit column. This is because the Inventory Report calculates cost using lot cost, not default cost. To verify the cost applied to a specific product, check its lot history.
Notable Exclusions
The following are not included in the Inventory Report:
Products with inventory tracking disabled. See Inventory Tracking.
Bundles, as they are comprised of other products already included in the report and do not independently add to inventory value. Note: if you plan to reverse your bundle or component setup, download any relevant reports first — you will start with a new inventory set and history for those products after the change.
Products with a null quantity. A null quantity means no inventory history exists (blank cell), which is different from zero. A quantity of zero indicates some inventory history and will still appear on the report.
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 Actions > Schedule Report.
Things to Note
Products with negative quantities in stock do not count against inventory value.
Total Value is calculated using lot costs.
Click any column header to re-sort the report.
Column totals vs. Summary Tiles: Column totals are calculated by summing already-rounded row values, while Summary Tile values round only at the end. If there is a small discrepancy between the two, the Summary Tile value is more precise.