iWRS
A web-based order management system that replaced handwritten notebooks with a real-time database for a small family business.
The Problem
My family runs a small business, and for years, everything was tracked on paper. Every order was handwritten in notebooks. When it came time to check who hadn't paid, someone had to manually flip through pages of scribbled orders, cross-reference payment records, and hope nothing was missed. It was tedious, error-prone, and honestly kind of frustrating to watch.
I got tired of seeing our employees waste hours on something a database could handle in seconds. So I built a system to fix it.
What I Built
I started by digitizing everything—manually entering all those handwritten orders into a MySQL database. Then I built a Laravel web app around it to manage the full order lifecycle: order intake, statement generation, payment tracking, and reporting.
The invoice module lets you pick any date range and instantly see all orders (paid and unpaid) for that period, with calculated remaining balances. No more manual arithmetic or hunting through old notebooks. Just select your dates, and the system does the rest.
What It Does
- Order Management — Track every order from creation to fulfillment, with full audit trails
- Statement Generation — Pick a date range and generate statements showing all orders with payment status and remaining balances
- Payment Tracking — See outstanding balances and payment history at a glance
- Performance Dashboard — Visualize revenue trends, order volume, and team metrics in real-time
The Result
What used to take hours now takes seconds. The business has a single source of truth for orders and payments. No more lost orders, no more missed invoices. And the business can finally focus on actual operations instead of drowning in paperwork.
This project taught me that the best solutions aren't always the most technically complex—they're the ones that solve real problems for real people.