Sales & Inventory System for a Hardware Store
Web app · sales and profit · kardex · dashboard

A web system that gives a hardware store full control of its sales and stock. Every sale is recorded and the day's total, profit, number of sales and average ticket are calculated automatically; each product carries its purchase and sale price, so margin is known per product and per sale; and every stock movement is kept in a kardex, with alerts before a product runs low.
Technologies
My role
Freelance, sole developer. Scoped the system with the owner, built the sales, product, inventory and statistics modules and the dashboard, and delivered documentation and user training.
Highlights
- Daily sales with automatic total, profit, sale count and average ticket; summaries by day, week and month
- Products with purchase and sale price and automatic profit per product or per sale
- Real-time stock with low-inventory alerts, stock-in and stock-out records, a basic kardex and full movement history
- Statistics: best and worst sellers, inventory turnover, margin per product, sales and movement charts
- Dashboard overview, smart search and optional user control; fully responsive, with an optional Docker container