Sri Mobiles Inventory & Sales Management System
✕ The Business Challenge
The client, a multi-brand mobile retailer, was managing inventory tracking, dealer invoicing, and profit tracking via manual paper ledgers. This resulted in frequent stock-outs of popular phones, untracked profit margins on wholesale dealer trades, and payment collection delays.
⚙ The Engineering Solution
Designed a responsive web application powered by a Node.js API and MySQL database. Implemented a unified database architecture with role-based access control (RBAC) separating wholesale dealers, administrators, and retail customers. Created a real-time inventory ledger module that calculates running stock averages and triggers email/dashboard alarms when stock counts fall below custom threshold levels. Developed a detailed reports dashboard compiling gross sales, vendor expenses, and net profit margins.
🚀 Business Value Delivered
- 100% Stock Visibility: Eliminated manual count bottlenecks.
- 90% Shortage Reduction: Automated warning thresholds ensure popular models are always in stock.
- 15+ Hours Saved Weekly: Automated sales calculations, profit margins, and dealer reports.