Tracking Weekly Grocery Discounts Across Tesco, ASDA & Sainsbury’s Powered by Actowiz Solutions

The Challenge: Manual Price Tracking Fails at Scale

The client — a global snack and beverage manufacturer — was launching multiple products across UK supermarkets and faced several pricing challenges:

Key Pain Points:

• Inconsistent visibility into weekly discount patterns
• Lack of competitor benchmarking (brand vs private label)
• Manual Excel tracking from public websites — time-consuming and error-prone
• No visibility into regional pricing differences across stores

They needed a solution that could:

• Track weekly promotions, discounts, and pricing shifts for specific SKUs
• Cover Tesco, ASDA, and Sainsbury’s comprehensively
• Provide structured data and trend reports every week
• Include historical comparisons and price change triggers

The Actowiz Solution: Weekly UK Supermarket Scraping System

To address the challenge, Actowiz Solutions deployed a custom web scraping pipeline tailored for the UK grocery market.

Platforms Covered:

• Tesco.com – including Clubcard Prices
• ASDA.com – including Rollback & multibuy offers
• Sainsburys.co.uk – including Nectar card savings

🔧 Our Multi-Layered Approach:

1. SKU & Variant Normalization

We matched client products and competitor SKUs across the three retailers, accounting for:

• Pack sizes (e.g., 6-pack vs 12-pack)
• Branded vs private label
• Multibuy or bundle formats

2. Weekly Scraping Scheduler

We scheduled crawlers to run every Friday to capture:

• Weekend discounts
• Loyalty card offers
• Time-limited flash deals

3. Promotions & Discount Detection

Each product entry included:

• Original price
• Discounted price
• % discount
• Promotion type (e.g., “2 for £3” or “£1 off”)
• Start and end date (when visible)

4. Retailer-Specific Tag Parsing

Retailers like Tesco and Sainsbury’s use custom HTML structures for promotions. We built parsers to extract:

• Nectar / Clubcard offers
• Multibuy details
• “Rollback” vs “Everyday Low Price” flags

5. Delivery Zone Emulation (Advanced Layer)

For deeper insights, we emulated store locations in London, Manchester, and Birmingham to detect regional price variations (optional for brands with zonal strategies).

Sample Dataset – Price Comparison Table

Here’s an example of weekly grocery pricing for a sample soft drink SKU across the three retailers:

Insight: Tesco had a temporary deeper discount in Week 2, while ASDA maintained a consistent rollback and Sainsbury’s ran a stable Nectar promotion across all weeks.

Chart: Discount Pattern Trends

plaintext

CopyEdit

Chart Title: % Weekly Discount Trends (Soft Drink SKU)

X-axis: Weeks (Jul 1–Jul 21)

Y-axis: Discount %

Lines:

- Tesco (Clubcard)

- ASDA (Rollback)

- Sainsbury’s (Nectar)

Insight: Tesco often initiates deeper short-term discounts, while ASDA maintains stable rollbacks. Sainsbury’s uses loyalty-linked savings with modest but steady percentages.

Strategic Impact for the Brand

After implementing Actowiz’s solution, the client was able to:

Benefits Delivered:

Use Cases Enabled

Promo Planning

Marketing teams aligned campaign budgets based on competitor activity — launching deeper discounts where needed.

Retail Negotiation

Sales teams used weekly trend reports to negotiate better positioning with Tesco buyers and justify pricing with ASDA category heads.

Regional Stock Management

Supply chain teams reallocated inventory when price drops triggered regional spikes in demand — saving overstocking in low-performing zones.

Pricing War Response

When ASDA launched a surprise rollback in Week 3, the brand launched a reactive 2-for-£2.50 bundle on Tesco within 72 hours — a move supported by Actowiz's rapid alert trigger.

Additional Retail Data Tracked

To enrich insights, Actowiz also scraped:

• Nutritional info and labels
• Product descriptions and images
• Ratings & reviews (to detect price-satisfaction gaps)
• Availability/stockout notices in select areas

This allowed category managers to match price drops with consumer sentiment and shelf dynamics.

Expansion Plans

Actowiz is now replicating this model in:

And for UK expansion:

• Morrisons & Iceland data scraping in Q3 2025
• Ocado online-only analysis by Q4 2025

Reporting Format

Clients receive:

• Weekly pricing dashboards (Power BI or Google Data Studio)
• Automated email digests every Monday
• CSV/Excel exports with custom SKU tags
• Discount alert triggers via Slack or Teams

Takeaways

1. Discount Depth ≠ Sales Success

Even a 5% discount advantage can capture shelf space — if executed regionally and timed right.

2. Weekly Tracking Beats Monthly Averages

Retailers change prices weekly, sometimes bi-weekly. Acting on stale data means lost opportunities.

3. Clubcard, Rollback & Nectar Have Different Strategies

Understanding the mechanism of discounting matters as much as the percentage.

4. Historical Trends Predict Future Behavior

With 6 months of data, brands can anticipate pricing patterns and run seasonal promotions proactively.