Skip to content
All work

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

Live2026For developers
Warehouse Management System

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

01

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.

02

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.

03

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.

04

Transfers without phone calls

Stock moves between warehouses or out to branches in a few clicks, and both sides update at once.

05

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.

06

The right screen for each person

43 permissions, 7 role templates and access per warehouse, plus 25 reports.

See it in action

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

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

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

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

  3. Counting a product one unit short, then the manager approves and stock updates

    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:

  1. 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.
  2. 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.
  3. 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

Architecture: Warehouse Management System

Next project

Elite

Employee benefits platform: offers, events, points and gifts

Elite: employee benefits platform

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