Odoo Retail & Ecommerce · intermediate · 9 min read
Retail Analytics and KPIs in Odoo
Measure retail performance in Odoo: sell-through, margin, inventory turns, fulfillment SLAs, channel mix, store KPIs, and building dashboards executives trust.
Last reviewed 2026-07-30 · Estimated effort: 2–6 weeks typical implementation slice
Table of contents
Retail analytics in Odoo combine POS orders, sales orders, delivery performance, stock valuations, and returns into KPIs that leaders use for buying, staffing, and channel investment.
Metrics only work when analytic tags, store dimensions, product categories, and promotion identifiers are configured consistently — garbage dimensions produce confident wrong decisions.
Manufacturing KPIs matter when retail demand drives replenishment production. Performance monitoring keeps dashboards responsive during peak reporting loads.
Teams implement Odoo retail then discover standard reports do not match the board deck: missing store dimension, blended channels, or margin distorted by unmapped discounts.
This article defines practical retail KPIs and the Odoo data they need. Implementation and architecture articles help embed dimensions early.
Revenue and units by channel, store, category, and season. Gross margin after discounts and returns — not list price fantasy.
Sell-through rate compares sales to available inventory over time, guiding markdown and reorder decisions.
- ▸Sales revenue and units
- ▸Gross margin and markdown rate
- ▸Average order value and basket size
- ▸Conversion where traffic data exists outside Odoo
Inventory turns, days of supply, and stockout frequency connect to sync and replenishment policies. Overstock ties up cash; chronic stockouts drive cancel rates online.
Shrink and adjustment rates by store highlight training or process gaps.
Order-to-ship time, on-time-in-full (OTIF), pick accuracy, and carrier exception rates measure warehouse and ship-from-store health.
BOPIS ready-time and pickup completion rate belong in omnichannel scorecards.
Return rate by SKU and channel, refund value, and restock recovery rate inform quality and sizing decisions.
Repeat returners may signal fraud or product issues — reason codes enable drill-down.
Align chart of accounts, analytic accounts, and product categories before go-live. Custom SQL or BI exports need documented definitions so teams do not debate numbers.
Cross-link Manufacturing when retail KPIs include make-to-stock replenishment. Cross-link Performance when dashboard refresh slows at month-end close.
- ✓Define a KPI dictionary with formula and Odoo source before building dashboards.
- ✓Tag orders with store, channel, and campaign where standard fields are insufficient.
- ✓Review margin weekly during promotions, not only at month-end.
- ✓Pair sell-through with incoming PO visibility for buyers.
- ✓Benchmark fulfillment SLAs by carrier and warehouse zone.
- ✓Load-test reporting queries before peak close with Performance guidance.
- !Reporting revenue without returns and discounts netted.
- !Mixing tax-included and tax-excluded figures on one dashboard.
- !No store dimension on ecommerce orders fulfilled from stores.
- !Chasing vanity metrics without inventory or margin context.
- !Building BI on stale nightly exports when ops needs intraday.
- !Ignoring unit of measure in volume rollups.
Retail analytics in Odoo pay off when KPI definitions, dimensions, and data hygiene are designed with operations — not pasted from a generic template after go-live.
Publish a KPI dictionary, embed store and channel tags early, and review margin and fulfillment weekly during active seasons.
On-time fulfillment
on track> 95%
Inventory accuracy
watch> 98%
Order cycle time
on track↓ trend
Exception rate
critical< 3%
| Option | Best when | Trade-off |
|---|---|---|
| Configure | Standard Odoo covers the need | Limited uniqueness |
| Customize | Differentiating workflow | Upgrade cost |
| Integrate | External system of record | Sync complexity |
Frequently asked questions
Does Odoo have built-in retail dashboards?
Standard sales and inventory reports cover basics. Chains often extend with custom dashboards or BI connectors via Development for executive views.
How do we compare POS and web performance?
Use consistent product categories and tag orders by channel. Avoid separate product catalogs that break comparison.
Can KPIs include marketplace fees?
Map marketplace fees in accounting or analytic lines so net margin reflects channel economics.
What KPIs trigger production orders?
When retail replenishment uses manufacturing, tie MO creation to reorder rules and monitor WIP plus finished goods turns — see Manufacturing guide.
Related articles
Building an Omnichannel Retail Strategy in Odoo
How to design an omnichannel retail strategy in Odoo: channel roles, inventory truth, buy-online-pick-up-in-store, ship-from-store, and customer experience without duplicate operations.
View →Inventory Synchronization Across Channels in Odoo
How to keep inventory synchronized across POS, ecommerce, and marketplaces in Odoo: available-to-promise rules, reservations, sync frequency, oversell prevention, and operational truth.
View →Pricing and Promotion Management in Odoo Retail
Manage retail pricing and promotions in Odoo: pricelists, discounts, loyalty, tax alignment, channel-specific rules, and keeping POS and ecommerce prices consistent.
View →Warehouse Fulfillment Workflow for Retail in Odoo
Design retail warehouse fulfillment in Odoo: pick-pack-ship, batch picking, carrier integration, ship-from-store, barcode scanning, and SLA-driven outbound operations.
View →Defining retail metrics in Odoo?
Share the KPIs your leadership expects — we will map them to Odoo data and gap custom reporting.
