Shopping

Local shop or app for regular items? A six-week price trial

A six-week price trial for five regular items bought from a neighbourhood shop and from an app, with fees included and a made-up result to learn from.

Editorial illustration for Local shop or app for regular items? A six-week price trial

To find out whether your local shop or a grocery app is cheaper for the things you buy every week, run a six-week trial. Pick five regular items, buy the same pack sizes from both for six weeks, and log item prices, delivery fees and tips on the app side. Add up each column at the end. The trial gives you a number for your own basket instead of a general claim.

How do I pick the five items and set the rules?

  • Choose items you buy every week and that come in fixed packs: atta 5 kg, toor dal 1 kg, cooking oil 1 litre, tea 250 g and detergent 1 kg are examples.
  • Match brand and pack size exactly on both sides. A different brand is a different item.
  • Buy them at the shop and on the app, either alternately or by splitting the basket, but price both for the same week. It is the price that you log, not necessarily the purchase.
  • Note a substitution or stock-out when it happens.

What does the log look like?

One row per week with columns for shop total, app item total, app fees and the week's note. A made-up six weeks is below.

WeekShop basketApp basketApp feesApp total
1₹1,010₹980₹30₹1,010
2₹990₹960₹30₹990
3₹1,020₹1,010₹0₹1,010
4₹1,000₹985₹30₹1,015
5₹1,030₹1,000₹0₹1,000
6₹1,010₹990₹30₹1,020
Total₹6,060₹5,925₹120₹6,045

Add the columns: the shop comes to ₹6,060, the app items to ₹5,925 and the fees to ₹120, so the app total is ₹6,045. The difference is ₹15 over six weeks in favour of the app, which is about ₹2.50 a week.

How do I read the result?

A gap of ₹15 over six weeks is a tie. When the totals are that close, decide on other things: whether the shop will deliver, whether you can pay at month end, whether the app has the right brand every time, and how much time each route costs. A big gap, say ₹300 or more over the same period, is a different story and worth acting on.

In a sheet, if the weekly shop totals are in B2 to B7 and the app totals are in E2 to E7, the six-week difference is =SUM($B$2:$B$7)-SUM($E$2:$E$7). A positive result means the app was cheaper.

What can distort the trial?

  • A first-order or festival discount on the app that will not repeat. Log it, but mark the row.
  • Delivery fees that vary with basket size. Record each week's fee as charged.
  • Prices that change within a week. Note the date you checked.
  • Loose items at the shop that have no printed price on a pack.

Where does the data come from?

The shop side is your slip or UPI payment, the app side is the order summary. If you import your bank or card statement into SpendixAI, the app orders and the shop payments land in the same Groceries category after you review them, so you can compare the totals for the six weeks quickly. The item prices still come from your own log.

A three-week version is faster, but the longer run is worth it when your basket is irregular, because a single week can be skewed by an offer or a stock-out. Keep the same five items throughout, even if you are tempted to add a sixth halfway, so that the weekly figures remain comparable.

After six weeks

  1. Total each column and write the difference.
  2. Decide whether the gap is large enough to change where you buy.
  3. If it is small, pick the route that is less effort or friendlier to your cash flow.
  4. Repeat the trial after a year, since prices and offers change.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports