Insights

Inventory management when you're growing fast

Stockouts kill momentum. Overstock kills cash flow. How to find the balance between the two as your store scales.

Topic
Operations
Published
5 Jul 2024
Reading time
8 min read
A warehouse worker scanning a box of stock

Run out of your bestseller in the middle of Black Friday and the damage doesn't stop at the orders you missed. The restock might not land until January, by which point the moment has passed and competitors have taken the customers who came looking for you. It usually happens because cash was tight and the order was cautious, which is a sensible instinct with an expensive outcome.

Then there's the opposite problem. Money sitting in boxes in a warehouse, moving at a glacial pace, while you can't afford to run the ads that might shift it.

Inventory management is unglamorous, but it's where a lot of businesses get stuck. The dynamics change as you scale. More products, more stock locations, more suppliers and more sales channels each add decisions, and a method that works for a small range sold in one place stops coping.

The core trade-off you're always making

Every inventory decision is a bet. Stock too little and you run out, losing sales, disappointing customers, wasting whatever you spent on ads sending people to 'out of stock' pages. Stock too much and cash is tied up, you're paying storage, and eventually you're discounting to move products that aren't selling.

When cash is tight, it's easy to err toward stockouts. Being prudent with cash is sensible, but the cost of a stockout is easy to underestimate. The lost sale is only part of it. Add the ad spend wasted, the customer who went to a competitor and might not come back, and the momentum that's hard to rebuild.

So don't treat every product the same. Rank your products by the contribution they make (what's left after product cost, delivery and fees) and by how reliable their demand is. The ones near the top of both lists, the dependable earners, deserve a high service level: you want them in stock almost all the time, and you're prepared to hold extra to make sure. Then choose a service target you can afford in cash, because 'never stock out' on everything is a promise your bank balance won't keep.

For everything else, be leaner. If a slow-moving product is out of stock for a few weeks, it's probably not materially hurting you.

Forecasting without fancy software

You don't need elaborate systems to forecast demand. A spreadsheet and some discipline gets you most of the way there.

Start with last year's data. How many of each product did you sell per month? That's your baseline. If you're growing, say 30% year on year, apply that multiplier to your baseline. If December was 2x your average month last year, assume similar seasonality.

So if you sold 100 units of something monthly last year, and you're up 30% this year, plan for 130. If December is typically double, plan for 260 in December. Then add a safety buffer for your bestsellers. As an illustrative starting assumption, not a benchmark, say 15-20%: widen it for products whose monthly sales swing a lot or whose supplier lead times are long or unreliable, and narrow it where demand is steady and restocking is quick.

The numbers won't be perfect. They never are. But it gives you a first estimate, which is far better than 'I reckon we need about 200.' Before relying on it, correct for months when you were out of stock, for promotions, and for products added to or dropped from the range.

Update your forecasts monthly. A product that's suddenly trending upward needs revised projections. One that's underperforming needs orders scaled back. Reality diverges from predictions constantly. The discipline is in adjusting as you go.

Lead times will surprise you

A lot of stockouts trace back to underestimated lead times.

Your lead time is longer than the time your supplier quotes. It's production time, plus shipping, plus customs if applicable, plus your own receiving process. If your supplier says '3 weeks' and shipping is another 2 weeks and it takes you a week to receive and shelve stock, your real lead time is 6 weeks. Not 3.

And lead times stretch unpredictably. That 6-week lead time might become 10 weeks around Chinese New Year or during a shipping crunch. Build in buffer.

Once you know your real lead time, you can calculate reorder points. The basic formula is: average daily sales multiplied by lead time, plus safety stock.

There's more than one way to set safety stock. The textbook method uses the statistical variability of your demand and the service level you've chosen. A simpler, deliberately conservative method takes the gap between your busy-day and average daily sales and multiplies it by the lead time. It assumes every day of the lead time is a busy day and that the lead time itself never slips, so it tends to over-protect on demand and under-protect on supplier delays. It's a reasonable place to start in a spreadsheet.

Worked example with that simple method: if you sell 10 units a day on average, but 18 on busy days, and your lead time is 42 days, safety stock is (18 − 10) × 42 = 336 units. The reorder point is (10 × 42) + 336 = 756 units.

When your inventory position hits 756, order more. Inventory position means stock on hand, plus stock already ordered and on its way, minus stock committed to orders you haven't shipped. Use stock on hand alone and you'll reorder twice for the same gap. Set up automated alerts. Don't rely on remembering to check.

Supplier relationships matter more than you think

