Stocking for Diwali without a January hangover

Buy to last year's festival curve, not to hope, and decide how each item leaves the godown before you order. A planning table and checklist for shops.

The safest way to plan festival season inventory is to buy to last year's sales curve for each item, not to your hopes for this year, and to decide how every item will leave your godown before you place the order. If you cannot name the exit for an item, you are not ready to buy it. Do that, and January becomes a normal month instead of one spent paying suppliers for boxes that never moved.

Why does festival stock cause trouble after the season?

Because the buying decision and the selling result arrive months apart. The order goes in when everyone is optimistic, suppliers are pushing schemes and the shop is busy. The bill falls due when the rush is over. Anything unsold is now cash locked in your godown, often in decorative, gift-packed or seasonal goods that do not sell well again until the next festival.

The hangover is rarely one big mistake. It is many small extras, a few more cases of every line "just in case", that add up to a stock pile nobody planned.

What does "buy to last year's curve" mean?

It means using what you actually sold last festival season, item by item, as the starting point for this season's buy. Not total turnover, not what the supplier says the market will do, and not what your neighbour is stocking.

Pull three things for each item from last year's records:

Quantity sold during the festival weeks. Not purchased, sold.
When it sold. Did it go early in the run-up, steadily, or only in the last few days?
What was left after the season. Leftovers mean you overbought, even if the item "did well".

Then adjust carefully. If an item sold out early and you turned customers away, buy a little more. If you had leftovers, buy less, by roughly the amount left over. If it sold exactly right, repeat the quantity. Resist rounding everything up.

If your records are in notebooks or scattered spreadsheets, this is the step that hurts. Our comparison of Excel and inventory software covers what it takes to get item-level history you can trust.

Why plan the exit before you buy?

Because your bargaining power is highest before the order is placed. Once the stock is in your godown, the supplier has no reason to take it back on good terms. Before you sign, you can ask for:

A return or exchange window for unsold, undamaged stock
Split delivery, with part of the quantity sent only if you call for it
A quick repeat order, so you can buy less upfront and top up
Credit terms that run past the season, so you pay after you have sold

Every item also needs a fallback: a party who takes leftovers at a known markdown, a bundle with a fast mover, or a plan to carry it to next year if it does not date. Writing this down forces an honest question: if this does not sell, what will it cost me?

How do I build the festival planning table?

One row per item. Fill in the last two columns before you call the supplier. The numbers below are illustrative, for a small gift and home-goods shop.

Item	Last year sold	Buy qty	Exit plan
Dry fruit gift boxes	220 boxes, sold out in the final week	250 boxes	Supplier exchange for unopened boxes; remainder sold to a corporate-gifting party at a set markdown
Decorative diyas, painted	600 pieces, 90 left over	500 pieces	Carry to next season; packed and stored dry
Steel dinner sets	40 sets, steady sales	40 sets, plus agreed repeat order of 10	Does not date; sells through wedding season
Branded sweets tins	150 tins, 30 left, near expiry	110 tins	Split delivery; second lot only on call
New LED string lights	Not stocked	60 pieces, test lot	Bundle with diyas; return window agreed with supplier

Read the table across, not down. Every buy quantity is explained by the column before it, and every row has an exit. The row for a new item has the smallest buy and the strongest exit, which is correct for something you have no history on.

For items with an expiry date, the exit column must account for shelf life. Stock that cannot be carried over needs a sell-through or return plan, and picking should follow first-expiry-first-out. See FIFO, LIFO and FEFO explained.

How do reorder points change in festival weeks?

Your normal reorder point assumes normal demand and normal lead times. Festival weeks break both: demand rises and transporters and factories slow down. Use last year's festival weeks for your daily usage and a festival lead time measured from last season's purchase orders. Our guide to the reorder point formula works through the calculation.

The better approach for most shops is to buy a smaller opening lot and rely on a reorder point to top up, instead of buying the whole season's stock on day one. The opening lot covers the early weeks; the reorder covers the peak, and you only place it if the item is actually moving.

What changes for a distributor?

A distributor carries the festival risk for many retailers at once. The same two rules apply, with one more layer: your retailers' orders are themselves a forecast. Ask your key parties for their festival indent early, compare it with what they actually lifted last season, and buy to the lower of the two plus a sensible cushion.

Agree return terms with retailers as clearly as you agree them with your principal, so leftovers do not come back to you without warning. Our piece on wholesale distributor inventory covers managing stock across many parties and locations.

Common mistakes to avoid

Buying to purchases, not sales. Last year's purchase bill includes what you overbought.
Taking the scheme. A free case on a slab you do not need is extra stock you paid for.
One rule for every item. Fast, high-margin lines deserve cover; slow, decorative lines deserve caution.
No exit for new lines. New items are where leftovers usually come from.
Ignoring the post-season review. Write down, item by item, what was left in January. That is next year's curve.

When does this approach not apply?

If you have no sales history at all, for instance in your first festival season, there is no curve to buy to. Start from comparable items or supplier guidance, keep every lot small and lean entirely on quick repeat orders. It also matters less for goods that do not date and sell year-round; carrying a little extra of those is a cash question, not a dead-stock risk.

Pre-order checklist

Last year's festival sales pulled item by item
Leftovers from last season noted against each item
Buy quantity justified by the history
Exit plan written for every row
Return, split-delivery and credit terms agreed in writing
Festival lead times and reorder points set
Treatment of supplier returns and markdowns confirmed with your CA

FAQ

Should I buy more than last year if business has grown? Only where you can see the growth in your own records, item by item. Overall turnover rising does not mean every line will sell more. Scale up the items that sold out early last season, keep the rest at last year's quantity, and treat any extra as a small top-up you reorder, not a bigger opening buy.

What counts as an exit plan for leftover festival stock? A written decision, made before buying, on where unsold stock goes: back to the supplier under an agreed return or exchange, sold off to a party at a set markdown, bundled with a fast mover, or carried into the next season if it does not date. If none of these is possible, buy less.

How do I plan for an item I have never stocked for the festival? Use a comparable item from last season as your guide, then buy a deliberately small first lot. Agree a quick repeat order with the supplier so you can top up if it moves. New festival lines are a test, and a test should never be big enough to hurt your cash if it fails.

Does festival stock change anything on the GST side? The principles are unchanged: purchases need proper invoices for input tax credit, and returns, discounts and stock write-offs each have their own treatment. Rules and figures change, so confirm how to record supplier returns and clearance markdowns with your CA or the official GST portal before the season rather than after. See input tax credit rules for small businesses.