Home > > > Hourly UK Supermarket Price Tracker — 12 Chains | Actowiz

Hourly UK Supermarket Price Tracker — 12 Chains | Actowiz

Author : Actowiz Solutions | Published On : 12 Jun 2026

12

UK SUPERMARKETS

1 hr

REFRESH CYCLE

85K

SKUs TRACKED

£3.8M

ANNUAL UPLIFT

Project Snapshot

What This Project Delivered

An hourly-refresh pricing API covering 12 of the UK's largest supermarkets — Tesco, Sainsbury's, Asda, Morrisons, Ocado, Aldi, Lidl, Waitrose, M&S Food, Iceland, Co-operative Food, and Amazon Fresh — with approximately 85,000 SKUs tracked and price changes captured within the hour they happen. Built for a London-based UK shopping app that turned grocery price comparison into a real-time consumer product.

Industry: GroceryTech / UK Shopping & Price Comparison App

Geography: UK-wide coverage across England, Scotland, Wales, and Northern Ireland

Chain Coverage: 12 leading UK supermarkets:

  • Tesco

  • Sainsbury's

  • Asda

  • Morrisons

  • Ocado

  • Aldi

  • Lidl

  • Waitrose

  • M&S Food

  • Iceland

  • Co-op

  • Amazon Fresh

SKU Coverage: Approximately 85,000 active SKUs across:

  • Grocery

  • Fresh Produce

  • Frozen Foods

  • Household Products

  • Baby Care

  • Pet Care

Refresh Frequency:

  • Hourly Updates (Premium Tier)

  • Daily Backstop Sweep for full catalogue validation

Delivery Methods:

  • REST API

  • Webhook Events for Price-Change Triggers

  • Daily CSV Snapshots

Compliance: UK GDPR aware; pricing and product data only, with no personal data collected or processed

Client Overview

The client is a London-headquartered GroceryTech startup running a UK shopping app that helps British households save money on weekly grocery shopping. The app surfaces the cheapest supermarket for a user's specific basket — letting families decide whether to drive to Asda, click-and-collect from Tesco, or order from Ocado for the same week's groceries.

