Back to Projects

Custom Software

Inventory Management

A full-stack inventory management system built for a real client. Features stock tracking, product management, low-stock alerts, and a visual analytics dashboard — all backed by a REST API connected to MySQL via Supabase with role-based access control.

React.jsNode.jsExpress.jsMySQLSupabaseREST API

Problem

Businesses managing physical inventory manually face stock discrepancies, delayed restocking, and lack of visibility into product movement — leading to revenue loss and operational inefficiency.

Solution

Delivered a full-stack inventory management system with a React frontend and a Node.js/Express.js REST API backend connected to MySQL via Supabase. The system provides real-time stock tracking, low-stock alerts, role-based access control, and a visual analytics dashboard for data-driven decision-making.

Demo

How It Works

  1. 01Admin logs in with role-based credentials.
  2. 02Products are added, updated, or removed via the management panel.
  3. 03Stock levels are tracked in real time against defined thresholds.
  4. 04Low-stock alerts trigger automatic notifications.
  5. 05Reporting dashboard visualizes inventory trends and analytics.
  6. 06All data is persisted in MySQL via Supabase with full CRUD support.

Key Features

  • 📦 Stock tracking & alerts
  • 🛒 Product management
  • 📊 Reporting dashboard
  • 👤 Role-based access
  • 🔔 Low-stock notifications
  • 📈 Visual analytics
  • ✅ Data validation
  • 🔄 Full CRUD operations

Project Status

Delivered — Client Project

Built and delivered for a real client. Designed as a scalable solution adaptable for retail, warehousing, and supply chain businesses.