Grocery Price Monitoring: Tracking Tesco Prices, Clubcard Deals & Unit Costs
Grocery price monitoring sounds simple until you try it. A supermarket shelf price is only one of several numbers attached to a product. There is the unit price, the member price, the multibuy offer and the availability flag, and each can change on its own schedule. If you only capture the headline price, you miss most of what actually drives shopper decisions.
To show what a proper capture looks like, we collected a free sample from the Milk, Butter & Eggs aisle of Tesco Groceries in the UK. You can download it from the Tesco grocery prices dataset page. This article walks through what is in it, what it says about Clubcard pricing and own-label positioning, and how to build a repeatable monitoring process around data like this.
Why grocery price monitoring needs more than a shelf price
Supermarkets compete on perception as much as on pounds. Loyalty pricing makes this sharper: the price a member pays is not the price a visitor sees, and a tracker that reads only one of them will misreport the market.
For brands, retailers and analysts, the questions are practical:
- How far below the shelf price does a loyalty offer sit?
- What share of a category is on some form of deal at any moment?
- How do pack sizes compare once you normalise to price per litre or per kilo?
- Which lines are unavailable, and for how long?
Answering these takes structured, repeatable supermarket price data, not screenshots. We cover the wider case for this approach in why ecommerce data collection matters and in how data becomes a strategic advantage.
What our Tesco sample shows
The sample holds 97 products from the dairy and eggs shelves, captured on 27 October 2026. Sponsored placements from other aisles were removed, and rows were deduplicated by product ID. All figures below are computed directly from the CSV.
Headline numbers
- Average shelf price: £2.52, with a median of £2.30. Prices run from £0.65 to £6.25.
- Clubcard price present: 20 of 97 products (20.6%).
- Any promotion (Clubcard price or multibuy text): 28 of 97 products (28.9%).
- Average Clubcard saving: £0.65 per item, which is 23.5% off the shelf price on average. The median discount is 24.5%.
- Deepest Clubcard discount: 43.2%, on a Starbucks iced coffee line.
- Out of stock: 3 products were flagged unavailable.
Own-label versus branded
We treated products whose brand name starts with "Tesco" (including Tesco Finest) as own-label. There are 33 of them in the sample, with an average shelf price of £1.99. The other 64 products average £2.79. Looking only at items quoted per litre, the median own-label unit price is £1.15 against £2.30 for the rest.
Own-label lines also rely less on loyalty pricing. Only one of the 33 carries a Clubcard price. Their low everyday price does the work that a member discount does for branded products.
Unit of measure mix
Unit prices are quoted per litre for 54 products, per kilo for 22 and per item for 21. That mix matters: you cannot compare a per-litre figure with a per-kilo one, so any comparison has to group by the unit column first.
Excerpt: Clubcard versus shelf price
| product_id | title | price_gbp | unit_price | unit | clubcard_price |
|---|---|---|---|---|---|
| 321222903 | For Goodness Shakes Protein Strawberry Shake 471ml | 3.00 | 6.37 | litre | 2.25 |
| 321208028 | For Goodness Shakes Protein Chocolate Shake 471ml | 3.00 | 6.37 | litre | 2.25 |
| 330772677 | Clarence Court Leghorn White 10 Medium Free Range Eggs | 4.75 | 0.48 | each | 4.25 |
| 390097699 | Happy Egg Poached Eggs 4 Pack | 3.50 | 0.88 | each | 3.00 |
| 390097552 | Happy Egg Boiled Eggs 6 Pack | 3.50 | 0.58 | each | 3.00 |
The protein shakes show the pattern clearly: a 25% member discount on a product that is otherwise priced well above the aisle average per litre. The egg lines show a smaller absolute gap of £0.50 to £0.60 but still a visible one.
A single day is a snapshot, not a trend. Scheduled refreshes are what turn this into price history.
Clubcard price versus regular price
The Clubcard gap is the most useful single metric in this data. Two measures are worth tracking:
- Coverage: the share of products with a member price. Here it is about one in five.
- Depth: the discount relative to the shelf price. Here it averages roughly a quarter.
Together they describe how aggressively a category is promoted. A category with high coverage and shallow depth behaves differently from one with low coverage and deep cuts. Brands can use this to see whether a competitor is buying volume through discounts, and retailers can check whether their own offers sit in the same range.
Note that the sample records the member price as a separate column rather than overwriting the shelf price. That keeps the regular price available for trend analysis, so a temporary discount does not look like a permanent price cut.
Multibuy and other promotions
Beyond Clubcard prices, the promotion column keeps any offer text that is not a simple member price, such as "Any 2 for £4" deals on selected dairy products or half-price labels. In this sample, 8 products carry such text.
Offer text is messy by nature. Wording varies, offers apply to groups of products ("Selected Oatly Ambient Drink") and some have conditions. If you plan to analyse them at scale, keep the raw text and add parsed fields such as offer type, required quantity and effective unit price in a second step. Parsing too early destroys information you may want later.
Unit price comparison
Unit prices are how shoppers, and regulators, compare different pack sizes. In the sample they range from £0.65 to £10.50 per litre, so the spread within one aisle is wide. Single-serve coffee drinks and cultured creams sit at the top, while own-label milk sits near the bottom.
Practical tips:
- Compare only within the same
unitvalue. - Recompute unit price yourself from pack size when you can, to catch rounding in the displayed figure.
- Watch for the "each" unit on eggs, where the number of items per pack drives the comparison.
Which fields matter and why
| Field | Why it matters |
|---|---|
product_id |
Stable key for joining snapshots over time |
price_gbp |
The everyday shelf price |
unit_price and unit |
Fair comparison across pack sizes |
clubcard_price |
Member price, kept separate from the shelf price |
promotion |
Raw offer text for multibuys and labels |
in_stock |
Availability signal for gap and shortage analysis |
scraped_at_utc |
Timestamp needed for any time series |
The product ID is the most important field for monitoring. Titles change when a pack is renamed, but the ID lets you follow the same item through those changes.
Use cases
- FMCG brands: track retail price against recommended price and see when competitors are on promotion.
- Retailers: benchmark own-label ladders and loyalty pricing against a rival.
- Price comparison and cost-of-living tools: feed basket calculators with current prices and unit costs.
- Analysts and journalists: build price indices for staples like milk, butter and eggs from observed data.
- Pricing teams: test elasticity models against real promotional calendars.
Common challenges in grocery data scraping
Grocery data scraping is harder than it looks, and our sample collection showed some of the reasons:
- Anti-bot measures. Large retailers protect their sites. Some pages in our run needed a full browser-rendering step, and a few page requests failed outright before others in the same series succeeded. Retries and fallbacks are part of the job.
- Pagination. Category pages split results across numbered pages, and results can shift between requests. You need to deduplicate by product ID.
- Sponsored items. Listings can include advertised products from other aisles. We removed those so the sample reflects the dairy and eggs shelves.
- Layout changes. Data embedded in the page can be renamed or restructured without notice. Parsers need tests and alerts.
- Data quality. Missing member prices, odd units and promotion text need normalising before analysis.
- Location dependence. Availability and some prices can vary by region or store, so requests should be made from the target market.
How often should you refresh?
For fast-moving staples and promotions, daily is a sensible default. Weekly refreshes can work for strategic benchmarking, where you care about positioning rather than individual deals. If you track promotional calendars, capture at least once per promotion cycle so you do not miss short offers. Whatever you choose, keep every snapshot with its timestamp, since history is what makes the data valuable.
FAQ
Is this a complete Tesco price tracker? No. It is a free sample of 97 products from one aisle, captured on a single day. A Tesco price tracker needs scheduled refreshes across the categories you care about.
Are Clubcard prices included?
Yes. The clubcard_price column holds the member price when one is shown, and it is empty otherwise. In this sample, 20 products have one.
Why are some unit prices per kilo and others per litre?
Because the retailer quotes the unit that suits each product. Group by the unit column before comparing values.
Can I get other supermarkets or categories? Yes. Datasets can cover other retailers, whole departments and regular refreshes. Request a sample of your own target to see the format.
Next steps
If you want a similar capture for another retailer, category or country, request a free sample of your own target. Our datasets start from $49, and you can see the options on the pricing page. You can also download the Tesco sample CSV to test it in your own pipeline first.
Author: DataHarbor Team