Optical Live
Order Lens Management
A full-stack system for optical shops: order lifecycle, customer/vendor tracking, and lens prescriptions in one place.
Live since Feb 2026, replacing spreadsheet workflow with full order traceability at one branch.
Private — internal project
The problem
Optical shops juggle lens orders, prescriptions, and vendor data across spreadsheets and chats, making status and history hard to track.
What it does
- Order lifecycle with lens prescription data (SPH / CYL / axis / PD) and real-time status
- Customer and vendor tracking with soft-delete recovery
- Analytics dashboard: revenue, profit margin, and order trends, filterable by date
- JWT auth, role-based access, PDF invoices, and CI/CD to a self-hosted VPS
Built with
- React Router v7
- Hono
- PostgreSQL
- TypeScript
- Docker