Enterprise Inventory Management System
Full-stack Prisma, Node.js, Express, React, and React Native inventory control, expense auditing, and stock logistics system.
Overview
An enterprise-grade, multi-platform inventory management solution engineered for warehouses, retail chains, and supply chain operators. The platform provides real-time stock tracking across multiple facilities, automated purchase order generation, expense auditing, traffic-guarded REST APIs, and a companion mobile app for barcode scanning and warehouse floor stock takes.
Design decisions
The choices that shaped the system, and why.
- 1
TrafficGuard Custom Middleware
Wrote custom token-bucket rate limiting and concurrency locking to prevent race-condition overselling during flash inventory sales.
- 2
Prisma Relational Modeling
Ensured strict end-to-end TypeScript type synchronization between PostgreSQL schemas and frontend React query hooks.
Architecture
Backend Microservice
TypeScript Express API guarded by custom `trafficGuard` rate-limiting and JWT authentication middleware.
Prisma ORM Data Modeling
High-integrity relational schema modeling products, sales orders, purchase shipments, expense categories, and warehouse bins.
Cross-Platform Client Tier
Web administration portal (React) and mobile warehouse companion (React Native).
Audit Logging
Immutable tracking of every stock movement, quantity adjustment, and staff transaction.
DevOps & deployment
Dockerized microservices ready for AWS ECS Fargate + Amazon RDS PostgreSQL, or Google Cloud Run + Cloud SQL.
How it ships · Docker Compose: client + server + PostgreSQL
- 1docker compose up
- 2Prisma migrate on server start
- 3React client served separately
Features
- Real-time stock level monitoring with low-inventory automated triggers.
- Multi-facility warehouse transfer tracking and supplier management.
- Comprehensive expense auditing with category breakdowns and profit margin analysis.
- Containerized deployment with pre-configured database seeds.
More in Full-Stack & Enterprise
Enterprise
The Part Timer
Decentralized labor and gig work marketplace for Sri Lanka connecting skilled crews, trades, and enterprise clients.
Enterprise
Intocare EPF & Workforce Roster Management System
Next.js App Router operational platform managing EPF statutory contributions, shift rosters, employee groups, and monthly payroll.