Managing inventory for an ecommerce business is fundamental to survival and growth. But for a lot of small and medium-sized business owners, inventory turnover stays fuzzy. You know the inventory turnover ratio matters. You’re less sure what your own number should be, or what to do when it moves.

In this article, we’ll demystify the complexities of the product lifecycle and help you learn how to calculate inventory turnover accurately, once and for all.

What is inventory turnover?

Inventory turnover measures how often you sell and replace your entire inventory in a set time period. It’s one of the few metrics that reads across finance and operations at once. 

Your inventory turnover rate tells you how hard your working capital is working, and how closely your inventory levels track real demand.

• A low turnover rate usually points to one of two problems: cash tied up in stock that isn’t moving, or supply chain timing that’s out of step with sales. 

Cash tied up in excess inventory can’t be spent on anything else. The longer stock sits, the more it costs you in storage, insurance, and the risk of markdowns before it sells. 

What are the basics of calculating inventory turnover?

There are two formulas to know.

• Cost of goods sold (COGS) ÷ Average inventory value = Inventory turnover ratio
• Number of units sold ÷ Average number of units on hand = Inventory turnover rate

The first works in dollars, so it accounts for what your stock cost you. It’s the number to use when you’re reporting to a lender, comparing yourself to industry benchmarks, or deciding how much cash to put into your next purchase order.

The second ignores cost and counts how fast product leaves the shelf. Use it for reorder timing and space planning.

A few expensive, slow-moving SKUs will drag the dollar ratio down while your units keep turning fine. If the rate looks healthy and the ratio doesn’t, the problem sits in your high-cost lines rather than across the catalog.

How to calculate inventory turnover step by step

Every inventory turnover calculation is only as good as the numbers you put into it. Three inputs matter: your COGS, your inventory value, and the time frame.

Step 1: Know your cost of goods sold

For most ecommerce sellers, COGS is simpler than it sounds. It’s what you paid to get your products ready to sell, not what it costs to run your business.

That includes:

• The purchase price you paid your supplier or manufacturer
• Inbound freight and customs costs to get stock into your warehouse
• Any direct packaging costs tied to the product itself

It doesn’t include warehouse rent, staff salaries, or marketing. Those are operating expenses, and they sit outside the COGS calculation.

Step 2: Track your inventory value

Turnover needs a dollar figure, not just a unit count. Take your inventory value (units on hand multiplied by their cost) at the start and end of your chosen period, then average the two.

Average inventory value = (starting inventory value + ending inventory value) ÷ 2

Getting this number right depends on knowing your stock levels at any given moment, not just at a stocktake. If you sell across several marketplaces, your inventory balance can shift within hours. A system that tracks stock as orders come in makes this step far easier than a manual count.

Step 3: Determine the time frame

Decide the period over which you want to measure turnover: monthly, quarterly, biannually, or annually. There’s no single right answer, as different industries turn over stock at different speeds:

• Shorter timeframes suit perishable goods like flowers, groceries, health foods, and supplements.
• Medium timeframes suit seasonal categories, like fashion retail, home furnishings, and agricultural supplies.
• Longer timeframes suit high-value items with slow procurement cycles, like machinery or furniture.

Whatever cadence you choose, keep it consistent. Comparing a monthly figure to a quarterly one won’t tell you anything useful.

Step 4: Calculate the ratio

Divide your COGS by your average inventory value. The result is your inventory turnover ratio: how many times you sold and replaced your stock over that period.

A practical example of inventory turnover

Say your figures for the year look like this:

• COGS : $500,000
• Starting inventory: $120,000
• Ending inventory: $80,000

Add the starting and ending inventory values, then divide by two, for an average inventory value of $100,000. So:

500,000 ÷ 100,000 = an inventory turnover ratio of 5.

The unit-based formula measures the same idea using stock counts instead of dollars, which gives you an inventory turnover rate rather than a ratio. It’s useful when you want a warehouse-level view, since it doesn’t need cost data and works even if your product prices vary widely.

Say you sell 2,000 units over the year and hold an average of 500 units in stock at any time.

2,000 ÷ 500 = an inventory turnover rate of 4.

The two numbers won’t always match. A few high-cost, slow-moving items can pull the value-based ratio down even if most of your units move fast, so it’s worth checking both if your catalog spans a wide price range.

How to calculate average inventory value if starting and ending values vary

The simple average above works well if your stock levels move steadily throughout the period. If they spike and dip — a busy sales month sandwiched between quiet ones, say — a single starting and ending figure can hide what actually happened in between. Three methods handle this better:

• Multiple-period averaging. Take inventory values at several points during the period (say, the end of each month rather than just the start and end of the year), then average all of them. This is the easiest way to smooth out short-term swings without changing your accounting method. 
• Weighted average cost method. Every time you receive new stock at a different cost, you recalculate the average cost per unit across everything currently in stock. That running average, rather than the original purchase price, is what values your inventory. It works well if your unit costs shift often, whether from supplier price changes or exchange rate movement. 
• Moving average price method. Similar to weighted average cost, but the price recalculates after every single acquisition rather than periodically. It suits businesses that reorder small quantities frequently and want their inventory value to reflect the most recent cost at any given moment. 

How to analyze inventory turnover results

Your inventory turnover ratio alone doesn’t change anything. You need to analyze and evaluate your results to decipher what they mean for your business. 

Here’s a quick guide to interpreting turnover and using benchmarking to find actionable insights.

High inventory turnover

A high turnover rate suggests that your SKUs are swiftly transitioning from shelves to customers, signaling efficiency, responsiveness, customer demand alignment, and optimum supply chain visibility. A high turnover rate often correlates to healthy profit margins, with products being efficiently converted into revenue. It also means your capital is continuously reinvested, minimizing the financial strain of excess inventory carrying costs. 

