Supermarket Price Tracker Template

Log grocery prices across stores and apps, compare like-for-like by unit price and see where each product is cheapest.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Checklists

Tables

Products, Price checks

Fields

19

Views

grid, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Products

10 fields · 5 sample rows

  • Products (Grid)
  • Shopping list (Grid)
ProductTextCategorySingle selectCompare perSingle selectPrice checksLink to another tableChecksCountLowest unit priceRollupHighest unit priceRollupAverage unit priceRollupMax savingFormulaOn my listCheckbox
Amul butterDairykg13 Nov 2026, 15 Nov 20262₹550.00₹620.00₹585.0011%Yes
Basmati riceStapleskg13 Nov 2026, 16 Nov 20262₹179.80₹209.00₹194.4014%
Sunflower oilStapleslitre13 Nov 2026, 17 Nov 20262₹147.00₹162.00₹154.509%Yes
BananasProducekg18 Nov 2026, 18 Nov 20262₹40.00₹54.00₹47.0026%
Surf Excel detergentHouseholdkg14 Nov 20261₹136.67₹136.67₹136.670%
Field details
Product · Text
Category · Single select
Staples, Dairy, Produce, Snacks, Household, Personal care
Compare per · Single select
kg, litre, 100 g, piece
Price checks · Link to another table
Links to Price checks
Checks · Count
Lowest unit price · Rollup
min of Unit price via Price checks
Highest unit price · Rollup
max of Unit price via Price checks
Average unit price · Rollup
avg of Unit price via Price checks
Max saving · Formula
IF({Highest unit price}, ({Highest unit price} - {Lowest unit price}) / {Highest unit price}, BLANK())
On my list · Checkbox

Price checks

9 fields · 8 sample rows

  • Price log (Grid)
  • Add a price (Form)
  • Store comparison (Dashboard)
DateDateProductLink to another tableStoreSingle selectBrand / variantTextPriceCurrencyPack sizeNumberUnit priceFormulaOn offerCheckboxNotesText
13 Nov 2026Amul butterDMart500 g pack₹275.000.500₹550.00
15 Nov 2026Amul butterBlinkit100 g pack₹62.000.100₹620.00
13 Nov 2026Basmati riceDMartIndia Gate Classic 5 kg₹899.005.000₹179.80Yes
16 Nov 2026Basmati riceBigBasketIndia Gate Classic 5 kg₹1,045.005.000₹209.00
13 Nov 2026Sunflower oilDMartFortune 5 L can₹735.005.000₹147.00
17 Nov 2026Sunflower oilReliance SmartFortune 1 L pouch₹162.001.000₹162.00
18 Nov 2026BananasLocal kiranaRobusta, 1 dozen (~1.5 kg)₹60.001.500₹40.00
18 Nov 2026BananasZeptoRobusta 1 kg₹54.001.000₹54.00
Field details
Date · Date
Product · Link to another table
Links to Products
Store · Single select
DMart, BigBasket, Reliance Smart, Blinkit, Zepto, Local kirana
Brand / variant · Text
Price · Currency
INR
Pack size · Number
Unit price · Formula
IF({Pack size}, ROUND({Price} / {Pack size}, 2), BLANK())
On offer · Checkbox
Notes · Text

Form view “Log a price” asks for: Date, Product, Store, Brand / variant, Price, Pack size, On offer, Notes.

Supermarket Price Tracker Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates