Web App Inventory System
Internal inventory and stock opname system built to help company operations manage inventory data, stock checking workflows, and reporting more efficiently.
This project started from a real operational problem: inventory and stock opname were managed with manual records and scattered spreadsheets. I designed and built an internal web application that gives the operations team a single, structured place to manage stock data, run stock opname workflows, and generate clear reports.
I worked end-to-end — from database design and API structure to the user interface. The main priority was usability for repeated daily work: fast searches, clear statuses, and flows that match how the team actually works.
The Problem
Manual stock records and spreadsheet-based workflows made it hard to see accurate stock levels, coordinate stock opname, and produce reliable reports.
The Solution
A web app with structured inventory data, guided stock opname flows, and reporting views — built around the team's real day-to-day process.
Tech Stack
Project Preview
Key Features
Inventory management: add, update, and search items with categories and quantities
Stock opname workflow: guided checking process with clear status tracking
Reporting views for stock visibility and operational decisions
Role-based access so only authorized staff can edit data
Challenges
- Translating an unstructured manual workflow into a structured digital flow without disrupting daily operations
- Designing the database so stock changes stay traceable and reporting remains simple
What I Learned
- How to turn a real business process into a usable product, not just code
- The importance of structured data flow and reporting clarity for operational teams