Warehouse management for a contractor — replacing the spreadsheet
Tools, materials, and safety equipment tracked across projects, so nobody has to ask which site a piece of equipment went to.
- Client
- Private client
- Role
- Solo developer
- Year
- 2026
Laravel · PHP · PostgreSQL · Tailwind CSS
The problem
The client ran their warehouse from one shared spreadsheet: tools, materials, stationery and safety equipment, all going out to different project sites and coming back — or not. The spreadsheet was the real specification, and it was also the problem. Two people editing it meant one person’s numbers quietly won, and nobody could say with confidence what was actually on the shelf.
What I built
A small, focused web application for the people who run the warehouse:
- One list per category — tools, materials, stationery and safety equipment — each with its own stock count that updates itself.
- Everything moves against a project. Items go out to a named site and come back to the warehouse, so the question “where is it?” always has an answer.
- Transaction history, so a discrepancy can be traced instead of argued about.
- Editable from the browser, in Indonesian, on the office machines they already have.
How it turned out
Delivered and handed over, with a written installation guide in Indonesian covering every step from installing the database to running the app — because handing a client software they can’t set up without me isn’t finished work.