ERP Platform for Advisor Operations, Sales Tracking & Bonus Calculation
We built a business-critical ERP platform that replaced manual spreadsheet workflows with automated advisor lifecycle management, real-time Shopify sales integration, and complex bonus calculation. The system supports 300+ advisors and reduced report generation from hours to seconds while maintaining 99.8% uptime.
Thermomix VIP Club required translating complex real-world business operations into structured, deterministic workflows. Key challenges included modeling multi-step advisor onboarding with conditional flows, calculating multiple interdependent bonus types with thresholds and approval layers, aggregating deeply relational datasets for reporting under performance constraints, adapting to evolving bonus policies during development, and eliminating high error risk from spreadsheet-based manual processes.
ERP Platform for Advisor Operations, Sales Tracking & Bonus Calculation
The system was built using Laravel for business logic and workflow orchestration, React via Inertia.js for a SPA-like experience without a full frontend/backend split, and AWS infrastructure (EC2, RDS, S3) for hosting and storage. Shopify webhooks stream sales events into the system in near real-time. Redis provides caching for high-read endpoints, and queue workers handle asynchronous processing such as report generation.
Laravel + Inertia.js were selected for balanced development velocity and modern UX, avoiding the complexity of a full SPA architecture. A denormalized reporting layer was introduced to overcome performance bottlenecks from complex relational queries. Asynchronous processing via queues was used for heavy workloads like report generation to prevent blocking user-facing operations. A caching strategy for critical endpoints reduced repeated heavy computations for daily and weekly reports.
The system processed hundreds of millions of IDR in transaction volume reliably under peak workloads. Report generation time was reduced from hours to seconds. Redis caching optimized high-frequency report access. Background queues offloaded CPU-intensive aggregation tasks. Denormalized tables were designed specifically for reporting performance. Shopify integration via webhooks ensured consistent and automated data ingestion.
Successfully processed hundreds of millions of IDR in daily transaction volume with consistent accuracy.
Reduced report generation time from hours to seconds, enabling real-time operational use.
Achieved 99.8% uptime in a business-critical system.
Eliminated manual bonus calculation workflows, reducing operational overhead significantly.
Enabled leadership to monitor advisor performance and sales data directly through the platform.
Ability to design systems that handle high-volume financial data with deterministic accuracy.
Translating ambiguous, evolving business rules into stable system logic.
Balancing data normalization vs performance through selective denormalization.
Applying targeted caching strategies where real-time computation is impractical.
A key insight was accepting eventual consistency in reporting (via caching and queues) to achieve significant performance gains without compromising decision-making accuracy.
This architecture is directly applicable to organizations managing distributed sales teams, commission-based systems, or multi-step operational workflows where accuracy, auditability, and reporting performance are critical. It is particularly relevant for companies transitioning from manual processes to automated ERP systems.
We specialize in dedicated team for consumer goods companies. If you're facing challenges like the ones we solved for Thermomix VIP Club, let's talk.