UK grocery is one of the most competitive retail markets in the world. The 'Big Four' (Tesco, Sainsbury's, Asda, Morrisons) plus disruptors (Aldi, Lidl), premium players (Waitrose, M&S), specialists (Ocado, Iceland, Co-op), and the digital-native entrant (Amazon Fresh) make every shopping decision a multi-way comparison. The £200 billion UK grocery market sees price changes happen multiple times a day — often in response to competitors moving first.

For a UK shopping app to be genuinely useful, the data behind it has to move at the speed of the market. Daily refresh is not enough when Tesco can drop a price on milk at 7 AM and Sainsbury's matches within 90 minutes. The app's founder explicitly required hourly refresh — and built the business around that promise to consumers.

Why UK Grocery Demands Hourly Refresh

UK supermarkets reprice multiple times per day, especially on staples — milk, bread, eggs, fresh produce. Competitive matching happens within hours. Loyalty pricing (Tesco Clubcard, Sainsbury's Nectar) adds another dynamic layer. Daily snapshots miss 60-70% of real price movements. Hourly tracking is the threshold where the data actually reflects the market.

Business Challenges

Building an hourly-refresh API across 12 UK supermarkets — at scale, sustainably, and within UK GDPR — presented five distinct challenges:

Challenge #1 — 12 Heterogeneous Platforms

Each of the 12 supermarkets runs a completely different e-commerce platform. Tesco's site behaves nothing like Sainsbury's. Ocado has its own engineering culture. Amazon Fresh inherits Amazon's infrastructure. M&S Food redirects to Ocado for some categories. Building 12 separate integrations — each with its own anti-bot defences, refresh patterns, and quirks — required dedicated chain expertise.

Challenge #2 — Hourly Refresh at Scale

Hourly refresh across 12 chains × 85,000 SKUs means over 2 million data points per hour, 50 million per day. Sustaining this without disruption — without exhausting proxy budgets, triggering anti-bot defences, or hitting platform rate limits — required serious infrastructure engineering.

Challenge #3 — Loyalty Pricing (Clubcard, Nectar) Complexity

Tesco Clubcard prices, Sainsbury's Nectar prices, and similar loyalty tiers create dual price structures. The same product shows £3.50 for non-members and £2.50 for Clubcard holders. For a consumer app to be accurate, both prices have to be captured cleanly and presented honestly.

Challenge #4 — UK GDPR Compliance

The UK GDPR (under the UK Data Protection Act 2018) imposes strict rules on data scraping. The client needed an absolute guarantee that no personal data was captured — only product and pricing information. ICO complaints over scraping practices have grown significantly in recent years; compliance was not optional.

Challenge #5 — Cross-Chain Product Matching

Tesco's 'British Whole Milk 2.272L' had to match Sainsbury's 'Whole Milk 4 Pint', Asda's 'Whole Milk 2.272L', and Ocado's '2.272L Whole Milk'. Without canonical matching, the app could not show 'Tesco £1.45 vs Sainsbury's £1.55 vs Asda £1.40' — it could only show four unrelated products. Matching is what makes comparison possible.

Pre-Project Cost Analysis

Before partnering, the client evaluated three alternatives — each with severe limitations:

In-House 12-Chain Build: £580K/year

Generic Data Vendor (Daily Updates Only): £320K/year

Partial Coverage (Big 4 Supermarkets Only): £180K/year

Actowiz Partnership (Hourly Refresh, Full 12 Chains): £140K/year

The Actowiz hourly partnership was the only option offering full 12-chain coverage at hourly refresh — and at a cost lower than even the partial-coverage daily alternative.

Project Objectives

Together with Actowiz Solutions, the client defined six measurable objectives:

  • Track approximately 85,000 SKUs across all 12 priority UK supermarkets

  • Refresh pricing data on an hourly cycle, with sub-hour latency on critical price changes

  • Capture both base prices and loyalty (Clubcard / Nectar) tier prices accurately

  • Build canonical product matching for true cross-chain comparison

  • Maintain UK GDPR compliance — no personal data captured anywhere in the pipeline

  • Deliver via REST API with webhook events on price changes for real-time app updates

Actowiz Solutions Approach

Actowiz built a 5-stage hourly pricing pipeline tuned to UK grocery's specific dynamics and the UK GDPR regulatory environment:

  • CAPTURE
    12 chain-specific hourly crawlers

  • MATCH
    Canonical UK product taxonomy

  • ENRICH
    Loyalty pricing + multi-buy parsing

  • DETECT
    Price change events + alerts

  • SERVE
    REST API + webhooks + snapshots

Stage 1 — 12 Dedicated Chain Crawlers

Actowiz built 12 separate chain-specific crawlers — each engineered for its target platform's structure, defences, and refresh tolerances. UK-region residential proxy infrastructure rotated across English, Scottish, Welsh, and Northern Irish IP pools, ensuring authentic regional pricing where chains differ by geography. Browser automation handled JavaScript-heavy frontends (Tesco, Ocado); mobile API capture handled chains with stronger app interfaces (Asda).

Stage 2 — Canonical UK Product Taxonomy

A UK-specific product taxonomy was built — handling British grocery conventions like pint vs litre measures, '2 for £3' multi-buy offers, weight-based produce pricing, and loyalty-tier variants. Each chain's native SKU was mapped to a canonical UK product ID, enabling 'whole milk 2.272L' across all 12 chains to roll up to a single comparable entity.

Stage 3 — Loyalty & Multi-Buy Enrichment

Loyalty pricing was captured separately and labelled clearly — Tesco Clubcard prices, Sainsbury's Nectar prices, and Asda Rewards prices were tagged as loyalty variants rather than mixed into base pricing. Multi-buy offers ('3 for £5', 'Buy 1 Get 1 Free') were parsed into structured offer records so the app could surface real per-unit costs.

Stage 4 — Price-Change Event Detection

An hourly diff engine compared each refresh against the prior snapshot, surfacing every price change as a structured event — including direction (up/down), magnitude, percentage change, and competitive context. These events fired webhooks to the client's app within minutes of detection, enabling near-real-time consumer alerts ('Bread just dropped 22% at Tesco near you').

Stage 5 — UK GDPR-Compliant Delivery

Data delivery was strictly product-only — no personal data, no customer reviews with identifiable information, no scraped account data. Every pipeline component was audited against UK ICO guidance. Authentication, rate-limiting, and per-app data scoping enabled secure multi-tenant use as the client onboarded enterprise partners.

Sample Data Snapshot (Illustrative)

Example #1 — 12-Chain Coverage Matrix

Pipeline coverage across the 12 priority UK chains (illustrative):

  • Tesco

    • Tier: Big Four

    • SKUs: ~12,800

    • Refresh Frequency: Hourly

    • Loyalty Tier: Clubcard Prices

  • Sainsbury's

    • Tier: Big Four

    • SKUs: ~10,400

    • Refresh Frequency: Hourly

    • Loyalty Tier: Nectar Prices

  • Asda

    • Tier: Big Four

    • SKUs: ~9,600

    • Refresh Frequency: Hourly

    • Loyalty Tier: Rewards Prices

  • Morrisons

    • Tier: Big Four

    • SKUs: ~8,900

    • Refresh Frequency: Hourly

    • Loyalty Tier: More Card Prices

  • Ocado

    • Tier: Premium Online

    • SKUs: ~11,200

    • Refresh Frequency: Hourly

    • Loyalty Tier: Smart Pass

  • Aldi

    • Tier: Discounter

    • SKUs: ~3,800

    • Refresh Frequency: Hourly

    • Loyalty Tier: —

  • Lidl

    • Tier: Discounter

    • SKUs: ~3,600

    • Refresh Frequency: Hourly

    • Loyalty Tier: Lidl Plus

  • Waitrose

    • Tier: Premium

    • SKUs: ~6,400

    • Refresh Frequency: Hourly

    • Loyalty Tier: myWaitrose

  • M&S Food

    • Tier: Premium

    • SKUs: ~5,200

    • Refresh Frequency: Hourly

    • Loyalty Tier: Sparks

  • Iceland

    • Tier: Frozen Specialist

    • SKUs: ~3,400

    • Refresh Frequency: Hourly

    • Loyalty Tier: Bonus Card

  • Co-operative Food

    • Tier: Convenience

    • SKUs: ~4,800

    • Refresh Frequency: Hourly

    • Loyalty Tier: Co-op Membership

  • Amazon Fresh

    • Tier: Digital-Native

    • SKUs: ~5,200

    • Refresh Frequency: Hourly

    • Loyalty Tier: Prime

Coverage Insight

The Big Four chains (Tesco, Sainsbury's, Asda, Morrisons) account for roughly 50% of tracked SKU volume but reflect about 65% of UK grocery market share. Adding the 8 specialist and discounter chains captures the remaining critical pricing dynamics — discounter price floors (Aldi/Lidl), premium positioning (Waitrose/M&S), and digital-only competition (Amazon Fresh).

Example #2 — Cross-Chain Hourly Price Snapshot

Single-product, single-postcode (SW1A 1AA, London) price comparison at 14:00 on a Tuesday:

Tesco

  • Base Price: £1.55

  • Loyalty Price: £1.40 (Clubcard)

  • Multi-Buy: —

  • Best Net Price: 🏆 £1.40

Sainsbury's

  • Base Price: £1.55

  • Loyalty Price: £1.45 (Nectar)

  • Multi-Buy: —

  • Best Net Price: £1.45

Asda

  • Base Price: £1.45

  • Loyalty Price: £1.45 (Rewards)

  • Multi-Buy: —

  • Best Net Price: £1.45

Morrisons

  • Base Price: £1.55

  • Loyalty Price: £1.50 (More)

  • Multi-Buy: —

  • Best Net Price: £1.50

Ocado

  • Base Price: £1.55

  • Loyalty Price: —

  • Multi-Buy: —

  • Best Net Price: £1.55

Aldi

  • Base Price: £1.39

  • Loyalty Price: —

  • Multi-Buy: —

  • Best Net Price: 🏆 £1.39

Lidl

  • Base Price: £1.39

  • Loyalty Price: —

  • Multi-Buy: —

  • Best Net Price: 🏆 £1.39

Waitrose

  • Base Price: £1.65

  • Loyalty Price: —

  • Multi-Buy: —

  • Best Net Price: £1.65

M&S Food

  • Base Price: £1.70

  • Loyalty Price: —

  • Multi-Buy: —

  • Best Net Price: £1.70

Iceland

  • Base Price: £1.50

  • Loyalty Price: —

  • Multi-Buy: —

  • Best Net Price: £1.50

Co-op

  • Base Price: £1.65

  • Loyalty Price: £1.55 (Member)

  • Multi-Buy: —

  • Best Net Price: £1.55

Amazon Fresh

  • Base Price: £1.55

  • Loyalty Price: £1.55 (Prime)

  • Multi-Buy: —

  • Best Net Price: £1.55

💡 App Consumer Recommendation

For 'Whole Milk 2.272L' near SW1A 1AA at 14:00 Tuesday: Aldi or Lidl at £1.39 if shopping in person; Tesco at £1.40 with Clubcard if doing a larger weekly shop online. Premium chains (Waitrose, M&S) priced 18-22% higher than discounters on this staple.

Example #3 — Real-Time Price Change Webhook Event

Sample webhook payload fired when a price change is detected (illustrative JSON):

  • event_type: price_change.detected

  • event_id: EVT_8472001_20260521

  • chain: Tesco

  • canonical_product_id: UK_PROD_847200

  • product_name: Whole Milk 2.272L

  • previous_price: £1.55

  • new_price: £1.40

  • change_direction: decrease

  • change_magnitude: -£0.15

  • change_percentage: -9.7%

  • loyalty_tier: Clubcard

  • detected_at: 2026-05-21T14:08:42Z

  • app_action_suggested: Notify nearby app users — major staple price drop

  • competitive_context: Now £0.05 below Sainsbury's, matches Asda + Co-op

Key Features Delivered

12-Chain UK Coverage: All Big Four supermarkets plus Ocado, Aldi, Lidl, Waitrose, M&S Food, Iceland, Co-op, and Amazon Fresh.

Hourly Refresh: Continuous hourly data capture across all 12 chains with sub-hour latency for critical price changes.

Loyalty Pricing Layer: Separate tracking of 8 loyalty programs, including Clubcard, Nectar, Rewards, More, Sparks, Lidl Plus, myWaitrose, and Prime.

Canonical UK Taxonomy: Standardized cross-chain product matching for accurate like-for-like grocery comparisons.

Multi-Buy Parsing: Structured extraction of promotions such as "2 for £3", BOGOF, mix-and-match offers, and bundle discounts.

⚡ Webhook Events: Real-time price-change notifications automatically pushed to client applications upon detection.

UK GDPR Compliant: Product and pricing intelligence only; no personal data collected or processed.

Daily CSV Backstop: Complete daily snapshots provided for reporting, analytics, auditing, and historical tracking.

Business Impact

Seven months after launch, the hourly UK pricing pipeline delivered transformational impact for the client's shopping app:

Annual Uplift: £3.8M

Active App Users: 180K

Average User Basket Savings: £412/year

Cost vs In-House Build: 76% Lower Cost

Impact Breakdown 

  • App Subscription Revenue: £1.65M

  • Enterprise API Licensing: £0.92M

  • Cost Saved vs In-House Build: £2.57M Saved

  • Premium Tier Upsell: £0.38M

Combined 7-month impact: approximately £2.95M revenue uplift + £2.57M build cost saved. Annualised run rate: approximately £5.05M — significantly ahead of the £3.8M projected business case.

Strategic Wins

  • Launched flagship 12-chain hourly coverage feature in just 9 weeks — a differentiator no competitor app matched

  • 180,000 active users by month 7, growing at 22% month-over-month

  • Average user reported £412/year basket savings using the app's recommendations

  • Enterprise API licensing deals signed with 4 UK grocery analytics firms

  • App featured in major UK consumer press as 'the smartest grocery savings app for British families'

  • Premium tier (real-time alerts) launched 4 months in — adopted by 24% of paid users within 60 days

  • UK GDPR audit passed with zero findings — ICO complaint risk eliminated

Client Feedback

"We made an audacious promise to UK shoppers: see real prices, refreshed every hour, across every supermarket that matters. Daily-refresh data would have made that promise a lie. Actowiz delivered exactly the infrastructure that turned the promise into a product — 12 chains, hourly cycles, loyalty pricing, UK GDPR clean. Seven months later, we have 180,000 active users, £2.95M in revenue, and enterprise deals in the pipeline. None of it works without the data partnership we have here."

— Founder & CEO, London-Based UK Shopping App

Conclusion

UK grocery is one of the world's most price-competitive retail markets — and one of the fastest-moving. Tesco can move first on milk pricing at 7 AM and force Sainsbury's, Asda, and Morrisons to match by lunchtime. Loyalty schemes create dual pricing structures. Discounters like Aldi and Lidl set the price floor. Premium chains hold the ceiling. A consumer app trying to make sense of this with daily-refresh data is already lying to its users.

Actowiz Solutions delivered the alternative: hourly-refresh capture across 12 priority UK supermarkets, with loyalty pricing layered cleanly, multi-buy offers parsed, and webhook events firing on every detected change. All built within UK GDPR boundaries from day one. The result for the client: £3.8M annualised revenue uplift, 180K active app users, enterprise licensing deals signed, and a 76% cost advantage versus the in-house build alternative.

For UK GroceryTech, shopping apps, retail analytics firms, and price-comparison platforms, the era of daily-refresh data is functionally over. Real-time consumer products demand real-time data — and partners able to deliver hourly cycles at scale, sustainably, and compliantly are the ones that turn ambitious app visions into shipped, growing products.

https://www.actowizsolutions.com/hourly-12-supermarket-uk-price-tracker-shopping-app.php