Orchestrating Chaos: A Digital Framework for Logistics & Data
Stabilizing daily operations through logic-based routing and building a structured product catalog from fragmented data.
The Context: Tribal Knowledge vs. Scalability
Best Value operations relied entirely on memory and manual processes. With 4,000 SKUs and no unified system, the warehouse faced daily friction: drivers reorganized pallets in the rain due to bad loading orders, and deliveries often arrived after clients had closed.
This lack of order created a high-stress environment for leadership and staff. My goal was to stop the daily firefighting by introducing two specific systems: one for physical logistics and one for digital product data.
Solution A: Systematizing the Delivery Routes
The priority was to reduce the morning chaos. I developed a custom JavaScript interface that digitized the routing constraints—mapping store hours, truck capacity, and delivery priority.
The Result:
- — Operational Control: Drivers received routes sorted in exact reverse-drop order, eliminating the need to reorganize cargo on the street.
- — Reduced Friction: By respecting client opening hours, we drastically reduced complaints and return trips.
- — Efficiency: The system cut daily planning time by 75%, allowing leadership to focus on management rather than manual sorting.
Solution B: The Digital Product Catalog
The Warehouse Management System (WMS) was underutilized, producing incomplete exports with data errors and missing asset links. A direct integration was impossible, so I built a standalone WordPress solution to bypass these structural limitations.
The Execution:
I worked around the corrupted legacy data, manually verifying the viable SKUs to populate the frontend.
With zero additional budget, I sourced and linked images for 1,000 SKUs (up from 300), creating the first visual record for the sales team. The functional MVP delivered working search and filters, proving the value of a digital tool despite the backend deficiencies.
