The Inventory Report shows a snapshot of what your inventory is (or was) at any given time. As long as Thrive Inventory by Shopventory was installed at the moment, we can tell you exactly what you had on the shelves! And now, you can get those numbers even faster.

The Inventory Report will show your total value of inventory (current or historic). This means you know your total cost of inventory in seconds.

Products or services with quantity tracking "Disabled" will not be included in the inventory report. Since Bundles do not contribute uniquely to inventory value, these are excluded. Products with negative quantities in stock do not count against inventory value.

  • NOTE: If you plan to reverse your bundle/component setups, be aware that you will be essentially starting with a new set of inventory and inventory history for those products. We encourage you to download any relevant reports before making the switch.

To get started, enter the point in time you want the report generated for, or select from one of the presets. The inventory report will be generated for a specific moment in time, vs. a Sales Report where you might want to see a range (whether that's 24 hours, a week, month or year). If you are wanting to see how your inventory has changed over a period of time, we recommend generating an Inventory Change Report.

Once that report has been generated, you'll see a screen that looks similar to this:

For more information on the Old Inventory Report, click here.

Report Summary

We've added a Potential Profit summary box, along side the existing Total Value, Potential Revenue and Quantity in Stock.

You can use the Filter button, or Search field to narrow your scope. When you filter the report in anyway, the summary boxes above will show the new results based on the filter.

The "Display" button will allow you to customize the columns of the report. The available columns include:

  • Product

  • Variant

  • Location

  • Categories*

  • Vendors*

  • SKU*

  • Barcode*

  • In Stock = Units in stock at the specified time

  • List Price = Current retail price

  • Cost/Unit = Range of costs applied to the units in stock

  • Total Value = Total cost of the units in stock

  • Potential Revenue = In Stock x List Price

  • Potential Profit = The sum of (Price - Cost) for each unit in stock with a cost

  • Profit Margin % = (Price - Cost) / Cost, converted to a percentage, of the current lot

  • Markup* = (Price - Cost) / Cost, converted to a percentage, of the current lot

*Click the "Display" button to enable these options

If a product was received at varying costs, the cost column will be listed as a range. This happens because we calculate cost on the inventory report based on lot cost (not default cost). If you would like to spot-check a product to ensure the right cost is being calculated, you can do that in the lot history.

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:

  • Total Value

  • Potential Revenue

  • Potential Profit

  • Quantity in Stock = Sum of In-Stock column

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 (old) Inventory Report

The (old) Inventory Report (click here) provides much of the same information, but is a slightly limited when compared to the new version.

Click the following links for more information on:

Report Summary

The columns on the Inventory Report include:

  • Product

  • Variant

  • Location

  • List Price

  • In Stock

  • Cost/unit

  • Total Value

  • Potential Revenue

  • Potential Profit (including a Profit Margin %)

Related Articles

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.

Did this answer your question?