Warehouse Management System
One system for 5 linked warehouses, replacing paper and Excel. Every unit of stock has a recorded history, and every order is checked twice before it leaves.
Role
Full system: frontend and backend

5
linked warehouses
25
employees use it daily
+1,000
products managed
2026
live since early in the year, full version since June
Before and after
Before
5 warehouses ran on paper and Excel, each with its own sheets. Nobody had one view of stock, orders were picked from printed lists, transfers depended on phone calls, and nobody could tell who changed a number.
After
A web system the whole team works in, from the office to the warehouse floor, with screens and permissions for each role. Stock lives in one database, every movement is recorded, and every order is checked twice by barcode.
Key features
Stock you can trust
Every movement is saved with who did it, when, the order or document behind it, and the balance before and after.
Every order is checked twice
One person picks by scanning, a second person checks by scanning, and products that need serial numbers are tracked per unit.
Problems are caught early
If another order takes the last units, the waiting order is flagged with the exact shortage, and it goes back in the queue as soon as new stock arrives.
Transfers without phone calls
Stock moves between warehouses or out to branches in a few clicks, and both sides update at once.
Stock counts without closing the warehouse
A count is spread over several days, two people can't count the same item at once, and any difference needs a manager's approval and a reason.
The right screen for each person
43 permissions, 7 role templates and access per warehouse, plus 25 reports.
See it in action

01Moving 8 TVs from the main warehouse to Alexandria, with both balances updated

02One order, two people: picked by scan with a serial number, then checked by scan

03Counting a product one unit short, then the manager approves and stock updates
Screens
Desktop
01/ 16
Dashboard: order status and alerts for the main warehouse
Screens and videos use invented demo data. No real client data is shown.
Mobile
Barcode picking on the warehouse floor
03 / 05
My role
Full system: frontend and backend
I built the full system on my own: the database design, backend, frontend and deployment.
Status
Live. In daily use since early 2026 (the full current version since June 2026). Integration with the company's POS is planned as the next phase.
Under the hood
Architecture: a layered API (routes and permission checks, controllers, services, repositories) on one PostgreSQL database. Redis handles live updates and background jobs. The whole system runs in Docker Compose, and the database is never exposed outside the server.
Three engineering decisions:
- Stock is a ledger, not a number. Every change runs inside a database transaction and writes a ledger line with the balance before and after. Stock is split into available, reserved and damaged, so units already promised to an order never show as free. Any count can be traced back line by line.
- Order conflicts are resolved at the moment of reservation. When a picker confirms an order, other waiting orders that need the same products are re-checked in the same transaction. If they are now short, they move to "Issue" with the exact reason. When stock arrives, they are checked again and released automatically.
- Counting is safe with many people on the floor. Each count task is locked with a single conditional update, so two people can't take the same item. A background job frees locks that were abandoned for 30 minutes, and every screen in that warehouse updates live. The barcode-scanner input also reads physical key positions, so scans still work when the PC keyboard is set to Arabic.
Stack
- React 19
- TypeScript
- Vite
- Tailwind CSS
- TanStack Query
- Zustand
- Node.js
- Express 5
- Prisma
- PostgreSQL
- Redis
- BullMQ
- Socket.io
- Docker Compose
- PWA
Architecture
Let's start your project
Message me on WhatsApp or by email, and I'll reply within 24 hours.
You can also find my work and experience on

