1. Home
  2. Tools
  3. Inventory turnover

How long your stock sits before it sells

Slow stock ties up cash that could pay for ads or the next order, and over-ordering adds storage and markdowns. Enter cost of goods sold and your stock value at the start and end of the period to get turnover and days of inventory. Add demand and costs to get the order size that keeps ordering and holding costs lowest.

Some links may earn us a commission at no cost to you. Drafted with AI, checked by a human. How we earn.

  • Your own numbers
  • Every formula shown
  • Runs in your browser
Illustration of payments and reserves

Stock and costs

Your own numbers

Value inventory at cost, not retail price.

1Turnover
2Economic order quantity (optional)

How the math works

Inventory turnover = cost of goods sold ÷ average inventory at cost, where average inventory = (start + end) ÷ 2. Days of inventory = days in the period ÷ turnover. Both sides must be at cost; dividing sales at retail by stock at cost overstates turnover.

EOQ, the economic order quantity, = √(2 × yearly demand × cost per order ÷ holding cost per unit per year). Cost per order covers admin, inbound freight minimums and receiving; holding cost covers storage, insurance, shrinkage and the cash tied up. Pair it with the safety stock calculator to decide when to reorder.

Track stock and COGS in Shopify

FAQ

What is a good inventory turnover?

It depends on the category: fresh food turns fast, furniture and jewellery slowly. Compare your own trend by quarter and by product line.

Where do I find COGS?

From your accounts, or work it out with the COGS calculator: beginning inventory + purchases and other costs − ending inventory.

Is EOQ still useful for a small store?

As a starting point. Minimum order quantities, price breaks and case packs often decide the real order size.

Is the Shopify link an affiliate link?

Yes. The Shopify /go/ link is a sponsored link. StoreVetted may earn a commission at no extra cost to you.