Diwali Stock Planning: Avoid ₹2L in Unsold Sweets

The most profitable month of the year is also where most supermarkets destroy the most value

Last Diwali, a supermarket owner in Coimbatore stocked ₹8 lakhs worth of sweets and dry fruits. He sold ₹6.2 lakhs by November 15th. The remaining ₹1.8 lakhs — kaju katli hardening in the display case, dry fruit gift boxes that nobody wanted the day after Diwali, premium chocolates that had crossed from "festive gift" to "overpriced impulse buy" overnight — recovered exactly ₹40,000 through clearance sales, staff discounts, and donations. Net loss: ₹1.4 lakhs on what should have been his most profitable month.

This isn't an outlier. This is the default outcome for the majority of Indian supermarkets during Diwali. The festival that should generate 25-30% of annual profit instead becomes a margin destruction event, and it happens for a specific, identifiable reason: the stocking decision is made in September based on optimism, and the market reality reveals itself in November when it's too late to do anything about it.

The paradox is genuine. You cannot miss Diwali. Empty dry fruit sections in October mean lost customers — not just for the festival, but year-round, because the customer who finds your store inadequately stocked during the most important shopping period of the year draws conclusions about your store's overall reliability. But overstocking Diwali items is categorically different from overstocking, say, cooking oil, because Diwali inventory has a hard cliff. Nobody wants Diwali sweets on November 16th. The product doesn't just decline in value — it drops to approximately zero overnight. There's no "wait and sell it eventually" option. Whatever doesn't sell by the evening of Diwali is gone.

the "last year plus 20%" trap that nearly everyone falls into

The stocking methodology at most supermarkets is a version of this: last year we stocked ₹6 lakhs, business grew about 15% this year, so let's stock ₹7 lakhs, maybe ₹7.5 to be safe. The word "safe" is doing heavy lifting in that sentence, and it's doing it in the wrong direction.

The critical error is basing this year's order on last year's stocking, not last year's sales. If you stocked ₹7.5 lakhs last year and sold ₹6 lakhs, the relevant number is ₹6 lakhs. Growing 15% from ₹6 lakhs gives you ₹6.9 lakhs — not the ₹8.6 lakhs you'd get from growing the stocking number, which already included ₹1.5 lakhs of unsold product. Every year, the overstocking compounds on itself, with last year's inflated number becoming this year's baseline, and the post-Diwali write-off grows in lockstep.

The early-bird pressure makes it worse. Distributors push September ordering — "book by the 15th for the best prices and selection" — which means you're committing capital two months before the festival based on vibes and a rough growth assumption. By the time October arrives and you can actually see demand signals (which neighbourhood is feeling flush, which competitor opened nearby, how the economy is treating your customer base), the orders are locked. The scheme discount you got on that ₹2 lakh gift box order looks a lot less compelling when ₹80,000 of it ends up in the donation pile.

the 60-30-10 model (or: how to stop betting everything on September guesswork)

The stores that consistently lose the least on Diwali don't make one big ordering decision. They make three smaller ones, each informed by progressively better data.

60% of the budget goes into core stock, 4-6 weeks before Diwali. These are proven SKUs that sell every year: loose dry fruits, standard packaged sweets, established chocolate brands. Conservative quantities — enough to fill the shelves and capture early-season purchases, not enough to survive a demand shortfall. For an ₹8 lakh budget, that's ₹4.8 lakhs committed by early October, focused on products with longer shelf life and lower Diwali-specificity (loose cashews sell year-round; kaju katli gift boxes don't).

30% goes into demand-response stock, 2-3 weeks before Diwali. This is where the data starts talking. If gift boxes are moving slower than expected, redirect that ₹2.4 lakhs toward loose dry fruits that are flying off the shelf. If premium sweets are outperforming projections, order more. The key is that this 30% remains liquid until you have actual sales data to guide it. Two weeks of sell-through data is infinitely more valuable than two months of optimistic forecasting.

10% stays cash, reserved for the final week. Emergency fills for surprise demand — the gift set that suddenly became the corporate favourite, the sweet variety that went viral on Instagram. You'll pay premium prices for last-minute orders. That's fine. The math on paying 10% more for a product you'll definitely sell is vastly better than the math on paying 10% less for a product that might rot in your storeroom.

If the last 10% isn't needed, it stays as cash. Cash on November 16th is worth more than any Diwali inventory on November 16th.

category-by-category: where the risk really concentrates

Traditional mithai is where the biggest losses happen, for the simple reason that it has the shortest fuse: 5-15 days, even refrigerated. The stores that manage this well don't order mithai until 10-12 days before Diwali, stop reordering 5 days before, and start marking down aggressively on the day of Diwali itself — 20% off on the evening, 40-50% the next day, donation by day three. The emotional resistance to discounting a product you bought at full margin two days ago is real, but the alternative is a 100% loss, which makes a 40% discount look like a gift.

