Inventory turnover
Also known as: Stock turnover
Inventory turnover is the number of times a store sells through its average inventory in a period, calculated as COGS divided by the average value of inventory held.
Formula
Average inventory = (opening inventory + closing inventory) ÷ 2
Inventory turnover = COGS ÷ average inventory
Days of inventory = 365 ÷ inventory turnoverValue inventory at cost, the same basis as COGS.
Worked example
Annual COGS is $240,000. Inventory at cost was $50,000 at the start of the year and $30,000 at the end.
- Average inventory = ($50,000 + $30,000) ÷ 2 = $40,000.
- Inventory turnover = $240,000 ÷ $40,000 = 6.
- Days of inventory = 365 ÷ 6 ≈ 61 days.
On average, a unit sits in stock about two months before it sells.
Why it matters for a Shopify store running ads
Inventory is cash sitting on shelves. Low turnover ties up money that could fund ads, and slow products risk becoming dead stock that has to be discounted. High turnover frees cash but can lead to stockouts that stop campaigns mid-scale.
For stores scaling on Meta and TikTok, turnover by product is a planning tool: before increasing spend on a winning product, check you have the stock and the reorder lead time to support it, or the ads will sell items you can't ship.
Common mistakes
- Using revenue instead of COGS in the numerator, which inflates turnover.
- Using only closing inventory instead of an average, which distorts seasonal businesses.
- Looking at store-wide turnover and missing slow SKUs hidden by fast bestsellers.
FAQ
What is a good inventory turnover ratio?
It depends on the category and supply chain. Perishable or fast-moving products need high turnover; seasonal or long-lead-time products run lower. Compare each product against its reorder lead time and your own history.
How do I find slow-moving products?
Calculate turnover or days of inventory per SKU. Products with many months of stock at the current sales rate are candidates for bundles, promotions or not reordering.
Related terms
- COGSCOGS (cost of goods sold) is the direct cost of the products you actually sold in a period, including purchase price, inbound freight and duties, but not marketing or overheads.
- Landed costLanded cost is the total cost of getting a product into your warehouse and ready to sell, including the purchase price, freight, insurance, import duties and customs or broker fees.
- Gross marginGross margin is the share of revenue left after subtracting the cost of goods sold, expressed as a percentage: (revenue − COGS) ÷ revenue.
- Net profitNet profit is the money a business keeps after subtracting every cost from revenue, including product costs, shipping, fees, refunds, advertising and fixed overheads.
Want this number for your own store without a spreadsheet? ProfitFly connects Shopify, Meta and TikTok and shows your real profit every day, free up to 50 orders a month.
Start free