Stock Checkout
Structured checkout flow that moves stock between states reliably, with validation and audit trail.
Full-Stack · Enterprise Operations
Inventory Management System
An enterprise inventory tracking and operations platform that gives teams real-time visibility into stock, reconciliation, and delivery — with Playwright automation for repetitive workflows.
Overview
Inventory accuracy is one of those problems that quietly costs businesses every day — miscounts, missed deliveries, stale data, and reconciliation work that piles up. This platform replaces that with a single source of truth: stock operations, inventory tracking, and the business workflows around them, all in one place.
The system handles end-to-end inventory lifecycle: checkout, reconciliation, discrepancy handling, delivery tracking, and live updates. Repetitive verification and validation flows are offloaded to Playwright-based automation so the team can focus on real exceptions instead of routine checks.
My Role
I built the system end-to-end as a full-stack developer — frontend dashboards, backend APIs, database modeling, and the automation layer.
- Designed and built React.js dashboards for stock visibility, checkout flows, and discrepancy management.
- Built scalable Node.js / Express APIs for inventory operations, with PostgreSQL as the source of truth.
- Modeled inventory schemas to handle real-time updates, quantity discrepancies, and delivery lifecycle events.
- Implemented Playwright-based automation for repetitive inventory processes, data validation, and workflow verification — improving operational efficiency.
- Containerised the app with Docker and deployed to AWS for reliable, scalable production hosting.
Tech Stack & Architecture
Frontend
- React.js
- JavaScript
- Responsive dashboards
Backend
- Node.js
- Express.js
- REST APIs
Data
- PostgreSQL
- Optimized queries
- Transactional ops
Automation & Infra
- Playwright
- Docker
- AWS
- Git & CI/CD
Key Features
Inventory Reconciliation
Tools for matching expected vs actual inventory counts and resolving differences without spreadsheet shuffling.
Discrepancy Handling
Dedicated workflow for quantity discrepancies — flag, investigate, resolve — with status tracked at every step.
Delivery Tracking
End-to-end visibility on deliveries, tied back to inventory movements so stock levels stay accurate.
Real-time Inventory Updates
Live updates so dashboards reflect the true state of stock as it changes, not yesterday's snapshot.
Playwright Workflow Automation
Automated runs for repetitive validation, data checks, and operational verification — reduces manual QA load.
Screenshots
Drop screenshot at
../assets/images/inventory-1.png
../assets/images/inventory-1.png
Drop screenshot at
../assets/images/inventory-2.png
../assets/images/inventory-2.png
Drop screenshot at
../assets/images/inventory-3.png
../assets/images/inventory-3.png
Challenges & Solutions
Challenge
Inventory state changes from many places at once — checkout, delivery, reconciliation. Keeping counts accurate under concurrent updates is tricky.
Solution
Modeled inventory operations as transactional database changes so updates either fully succeed or fully roll back. Real-time UI updates surface the resulting state without users having to refresh.
Challenge
Repetitive verification steps were eating into the operations team's time and were error-prone when done manually.
Solution
Built Playwright-based automation for the most repetitive flows — validation, workflow checks, and operational verification. The team's time freed up to focus on exceptions instead of routine checks.
Challenge
Quantity discrepancies needed a clear, auditable resolution path — not a slack thread.
Solution
Designed a discrepancy workflow with explicit states (flagged, investigating, resolved) and an audit log so every adjustment is traceable.
Outcomes & Learnings
- Improved inventory visibility and accuracy with real-time dashboards and transactional updates.
- Reduced repetitive manual work via Playwright automation — a great lesson in identifying which workflows are worth automating vs which are worth redesigning.
- Got deeper experience modeling event-driven, state-heavy domains in PostgreSQL.
- Sharpened skills in containerization and AWS deployment for production reliability.