Project Overview
CitroPak Fruitien, a leading beverage manufacturer, needed a robust solution to manage their complex distribution network. The existing manual processes were leading to stock discrepancies, delayed orders, and inefficient route planning.
I engineered a comprehensive Distribution Management System (DMS) that digitized their entire supply chain workflow. The system handles everything from primary sales (company to distributor) to secondary sales (distributor to retailer), providing real-time visibility into stock levels and sales performance.
Key Challenges
• Data Synchronization: Ensuring real-time stock updates across multiple
distributor nodes.
• Complex Pricing: Implementing dynamic discount schemes and trade offers
based on various criteria.
• Performance: Handling large datasets of daily transactions without
latency.
The Solution
We chose a modern stack combining the robustness of Laravel with the interactivity of Vue.js via Inertia.js. Tailwind CSS was used to create a custom, responsive design system.
The architecture features a multi-tenant database design where each distributor operates within a secure data scope. We implemented Redis caching for high-frequency data access and queued jobs for heavy background processing like report generation.
Key Features
- Real-time Inventory Tracking: Automated stock deduction and low-stock alerts.
- Order Management: Comprehensive workflow from booking to delivery and invoicing.
- Dynamic Discount Engine: Configurable schemes for BOGOF, quantity discounts, and trade offers.
- Geolocation Tracking: Sales force tracking to ensure route compliance.