Your suppliers can make or break your inventory performance. The relationship is worth investing in.

Negotiate on lead times. Can they hold buffer stock for you? Can you get priority treatment during peak seasons if you commit to volumes? These conversations are worth having.

Push back on minimum order quantities. High MOQs force you to over-order slow sellers, which creates the dead stock problem. Sometimes you can negotiate lower MOQs if you pay slightly more per unit. Often worth it.

Payment terms matter for cash flow. Net-30 or Net-60 terms, where payment falls due 30 or 60 days after a date your contract sets (invoice, shipment or delivery, which need not be when you receive the goods) rather than upfront, can significantly ease the cash pressure of holding inventory. As you grow and become a more valuable customer, these terms become easier to negotiate.

Diversify if you can. A single supplier is a concentration risk. One factory fire, one quality problem, one port closure, and you're stuck with nothing to sell. This isn't always feasible early on (you might not have the volume to spread across suppliers), but work toward it.

And just be a good customer. Pay on time. Communicate clearly. Give them visibility of your forecasts. When capacity is tight, suppliers prioritise the customers who aren't nightmares to deal with.

Inventory is cash in physical form.

Dealing with slow movers and dead stock

Every range has products that seemed like a good idea but don't sell. The question is how long you sit on them.

Look at inventory turnover by product. If something turns over less than twice a year, I'd call it slow. Below once a year, ask why before calling it dead. A seasonal line sells in one burst, an expensive item turns slowly by nature, and a specialist part you stock deliberately for a few customers may be doing its job. Stock that's none of those and still isn't selling is the dead stock to deal with.

First, try bundling. Sometimes a slow mover sells when paired with a popular item at a slight discount. It's a way to move units without discounting the product itself.

Second, check if it's been given a fair shot. Maybe the photography is poor. Maybe it's buried in your navigation. Maybe you've never promoted it. Some products need a push before you write them off.

Third, if it's genuinely not working, discount and clear. Get the cash out. Stop paying storage. It feels like admitting defeat, but holding onto dead stock costs money every day. Better to take the hit and redeploy the cash into products that sell.

The best approach is prevention: order conservatively on new products. Test with small quantities before committing to large orders. Air freight exists if something takes off. You can't un-order stock that isn't moving.

Tools and systems

At low volume, a spreadsheet is fine. Really. A well-kept sheet can run a business with a modest range and one stock location, as long as someone updates it with discipline.

As you scale, you need something more robust. Work out what the system has to do before you look at products: track stock across locations, calculate days of stock remaining, alert you at reorder points using inventory position rather than stock on hand, integrate with your sales channels so data is accurate and close to real time, and report on turnover and slow movers.

Shopify's built-in inventory is fine for simple operations. Once you're multi-location, selling wholesale as well as retail, or running marketplaces alongside your own shop, look at dedicated inventory and order management systems; Cin7 and Brightpearl are two established names at the heavier end. Check what's current before you commit, because this part of the market changes: apps get retired and products get absorbed into bigger ones.

The principle is matching your tools to your complexity. Don't over-invest in systems you don't need yet. But don't outgrow your tools either. Trying to run several locations and channels through chaotic spreadsheets leads to expensive mistakes.

The cash flow reality

Inventory is cash in physical form. Every pound sitting on a shelf is a pound you can't spend on growth.

Growing businesses often hit cash crunches because inventory needs grow faster than revenue. Say sales grow 20%: you can easily need far more than 20% extra stock, because you're stocking a larger range, carrying more safety stock, and can't afford the stockout risk. This catches people by surprise.

Ways to ease the pressure: negotiate payment terms so you're paying suppliers after you've sold the product, not before. Improve turnover by focusing marketing on proven sellers rather than slow movers. Reduce lead times where possible. Shorter lead times mean smaller safety stock requirements.

Consider dropshipping for true long-tail items. If something sells once a month, maybe it doesn't need to sit in your warehouse. Let someone else hold that inventory risk.

Inventory financing exists too: lenders who'll advance cash against stock. It costs money, but it can fund growth if cash is the bottleneck.

Know your inventory value at any moment. Track how much cash is tied up in stock. Watch whether that number is growing faster than revenue. If it is, you've got a problem developing.

How we help: Process Efficiency · Connected Data and Reporting

Want to talk this through for your own business? Dax reads every message personally and usually replies within a day.

Tell us what you need

Or get the next article by email, every couple of weeks.

Let's find a way forward

Dax reads every enquiry personally.

Step 1 of 4

What would you like to improve?

Choose the closest fit. We’ll help you turn it into a useful brief.