To check whether a sale discount is real, log the item's price every day for 30 days before the sale, then compare the sale price with your own average and lowest figures instead of the crossed-out price. If the sale price is about the same as your 30-day average, the headline discount is mostly a comparison with a high starting point. Your log is the only reference that cannot be moved.
What do you need to log?
- The date.
- The price shown for one fixed variant, same colour, size and seller.
- The delivery fee shown at your pin code.
- The crossed-out MRP or list price, if shown.
- A note if a bank or coupon offer is advertised on the page.
A reminder at the same time every day makes this stick. Even every second day works if the price does not move much. Take a screenshot if you want proof, and save it in a folder named after the product.
What does a made-up 30-day log look like?
Say you want a wireless speaker. The sale is announced, and the page shows a crossed-out price of ₹5,999 and a sale price of ₹3,799, with a label saying 37% off. Your own log for the 30 days before looks like this:
| Days | Price per day | Number of days | Subtotal |
|---|---|---|---|
| Days 1 to 10 | ₹3,499 | 10 | ₹34,990 |
| Days 11 to 20 | ₹3,599 | 10 | ₹35,990 |
| Days 21 to 28 | ₹4,299 | 8 | ₹34,392 |
| Days 29 to 30 | ₹4,499 | 2 | ₹8,998 |
| Total | Average ₹3,812 | 30 | ₹1,14,370 |
The thirty daily prices add up to ₹34,990 + ₹35,990 + ₹34,392 + ₹8,998 = ₹1,14,370, and ₹1,14,370 ÷ 30 comes to about ₹3,812. A formula for this is =AVERAGE($B$2:$B$31) when each day has its own row.
How does the sale price compare?
The advertised discount works out as (₹5,999 − ₹3,799) ÷ ₹5,999, about 37%. Against your own log, the picture changes:
- Against the 30-day average of about ₹3,812: the sale price is ₹13 lower, a drop of roughly 0.3%.
- Against the lowest log price of ₹3,499: the sale price is ₹300 higher, which is 8.6% more.
- Against the price in the last two days before the sale, ₹4,499: it is ₹700 lower, but that is ₹1,000 above where the log started.
In this made-up case, the price climbed before the sale, and the sale brought it back to roughly where it had been. It is not a terrible price, but it is not a 37% bargain either. You could have paid ₹300 less in the first ten days.
What if you did not log it in time?
Start now for the next sale. For a product you already follow, begin logging at least a month before a big event, such as a festival season or an end-of-season sale. If you must decide today, compare two or three other sellers for the same model, with delivery and returns.
What should you do with the result?
- If the sale price is at or below your lowest, it is a good time to buy, provided you need the item.
- If it is near the average, ask whether you would buy it at this price on any normal day.
- If it is above the average, skip it and keep logging.
Once you buy, record the amount you actually paid. If you track expenses in SpendixAI, an imported statement or hand entry shows the real price, and later you can see how much of the month's shopping came from sales. Remember that a sale is a reason to look, not a reason to buy.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

