SKU Mapping Tool

When warehouse operations at Spectrum Brands faced critical disruptions, we needed a fast, scalable way to keep orders moving. I created a SKU-matching tool to help sales reps and dealer partners reroute orders in real time; enabling inventory continuity without manual workarounds. Built with familiar tools and rolled out across 30+ distribution centers, it became a frontline solution during one of our most pressing logistical challenges. 

I 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. 

 What began as a rapid solution to protect $9M in direct-to-consumer revenue became a strategic growth engine. By enabling dynamic mapping across over 5,000 SKUs, the tool drove a 25% increase in product variety across regional warehouses and supported international product conversions. This expansion improved retail assortment and drove a 15% lift in sales across key partner accounts. It also enabled over 50+ competitive SKU conversions, helping field teams win shelf space and grow share in priority domestic and international markets.