Understand your Odoo environment in seconds, not days

Gross Margin — Top 10 Products, Q1 2025

Here's your margin breakdown for the current quarter, pulled directly from your confirmed sales orders and product cost data. I've flagged 3 products that fall below your 20% threshold — these are worth reviewing with your purchasing team before the next order cycle.

What's driving the low margins

• •Aluminium Sheets (17%) — your supplier raised prices by 12% in October, but your pricelist for this category hasn't been updated since June. Adjusting the pricelist would bring the margin back to approximately 24%, which is above your threshold.
• •Motor Bearings (16.2%) — you're currently purchasing from your secondary supplier at a higher cost. The primary supplier offers a 9% lower unit price. Switching back or renegotiating the secondary contract would resolve this.
• •Cardboard Packaging (15%) — this is typically sold as a standalone line item, but most of your competitors bundle it into service contracts. If you include packaging in your service bundles, it removes the standalone margin pressure entirely.

Trend vs. last quarter

Compared to Q4 2024, your overall average margin dropped from 38.2% to 35.7%. The primary driver is the raw materials category — Aluminium and Bearings alone account for 80% of the decline. Services and software margins remain stable and strong.

💡 I can generate a detailed quarter-over-quarter comparison report with charts that you can share directly with your purchasing team. Want me to create that?

HubSpot + Asana + QuickBooks → Odoo

Consolidating three separate tools into one unified system is exactly what Odoo excels at. The critical thing is importing in the right order — sales and project records reference contacts and products, so those must exist in Odoo first. Here's the full plan.

Import Sequence

1. •HubSpot → Contacts & Companies — 25,000 records. Deduplicate on email first — expect ~2,800 duplicates from contacts who exist in multiple HubSpot lists.
2. •QuickBooks → Chart of Accounts & Products — import your account structure first, then products/services with their QB item codes. Tax mappings need manual review.
3. •QuickBooks → 3 Years of Invoice History — ~420k invoice lines. Import as posted journal entries — do not trigger payment workflows or stock movements.
4. •Asana → Projects & Tasks — 400 projects. Map Asana boards to Odoo project stages. Match team members by email address.
5. •Validate & Reconcile — compare totals across all 3 source systems vs. Odoo before cutting over.

Common gotchas for this stack

• •HubSpot deals ≠ Odoo opportunities — HubSpot's pipeline stages don't map 1-to-1 to Odoo CRM stages. You'll need to create a mapping table before starting. I can generate one once you share your HubSpot pipeline configuration.
• •QuickBooks tax codes — QB stores tax as a flat amount on each invoice line. Odoo uses fiscal positions and tax groups, which work fundamentally differently. You'll need to rebuild your tax rules in Odoo, not import them from QB.
• •Asana attachments — files attached to Asana tasks can be exported via their API, but budget significant extra time for this step. In a typical migration, attachments are 3–5x the task count in total files.
• •Opening balances — after importing QuickBooks invoices, you need to post an opening balance journal entry in Odoo that matches your QB trial balance on the cutover date. Don't skip this or your accounting will be off from Day 1.

⏱️ For this volume and complexity: 2 weeks of data preparation and field mapping, 1 week for test imports and validation, then 3–4 days for the final production migration. Keep all 3 source systems in read-only mode during the final import window.

Route Conflict — Manufacture + Dropship

This is one of the most common — and most confusing — issues in Odoo inventory configuration. When multiple routes are assigned to a product, Odoo doesn't choose the "best" one. It evaluates all active routes simultaneously when a sale order is confirmed, which is why you're seeing both a manufacturing order and a dropship purchase created at the same time.

What's happening now

When a sale order is confirmed for your product, Odoo fires both the Manufacture and Dropship procurement rules at the same time. This creates a manufacturing order that consumes components from your stock AND a purchase order that ships directly from the supplier — double fulfillment, wrong costs, and a confused warehouse.

How to fix it

You need a single route with conditional logic, not two separate routes competing. Here's exactly what to change:

