This project was critical for maintaining sales continuity during operational disruptions at key distribution centers, helping field teams support major dealer partners like Ace and True Value.
Built a SKU routing and cross-referencing tool to solve warehouse picking failures at Spectrum Brands. The tool allowed customers who typically ordered direct to seamlessly order through their warehouse affiliate by matching direct SKUs to dealer-specific SKUs, ensuring continued product flow during fulfillment disruptions.
Tool Creation: Designed and built the VLOOKUP-powered SKU matching tool across 30 warehouses.
Process Innovation: Enabled dynamic mapping between direct product SKUs and warehouse-specific SKUs for quick, reliable order rerouting.
Field Training: Rolled out training to sales teams and dealer support groups to integrate the tool into standard workflows.
Operational Impact: Protected $9M+ in revenue during disruptions and improved fulfillment agility by 12%.
Dealer Success: Helped major dealers maintain inventory without direct shipment reliance, stabilizing customer satisfaction during a critical period.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.