That liquidity funds day-to-day operations and gives you room to move when demand shifts. There’s a ceiling, though. Push inventory turnover too high, and you’ll end up running on insufficient inventory, which shows up as stockouts, expedited freight, and marketplace listings going dark. A higher inventory turnover ratio isn’t automatically a better one.

Low inventory turnover

A low inventory turnover ratio ties up capital and raises carrying costs. It usually points to sluggish sales or excess stock. Unsold inventory ages badly, too. The longer it sits, the more likely it is that you’ll have to discount it. If your inventory turnover rate lands below expectation, re-examine your pricing strategies, market positioning, and product relevance. You might need to adapt your product mix and marketing tactics to better meet customer demand.

How to benchmark your turnover rate against industry standards

The ideal inventory turnover rate is entirely dependent on your industry. Some industries will naturally have higher or lower turnover rates than others, so industry benchmarks matter more than any universal target.

Industry associations, market research reports, and trade publications can often provide valuable insights into the right norm for your operation. If yours is significantly higher than other similar businesses’, it may suggest aggressive sales strategies or potential stockouts. If it’s lower, it could signal overstocking or less effective inventory management.

Whatever the results, you should regularly revisit and reevaluate your benchmarking processes to ensure your business stays aligned with current trends.

How to improve inventory turnover

Improving inventory turnover requires finesse and proactive decision-making. Here are a few top tips to maintain healthy inventory turnover rates:

• Embrace Just-in-Time (JIT) inventory management: order and receive goods close to when you actually need them, and you cut holding costs and the risk of overstocking.
• Improve your demand forecasting strategies: use your own sales history to predict demand, so your inventory levels track what customers buy.
• Implement inventory automation: automating stock tracking cuts manual errors and gives you a live view of inventory levels across every channel you sell on.
• Tighten supplier management: reliable delivery windows let you hold less safety stock, and good supplier relationships often come with payment terms that improve cash flow.
• Use pricing to clear excess stock: discounts, bundles, and flash sales move slow-selling SKUs before they turn into dead weight. Dynamic pricing tied to demand and inventory levels does the same job continuously.
• Reconsider your product mix: SKU-level sales data tells you which products earn their shelf space and which are a drag on your inventory ratio.
• Diversify your product offering: new variations reduce reliance on a handful of SKUs and keep your entire inventory closer to current demand.

Common mistakes in inventory turnover calculations

An accurate calculation depends on precise inputs. Here are the mistakes that most often throw the numbers off, and how to avoid them.

Overlooking costs

Missing costs inflate your turnover rate artificially, making your stock look like it’s moving faster than it is. The costs most often left out aren’t the obvious ones: 

• Customs duties on imported stock
• Packaging costs tied directly to the product
• Software or platform fees for managing inventory

Fix: Review your COGS inputs against your actual supplier and logistics invoices, not just your accounting system’s default categories. Costs that live outside your main ledger are the ones most likely to go missing. 

Misreading fluctuations

A turnover number on its own doesn’t explain why it moved. Reading it without context leads to bad calls:

• Seasonal spikes or lulls get mistaken for a lasting trend.
• A new product launch temporarily skews the ratio while stock builds ahead of sales.
• Longer supplier lead times inflate average inventory without any change in demand.

Fix: Compare turnover to the same period a year earlier, not just the period before it, and note any one-off events (a launch, a supplier change) that could explain a swing before you act on it.

Inventory management software for tracking turnover

You can run inventory turnover calculations by hand. Plenty of SMBs do. At one or two sales channels, the math is quick. The trouble starts once stock is moving across three marketplaces and a webstore, and your inventory balance has already changed by the time you finish counting.

Software helps ensure your data inputs are up to date. With a solid foundation of actionable reports and insights based on historical performance, market trends, and other critical parameters, you can make more confident strategic decisions.

Platforms like Linnworks bring inventory management into one place, which is what makes tracking inventory turnover workable at scale:

• Real-time inventory visibility across every channel
• Automated COGS calculation
• Efficient order processing
• Multichannel integration
• Reorder management tied to actual sell-through
• Enhanced stock forecasting accuracy

Need help with how to calculate inventory turnover, manage your inventory processes, or master warehouse management? Book a demo today to discuss your pain points and find the right solution for your business.

Inventory turnover FAQs

What is a good inventory turnover ratio?

There is no single ideal inventory turnover ratio across every category. Grocery and perishables run a much higher inventory turnover rate, while furniture and jewelry run low turnover by design. Compare your ratio against benchmarks for your category rather than a universal target, and watch the trend across your own inventory turnover calculations over time.

What is the inventory turnover formula?

The inventory turnover formula is cost of goods sold divided by average inventory value. 

The unit-based version is the number of units sold divided by average units on hand. 

To convert the ratio into days, divide 365 by it. An inventory turnover ratio of 5 works out to roughly 73 days of stock on hand.

What does a low inventory turnover ratio mean?

A low inventory turnover ratio means inventory is selling slower than you are buying it. That ties up capital in unsold inventory, raises storage and insurance costs, and increases the odds that excess stock turns into markdowns or write-offs. Low turnover usually traces back to over-ordering, a product mix that stopped matching demand, or pricing that is not moving slow SKUs.

Is a high inventory turnover ratio always good?

No. A high inventory turnover ratio usually signals efficient inventory management and strong demand, but it can also mean you’re carrying too little stock. If high turnover comes with stockouts, expedited freight, and listings going dark at peak, your inventory levels are too lean. The goal is a rate that clears stock without running out of it.

How do I calculate average inventory when inventory levels vary?

Add starting and ending inventory, then divide by two. If your balance swings seasonally, use more data points: average several periods, or apply the weighted average cost or moving average price method.