Case study · Web Applications
Stock Management System
An inventory and sales tool — stock, purchases, sales, returns and cost-of-goods reports.
- Category
- Web Applications
- Role
- Full-stack developer (freelance)
- Team
- Solo project
- Duration
- Jan – Mar 2024
- Technologies
01
Overview
A web app for a client to track what their business buys, sells and holds. Staff record purchases and sales, process returns, see stock in hand, and run sales, purchase and cost-of-goods-sold reports that export to CSV. I built it on my own: a Laravel REST API with JWT authentication and a React and Redux single-page app on top of a licensed admin template.
02
Key features
- Brands, product types and products
- Purchase and sale entry from one screen
- Live stock in hand
- Sale and purchase returns
- Sales, purchase and cost-of-goods-sold reports
- CSV exports for stock, sales, purchases and reports
Stack
How it’s built
API
Front end
03
My contribution
- 01
Inventory data model and API
Designed the schema for brands, types, products, purchases, sales and stock in hand, and built the Laravel REST API with JWT login and full create, read, update and delete for each.
- 02
Stock movements and returns
Purchases, sales and returns all feed into stock in hand, so stock levels follow every movement — including returned items.
- 03
Reports and exports
Sales, purchase and cost-of-goods-sold reports — grouped by month and product — with CSV export for every report and stock list.
- 04
React front end
A React and Redux single-page app with modal forms built in Formik, data tables, searchable selects and toast messages, styled with the Minia admin template.
05
Challenges
Challenge
Keeping stock figures right as purchases, sales and returns change.
How I addressed it
Purchases, sales and returns all write to the same stock records, so the stock screen and the reports read from one source of truth.
Challenge
Reports the owner could actually use.
How I addressed it
Cost of goods sold is grouped by month and product and every report exports to CSV, so figures can go straight into a spreadsheet.
06
Outcome
Stock Management System has no public link to share.
- Built and delivered solo in about two months (January – March 2024).
07
What I learned
“For business tools, getting the data model right first matters more than the screens — every report was easy once stock movements were recorded consistently.”
Next project
HealthEZ
A React Native app for patients and doctors — ML-assisted prescriptions for selected diseases and online consultations.
Have an idea? Let’s build it.
If a project like this is on your roadmap, I’d be glad to hear about it.