Delivery team online — 09:30–19:00 IST
How to · Ecommerce and marketplaces

How to forecast stock for the holiday peak

Commit holiday inventory with a defensible method, separating baseline demand from event uplift and sizing the real cost of being wrong either way.

You have to commit before you know anything

Holiday inventory decisions are made six to ten weeks before the demand arrives because that is what supplier lead times require. You are committing cash against a number nobody can verify yet. Order too little and your best week sells out on day two. Order too much and the excess goes into a quiet January at a discount.

Forecasting does not remove that risk. It makes the bet explicit and sized so that when you are wrong you are wrong by a margin the business can absorb. That is the entire ambition and any method promising more is overstating itself.

The two kinds of being wrong cost different amounts

Before forecasting anything price both errors because they are rarely symmetric. Overstocking costs the capital locked in unsold goods plus storage plus the discount required to clear it. Understocking costs the contribution on sales you could not fulfil plus any marketplace ranking you lose when a listing goes out of stock mid-event plus the buyer who goes to a competitor and stays there.

For most categories understocking a proven seller costs more than overstocking it and overstocking an unproven line costs more than understocking it. That asymmetry should drive the plan. It argues for depth on known winners and caution on anything new.

Who should not forecast a holiday uplift

A store in its first year has nothing to forecast from. Without a comparable previous season any uplift multiple is invented and committing capital against an invented number is how first-year stores end up with a warehouse they cannot clear. Buy conservatively instead and arrange the fastest possible reorder path with your supplier even at a worse unit price. Paying more per unit for flexibility is cheap compared with a write-off.

Made to order businesses should not stockpile at all. Their constraint is production capacity during the window and the useful planning work is scheduling labour and raw materials rather than finished goods. Forecasting finished stock for them creates inventory they would never otherwise hold.

And a business whose working capital is already tight should deliberately plan to understock. This is the uncomfortable recommendation. A stockout costs you revenue you never had. Unsold peak-season inventory bought on credit can end the business. If a bad season would leave you unable to pay suppliers in February then forecast low and accept the lost sales as the price of surviving. No forecasting method changes that calculation.

Building the number

Work at item level and not in aggregate dollars. Start with the current weekly run rate per item from a recent normal month. That is the baseline and the part you actually know.

Then take last year's peak trading period and calculate the uplift each item saw over its own baseline at that time rather than over the category average. Uplift is wildly uneven across a catalogue. Apply last year's multiple adjusted for how the business has grown and for structural changes such as a new marketplace or a dropped channel.

Three corrections then matter. Allow for returns and chargebacks because gross orders overstate true sell-through and understate what comes back weeks later. Map the dates properly since marketplace events and the main holiday dates do not fall in the same week every year and a forecast anchored to the wrong week fails on timing rather than on volume. Finally set a reorder cut-off. Work back from supplier lead time to the last date a top-up can arrive in time and place a second smaller order then using the first fortnight of real demand. Splitting the commitment into two tranches removes much of the risk at a slightly worse unit price.

What to measure during and after

Total holiday revenue flatters. It rises with discounting and advertising spend and looks respectable whether the stock plan was good or disastrous. Selling out flatters even harder because it feels like success. A line that sold out on day three of a fortnight-long event cost you the remaining eleven days.

Measure sell-through per item at the close of the window against what you committed. Alongside it record stockout days per item during the event. Those two together tell you which items to go deeper on next year and which to halve. After the season measure what remains and what it eventually clears for. The true result of a holiday plan is known only once the leftovers are sold.

The common mistake

The common mistake is forecasting one uplift multiple and applying it across the catalogue. It is quick and it is wrong at the level where the money is made. Your best sellers under this method are understocked and sell out early while your slow lines are overstocked and come back as January discount stock. The aggregate forecast can be almost exactly right while every individual item is wrong.

The second mistake is forecasting sales without forecasting cash. Marketplace payouts arrive on a cycle and supplier payments often do not wait for them. A store can have an excellent Black Friday on paper and still be unable to pay for the stock that produced it. Build the cash timeline alongside the unit forecast and check that the gap between paying for inventory and being paid for it is one you can fund.

This guide explains how something works. It is not legal, tax or financial advice, and rules change. Confirm anything regulatory with a qualified professional before you act on it.