Once a week, walk the shelves and write down the ten items with the earliest expiry dates, with the date, the quantity and the days left. Apply one rule: when two weeks are left, move the item to the front and discount it. This takes about 20 minutes and saves you from throwing away stock you have already paid for.
How do you build the weekly dated list?
- Start at the shelves where short-life goods sit: biscuits, noodles, juices, sauces, snacks and dairy-based items.
- Read the printed date on the pack, not the date on your invoice. Write item, expiry date and quantity on one line.
- Keep going until you have the ten earliest dates across the shop, replacing the latest entries as you find earlier ones.
- Next to each line, write the days left and what you will do about it.
What does a made-up list look like?
Say the walk happens on 10 November and your rule is to discount at 14 days or fewer.
| Item | Expiry | Qty | Days left | Action |
|---|---|---|---|---|
| Biscuit pack | 18 Nov | 12 | 8 | Discount, front shelf |
| Instant noodles | 21 Nov | 9 | 11 | Discount, bundle |
| Fruit juice 1 litre | 26 Nov | 6 | 16 | Watch, recheck next week |
| Tomato ketchup | 30 Nov | 4 | 20 | Watch |
| Tea 500 g | 5 Dec | 7 | 25 | Watch |
The days left are counted from 10 November: 18 - 10 = 8, 21 - 10 = 11, and for juice 26 - 10 = 16. For the December date, November has 30 days, so 20 days remain to 30 November plus 5 more gives 25. In a spreadsheet with the expiry date in column B, days left is =B2-TODAY() and the action can be =IF(C2<=14,"Discount","Watch").
Why discount at two weeks and not at the last minute?
A discount works only if customers have time to buy. A pack with two days left rarely sells at any price, but a pack with two weeks left often does. Say an item costs you ₹40 and the printed price is ₹50. Selling at ₹45 earns ₹5. Binning it loses ₹40. You can afford a deep cut on the last few pieces long before the loss becomes real.
How do you keep the older stock selling first?
- When new stock arrives, put it behind or beneath the old pieces.
- Check the dates of the delivery when it comes in. If a pack arrives with very short life, ask the supplier about replacing it while the delivery is fresh.
- Keep short-dated items at eye level or near the billing counter for impulse buying.
- Never cover, alter or relabel a printed date, and never keep expired goods on the shelf.
What if you have no time for a full walk?
Split it. Check one section of the shop each day instead of everything on one day, and keep a single running list that you correct as you go. Items with the shortest life, such as bread and dairy, deserve a quick look every day.
What do you do when stock arrives already short-dated?
Check the dates on the day of delivery, before you sign the challan. If many packs have a very short life, ask the supplier whether they will replace or take them back, and note the answer. Over a few months this shows you which supplier or distributor sends you the shortest dates, which is a good reason to talk to them or to change the order pattern.
What to note on the sheet each week
- How many items went to discount this week, and how many of them sold.
- What expired, with its cost.
- Which supplier's goods arrive with the shortest dates.
- Which items you ordered too much of, so you can order fewer next time.
After four weeks, read the sheets together. If the same product appears again and again, the fix is a smaller order, not a better discount.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


