Back to portfolio
Market Analytics & Assortment Expansion
The system collects market data, finds gaps in the assortment, and generates ready procurement hypotheses — 12M+ records processed
2025 · ~3 months
Client: Japan Parts — auto parts packager (~60,000 SKUs), focused on adapting assortment for the rapidly growing Chinese vehicle market
Problem
Assortment not keeping up with market changes (especially China)
No systematic way to identify new in-demand SKUs
Manual analysis of competitor price lists and marketplaces
No transparent mechanism for generating procurement hypotheses
What Was Built
System for collecting and aggregating competitor and marketplace price data
SKU matching mechanism through catalogs
Automated assortment and price segment analysis
Wishlist and target-list generation for the procurement team
Order generation with supplier distribution
Web interface with personal dashboard, file upload, data processing, and analytics
AI assistant (chatbot) for real-time data queries
Approach
Chaotic market data systematized into a unified structure
Continuous monitoring instead of one-off research
Analytics converted into operational action (procurement)
Results
Continuous assortment expansion system established
Reduced decision time for new SKUs
Procurement team works with ready hypotheses, not from scratch
Real-time data access including supplier negotiations
12M+ records processed and structured