1. •Remove the Dropship route from the product form. Keep only "Manufacture" as the active route. This prevents both routes from firing simultaneously.
2. •Create a reordering rule on the product with minimum quantity = 0 and preferred route = Manufacture. When stock drops below minimum after a sale, Odoo will automatically create a manufacturing order to replenish.
3. •For dropship scenarios, create a separate product variant called "Custom Sensor Kit (Dropship)" that uses only the Dropship route. Your sales team selects this variant when the customer explicitly requests direct delivery from the supplier.
4. •Link the operations together by setting procurement group propagation to "Fixed" on the manufacture route. This ensures the delivery order stays in "Waiting" status until the manufacturing order is completed — no partial shipments or manual intervention needed.

How the operations link together

With this setup, confirming a sale creates a delivery order in "Waiting" status. The reordering rule then creates an MO. Once the MO is completed and products enter stock, the delivery automatically becomes "Ready" — no manual intervention needed. One path, one fulfillment, correct costs.

MRP + Inventory Go-Live — 12 Weeks

Moving from Excel to Odoo Manufacturing is a significant step, but 3 months is realistic if you follow a structured approach. The biggest risk isn't the software — it's data quality and team adoption. Here's the full plan.

Implementation Roadmap

Phase 1: Foundation — Weeks 1–3 · Low effort Set up warehouses, stock locations, units of measure, and basic product categories. This is the skeleton everything else builds on.

Phase 2: Product Catalog & BoMs — Weeks 3–5 · Medium effort Import your product list from Excel, create Bills of Materials, and define reordering rules. This is the most data-intensive phase — budget all of Week 4–5 for BoM validation with your production team.

Phase 3: Manufacturing Configuration — Weeks 5–8 · Medium effort Configure work centers, define manufacturing operations and routings, set up the production scheduler. Test with 2–3 sample products end-to-end before proceeding.

Phase 4: User Acceptance Testing — Weeks 8–10 · Intensive Full simulation using real orders from your last month. Every warehouse user should process at least 20 orders in the test environment. Document every issue you find.

Phase 5: Go-Live ✓ — Weeks 11–12 · Critical Physical stock count (schedule on a weekend), cutover from Excel, and run both systems in parallel for at least 5 business days to catch discrepancies.

Top 3 risks for your situation

• •Bills of Materials accuracy — this is the #1 reason manufacturing go-lives fail. If your BoMs are wrong, every production order will consume the wrong quantities and your inventory will be off within days. Budget all of weeks 4–5 for BoM validation with your production manager physically in the room.
• •Opening stock count — your Odoo stock levels must match the physical warehouse on Day 1, or every subsequent transaction will compound the error. Schedule a full physical count during Week 10, ideally on a Saturday when the warehouse is quiet and nothing is being shipped.
• •Team adoption — warehouse staff moving from Excel to tablets/barcode scanners need hands-on training, not just a demo. Plan at least 2 dedicated training sessions per team, plus 1 week of floor support during go-live.

📋 Upload your Excel product list to your ERPeek project. I'll analyze every column, map it to the corresponding Odoo fields, flag any gaps or formatting issues, and generate an import-ready CSV — so you can start Week 1 with clean data.

Environment Audit — 14 Custom Modules

I've scanned the full environment — every installed custom module, its dependencies, what standard Odoo behavior it overrides, and the risk level if you need to modify or remove it. Here's the complete picture.

Module Inventory

... and 9 more modules analyzed — full report available on request

Module Dependencies

The 2 high-risk modules sit at the top of the dependency chain:

• •custom_sale_workflow → sale_margin_ext → report_templates
• •stock_barcode_custom → mrp_quality_ext
• •hr_expense_rules — standalone, no dependencies

You cannot uninstall or modify a module without first understanding everything downstream of it.

Risk Summary

• •🔴 2 high-risk modules — custom_sale_workflow and stock_barcode_custom heavily override core Odoo behavior. Any changes to these could break daily operations for the sales and warehouse teams. Understand them completely before touching anything.
• •🟡 4 medium-risk modules — extend standard features with custom fields and modified views. Functional but will need updates if the client upgrades Odoo versions.
• •🟢 8 low-risk modules — mostly report templates, small field additions, and UI tweaks. Safe to maintain as-is.

📋 Recommended next steps for the takeover: 1. Schedule a 2-hour walkthrough of the 2 high-risk modules with the client's key users. 2. Ask me to "explain custom_sale_workflow in detail" for a full technical trace. 3. Before modifying anything, check the dependency chain above.