How to Calculate Inventory Turnover Ratio for Your Shopify Store

Your inventory turnover ratio tells you how many times you sold and replaced your stock over a given period. It's one number, but it carries a lot of signal: whether you're buying too much, too little, whether your cash is sitting in boxes, and whether your product mix matches actual demand.

Most Shopify merchants don't track it. They watch revenue and orders and call it a day. That works until you run out of your best seller in peak season or find yourself sitting on $60,000 of product that nobody's buying. Turnover ratio is the metric that catches both problems early.

The inventory turnover ratio formula

There are two versions. Both are valid. Know which one you're using.

Version 1: Using cost of goods sold

Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory Value

This is the standard accounting version. COGS is the total cost of products sold in the period — what you paid for them, not what you charged customers. Average inventory is (beginning inventory + ending inventory) / 2, measured at cost.

Example: You sold $180,000 worth of product at cost over the year. Your average inventory value was $45,000. Turnover ratio = 180,000 / 45,000 = 4.0.

Version 2: Using revenue

Inventory Turnover Ratio = Net Revenue / Average Inventory Value

This is less precise for benchmarking against industry standards (which typically use COGS), but it's easier to calculate in Shopify since revenue is always visible. Average inventory here is still measured at cost if you track that, or at retail value if you don't.

Pick one and stick with it. Mixing methods between periods gives you meaningless trend data.

How to get the numbers from Shopify

Shopify doesn't have a built-in turnover ratio report. You have to assemble the inputs manually.

For revenue: go to Analytics > Reports > Sales and filter to your period. Net sales is your top-line revenue number.

For COGS: this is only available if you've entered cost per item on each product variant. If you have, Shopify includes COGS in the Finances Summary report. If you haven't tracked this, you'll need to calculate it from your purchase records.

For average inventory: go to Reports > Inventory and pull the "Inventory value" snapshot. You need the value at the start of your period and the end. Average them.

One gotcha: Shopify's inventory value report shows retail price by default for some plans. Make sure you're looking at cost-based inventory value, not retail. The two are very different and will produce a misleading ratio.

A worked example for a real Shopify store

Say you run a home goods store. Here's the data for last year:

Turnover ratio (COGS method) = 160,000 / 40,000 = 4.0

That means you cycled through your entire average inventory 4 times during the year, or roughly once per quarter. Whether that's good depends on your category — which brings us to benchmarks.

Inventory turnover benchmarks by industry

There's no universal "good" turnover ratio. It depends entirely on what you sell. Here are typical ranges for ecommerce categories:

If your ratio falls below the low end of your category's range, your cash is tied up in inventory longer than it needs to be. If you're well above the high end, you may be understocking and leaving sales on the table.

Days inventory outstanding: the other way to read it

Turnover ratio is useful but abstract. Days Inventory Outstanding (DIO) converts the same data into "how many days does inventory sit before it's sold" — which is easier to act on.

DIO = 365 / Inventory Turnover Ratio

Using the home goods example above: 365 / 4.0 = 91 days. On average, inventory sits in your warehouse (or 3PL) for 91 days before it's sold.

For a store with net-30 payment terms from its supplier, that means you pay for the goods, they sit for 61 more days after the bill is due, and then they sell. Your cash is locked up for months. Improving turnover directly improves cash flow.

What a low turnover ratio actually costs you

Slow inventory isn't free to hold. Industry estimates put total carrying costs at 20–30% of inventory value annually. That covers storage fees, capital cost (the opportunity cost of cash tied up), insurance, shrinkage, and eventual markdowns.

If you have $80,000 in average inventory and a carrying cost of 25%, you're spending $20,000 per year just to hold that stock — before a single unit is sold. A 4x turnover means you're turning that $80,000 into $320,000 COGS per year. A 2x turnover means only $160,000 COGS while paying the same holding cost. The spread goes straight out of your margin.

How to improve your inventory turnover ratio

Cut reorder quantities on slow movers

The simplest lever. If a product turns 1.5x annually, cut your next order in half. You'll run tighter on stock but you'll free up cash for products that actually move. Use your historical sell-through rate to set a reorder point that keeps you covered without overbuying.

Move dead stock faster

Products sitting past 90 days with no sales movement need a push: bundle them with faster-moving items, run a clearance discount, or put them in a flash sale. Getting 40 cents back on the dollar is better than paying carrying costs while the product sits another 60 days.

Tighten your catalog

More SKUs don't mean more revenue. A 400-product catalog where 80 products drive 90% of revenue is carrying 320 products' worth of overhead. Rationalizing the catalog — cutting the bottom performers and focusing restock dollars on winners — usually lifts both turnover and margin simultaneously.

Improve demand forecasting

Over-purchasing is the most common cause of low turnover. Most Shopify merchants buy based on gut feeling or "last time we ordered X and it lasted Y weeks." Using actual velocity data — units per day by product — gives you an order quantity that matches real demand without excess buffer.

Identify and resolve cannibalization

Two products competing for the same buyer will both show lower-than-expected turnover. Neither is fully performing because they're splitting demand. If you have product pairs like this, consolidating or differentiating them lifts both products' velocity numbers. ShelfMerge's cannibalization detector finds these pairs automatically.

Tracking turnover by product, not just store-level

A store-level turnover ratio of 4.0 can hide a lot of variation. You might have 40 products turning 8x and 60 products turning 1x, averaging out to a number that looks fine. The actionable insight is always at the SKU level.

Per-SKU turnover = (Units sold in period) / (Average units on hand in period)

Sort every product by turnover ratio, ascending. The bottom of that list is your problem inventory. The top is where you want to concentrate your restock dollars. ShelfMerge's turnover calculator runs this automatically and shows you where each product sits relative to your category benchmarks, so you know immediately which numbers are concerning and which are just normal for your product type.

When to recalculate

Monthly is ideal for active merchants. Annual is the minimum. If you're seasonal, calculate separately for peak and off-peak periods — your holiday quarter numbers will look very different from Q2, and averaging them obscures the actual inventory dynamics of each period.

Set a recurring reminder. This is not a set-it-and-forget metric. Turnover shifts as your catalog changes, as you enter new categories, and as your supplier lead times change. A product that turned 5x last year can be turning 2x this year if a competitor entered the market or you added a similar SKU that's splitting demand.

Know your number. It's the foundation of everything else in inventory management.