The warehouse hub I built from A to Z to stop a seven-figure oil loss
Used cooking oil was going missing between the collector and the port, a loss the company put at seven figures a year, and a paper slip and a spreadsheet could not say where. I designed, built, and shipped the Arabic warehouse hub that monitors every step from the gate to the tank to the ship, with a live truck scale read in the browser and photo evidence on every weighing.
Outcome
- 100% of the warehouse operation runs on it, and the paper slips and side spreadsheets are gone
- The oil is monitored at every step from the collector's trip to the tank to the port, so a quantity can no longer go missing between two records
- Losses are down and the openings for fraud are closed, because every weighing comes from the scale itself with a photo, a name, and a time on the record
A collector loads used cooking oil in the field and brings it to a warehouse. It goes into a tank, and later it goes to the port. The record of all that was a slip at the gate and a spreadsheet at the desk, which could tell you the quantity that left and the quantity that arrived and nothing about the distance between them. The company was losing oil somewhere in there, by its own estimate seven figures' worth every year, and the paperwork could not say where.
So the warehouse needed to stop being a blind spot. I designed and built the product that closed it: the Arabic interface, the backend, the deployment, and the support after launch. That meant a web app reading a physical truck scale, live, in the browser. It worked on my laptop. On the warehouse PC, the scale read zero.
What the full case study covers
- Why the warehouse is the one link in the chain where a quantity can be proved
- How one receiving screen routes each trip into one of two ways of verifying what arrived
- The day at the weighbridge, and five problems you only find standing next to the hardware
- What happened to the slips and the spreadsheets once the product was in daily use
Protected case study
The rest is behind a password
This case study goes deep into an internal product, so I share the full version on request.
No password? Ask me for one and I’ll send it.
Stays unlocked on this browser for 30 days.