Guide

Cash tied up in inventory? How to order less without running out

Revenue looks great but the bank account doesn't? Here's how to find the cash sitting on your shelves and free it up without risking stockouts on your best-sellers.

Where the cash is hiding

  • Slow sellers reordered on autopilot. They're often 20% of revenue and 50% of inventory value.
  • Orders sized for the price break, not for sales.
  • The same buffer on everything. A best-seller and a slow product don't need the same safety stock.
  • Long gaps between orders. Ordering every 90 days means holding 90 days of stock.

Step 1: Rank products by cash, not units

Multiply units on hand by cost for each product and sort. Then add days of stock (units ÷ daily sales). Products with lots of cash and lots of days are where the money is. Shopify's ABC analysis report helps you see which ones actually earn it back.

Step 2: Size orders from the formula, not the gut

Order qty = daily sales × (lead time + days of cover) − (on hand + on order)

Shrinking "days of cover" from 90 to 45 on steady sellers roughly halves the cash in each order. You place orders twice as often, so check shipping and minimums. The EOQ calculator shows where the balance is.

Step 3: Protect the best-sellers

Cut stock on slow products first. On your A products, keep safety stock and order on time, because a stockout there costs more than the cash you'd save. See the stockout cost calculator.

Step 4: Stop the slow ones

If sell-through has been low for a few months, don't reorder. Clear what's left (see dead stock).

Doing this for every product

Doing it by hand works for 20 SKUs. For more than that, SteadyShelf calculates the order-by date and quantity for every product from your Shopify sales and each supplier's lead time, so each order covers what you'll sell and no more.

SteadyShelf is launching on the Shopify App Store. Join early access to get the install link first.

FAQ

Why is all my cash tied up in inventory?

Usually because orders are sized for safety instead of sales: big orders to hit price breaks, extra buffer on everything, and reorders of slow products alongside fast ones.

How much inventory should I hold?

Enough to cover the supplier's lead time plus your safety stock plus the days until your next order, for each product. Anything beyond that is cash you could be using elsewhere.

Is it worth paying more per unit to order smaller quantities?

Often yes for slow or uncertain products. Compare the unit price break with your carrying cost and the risk of being stuck with stock.

Let SteadyShelf do this math for every SKU

Order-by dates per supplier, seasonal forecasts and draft POs for your Shopify store. $29/month after a 30-day free trial.

Get early access