The Challenge
Mary Bruce spent 45 years building The Green Chemical Store into a trusted partner for large facilities maintenance teams across medical centers, universities, corporate headquarters, and Department of Defense facilities. Her specialty is private labeling specialty chemicals, but managing hundreds of SKUs across multiple storage locations with Excel spreadsheets was holding her back.
We were working off an Excel spreadsheet. Our new operations guy was trying to learn hundreds of different products. Every label was foreign to him. We weren't getting accurate data handed off to logistics, which connects to sales and filling customer orders.
The Transformation
Mary turned the project over to Travis McDonald, her operations manager, who quickly became the system’s champion. Barcodes were in place three weeks after kickoff.
- Excel spreadsheet tracking across hundreds of SKUs
- A new operations manager learning unfamiliar product labels
- Inaccurate counts going to logistics
- Remote storage sites updated in person
- Mary pulled into daily inventory questions
- Barcode scanning
- One operations manager runs the whole inventory
- An accurate weekly report to logistics
- Remote storage sites updated from the main location
- Mary back to customers and new products
The Features That Made the Difference
Three features made the biggest difference:
One of the most impactful features is its support for remote storage sites. Thanks to Rocket's virtual site functionality, we can scan barcodes from our main location and automatically update inventory across external sites, no physical presence required.
The system also allows multiple product types to be stored within a single bin or location. If a product is stored elsewhere, simply enter the name or SKU, and Rocket instantly identifies its location.
Inventory monitoring is equally intuitive. Customizable quantity thresholds trigger visual alerts via a color-coded status bar. Yellow or red indicators highlight items that require attention. A single click reveals which products are running low, enabling proactive restocking.
The Result
Travis runs the inventory and sends an accurate report to logistics every week, and Mary is back to customers and new products.
It's just a sweet, simple solution. Program that's super manageable for one guy. Travis is managing the inventory beautifully. Getting the report off to logistics at the end of every week. It's an accurate count. And I don't have to be pulled in on the ups and downs anymore.