🚀 The Spark

•The Goal: Build a centralized operations hub to manage complex retail workflows that outgrew spreadsheet-based tracking.

•The Challenge: Automating the synchronization between external sales channels (SalesDrive) and internal warehouse operations, while managing multiple legal entities (FOPs) without increasing administrative overhead.

🧱 The Bottleneck

•Manual Fragmentation: Managing stock across multiple locations and reconciling orders from 8+ different legal entities was a primary source of operational friction.

•Inventory Blind Spots: Lack of real-time serial number tracking led to traceability issues and potential stock inaccuracies during peak periods.

⚡ Surgical Intervention

Core Actions

•High-Frequency Sync Engine: Engineered a robust, automated synchronization pipeline with SalesDrive that refreshes every 60 seconds, maintaining a single, accurate source of truth.

•Granular Traceability Module: Implemented a specialized serial number tracking system that monitors every product's lifecycle from warehouse intake to final customer fulfillment.

•Unified Requisite Manager: Developed a "one-click" interface for managing and distributing billing details across 8+ different FOPs, eliminating manual entry errors.

•Automated Stock Lifecycle: Designed Poka-yoke logic where inventory is automatically deducted only upon verified shipment status, preventing data drift and double-counting.

Methodology

•Surgical Engineering: Prioritizing the "critical path" of inventory integrity and high-frequency data synchronization.

•Poka-yoke (Error-Proofing): System architecture prevents inventory mismatches through automated reconciliation and status-locked stock deductions.

🛠️ The Tech Stack

•Stack: Next.js (App Router), Supabase, PostgreSQL.

•Integrations: SalesDrive API (Inventory & Order Sync), Transactional Email, Multi-entity Requisite Management.

📈 Key Results

•100% Operational Transparency: Achieved full Visibility into multi-store stock levels with automated replenish notifications.

•Zero-Mistake Billing: Standardized requisite management for all 8+ legal entities with instant retrieval and copy-paste capabilities.

•High-Pace Scalability: The system comfortably handles continuous real-time data updates without manual intervention or data degradation.