Tracking 5M+ SKUs Across 50 E-commerce Sites for Real-Time Price & Stock Monitoring

Executive Summary

Client Industry: Global Consumer Electronics & Home Appliances

Markets Covered: North America, Europe, Asia-Pacific

Scope: 5M+ SKUs, 50 e-commerce platforms, daily price & stock refresh

Objective: Real-time competitive price intelligence and inventory visibility

Actowiz Solutions designed and implemented an enterprise-scale multi-platform scraping system that monitors millions of SKUs daily, enabling our client to optimize pricing, detect competitor moves, and improve supply chain planning.

Introduction / Background

Our client, a global retail leader in electronics and appliances, operates in multiple countries and sells through both direct channels and third-party marketplaces. They faced:

• Fragmented competitive data spread across different regions and platforms
• Frequent price changes and flash sales they could not track in real-time
• Stock visibility issues leading to lost sales opportunities

Without a unified price and inventory monitoring system, decision-making was reactive instead of proactive.

Challenges & Goals

Challenges:

• Scale: Over 5 million SKUs to be monitored daily.
• Platform Diversity: Amazon, Walmart, Best Buy, Target, Flipkart, and 45+ regional e-commerce sites — each with different structures.
• Data Complexity: Need to capture not just base price, but discounts, coupon offers, multi-pack pricing, and stock status.
• Latency: Competitor pricing changes multiple times per day.
• Compliance: Scraping must follow local laws and platform policies.

Goals:

• Build a real-time, scalable scraping infrastructure.
• Normalize product data for easy cross-platform comparison.
• Provide instant alerts for price changes, stock-outs, and promotions.
• Integrate with client’s BI system for automated decision-making.

Solution Approach

Actowiz Solutions built a global price and stock intelligence platform using:

• Cloud-based scalable crawlers for 24/7 monitoring.
• Geo-targeted IP rotation for local price accuracy.
• AI-powered product matching to map SKUs across platforms.
• Real-time API feeds delivering fresh data into client’s ERP & BI tools.

Features Implemented:

• 1. Multi-Currency Conversion: All prices converted to USD & local currencies.
• 2. Stock Status Detection: “In stock”, “Low stock”, “Out of stock” tracking.
• 3. Promotion Capture: Coupons, bundle deals, BOGO, and flash sale flags.
• 4. Historical Price Trends: Daily archiving for analytics.
• 5. Custom Alerts: SMS/email notifications for high-impact changes.

Results & Insights

Measurable Outcomes:

• Data Coverage: 99.3% SKU coverage across 50 platforms.
• Price Change Detection: 97% accuracy in tracking daily adjustments.
• Stock Visibility: Improved out-of-stock detection from 48 hrs to under 3 hrs.
• Decision Speed: Pricing strategy adjustments now occur same day, instead of weekly.

Key Insights Delivered:

• Competitor A ran unannounced weekend discounts 12 times in 3 months.
• Platform B’s sellers frequently used hidden coupons to undercut MAP prices.
• Certain SKUs had high volatility in the Indian and Middle Eastern markets.

Conclusion & Future Outlook

By integrating Actowiz Solutions’ real-time scraping system, the client transformed their pricing and inventory management from reactive to predictive.

Future plans:

• Add AI-driven price forecasting models.
• Expand monitoring to quick commerce platforms.
• Implement image-based price recognition for in-store shelf tracking.