Dry fruits split into two categories with fundamentally different risk profiles. Loose dry fruits — cashews, almonds, raisins in bulk — have longer effective shelf life, can be repackaged with regular inventory post-Diwali, and offer flexible quantity management. The risk is low. Packaged gift boxes are the opposite: high margin (buy for ₹800, sell for ₹1,500, nearly 50% gross), but zero flexibility. Diwali-specific packaging becomes unsellable the moment the festival passes. The gift box market also shifts unpredictably year to year — customers might suddenly prefer ₹800 boxes over ₹1,200 ones, or shift to online gifting services entirely. A 70/30 split favouring loose dry fruits over gift boxes protects against the catastrophic case while still capturing the gift box margin.

Chocolates are the safety category. They have 6-12 months of shelf life, year-round demand, and packaging that doesn't scream "Diwali leftover" in December. The only Diwali-specific risk is chocolate gift boxes with festive packaging — keep those to 20% of your chocolate budget and you're covered. The remaining 80% sells through Christmas, New Year, and the long tail of "I should bring something when I visit" occasions.

velocity tracking: the dashboard that changes everything

Once Diwali stock arrives, the single most important discipline is daily sell-through tracking by SKU. Not weekly. Daily. Because the selling window is 3-4 weeks, and a product that's tracking at 40% sell-through in week one is not going to magically accelerate in week three. It's going to end up in the donation pile unless you intervene now.

The calculation is simple. You ordered 100 boxes of a gift set. Ten sold in week one. Three weeks remain. At current pace, you'll sell 40 total. That's 60 unsold boxes worth ₹48,000. If you discount 10% now, you'll move more volume and recover 90% of margin. If you wait until post-Diwali, you'll recover 30% at best. The difference between acting on week-one data and acting on post-Diwali panic is ₹20,000-30,000 on a single SKU.

A supermarket owner in Coimbatore (the first one I mentioned, who learned from his ₹1.4 lakh loss) switched to digital sell-through tracking the following year. The system flagged gift boxes as slow movers on day 8. Previous years he wouldn't have noticed until day 20. He ran a promotion early, cleared 80% at 10% discount instead of clearing 50% at 40% discount post-Diwali. That one early alert was worth ₹16,000 in recovered value, and he had dozens of similar interventions across his Diwali inventory.

supplier negotiations you should be having but probably aren't

Your post-Diwali data is your most powerful negotiating tool for next year's pre-Diwali orders, and most supermarkets throw it away.

When a supplier wants you to commit to ₹2 lakhs of gift boxes in September, the right response is: "Last year I ordered ₹2 lakhs, returned ₹80,000, and recovered ₹24,000. That cost me ₹56,000. I'll commit to ₹1.2 lakhs this year unless you offer a 15-day post-Diwali return window." The supplier who wants your business will negotiate. The supplier who won't is asking you to absorb risk that should be shared.

During the season, the leverage continues: "This SKU isn't moving. Your competitor's product is outselling it 3:1. Can you swap it for a different variant at the same terms?" Post-season: "Your non-returnable policy cost me ₹40,000. That's factored into next year's discussion." Document everything — every unsold unit, every forced markdown, every gap between what was promised and what happened. Suppliers respond to data. They do not respond to complaints without numbers behind them.

the number that matters isn't revenue — it's sell-through rate

Successful Diwali stocking isn't about maximising sales. It's about maximising the percentage of inventory that sells at or near full margin.

A store that stocks ₹6 lakhs and achieves 90% sell-through at full margin is dramatically more profitable than a store that stocks ₹10 lakhs and achieves 75% sell-through with heavy post-Diwali discounting. The first store made less revenue and more profit. The second store's Diwali "success" (look at those sales numbers!) actually destroyed value once you account for the ₹2.5 lakhs of unsold stock and the margins sacrificed on the clearance items.

The target: 85%+ sell-through with less than 5% post-Diwali unsold. Get there by ordering from data not hope, tracking daily not monthly, adjusting weekly not never, and accepting small early losses (a 10% markdown in week two) to avoid catastrophic late losses (a 50% markdown on November 16th, if anyone's even buying).

That ₹2 lakhs sitting as unsold sweets the morning after Diwali started as an ordering decision in September. Make better September decisions, informed by last year's actual sales data, and the November problem shrinks to a manageable size.

ShelfLifePro provides real-time sell-through tracking, expiry countdowns, and FEFO automation for festival inventory. Because Diwali should be your most profitable month, not your most expensive lesson.