Skip to content
<Rojit />
Transactions· 2024

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

LaravelFilamentLivewireRedisMySQL

Stack diagram

Frontend
Livewire
Application
LaravelFilament
Data
RedisMySQL
Client / Problem
$
  • 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.
My Role
$
  • Full-stack developer — Laravel management information system with Filament panels, transaction tracking, reporting, and Redis caching.
  • Designed the inventory and transaction schema.
Architecture
$
  • 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.
Database Design
$
  • Schema for items, batches, inventory movements, transactions, and pricing history.
  • Inventory movements normalized so stock levels are computed from an immutable ledger.
Authentication
$
  • Role-based access distinguishing operators, managers, and administrators in Filament.
Deployment
$
  • Laravel behind Nginx, MySQL, Redis cache, Supervisor-managed workers for report generation.
Performance Optimization
$
  • Redis-cached rates and catalogs keep the busiest queries off the database.
  • Report generation runs in the background and streams large Excel exports.
Problems Encountered
$
  • Inventory reconciliation was error-prone when tracked in spreadsheets.
  • Large report exports could stall the web process if run synchronously.
How I Solved Them
$
  • Immutable inventory-movement ledger makes stock levels auditable and computable.
  • Queued, chunked Excel/PDF export generation with a ready notification.
Results
$
  • Production MIS replacing spreadsheet operations with structured, auditable transaction tracking and reporting.
Lessons Learned
$
  • An immutable ledger is the right foundation for any inventory system.
  • Cache the hot reads; queue the heavy reports.

Want a production system like this?

I build production web applications end-to-end. Let's discuss your project.

Get in Touch