Talha Tanveer

Case study · Web Applications

Stock Management System

An inventory and sales tool — stock, purchases, sales, returns and cost-of-goods reports.

DashboardProjectsTasksTeamReportsSettings
Dashboard
Illustrative preview · no public screenshot available
Category
Web Applications
Role
Full-stack developer (freelance)
Team
Solo project
Duration
Jan – Mar 2024
Technologies
  • Laravel
  • React
  • Redux
  • MySQL
  • JWT

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

  • Laravel 10
  • PHP 8.1
  • MySQL
  • JWT auth
  • league/csv

Front end

  • React 18
  • Redux Toolkit
  • React Router
  • Formik
  • Minia admin template (licensed)

03

My contribution

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

  2. 02

    Stock movements and returns

    Purchases, sales and returns all feed into stock in hand, so stock levels follow every movement — including returned items.

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

  4. 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.