The Challenge: Breaking the “Warehouse” Silo
The client, a major regional wholesaler (CrazyService), operated on a legacy infrastructure where critical business data (10,000+ SKU, real-time stock levels, tiered pricing) was trapped in a static ERP system (1C).
The Problem: Manual updates caused “Data Latency” — the website showed outdated prices and stock, leading to lost sales and operational chaos.
The Architecture: A classic “Polling” model where the frontend constantly begged the backend for updates, creating a bottleneck.
The Strategy: From “Polling” to “Streaming”
As the Lead Architect and Product Owner, I redesigned the platform using the principles of Event-Driven Architecture (EDA) — the same logic that powers systems like Apache Kafka and Google Tag Manager.
The Implementation (The Pipeline)
Instead of manual entry, we built an automated Data Pipeline:
Event Ingestion: Deployed autonomous agents powered by Python and Playwright. These agents monitor the ERP “Warehouse” for state changes (Price Change, Stock In/Out).
The Broker Logic: Every state change was treated as an Event. These events were routed through a central “Broker” logic to update the B2B portal, analytics (GA4), and marketing channels simultaneously.
Integrity Layer: Integrated SQL-based validation to ensure that the “Business Truth” in the ERP perfectly matched the “Consumer Flow” on the website.
Technical Stack
Automation: Python, Playwright (for legacy interface data extraction).
Data Flow: Event-Driven Design, API-driven synchronization.
Analytics & BI: GA4, Looker Studio, GTM (for monitoring data pipeline health).
Management: End-to-end Product Ownership, Stakeholder Governance.
Business Outcomes
40% Operational Cost Reduction: Eliminated the need for manual content updates.
Real-Time Accuracy: 100% synchronization of 10,000+ SKU across all digital touchpoints.
Scalability: The system now handles high-load B2B transactions without performance degradation.
“I didn’t just build a website; I built a high-speed data highway that turns legacy constraints into a competitive advantage.” — Anton Oshmian
