Photo by Carlos Muza on UnsplashOverview
A web-based inventory management system for small to medium businesses, built with Next.js, PHP, and SQL. Users can manage products, track sales, and monitor profitability in real time. The system automatically calculates total value from price and quantity, tracks how many units have been sold, and shows live profit or loss per product and across the full catalogue.
Key Features
Product Management
Add products with name, price, quantity, and seller details. Edit and delete operations with confirmation prompts to prevent accidental data loss.
Auto Price Calculation
Total product value is calculated automatically from unit price and quantity on every update. No manual arithmetic required.
Sales Tracking
Record sold units and the system instantly updates available stock, logs the transaction, and recalculates running totals.
Profit and Loss Analysis
Real-time profitability per product and across the entire catalogue. Separate views for individual seller performance.
Multi-Seller Support
Products can be assigned to specific sellers. Each seller has their own performance view showing their listings and revenue.
Summary Dashboard
A top-level view showing total stock value, sales to date, and overall profit or loss — updated in real time as transactions are recorded.
The Challenge
Ensuring data consistency when multiple users recorded sales simultaneously required careful transaction management in SQL. I used explicit locking on stock rows during sale operations to prevent negative inventory counts.
Outcome
Fully functional inventory system replacing manual spreadsheet workflows. Accurate real-time profit tracking with no data inconsistencies reported after deployment.
Interested in working together?
I build projects like this for clients across Australia and globally. Get in touch to discuss your idea.