How do I get a month-end inventory value on Shopify?

Turn on snapshots in the inventory value report (weekly or monthly). Any saved snapshot date then shows that day's totals and per-product detail, which is the month-end number accountants ask for.

Why does a product show zero inventory value?

A variant with no cost set counts as zero at cost until you add its cost, in Shopify or in the app. The report shows a banner when variants in stock are missing costs.

Should inventory be valued at cost or retail?

At cost for accounting and month-end reporting. Retail value is useful commercially: the gap between the two is your unrealized margin, the profit still sitting on the shelf.

All use cases

How-to - inventory

How to find your total inventory value on Shopify

Q: How do I find my total inventory value on Shopify?

Multiply units on hand by cost per unit across all products and locations. Easy Profit Calculator's inventory value report does this automatically, valued at cost and at retail, with an all-locations total.

Short answer

Your inventory value is units on hand multiplied by cost per unit, summed across every product and location - and it only works if each variant has a cost set. Easy Profit Calculator's inventory value report does the sum for you: current stock valued at cost and at retail, split by location, with a trend over time and saved snapshots so you can pull the month-end number your accountant asks for. It is available on every plan, including free, with CSV export.

How it works

Make sure your products have costs

Inventory value at cost is only as complete as your cost data. Set cost per item on your Shopify variants, or use cost rules and CSV import in the app. Variants without a cost count as zero, and the report shows a banner when that is happening.

Open the inventory value report

The locations table totals your current stock at cost and at retail, with unrealized margin (the gap between the two), margin percent and SKU count per location, plus an all-locations total.

Turn on snapshots for month-end numbers

Choose weekly or monthly snapshots, or take one right now. From then on you can switch the "Stock as of" date to any saved snapshot and read that day's totals - which is exactly the month-end inventory value accountants ask for.

Export the detail when someone needs proof

Each location has a per-product table with SKU, quantity, unit cost, stock value and retail value, and its own CSV export. Snapshots store the same detail going forward, so a saved date exports too.

What you get

Stock valued at cost and at retail, by location
Unrealized margin per location: retail value minus cost value
Weekly or monthly snapshots for month-end reporting
A stock-value trend since your first snapshot
CSV export on every plan, including free

Why cost and retail are both worth watching

Value at cost is the accounting number: the cash currently sitting on your shelves, the one that belongs in month-end reporting. Value at retail is the commercial one: what that stock would bring in if it all sold at current prices. The gap between them is your unrealized margin, and watching it per location tells you where your buying is strongest.

The trend line matters more than either single number. Stock value climbing while sales stay flat means cash is quietly converting into shelves - usually the first visible sign of an overbuying problem.

From knowing the value to acting on it

Once you can see what the stock is worth, the next question is which part of it is dead weight. The products not selling report lists stock with no recent sales, and the inventory profit health report scores where stock value and profit pull in different directions.

For the month-end routine, schedule the report by email so the numbers arrive without anyone remembering to pull them (scheduling needs the Pro plan; viewing and exporting works on free).