Introduction
In today’s hyper-competitive grocery market, missing SKUs or out-of-sync assortments across top platforms like Walmart, Target, and Amazon Fresh can directly lead to lost revenue and poor customer experience.
To address this problem, a leading U.S. CPG (Consumer Packaged Goods) company partnered with Actowiz Solutions to build a real-time assortment gap detection engine, enabling data-driven decisions to optimize listing presence across online platforms.
Client Objective
- Track the availability of 500+ SKUs across Amazon Fresh, Walmart, and Target.
- Detect which products were missing from specific platforms or ZIP codes.
- Identify product duplication and inconsistent variants.
- Get daily actionable reports for internal sales and platform account teams.
Business Challenges
- SKU naming and packaging differences across platforms.
- Region-specific listing gaps undetected by sales teams.
- Platform APIs didn’t always surface out-of-stock vs. delisted SKUs.
- Need for high-frequency updates (4x per day).
Actowiz Solutions’ Strategy
1. Multi-Platform API & Scraping Setup:
- Walmart & Target APIs were integrated for real-time inventory queries.
- Amazon Fresh used headless scraping with region-based simulation.
- Proxy pools ensured unblocked access to geotargeted product pages.
2. SKU Matching Intelligence:
- Used NLP + fuzzy logic to align product names, brand, variant, pack size.
- Created a master SKU sheet to benchmark across platforms.
3. Gap Detection Engine:
- Mapped SKU availability across 50 U.S. ZIP codes.
- Color-coded daily dashboard showing:
- ✅ Present
- ❌ Missing
- ⚠️ Out of Stock
4. Alerts & Reporting:
- Slack/email alerts triggered when top SKUs were missing or had no stock on any major platform.
- Automated Excel reports with timestamps, category-level analysis, and recommended actions.
Sample Data Snapshot
| SKU ID |
Product Name |
ZIP Code |
Walmart |
Amazon Fresh |
Target |
Gap Status |
| 10012 |
Tropicana Orange 52oz |
10001 |
✅ |
❌ |
✅ |
Missing on Amazon |
| 10345 |
Lay’s Classic 8oz |
60601 |
⚠️ |
✅ |
❌ |
Missing on Target |
| 10876 |
Cheerios 12oz |
90210 |
✅ |
✅ |
✅ |
Complete |
Results
🔹 93% Coverage Accuracy in SKU Detection
- Only 7% of SKUs had inconsistencies due to variant mismatch, which were flagged and corrected.
🔹 2,100+ Gaps Detected in 30 Days
- Across regions and categories, ensuring complete visibility.
🔹 Platform-Specific Trends Identified:
- Target had the most frequent delistings in the Beverage category.
- Amazon Fresh had delayed relisting after out-of-stock events.
🔹 25% Faster Restocking Response
- Sales teams acted quicker using gap alerts to initiate relisting.
Visual Dashboards Delivered
- Assortment Heat Map (SKU vs. Platform vs. ZIP)
- Gap Trends Over Time
- Category-Level Missing SKU Charts
- Priority Gaps by Revenue Impact
Tech Stack Used
- Languages: Python, Node.js
- Frameworks: Flask, FastAPI
- Data Layer: PostgreSQL + MongoDB
- APIs: Walmart & Target APIs, Amazon Scraper (Selenium + Puppeteer)
- Dashboards: Power BI, Looker Studio
- Deployment: AWS EC2, S3, Lambda
Why Actowiz Solutions?
- 🚀 Fast Go-To-Market (Live in 14 days)
- 📈 Expertise in platform-specific inventory monitoring
- 🔄 Automated daily insights + alert system
- 🌐 50+ ZIP code geolocation-based gap mapping
Client Feedback
"Our teams used to spend weeks manually detecting listing issues. Now, Actowiz shows us SKU gaps before our customers even notice. Game-changer!"
— U.S. Director of Omni-Channel Operations
Future Roadmap
- Integrate Kroger and Costco data feeds
- Add competitor price comparisons into same dashboard
- Correlate product gaps with revenue impact & reviews
Conclusion
Actowiz Solutions helped this CPG brand close the loop on lost digital shelf visibility by providing a precise, real-time view of assortment gaps across Walmart, Amazon, and Target. As online grocery competition intensifies, automated SKU gap analysis has become a vital weapon for retail success.
