Eight Integration Patterns That Hold Up at $5M–$50M GMV
Shopify is a brilliant storefront. It is not an ERP. Once a founder crosses $5M in annual GMV — multi-warehouse fulfilment, cross-border duties, variant explosions, B2B tiers, payment reconciliation — the off-the-shelf Shopify-to-Odoo connector starts to creak. The eight integration patterns below are the ones that hold up under high-volume traffic, refunds, and audit. Each one is the difference between Odoo being your source of truth and Odoo being a downstream report nobody trusts. Configure these before you bolt on another app.
Octura packages these as fixed-price e-commerce integrations with senior engineers on every project — no junior consultants billed at senior rates.
Near-Real-Time Stock Sync (5–15-Min Polling vs Webhook-Only)
Webhook-only stock sync looks great in a demo and breaks in production. Shopify webhooks deliver at-least-once, in arbitrary order, and silently drop under load. The pattern that holds up is webhooks for low-latency updates plus a 5–15-minute reconciliation poll that compares Odoo on-hand against Shopify available — and pushes the delta. You stop overselling Black Friday inventory. The Odoo side runs as a scheduled action on a dedicated queue worker so the integration cannot starve the rest of the ERP. See e-commerce ERP integration patterns.
Payment Reconciliation Through Stripe and Shopify Payments
Shopify reports gross revenue. Stripe and Shopify Payments deposit net of fees, refunds, chargebacks, and currency conversion — often days later, in a different ledger period. The integration that survives audit ingests Stripe balance transactions and Shopify payouts directly into Odoo bank statements, matches each deposit to its underlying orders, and posts processor fees as a separate expense line. Month-end goes from a three-day reconciliation to a thirty-minute review. Detail in Odoo payment providers and gateway integration.
Multi-Warehouse Routing That Picks Closest Stock
At one warehouse, Shopify's default fulfilment routing is fine. At three or more, it leaks money — California stock shipping to a Manhattan customer costs you a day of transit and a chunk of margin. The fix is order routing decided in Odoo, not Shopify: incoming orders match the customer ship-to against a warehouse-priority matrix (proximity, available stock, carrier rate), then write the chosen location back to Shopify before fulfilment. Founders who layer this on top of base Shopify recover 8–15 % of shipping spend. Pattern in multi-warehouse routing rules.
Cross-Border Duties and Tax via Avalara Hook
Selling US-to-Canada, EU-to-UK, or anywhere across a customs border without landed-duty calculation at checkout is the fastest way to lose a customer at the door. The integration that works is an Avalara AvaTax hook wired to both Shopify checkout and Odoo invoicing — same tax engine, same HS code mapping, same exemption certificates. Sales tax, GST/HST, VAT, and duties stay in sync between the two systems, and Odoo holds the audit trail. Without this, you discover the mismatch at sales-tax filing season.
Refund and Partial-Fulfilment Handling
This is where every off-the-shelf connector breaks. A customer orders three items, you ship two, refund one before shipment, and partially refund another for damage post-delivery. The connector either creates duplicate credit notes, misses the inventory return, or posts the refund to the wrong period. The integration that survives models Shopify refund objects explicitly — full refunds become credit notes, line-item refunds adjust the original invoice, restocking-fee refunds split into two journal entries. Solve this once and you stop the weekly accounting fire-drill. See payment follow-up and dunning.
Product Variant + Size-Grid Sync for SKU-Heavy Stores
Apparel and footwear founders live and die by variant sync. A single style with 8 colours and 12 sizes is 96 SKUs — and Shopify caps variants per product at 100. Odoo's product attributes and variants with size-grid templates map cleanly to Shopify when the integration treats Odoo as master and pushes attribute lines, not flattened SKU strings. Add automated barcode generation per variant and you get clean POS, warehouse, and online inventory from a single source. Detail in fashion variant management.
Subscription and Recurring-Revenue Billing Patterns
Shopify Subscriptions handles the checkout. Odoo handles the revenue recognition, deferred-revenue schedule, and customer-lifetime-value reporting. The integration that ties them together pushes Shopify subscription contracts into Odoo recurring invoices, syncs pauses/cancellations/upgrades, and posts the MRR change to a deferred-revenue account on the right date. Founders who skip this step discover at year-end that their books and their dashboard disagree by six figures. Pattern in recurring invoices and subscriptions.
B2B Portal and Wholesale Pricing Tier Sync
The DTC brand that adds a B2B channel doubles its complexity overnight: wholesale price tiers, NET-30 terms, credit limits, quick-order forms, and tax-exemption certificates. Shopify Plus B2B handles the storefront; Odoo handles the AR aging, credit holds, and tier-pricing engine. The integration that works keeps customer-specific pricelists and credit limits in Odoo and pushes the effective price into Shopify per logged-in customer — not the reverse. See B2B portal and wholesale pricing.
How to Evaluate an Odoo Partner Without Getting Burned
The integration patterns matter; the partner shipping them matters more. Eight checks separate the partners who deliver from the ones who learn on your budget:
- Official Odoo certification (Ready, Silver, or Gold) — not just "we work with Odoo".
- Discovery-call person is the build person. Account-manager handoffs lose scope.
- Fixed-price scope after discovery. Time-and-materials is a budget vacuum on ERP work.
- Senior engineers on the project. Octura runs seniors only — ask any prospective partner who actually writes your code.
- Two reference customers willing to take a call. "We have many clients" without a name is a red flag.
- Vertical specialism in e-commerce. A generalist who ships one storefront a quarter is not the right partner for a high-volume project.
- Documented multi-phase methodology. Discovery → configuration → customization → migration → go-live → hyper-care.
- Transparent published rates. "Custom quote" is fine; refusing to share a starting number is not.
The longer version is in the Odoo partner audit.