| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Discuss (mail) |
| Lines of code | 2652 |
| Technical Name |
business_margin_intelligence |
| License | OPL-1 |
| Versions | 17.0 18.0 19.0 |
Odoo Business
Intelligence Dashboard
Real-time business intelligence for Odoo — combining Sales & Purchases into one powerful profitability cockpit.
Stop guessing. Know exactly which products make money, which drain margins, how hard your team discounts, and whether you are dangerously reliant on a single vendor — all from one interactive Odoo dashboard.
Everything You Need to Master Margins
A complete analytics suite built natively inside Odoo — no external BI tool needed.
Real-time Profit & Margin Analytics
Instantly see revenue, cost, gross profit, and margin % across any date range, product category, customer, or vendor.
Sales vs Purchase Intelligence
Side-by-side monthly trend of sales revenue against purchase costs, with estimated margin evolution over time.
Top Profitable Products
Ranked table of your top 20 products by gross profit — know exactly what drives the most value.
Low Margin Product Detection
Automatic alerts flag products with negative or critically low margins before they silently erode your bottom line.
Vendor Concentration Risk
Detects when a single supplier exceeds a configurable share of your total purchase spend — protecting supply chain resilience.
Discount Impact Analysis
Track average discount rates applied by your sales team and understand how deeply discounting affects overall profitability.
Product Velocity Tracking
Identify your fastest and slowest moving products by quantity sold per day — optimise inventory and purchasing accordingly.
Clean OWL Dashboard Interface
Built with Odoo's modern OWL 2 framework — reactive, fast, and fully integrated into the Odoo shell without any external dependency.
Your Profitability at a Glance
Eight headline metrics displayed in real time at the top of the dashboard, updated whenever you adjust date, category, customer, or vendor filters.
Turn Data into Decisions
Designed for companies that need to move fast on pricing, procurement, and product strategy — without leaving Odoo.
-
🔍 Identify Profitable ProductsSurface the 20% of your catalogue that generates 80% of your profit — stop over-investing in low-return SKUs.
-
🚨 Detect Margin LeaksAutomatic alerting for products with negative or dangerously thin margins — catch problems before they compound.
-
💳 Monitor Discount PoliciesSee whether your sales team discounts systematically and quantify the revenue impact in real time.
-
🏭 Reduce Supplier DependencyVendor concentration risk scores help procurement teams diversify before a single-supplier crisis hits.
-
📉 Improve Pricing StrategyCompare margin distribution across price tiers and categories to guide data-driven repricing decisions.
-
⚡ Act at the Speed of BusinessCached, optimised queries mean the dashboard loads in seconds — even on databases with millions of order lines.
Built the Right Way for Odoo
Premium performance, clean architecture, and zero external runtime dependencies.
Architecture at a Glance
| Frontend | OWL 2 Component, useState, useRef, Chart.js |
| Backend | Python TransientModel, raw SQL with psycopg2, module-level TTL cache |
| Data Sources | sale.order.line, pos.order.line, purchase.order.line, stock.quant |
| Security | BMI User (read/analyse) + BMI Manager (configure/export) |
| Export | Base64 CSV (UTF-8 BOM) — Excel compatible, no server temp files |
Works with Your Odoo Stack
Tested on Odoo 17 & 18. Designed to be forward-compatible with Odoo 19.
🛡️ Built for Long-Term Compatibility
| JSONB field detection | standard_price & translatable names detected at runtime — works on Odoo 16/17/18/19 |
| Chart.js multi-path fallback | Tries 3 candidate paths in order — dashboard stays functional even if Odoo 19 ships a different Chart.js build |
| OWL standard hooks only | useState, useService, onWillStart — core API stable across all OWL 2.x versions |
| POS auto-detection | Checks ir.module.module at runtime — integrates or skips automatically |
| PostgreSQL CTEs | Raw SQL with WITH ... AS — 100% database-level, zero Odoo ORM coupling |
Perfect For
Any Odoo user who needs clear, actionable profitability data without a dedicated BI team.
Start Mastering Your Margins Today
Install the Odoo Business Intelligence Dashboard and gain instant, real-time visibility into every corner of your business profitability — directly inside Odoo, zero external tools required.
Unlock Your Profit Insights →One-click install • No setup complexity • Works with your existing data
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module