Shopventory's inventory reports show a snapshot of what your inventory is (or was) at any given time. As long as Shopventory was installed at the moment, we can tell you exactly what you had on the shelves!
The Inventory Report will also 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 on the inventory report. Since Bundles do not contribute uniquely to inventory value, these are excluded as well. Products with negative quantities in stock do not count against inventory value.
Pulling an Inventory Report
To view your Inventory Reports, simply go to the Reports section in Shopventory and click on the Inventory Report option.
You can customize the date and time of the snapshot in the upper right-hand menu. Make sure your Timezone Settings are correct.
You can also filter the report by Category before pulling the report (this will help speed things up for you if you're only interested in a single Category's info:
Inventory totals are broken down by each Variant. Just scroll down to view the full Report in detail.
- Reports can be filtered by Location.
- Reports can also be filtered by Category.
- The search box can be used to filter by keyword.
Export / Print an Inventory Report
You will notice PDF and CSV options to export just below the date and time selection.
- Filters that have been applied on the page will be applied on export.
- A PDF file is a better choice if you prefer to print a hard copy.
- A CSV file is a spreadsheet file format that is better if you plan to use a spreadsheet program like Microsoft Excel™ or Google Sheets™.
The same Product may show more than once...
This is actually due to the different Lots in inventory. Because different lots (or shipments) can come in at different costs, each lot affects inventory value on its own terms. Shopventory will display Products with multiple lots at different costs on their own row in the Inventory Report. Learn more
Pro-Tip: Use the Keyword Filter to search for specific Variants or Product groups.
- Inventory Costs
- Sales Reports
- Dead Inventory Reports
- Inventory Alerts
- Stock Remaining Reports
- Timezone Settings
Let us know if you have questions. We are here to help!