Inventory management for an Australian ecommerce store: a practical guide

Most small ecommerce operators manage stock the same way they manage everything else early on: by feel. A number that "seems about right" gets reordered when someone notices the shelf looking thin. It works, until the day a bestseller sells out mid-campaign, or a container of slow-moving stock arrives that takes eight months to clear and quietly eats the cash that should have funded the next order. Inventory management is not really about the stock. It is about protecting cash flow and sales at the same time, and the two pull in opposite directions if you let them.

The good news is that this does not require enterprise software or a warehouse team. It requires a handful of numbers, tracked consistently, and a method that matches the size of your catalogue. Here is how to build that from the ground up.

How much stock should an Australian ecommerce store hold?

The right stock level is not a round number you pick and hold forever. It is a moving target calculated from two things: how fast a product sells, and how long it takes to get more of it. The working formula most small operators use is a reorder point:

Reorder point = (average daily sales × lead time in days) + safety stock

Lead time is where Australian stores get caught out. If you manufacture or import from Asia, Europe or the US, lead time is not just production time. It is production, plus international freight, plus customs clearance, plus the last-mile trip to your warehouse or 3PL, and each of those has historically blown out further than owners plan for. Measure your actual lead time from past orders rather than the figure a supplier quotes, and build in a margin for the times it runs long.

Safety stock is your buffer against the two things that make lead time and demand unpredictable: a supplier running late, or a sales spike you did not forecast. There is no single correct formula, but a workable starting point is to hold extra stock equivalent to several days to a few weeks of average sales on your important lines, sized to how damaging a stockout on that product would actually be. A hero product that drives most of your paid traffic deserves a thicker buffer than a slow-moving accessory.

It is worth separating this from cash flow planning too. Every dollar sitting in safety stock is a dollar not available for ad spend, new product development or simply a buffer in the bank account, so the goal is never to maximise stock cover. It is to hold the smallest buffer that keeps your important lines available, and to review that number as sales patterns and supplier reliability change rather than setting it once and forgetting it.

Which inventory method actually fits your store?

The right system depends on your catalogue size and channel count, not on what looks most sophisticated. Overbuilding this early wastes time; underbuilding it once you have outgrown it causes stockouts and overselling.

Method	Best fit	Effort to run	Where it breaks
Manual / spreadsheet tracking	Small catalogue, single sales channel	Low, but manual updates	Human error, no real-time view
Par level / reorder point	Predictable demand, moderate SKU count	Moderate, needs regular review	Struggles with seasonal spikes
ABC analysis + demand forecasting	Growing catalogue, uneven product performance	Moderate, front-loaded setup	Needs a decent sales history to be accurate
Perpetual inventory software	Multi-channel, higher order volume	Low ongoing, higher setup cost	Overkill, and an added cost, for a very small catalogue

Most Australian stores move through this table roughly in order as they grow, and there is no prize for skipping ahead. A spreadsheet that is actually kept up to date beats an expensive system nobody trusts.

How do you avoid stockouts and overstock at the same time?

These feel like opposite problems, but they usually come from the same root cause: treating every product in the catalogue the same way. A simple ABC analysis fixes this. Rank products by revenue contribution. Your A-tier, typically a fairly small share of SKUs that drives the majority of revenue, gets the tightest monitoring, the most generous safety stock and the fastest reorder cycle. Your C-tier, the long tail of low-volume lines, gets reviewed far less often and held leaner, because tying up cash there for "just in case" is exactly how dead stock accumulates.

Layer in known demand shifts on top of this. If a product features in an upcoming campaign, a seasonal peak, or a Black Friday push, increase its buffer ahead of time rather than reacting once the spike has already emptied the shelf. Stockouts on a promoted product are one of the more expensive mistakes in ecommerce, because you have already paid to drive the traffic that then arrives at a page with nothing to sell.

The same split applies to slow movers once they stop selling altogether. Set a simple rule, for example no meaningful sales in six months, and review anything that meets it on a fixed schedule rather than letting it sit indefinitely. Some of it will genuinely be worth clearing at a discount; some of it will reveal a product page, price or listing problem worth fixing before you write the stock off as unsellable.

When should you move from spreadsheets to dedicated inventory software?

There is no fixed revenue threshold for this. The honest signal is friction: stocktakes that regularly disagree with what the spreadsheet says, hours lost each week to manual updates, or an oversold product that damaged a customer relationship. If none of that is happening yet, a well-maintained spreadsheet is a perfectly legitimate system, not a placeholder for something better. This is the same build-versus-buy question that applies to most small business software decisions, and the same vendor-neutral test applies: buy a purpose-built tool by default once the pain is real, rather than building or bolting together a workaround. If the friction is showing up across more than just inventory, for example in customer records or reporting too, it is worth checking the broader signs your business has outgrown spreadsheets.

How does selling across multiple channels change inventory management?

The moment you sell the same product on Shopify and a marketplace such as Amazon, eBay or Catch, a spreadsheet stops being safe. Two channels updated by hand will drift out of sync, and the failure mode is an oversold unit: a customer pays for something you no longer have, on both channels, at once. The fix is structural, not behavioural. Nominate one system as the single source of truth for stock on hand, and sync every channel to it automatically rather than relying on someone remembering to update each one after a sale. This is usually the first paid inventory tool worth adding, well before your catalogue is large enough to need forecasting software, because the cost of an oversell, in refunds, marketplace penalties and a frustrated customer, is high relative to the tool's price.

What does poor inventory management actually cost an ecommerce business?

The costs are real even when they never show up as a single line item. Holding costs, storage, insurance, and the capital tied up in stock sitting on a shelf, quietly reduce the margin on everything else you sell. Dead stock, product that has stopped selling, does the same thing more severely: it consumes cash and space while returning nothing, and the longer it sits, the more it typically has to be discounted to move at all. Stockouts cost you the sale directly, plus the wasted ad spend that drove the visitor to an empty product page, plus, for a repeat customer, a small dent in trust. None of these show up neatly on a profit and loss statement, but together they are one of the quieter ways inventory quietly erodes the margin that funds the rest of the business. Treating inventory as a discipline rather than an afterthought is what keeps that leak closed.

Where to start

You do not need to build a full system this week. Start with your top ten to twenty products by revenue, calculate a real reorder point and safety stock for each using your actual lead times, and put a recurring reminder in place to review them monthly. That single habit, applied consistently to the products that matter most, closes most of the gap between "managing stock by feel" and running inventory properly, well before any software purchase is necessary. If you want a second set of eyes on where your stock levels or systems are quietly costing you money, book a consultation and we will work through your numbers together.