Work orders and stock for a network of workshops
Each workshop sees only its own data, and stock counts point out where the numbers don't match.
- React
- Node.js
- Express
- PostgreSQL
- Android
The problem
A network of tire workshops needed work orders and stock per location, with a field team on their phones and data coming from an old system.
Seeing the others
One workshop must not see another's orders.
An old system
The data came from an old system with a different structure.
Stock never counted
Without a count, stock gaps went unnoticed.
How it works
Per-workshop scope
Each location sees only its own work orders.
Search by size
Tires registered and searched by size, and receiving validated before it is saved.
Stock counts
They point out the gap between what was counted and what was expected.
Android app
For the field team, with file uploads and work order notifications.
Migration
The old system's tables moved to the new structure, with sequences reset.
Outcome
The workshops now work in the same system, each with its own data, and stock differences show up in the count.