Gold Exchange MIS
Operations and inventory management system for a gold exchange with transaction tracking, Excel/PDF reporting, Redis caching, and comprehensive Filament admin panels.
Technical case study by Rojit Pokharel — Full-Stack Web Developer & System Architect, Kathmandu, Nepal
Stack diagram
- ›A gold exchange ran operations and inventory on spreadsheets — no real-time visibility into stock, transactions, or pricing.
- ›Managers needed structured reporting (Excel/PDF) for audits and daily reconciliation.
- ›High-read operational queries needed caching to stay fast during market hours.
- ›Full-stack developer — Laravel management information system with Filament panels, transaction tracking, reporting, and Redis caching.
- ›Designed the inventory and transaction schema.
- ›Laravel + Filament admin panels for inventory, transactions, pricing, and reporting.
- ›Redis caching for frequently read lookup data (current rates, item catalogs).
- ›Excel and PDF report generation for audits and daily reconciliation.
- ›Schema for items, batches, inventory movements, transactions, and pricing history.
- ›Inventory movements normalized so stock levels are computed from an immutable ledger.
- ›Role-based access distinguishing operators, managers, and administrators in Filament.
- ›Laravel behind Nginx, MySQL, Redis cache, Supervisor-managed workers for report generation.
- ›Redis-cached rates and catalogs keep the busiest queries off the database.
- ›Report generation runs in the background and streams large Excel exports.
- ›Inventory reconciliation was error-prone when tracked in spreadsheets.
- ›Large report exports could stall the web process if run synchronously.
- ›Immutable inventory-movement ledger makes stock levels auditable and computable.
- ›Queued, chunked Excel/PDF export generation with a ready notification.
- ›Production MIS replacing spreadsheet operations with structured, auditable transaction tracking and reporting.
- ›An immutable ledger is the right foundation for any inventory system.
- ›Cache the hot reads; queue the heavy reports.
Full-Stack
Production Web Applications: Six Real-World Projects That Deliver Results
Explore six production web applications that solve real business problems — restaurant SaaS, insurance platforms, multi-vendor marketplaces, and real-time systems.
Payments
Payment Gateway Integration in Nepal: eSewa, Khalti, ConnectIPS & International
How to integrate payment gateways in Nepal — eSewa, Khalti, ConnectIPS, FonePay — plus Stripe and PayPal for international customers, and how NRB rules shape online payment integration.
Answers
Read the Answers
Direct answers to questions about Rojit Pokharel and the technologies used across these projects.
Want a production system like this?
I build production web applications end-to-end. Let's discuss your project.
Get in Touch