Inventory Turnover for Shopify Brands: Formula, Benchmarks, Fixes
How to calculate inventory turnover from Shopify's own reports, 2026 benchmarks by category, and the fixes that free up cash tied up in slow stock.
On this page
Last reviewed October 2026.
TL;DR
- Formula: inventory turnover = cost of goods sold ÷ average inventory. Divide 365 by the result to get days of inventory.
- Shopify has no built-in turnover report. Calculate it from two reports it does have: cost of goods sold and month-end inventory value.
- Benchmarks vary by category. Apparel turns about 4 to 6 times a year. Health and beauty turns 6 to 10, jewelry 1 to 3 and grocery 14 to 20.
- Faster turnover frees cash. A brand with $600,000 in yearly cost of goods sold that moves from 4 to 6 turns frees about $50,000 tied up in stock.
- The fixes: grade products with ABC analysis and reorder from days-remaining data. Bundle or mark down slow sellers, and sync inventory in real time.
What is inventory turnover?
Inventory turnover measures how many times a business sells through and replaces its average inventory in a year. It's calculated by dividing cost of goods sold by average inventory. A ratio of 5 means you sell through your stock about five times a year, or roughly every 73 days. Higher turnover generally means less cash tied up in stock.
It's sometimes called stock turnover or product turnover, and the calculation is the same whichever name you use.
How do you calculate inventory turnover?
To calculate the inventory turnover ratio, divide cost of goods sold for a period by average inventory value for the same period. Average inventory is your opening inventory plus your closing inventory, divided by two. Then divide 365 by the ratio. That gives the average number of days an item sits in stock before it sells.
Here's how to calculate inventory turnover in three steps:
| Step | Formula |
|---|---|
| 1. Average inventory | (Opening inventory value + closing inventory value) ÷ 2 |
| 2. Inventory turnover ratio | Cost of goods sold ÷ average inventory |
| 3. Days of inventory | 365 ÷ inventory turnover ratio |
Worked example: a brand has $600,000 in yearly cost of goods sold and $120,000 in average inventory. Its ratio is 5, or about 73 days of inventory.
Accountants often call this an inventory turns calculation, and the number is simply "turns": five turns means you sold through your average stock five times.
Use cost of goods sold rather than revenue. Revenue includes your margin, which inflates the ratio and makes it impossible to compare with industry benchmarks.
How do you find inventory turnover in Shopify?
Shopify doesn't have a report called inventory turnover, but you can calculate it from two reports it does provide. Take cost of goods sold from Shopify's profit reports, which need a cost entered for each product. Take average inventory from the month-end inventory value report. Then apply the formula.
- Enter a cost per item on every product. Without it, Shopify can't report cost of goods sold accurately.
- Pull cost of goods sold for the year from Analytics → Reports, using the profit or gross profit reports.
-
Pull month-end inventory value for each month of the same year, and average them. Averaging twelve months is more accurate than averaging just the first and last.
Shopify’s inventory reports in Analytics → Reports, filtered by Inventory. Screenshot taken October 2026.
- Divide cost of goods sold by that average.
Shopify confirms this in its own inventory reporting guide, which lists sell-through rate, inventory sold daily and inventory remaining per product as the related reports.
For a quick monthly check on individual products, Shopify's sell-through rate report is a useful companion. Shopify defines sell-through as units sold ÷ (units sold + ending inventory units), which shows how quickly each product's stock is moving.
What's the difference between inventory turnover, sell-through rate and days remaining?
| Metric | What it tells you | Best for |
|---|---|---|
| Inventory turnover | How many times you sell through average inventory in a year | Comparing against benchmarks and tracking cash efficiency |
| Sell-through rate | What share of a product's stock sold in a period | Spotting slow or fast products each month |
| Days of inventory remaining | How long current stock will last at recent sales speed | Reordering and predicting stockouts |
What's a good inventory turnover ratio?
There's no single target, because turnover depends on what you sell. Published retail benchmarks put apparel at roughly 4 to 6 turns a year and health and beauty at 6 to 10. Jewelry turns just 1 to 3 times, while grocery turns 14 to 20. Compare yourself with your own category, not an average across all retail.
| Category | Typical turns per year | Rough days of inventory |
|---|---|---|
| Grocery and perishables | 14–20 | 18–26 |
| Health and beauty | 6–10 | 37–61 |
| Consumer electronics | 6–10 | 37–61 |
| Pet supplies | 6–9 | 41–61 |
| Apparel and fashion | 4–6 | 61–91 |
| Footwear | 3–5 | 73–122 |
| Sporting goods | 3–5 | 73–122 |
| Home and furniture | 2–4 | 91–183 |
| Luxury and jewelry | 1–3 | 122–365 |
Ranges from Retail Ops Toolkit's inventory turnover benchmarks by category, reviewed August 2026. Days calculated as 365 ÷ turns.
Slow turnover isn't always a problem. Jewelry and luxury brands deliberately carry low turnover, which their margins pay for. Retailers also got leaner over the past year. US Census data shows the retail inventory-to-sales ratio fell from 1.29 in June 2025 to 1.25 in June 2026.
How much cash is tied up in slow stock?
Improving inventory turnover releases cash you've already spent on stock. At $600,000 in yearly cost of goods sold, a brand turning inventory 4 times a year holds about $150,000 in stock on average. At 6 turns, it holds about $100,000, freeing roughly $50,000 to spend on marketing, new products or debt.
| Turns per year | Average inventory | Days of inventory |
|---|---|---|
| 4 | $150,000 | 91 |
| 5 | $120,000 | 73 |
| 6 | $100,000 | 61 |
Our calculation, based on $600,000 in yearly cost of goods sold.
The saving is more than the cash itself. Holding slow-moving stock is often estimated to cost 20% to 30% of its value each year in storage, insurance, shrinkage and markdowns. On the $50,000 freed above, that's another $10,000 to $15,000 a year.
What are the biggest inventory management challenges?
The most common inventory management challenges are stockouts, overstock, cash tied up in stock, overselling and poor forecasts. Each one carries a risk: lost sales, markdowns, storage costs or unhappy customers. Most trace back to stock data that's late, wrong or held in more than one system.
| Challenge | Risk | Usual cause |
|---|---|---|
| Stockouts | Lost sales and customers buying elsewhere | Reordering too late for supplier lead times |
| Overstock and dead stock | Markdowns, storage costs, cash tied up | Ordering to forecasts rather than sales |
| Overselling | Cancelled orders and refunds | Channels or locations not synced in real time |
| Inaccurate counts | Bad reorder decisions | Manual adjustments and unrecorded shrinkage |
| Poor forecasts | Both stockouts and overstock | Ignoring seasonality and trends |
How do you turn over inventory faster on Shopify?
The fastest gains come from treating products differently. Keep best sellers in stock, reorder from real sales data, and clear slow stock before it ages. Shopify's own reports cover most of this. These inventory management best practices mirror retail inventory management best practices, and they work with one warehouse or several.
1. Grade your catalog with ABC analysis
Shopify's ABC analysis, available on Grow and higher plans, grades products by revenue share over the last 28 days. A-grade products typically make up about 80% of revenue, B-grade about 15% and C-grade the last 5%. Keep A-grade items in stock, review B-grade items by season and location, and reduce orders for C-grade items.
2. Predict stockouts from days remaining
To predict stock outs, compare days of inventory remaining with each supplier's lead time. Shopify gives a simple example. A product has 10 days of stock left, and the supplier takes 21 days to deliver. Transfer stock from another location or find a faster supplier now, not when it sells out.
3. Bundle or mark down slow sellers
C-grade products tie up cash. Bundle them with best sellers, discount them, or sell them through wholesale. Native Shopify B2B, available on the Basic, Grow, Advanced and Plus plans since April 2, 2026, lets you offer excess stock to trade buyers without discounting it publicly.
4. Use preorders for new launches
Taking a preorder before stock arrives lets you size purchase orders to real demand. That keeps launches from becoming next season's dead stock.
5. Keep inventory synced in real time, and automate it
Real-time inventory management means stock updates the moment something sells, across your website, shops and warehouse. Without it, you oversell, then over-order to compensate. Connect Shopify to your warehouse or ERP so one system owns stock levels. Then let an automated inventory management system handle updates and reorder alerts instead of spreadsheets. Inventory automation removes the manual uploads that cause most count errors.
If you sell through several shops, warehouses or marketplaces, multi-location inventory management matters most. See our multi-location inventory sync service for how we keep stock aligned across every channel. Our integration scorecard explains how to choose the right connection.
6. Forecast demand with simple methods first
You don't need complex software to start. Three inventory forecasting methods cover most Shopify brands:
- Run rate: average daily sales over recent weeks, which is what Shopify's days-remaining report uses.
- Seasonal comparison: the same period last year, adjusted for growth, for products with clear peaks.
- Safety stock by grade: more buffer for A-grade products, little or none for C-grade.
Combine them with supplier lead times, and your inventory prediction will catch most stockouts before they happen.
7. Use transfers and purchase orders inside Shopify
Move stock between locations before reordering, and raise purchase orders against your days-remaining data so every order has a reason.
Inventory work we've done
Renard's Cheese, a Door County cheesemaker with a shop, a bistro and an online store, moved four separate systems onto Shopify. Shopify's case study reports real-time inventory sync across every channel, replacing manual uploads that ran hourly. We handled the Shopify setup and implementation.
HUK Gear runs 59 Shopify POS locations with inventory synced to its ERP. We built it working directly with HUK's CIO, so stock in every store matches what's sold online.
Solo Media Group is a Shopify Platinum Partner, the top of Shopify's five tiers.
Inventory turnover FAQs
How do you calculate inventory turnover?
Divide cost of goods sold by average inventory for the same period. Average inventory is opening plus closing inventory, divided by two. A brand with $600,000 in cost of goods sold and $120,000 in average inventory has a turnover of 5.
How do you calculate the stock turnover ratio?
The same way. Stock turnover ratio is another name for inventory turnover: cost of goods sold divided by average stock value. Divide 365 by the ratio to see how many days stock sits before it sells.
Does Shopify have an inventory turnover report?
No. Shopify has related reports, including sell-through rate, ABC analysis, days of inventory remaining and month-end inventory value. Calculate turnover by dividing cost of goods sold by your average month-end inventory value.
What is a good inventory turnover ratio for ecommerce?
It depends on the category. Apparel brands typically turn inventory 4 to 6 times a year, health and beauty 6 to 10 times, and grocery 14 to 20 times. Jewelry and luxury brands often turn just 1 to 3 times, offset by higher margins.
How can I predict stockouts on Shopify?
Compare each product's days of inventory remaining with your supplier's lead time. If stock will run out before a new order can arrive, transfer stock from another location, order now, or find a faster supplier.
How should a small business manage inventory on Shopify?
Start with the basics. Enter a cost for every product, check days of inventory remaining weekly, and grade products with ABC analysis. Reorder best sellers first. Inventory management for a small business is mostly about consistency, not software. Add an inventory app or ERP connection once you sell across several locations or channels.
Is higher inventory turnover always better?
Not always. Very high turnover can mean you're understocking and losing sales to stockouts. Aim for the range typical of your category, while keeping best sellers in stock.
