Client: Serrana Solar
Technologies Used
- PHP (Custom Framework)
- Both Standalone and Bundled Vue.js
- TailwindCSS
- MySQL / MariaDB Database Architecture
- Bidirectional ERP Integration Layer
- Third-Party TMS Integration (Transport Management System)
- Responsive Web Design
- Session Management & Authentication System
Challenge
Serrana Solar needed to modernize its B2B operations by giving integrators full autonomy over the sales cycle while maintaining perfect data integrity across multiple enterprise systems.
The existing workflow required constant manual intervention, creating bottlenecks that delayed quote approvals, limited order visibility, and prevented integrators from serving customers efficiently.
The platform had to:
- Support complex solar calculations and dynamic pricing
- Ensure bidirectional ERP synchronization
- Provide real-time order tracking using internal and external logistics data
- Scale to 7,000+ API requests/hour
- Support financial services and training modules within the same ecosystem
Implemented Solution
Developed Portal do Integrador, a complete B2B ecosystem organized into 10 interconnected modules, enabling integrators to manage the full sales and fulfillment cycle independently.
Core Sales & Operations Modules
- Calculadora Solar (Solar Calculator): Interactive solar dimensioning tool based on consumption, location, and inventory
- Prazo de Transporte (Transportation Deadlines): Real-time delivery estimation considering destination and logistics capacity
- Orçamento On-line (Online Budgeting): Full budgeting builder with live catalog, automatic pricing, and approval workflow
- Orçamentos e Pedidos (Budgets & Orders Management): History, tracking, filtering, export, and status management for quotes and orders
- Acompanhe o seu Pedido (Order Tracking): Unified tracking interface aggregating ERP warehouse data and external TMS updates
Financial & Incentive Modules
- Análise de Crédito (Credit Analysis): Integrated credit evaluation enabling financing options
- Serrana Cashback: Loyalty rewards program that generates credit for future purchases
- Desconto Progressivo (Progressive Discounts): Volume-based dynamic discounts applied in real-time
Support & Development Modules
- Suporte Técnico (Technical Support): Integrated system for technical support and product guidance
- Programa Capacita (Training Program): Professional training portal with exclusive video courses
Technical Architecture Highlights
The platform's architecture prioritizes autonomous operation and data integrity through several key design decisions:
- Bidirectional ERP Integration: Real-time sync of inventory, pricing, customer data, and approved budgets → automatic ERP order creation
- Dual-Source Order Tracking: Aggregated timeline combining internal warehouse status and external TMS tracking
- Self-Service Approval Authority: Integrators can create and approve budgets independently, with approval logic triggering automatic ERP record creation and order processing workflows
- High-Volume API Infrastructure: Optimized caching and request handling for 7,000+ API calls per hour (validated), but with room for at least 10x more
- Modular Architecture: Independent modules with shared authentication and data layers for scalable updates
Results / Impact
- 400+ active integrators daily
- 7,000+ API requests/hour during peak periods with stable performance
- Zero-touch order processing: approved budgets automatically become ERP orders
- Full sales autonomy for integrators without internal intervention
- Unified tracking across internal and external systems
- 100% data consistency between portal, intranet, and ERP
- Consolidation of 10 tools into one platform
- Faster financing decisions through integrated credit analysis
- Higher course completion via embedded training program
Why This Project Matters
This case demonstrates enterprise-grade integration architecture at scale, combining complex business logic with high reliability and a modern UX. The portal successfully replaced manual workflows, reduced errors, and turned a fragmented system into a unified operational ecosystem.
Notes
The platform's success is evidenced by its daily adoption across the entire integrator network — 400+ users relying on it as their primary operational tool rather than a supplementary system.
The bidirectional ERP integration eliminates the typical friction point in B2B platforms where approved transactions still require manual processing, while the dual-source order tracking solves the common visibility problem when fulfillment spans internal and external systems.
The inclusion of educational content (Programa Capacita) alongside transactional features reflects an understanding that B2B platforms serve strategic partnership roles beyond pure commerce.