Inventory turnover ratio — compute it from your Shopify exports and read it honestly

Your inventory turnover ratio is the cost of goods you sold in a period divided by your average inventory value over that same period — it answers "how many times did my stock dollars turn into sales dollars this year?" A store doing $600,000 in COGS on $150,000 of average stock turns 4×: each inventory dollar became four sales dollars annually. The formula is one division; the honest part is that the inputs come from your own exports and the interpretation depends entirely on your category. Here's a fill-in worksheet to compute yours from Shopify data tonight, and how to read the result without borrowing someone else's benchmark.

Fill-in worksheet: compute yours in 15 minutes

Fill these in as you go. Every input comes from your Shopify admin or a CSV export — no app required.

Inputs

1. COGS for the last 12 months. If you maintain the Cost per item field, Shopify's profit reports give you this directly (Reports → profit, or a sales-by-product export with costs — Shopify Help Center, profit reports and cost-per-item documentation, accessed October 2026). If your cost field is incomplete, fix that first — a turnover computed on revenue or on half-populated costs is a number that means nothing. The cost-per-item mechanics are covered in the COGS guide if you need the setup.
2. Inventory value at the start of the period. The total value of on-hand stock 12 months ago — from an inventory snapshot, your books, or your accounting year-end count.
3. Inventory value at the end of the period. Same measurement, today.

Arithmetic

• Average inventory value = (start value + end value) ÷ 2 = ______
• Turnover = annual COGS ÷ average inventory = ______

Sanity checks before you trust it:

• Both inventory values must be at cost, not retail. Mixing a retail-valued snapshot into a cost-based average inflates inventory and understates turnover.
• Use the same valuation basis at both endpoints.
• If you carried dramatically different stock levels across the year (a big Q4 build), the two-point average blurs that — see the averaging discussion in average inventory.

Worked example. A spice shop: COGS last 12 months = $210,000; stock at cost was $48,000 a year ago and $52,000 today. Average = $50,000. Turnover = 210,000 ÷ 50,000 = 4.2×.

Reading the number: category sets the frame, not a benchmark table

The same ratio means opposite things in different categories:

• 4.2× for spices is plausible — shelf-stable goods with moderate velocity.
• 4.2× for fresh pet treats would be alarming — short-life goods should turn far faster before they expire on the shelf.
• 4.2× for vinyl records might be excellent — slow-turning collectible depth is often the point of the assortment.
• 4.2× for fishing lures entering a new season could mean the seasonal build hasn't had its selling window yet — a "low" ratio that's just mistimed.

This is why published "good turnover" tables deserve skepticism: they average across catalog mixes, valuation methods, and seasonal timing you can't see. Treat any universal benchmark as an assumption, not a law.

Self-baselining: the only comparison that's actionable

Your useful comparisons are internal:

1. You vs you, last year. Same formula, same period length, 12 months apart. Direction and consistency beat level.
2. Category vs category inside your own store. Compute turnover per product type (you have COGS by product in the export). The spread tells you where cash is working and where it's parked — a kitchen-knives line turning 6× beside a slow 1.5× art-supplies line is a buying-allocation insight no store-wide average can give you.
3. Turnover vs the stock you can't sell. A healthy aggregate ratio can hide a pile of dead SKUs being offset by fast movers; the aging view exposes that.

A target built this way — "lift the tail categories one turn this year" — is defensible. A target built from a magazine benchmark is decoration.

What turnover doesn't tell you

The ratio is a result, not a control. It moves for reasons ranging from excellent buying to a fire-sale markdown, and it can't distinguish them:

• High turnover can mean tight, disciplined buying — or chronic dark days on heroes (you sold out and lost the rest of the period's sales) — or a markdown clearing the slate. All three raise the ratio.
• Low turnover can mean over-buying — or deliberate seasonal buildup (a camping-stove buy landed in September for Q4), or intentional depth on slow, high-margin collectibles.

That ambiguity is why turnover works best paired with a speed metric. Days of cover answers "how many selling days until I'm dark, per SKU" — a forward-looking operational number — while turnover is backward-looking and store-wide. The pair together catch what either alone misses: strong cover with falling turnover means stock is arriving faster than it sells; strong turnover with collapsing cover means you're about to start missing sales.

Where it fits in the measurement stack

Turnover is one of a small set of numbers worth a monthly look — cover, sell-through, aging, and margin metrics each answer a different question, and the full set with the weekly rhythm around them is covered in the inventory KPIs guide. If you want the capital-efficiency version — turnover scored against margin rather than read alone — that's GMROI, which divides gross profit by average inventory cost and answers "does this stock pay for itself?"

Common questions

What is the inventory turnover ratio formula? Inventory turnover = cost of goods sold ÷ average inventory value, both for the same period and both at cost. Example: $210,000 annual COGS ÷ $50,000 average stock = 4.2 turns per year. Using retail value in the denominator or mixing valuation bases corrupts the comparison.

How do I calculate inventory turnover from Shopify? Pull annual COGS from Shopify's profit reports (requires the Cost per item field to be populated), take inventory value at cost from two snapshots 12 months apart, average them, and divide. It's a spreadsheet job — about 15 minutes — because Shopify doesn't report turnover natively as of October 2026 (Shopify Help Center, inventory and profit reports documentation, accessed October 2026).

What is a good inventory turnover ratio? There's no trustworthy universal number — the same ratio is healthy in one category and broken in another, and published benchmarks mix methods and seasons. Baseline against your own store: this year vs last year, and per product type within your catalog. Target improvement against your own baseline, not a table.

Is higher inventory turnover always better? No. Very high turnover can signal chronic under-buying — you're selling out and losing the remainder of each period's demand — or markdown-driven clearing. It pairs best with a forward-looking metric like days of cover: strong turnover with thin cover means your buying is too tight, not too good.

Should I use COGS or revenue in the turnover formula? COGS. Revenue in the numerator inflates the ratio by your entire margin and makes the number incomparable across stores with different pricing. Every inventory value in the calculation must be at cost for the same reason — consistency of basis is what makes the ratio mean anything.

Next step

Run the worksheet on last year: two inventory values, one COGS figure, one division. Then run it again per product type using the sales-by-product export — the spread between your best and worst-turning category is the actual finding, and it usually names your next buying decision more clearly than any benchmark table could.