Inventory Turnover: Measure How Fast Each SKU Sells Through
Inventory turnover shows how often you sell and replace stock. The useful view is not one storewide ratio. It is turnover by SKU, translated into days on hand and compared with the time needed to replenish.
$240,000 divided by $60,000 equals four turns. 365 days divided by four equals about 91 days on hand.
You can have strong sales and still hold too much cash in inventory. One product sells out before the next purchase order arrives. Another sits in the warehouse through two campaign cycles. A storewide stock value will not show which SKU creates either problem.
Inventory turnover gives you a common measure. Calculate how many times each product sells through during a period, then convert the ratio into days on hand. Compare those days with the supplier lead time and the amount of stock you need to protect customer availability.
What inventory turnover measures
Inventory turnover measures how many times a business sells and replaces its average inventory during a month, quarter, or year. The standard formula uses cost of goods sold divided by average inventory value. Shopify uses the same definition in its inventory turnover guide.
Keep both sides of the formula at cost. Revenue includes your markup, while inventory on the balance sheet normally reflects product cost. Dividing revenue by cost-based inventory makes turnover look higher without changing how much physical stock moved.
A higher ratio means inventory moved faster. That can free cash and reduce storage exposure. It can also reveal that you carry too little stock. If a bestseller turns quickly but spends ten days out of stock before every replenishment, the ratio describes scarcity as much as demand.
Calculate turnover, then convert it to days
Start with cost of goods sold for the period. Next, calculate average inventory value. The basic average adds beginning inventory and ending inventory, then divides by two. For a seasonal brand, monthly ending balances give a more faithful average because a two-point calculation can miss the stock built before a holiday or launch.
Divide cost of goods sold by average inventory. If annual cost of goods sold is $240,000 and average inventory is $60,000, the business turns inventory four times per year. Divide 365 by four to get about 91 days on hand.
Oracle NetSuite documents the same cost-of-sales formula and reports average days on hand for each inventory item in its Inventory Turnover Report. That item-level view matters because an aggregate ratio can let fast products hide slow ones.
A DTC inventory example
Consider a hypothetical skincare brand with an annual turnover ratio of four. The headline suggests 91 days of inventory. The operator might accept that number because the contract manufacturer needs 45 days and the team wants a buffer for freight and demand changes.
The SKU view tells a different story. The daily cleanser turns six times per year, equal to about 61 days on hand. It sells steadily and leaves a narrow margin above the 45-day production lead time. The holiday gift set turns 1.5 times, equal to about 243 days. Unsold sets remain after the selling window closes.
The storewide ratio blended those products into one average. The operator needs two decisions. Place the cleanser reorder earlier or shorten its lead time. Reduce the next gift-set order and plan how to sell the remaining units without treating a seasonal package like an evergreen product.
Read turnover beside lead time and product role
Compare products that behave alike. Replenishable basics, limited launches, bundles, and products with expiration dates carry different jobs. A slow-turning hero product may need a merchandising fix. A slow-turning spare part may be acceptable because customers expect it to remain available.
Lead time sets the operating constraint. If a product has 30 days on hand and takes 60 days to replenish, the team already faces a stockout unless an open purchase order covers the gap. If the same product has 180 days on hand, buying more because sales rose last week may lock cash into stock for months.
Review the ratio with stockout days, open purchase orders, inbound dates, and margin. Turnover tells you how fast inventory moved. Those records tell you whether the speed supports the customer experience and the cash plan.
Build a monthly SKU turnover review
Use the ratio to identify a short list of products that need a buying, merchandising, or replenishment decision.
Where ShopDucky fits
ShopDucky can read sales, inventory, purchase-order, and supplier records across an ecommerce stack, calculate SKU-level exceptions, and prepare the next action for review. Teams can keep purchase orders behind human approval while an AI employee monitors days on hand and changing lead times. See how this works in AI inventory management and the store operations workflow.
Inventory turnover, answered
What is inventory turnover?+
Inventory turnover is the number of times a business sells and replaces its average inventory during a period. The standard formula divides cost of goods sold by average inventory value for the same period.
What is a good inventory turnover ratio for ecommerce?+
There is no useful universal target. Compare similar products, prior periods, supplier lead times, and the service level you want to maintain. A ratio that works for replenishable skincare may be dangerous for seasonal merchandise or products with long manufacturing lead times.
How do you convert inventory turnover to days on hand?+
Divide the number of days in the period by the turnover ratio. Annual turnover of 4 equals about 91 days on hand because 365 divided by 4 is 91.25.
Can high inventory turnover be a problem?+
Yes. High turnover can reflect strong demand, but it can also mean the business carries too little stock and loses sales to stockouts. Read turnover beside stockout frequency, supplier lead time, and backorder volume.
