Automating Competitor Price Tracking to Protect Margin & Inform Strategy
Industry: Industrial Wholesale (Mining, Medical, Air Systems)
Focus: Competitive Analysis, Price Intelligence, Margin Recovery
Tools: Python, SQL Server, Excel VBA, OEM Matching, Web Scraping
If this sounds like you — pricing decisions rely on gut feel, spreadsheets are outdated, and nobody knows whether products are truly competitive or quietly losing margin — the problem is not pricing discipline.
The real problem is visibility. Without structured competitor data, pricing becomes reactive, and profit leaks quietly across hundreds of SKUs.
This project turned fragmented competitor data into an automated intelligence system that surfaces margin risk and pricing opportunities every month.
The Hidden Problem
After years of growth, the business had effectively lost control of its pricing strategy. Margins were eroding, some products were unknowingly priced below cost, and price updates were reactive rather than strategic.
- No structured competitor price tracking
- No connection between OEM data and internal SKUs
- Manual price updates creating inconsistency
- Executives lacking visibility across the range
Without reliable data, pricing became a guessing game — costing the company profit every month.
The Practical Fix
- Python Web Scraper
Captured competitor prices, SKUs, pack sizes and OEM numbers directly from major supplier websites. - OEM to SKU Matching Engine
Built a VBA-powered rule engine to map competitor OEM numbers to internal SKUs. - SQL Reporting Layer
Cleaned and structured competitor data to calculate price variance, margin risk, and market positioning. - Automated Monthly Reports
Delivered executive-ready Excel dashboards highlighting pricing risks, opportunities, and competitor movements.
The Result
- Uncovered hundreds of SKUs priced below cost
- Recovered margin through strategic price adjustments
- Created a repeatable automated pricing review process
- Enabled supplier negotiations backed by real data
- Shifted pricing from reactive to strategic
Rule of thumb: If you are not monitoring competitor prices systematically, your margins are drifting whether you realise it or not.
Implementation Snapshot
- Scraped competitor websites using Python automation.
- Matched OEM numbers to internal SKUs using VBA logic.
- Loaded structured data into SQL reporting tables.
- Generated automated pricing variance analysis.
- Delivered monthly executive pricing review reports.
Key Takeaways
- Manual pricing left large margin blind spots
- Python and VBA automated competitor monitoring
- SQL analysis surfaced hidden pricing risks
- Hundreds of SKUs identified as underpriced
- Leadership now adjusts pricing proactively
Bring pricing under control
Automate competitor tracking, surface margin risks, and turn pricing into a strategic advantage.
Book a Strategy Call