Introduction
As private label products grow in popularity across platforms like Walmart (Great Value), Target (Good & Gather), and Amazon (Amazon Fresh), national brands are under pressure to remain competitively priced. Understanding how private labels are priced in real time, and how frequently they undercut name brands, is critical.
Actowiz Solutions partnered with a major U.S. FMCG company to automate the comparison of national brand SKUs vs private labels using daily pricing insights across top platforms.
Objectives
- Track and compare pricing for 150+ brand SKUs and their private label counterparts.
- Monitor regional price variations and discount behavior.
- Detect undercutting trends by ZIP code and platform.
- Generate weekly reports for sales and pricing optimization.
Key Challenges
- Identifying true equivalents between private label and branded SKUs.
- Handling inconsistent naming and package sizes.
- Detecting subtle promotional strategies like bundling and hidden discounts.
Actowiz’s Implementation Strategy
1. Product Matching Engine:
- Mapped private label SKUs to national brands based on size, type, and nutritional specs.
- Used semantic matching (e.g., “Peanut Butter Creamy 16oz” vs “Nutty Delight Creamy 15.9oz”).
2. Price Monitoring Pipeline:
- Tracked daily prices via Walmart and Target APIs and Amazon scraping.
- Focused on 10 ZIP codes per platform, refreshed every 4 hours.
3. Reporting Framework:
- Calculated average % undercut by category and region.
- Highlighted top private-label pressure zones.
- Dashboard segmented by SKU pair, platform, city.
Sample Price Comparison Data
SKU Pair |
Platform |
ZIP |
Brand Price |
Private Label Price |
Price Gap |
Undercut % |
Jif Peanut Butter 16oz vs GV |
Walmart |
77001 |
$3.49 |
$2.59 |
$0.90 |
25.8% |
Cheerios 12oz vs Good & Gather |
Target |
10001 |
$3.99 |
$3.19 |
$0.80 |
20.1% |
Bounty 6-Roll vs Amazon Brand |
Amazon |
30301 |
$9.99 |
$8.49 |
$1.50 |
15.0% |
Results & Insights
🔹 92% SKU Matching Accuracy
- High-confidence pairing enabled meaningful analysis.
🔹 Avg. Undercut: 18.4% Nationwide
- Private labels priced lower in 83% of matched comparisons.
🔹 Regional Impact Analysis
- Greater pricing gaps found in urban ZIP codes vs rural ones.
🔹 Strategy Alignment
- Client realigned brand discounts in high-pressure categories.
Dashboard Deliverables
- Brand vs Private Label Undercut Map
- Category-Wise Price Gap Trends
- ZIP Code Pressure Index
- Weekly Competitive Alert Summary
Technology Stack
- Languages: Python, JavaScript
- Frameworks: Flask, FastAPI
- Databases: PostgreSQL, MongoDB
- Scraping/API: Amazon Scraper, Walmart/ Target APIs
- Visualization: Power BI, Looker Studio
Why Actowiz Solutions?
- 📊 Category-level price intelligence
- ⚖️ Matched private-label product intelligence
- 🚀 Real-time scraping + API hybrid model
- 🌎 Scalable coverage across major U.S. metros
Client Testimonial
“The private label visibility we gained with Actowiz changed our pricing game. We now move quicker and smarter on every retail channel."
— Director of U.S. Trade Analytics, CPG Brand
Next Steps
- Integrate loyalty pricing into gap analysis
- Add sentiment analysis from reviews
- Predict undercut trends using historical patterns
Conclusion
In an age where private labels are aggressively gaining ground, Actowiz Solutions helped this brand stay ahead with real-time, SKU-level visibility. The result: better pricing control, more effective promotion planning, and actionable insights that drive profit.