Shopify inventory value report

What is the stock we hold worth right now, at cost and at retail?

Install on Shopify

14-day free trial.

Know what your stock is worth, at cost and at retail

Captured dates, not just month end

Today, the last day of the quarter, the day before the sale started. Value history shows how it moved.

By location, by vendor, by type

Open "Inventory by location" for available, on hand, committed and incoming per site. Group by vendor to see where the money is sitting.

With finance before they ask

Schedule it for the first of the month as an Excel attachment. Add a Unit cost column and a filter for empty costs, and the clean-up list comes with it.

Or we build it in your shape

One row per location with cost and retail side by side? Describe it in the app and our team builds it. How it works.

What it looks like

One row per variant: the units available right now, what they cost you and what they would sell for. This version adds a Unit cost column to the built-in. The last row has no cost in Shopify, so its value at cost is $0.00 and the blank tells you which variant to fix.

Sample output, as of 8 October 2026The built-in "Inventory value by variant" report. Made-up store, made-up numbers.
SKUVariantAvailableUnit costValue at costPriceValue at retail
TR2-BLK-10Trail Runner 2, Black, 10318$41.00$13,038.00$130.00$41,340.00
TR2-BLK-11Trail Runner 2, Black, 11264$41.00$10,824.00$130.00$34,320.00
MCS-3PK-LMerino Crew Sock 3-pack, L1,020$9.40$9,588.00$28.00$28,560.00
ASJ-NVY-MAlpine Shell Jacket, Navy, M96$88.50$8,496.00$240.00$23,040.00
DP22-GRNDaypack 22L, Green141$27.20$3,835.20$90.00$12,690.00
IB750-STLInsulated Bottle 750ml, Steel455$0.00$25.00$11,375.00
Total2,294$45,781.20$151,325.00

What each number means

So the figure means the same thing to everyone who reads it.

Available
Units available to sell across your locations. On hand, committed and incoming are separate fields you can add.
Unit cost
The cost per item on the variant in Shopify.
Value at cost
Available times unit cost. A variant with no cost in Shopify contributes $0.00, and an added Unit cost column shows you which ones.
Price
The variant's current selling price.
Value at retail
Available times price. What the stock would bring in at full price.
Past dates
This report is today's picture. "Inventory on a date" and "Inventory value history" give you the same figures for any captured date.

Already have Shopify's reports?

Shopify's own reports can be edited, saved and exported to a spreadsheet (Shopify Help). That covers a one-off. ReportNerds keeps the exact version your team needs, sends it on a schedule, and our nerds build the ones you would rather not.

Want this report for your store?

Install ReportNerds and run it on your own orders, or tell us the version you need and our nerds build it. 14-day free trial.

Install on Shopify