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 turnover

Value 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.

  1. Average inventory = ($50,000 + $30,000) ÷ 2 = $40,000.
  2. Inventory turnover = $240,000 ÷ $40,000 = 6.
  3. 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

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