Milano – Manufacturing & Sales Optimization on Odoo
Milano – Manufacturing & Sales Optimization on Odoo
Industry : Door Manufacturing & Building Products
Products : Interior Doors, Exterior Doors, Commercial Doors, Mouldings, Locks, Hardware, Bath Sets
Location : Edmonton, Alberta, Canada
Business Model : Retail + Manufacturing + Custom Door Manufacturing
Customers : Homeowners, Contractors, Builders, Commercial Projects
Platform : Odoo 19
Business Overview
Milano Doors & Mouldings is a Canada-based company specializing in residential and commercial door solutions. Operating from Edmonton, Alberta, the company offers a wide range of products including interior doors, exterior doors, commercial doors, mouldings, locks, hardware, and bath accessories.
Milano serves homeowners, contractors, builders, and commercial customers through retail operations and customized product offerings.
With a large catalogue of door styles and configurations, the company focuses on providing customized solutions while maintaining product quality, design flexibility, and operational efficiency. The business manages sales, inventory, manufacturing, and order fulfilment processes, where accurate product configuration and production planning are critical for day-to-day operations.
Business Challenge
Manufacturing Planning
Milano uses a CPQ-based door configuration system where BOM, operations, and work orders vary based on door type. Since each configuration can differ, operations and work centers cannot always be predefined in a standard manufacturing setup.
Margin Accuracy
Milano uses CPQ to configure doors with different components and options, resulting in varying cost and selling prices for each configuration.
However, margin calculation was based on product master cost and sales price. This caused inaccurate profitability reporting, as margins did not reflect the actual configured product value.
Commission Complexity
In standard Odoo, commission is calculated based on sales order, invoice, delivered quantity, or invoiced quantity, not actual payment.
Additionally, it does not support multiple agents with different commission percentages on the same sale. Milano required commission calculation only after payment receipt.
Techvaria Approach
Techvaria focused on process optimization over system replacement:
- Extended existing manufacturing workflows
- Reduced manual decision points
- Standardized financial logic
- Introduced rule-based automation
- Simplified commission structure into a predictable model
Feature Details
Feature 1 – Manufacturing Automation & Work Order Management
To simplify manufacturing order processing, two enhancements were implemented:
1.1 Bulk Operation & Work Center Assignment
After Manufacturing Orders are generated from confirmed sales orders, users can select multiple MOs from the list view and assign operations and work centers in bulk. This reduces manual effort and saves planning time.
1.2 Door Type-Based Operation Automation
Configuration options were added at the door type level (e.g., Single Door, Double Door). Operations and work centers are pre-defined per door type. When a Manufacturing Order is created through CPQ, the relevant operations and work centers are automatically assigned based on configuration.
Feature 2 – Stable Margin Calculation Logic
A custom logic was implemented to calculate cost and selling price based on CPQ-selected components.
When a door is configured, the system derives actual cost and selling price from selected components and uses them for margin calculation instead of product master values.
Feature 3 – Fixed Percentage Commission System
A custom commission system was implemented where:
- Multiple agents can be assigned to a single sale
- Each agent has a separate commission percentage
- Commission is calculated only after payment is completed (not invoice-based)
Project Outcomes
- Reduced manufacturing planning effort through bulk assignment
- Improved production consistency through automated routing
- More accurate profitability calculations based on CPQ configuration
- Simplified commission processing for multiple agents
Modules Implemented
- Sales
- Purchase
- Inventory
- Manufacturing
- Accounting
Business Impact
- Reduced manual production planning
- Improved consistency in manufacturing workflows
- More accurate profitability reporting
- Simplified commission structure for sales agents
Why This Matters
This engagement focused on one core principle:
Existing ERP systems often fail not because they are wrong, but because they are not optimized for real operational behaviour.
Milano’s system was enhanced to align Odoo with real manufacturing and sales complexity without disrupting the existing setup.
Why Milano Chose Techvaria
Milano evaluated Techvaria, an Odoo Silver Partner, during the selection process for improving their existing Odoo system.
Techvaria Strengths
- Odoo Silver Partner focused on standard Odoo implementations
- Strong expertise in core modules like Sales, Inventory, and Manufacturing
- Prefers standard Odoo workflows with minimal customization
- Suitable for companies adopting or restructuring Odoo from base level
- Follows Odoo best practices for stability and maintainability
- Focuses on configuration over deep custom development
Conclusion
Milano’s manufacturing and sales operations required greater flexibility than standard ERP workflows could provide. By enhancing Odoo 19 with manufacturing automation, configuration-based margin calculations, and payment-driven commission management, TechVaria helped align the system with real-world business processes.
The result was a more efficient production planning process, improved profitability visibility, streamlined commission tracking, and greater operational consistency across manufacturing and sales. Through targeted optimization rather than large-scale system changes, Milano was able to maximize the value of its existing Odoo investment while supporting continued business growth.
