# 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](https://storevetted.com/disclosure/).

- Your own numbers
- Every formula shown
- Runs in your browser

## 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](https://storevetted.com/safety-stock-calculator/) to decide when to reorder.

[Track stock and COGS in Shopify](https://storevetted.com/go/shopify)

From the guides

## Related guides

[All guides](https://storevetted.com/guides/)

- [Year-end Shopify stocktake](https://storevetted.com/guides/year-end-shopify-stocktake-inventory/)
- [Leftover holiday stock on Shopify](https://storevetted.com/guides/leftover-holiday-stock-shopify/)
- [Shopify preorders and overselling at BFCM](https://storevetted.com/guides/shopify-continue-selling-out-of-stock-preorder/)

Keep going

## Related free tools

[All 81 tools](https://storevetted.com/tools/)

[Safety stock calculator](https://storevetted.com/safety-stock-calculator/): Reorder point with demand swings.

[COGS calculator](https://storevetted.com/cogs-calculator/): Cost of goods sold for the period.

[Pallet calculator](https://storevetted.com/pallet-calculator/): Cartons per pallet.

[SKU generator](https://storevetted.com/sku-generator/): Consistent variant codes.

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

---

Canonical: https://storevetted.com/inventory-turnover-calculator/  
Publisher: StoreVetted (https://storevetted.com/). Some links may earn a commission at no cost to you: https://storevetted.com/disclosure/  
Site index for agents: https://storevetted.com/llms.txt
