Quick overview of Shopify Inventory Value Report

Learn how to build, understand and use inventory value reports.

Conventionally, all inventory reports can be divided into 3 groups by reporting period:

Shopify Inventory Value Report

Inventory value reports provide you with precise quantitative information about the products and variants available in your locations (warehouses).

Unlike other inventory reports, the inventory value report is based only on actual stock quantities on a date:

  • month-end inventory value
  • day-end inventory value
  • current inventory value (inventory on hand), and so on.

In the general cases, an inventory value report provides stock quantity, cost, and total cost for each product or product variant that is available in your Shopify store. Additionally, the report can include the actual product price, margin rate, potential profit, etc.

By default, the report is grouped by SKU (i.e. one product - one row in the report), but for other tasks, the report can be grouped by Inventory Locations, Vendor Names, Suppliers, or even by product' ABC class.

Key Definitions

  • Financial quantity (Total Available, Quantity) - the total quantity of physical inventory.
  • Ending quantity - the total quantity at the end of the reporting period.
  • Cost - the cost of purchased merchandise
  • Price - the price of the product for the end-user.
  • Total Cost - Financial quantity × Cost
  • Margin rate, % - (Price ÷ Cost - 1) × 100%
  • Potential Profit, $ - Total Price - Total Cost

Inventory value report examples

Below we collected different variations of inventory value reports that can be generated in Shopify or with our app. Additionally to built-in reports, you can build custom Shopify reports with your own columns and filters.

Default Inventory value report

That report is a part of Shopify by default and can be extended with various product/variant attributes.

ProductsName Product VariantsName Product VariantsSKU Inventory LevelsTotal Available Inventory ItemsCost Inventory ItemsTotal Cost
Abominable Hoodie Blue / S MH09-S-Blue 671 $58.00 $38,918.00
Abominable Hoodie Green / XS MH09-XS-Green 460 $58.00 $26,680.00
Adrienne Trek Jacket Gray / XS WJ08-XS-Gray 12 $17.00 $204.00
729 $65,802.00

Inventory value report by Location

Inventory value by location is a report in Mipler: Advanced Reports app across with 10+ other built-in inventory reports.

* Products, Variants Count - total number of unique SKUs

* the total number of products and variants doesn't match the sum of row values, because the different location has the same SKUs.

LocationsName ProductsCount Product VariantsCount Inventory LevelsTotal Available Inventory ItemsTotal Cost
3400 Richmond Pkwy #2124 24 141 811 $38,918.00
241 New Jersey Rd, NJ 08030 85 443 87 $12,718.70
109 584 898 $51,636.70

Inventory value report with a pivot by Location

Pivoting by column is a unique feature of our app, that allows built use to understand reports.

LocationsName 3400 Richmond Pkwy #2124 241 New Jersey Rd, NJ 08030
ProductsName Product VariantsName Product VariantsSKU Inventory LevelsTotal Available Inventory ItemsTotal Cost Inventory LevelsTotal Available Inventory ItemsTotal Cost
Abominable Hoodie Blue / S MH09-S-Blue 599 $34,724.00 72 $4,176.00
Abominable Hoodie Blue / S MH09-S-Blue 299 $24,724.00 32 $3,721.00
Abominable Hoodie Green / XS MH09-XS-Green 52 $4,892.00 12 $5,176.00
Adrienne Trek Jacket Green / SM MH01-SM-Green 49 $9,442.00 21 $4,176.00

Inventory value report by Vendor

ProductsVendor Inventory LevelsTotal Available Inventory ItemsCost Inventory ItemsTotal Cost
Hugo 671 $58.00 $38,918.00
Arma 460 $58.00 $26,680.00
Simo&Raim 12 $17.00 $204.00
729 $65,802.00

Inventory value report by ABC class

ProductsABC Class Inventory LevelsTotal Available Inventory ItemsCost Inventory ItemsTotal Cost
A ### $##.## $##.##
B ### $##.## $##.##
C ### $##.## $##.##
### $##.##

Get rid of boring, tedious tasks.

Get full access to platform within a 14-day free trial.
No credit card required.

Start Free Trial Book 15 minute demo →