WooCommerce Paid Order → Odoo CRM Sync (No Duplicates) | n8n

Sync WooCommerce paid orders to Odoo Contacts—without creating obvious duplicates (n8n)

This n8n workflow listens for WooCommerce order updates when an order is completed/paid and syncs the customer’s shipping details into Odoo CRM Contacts (res.partner), including a practical two-step duplicate check to reduce redundant contacts.

What this workflow does

• Triggers on WooCommerce order.updated events, then continues only when order status equals completed.
• Searches Odoo Contacts in res.partner to determine whether a matching contact already exists.
• If an existing contact is detected (or specific matching rules indicate the first match path), it creates a new Odoo contact using the WooCommerce order’s shipping address, email, and phone fields.
• Runs a secondary duplicate check by splitting the incoming contact id data and performing a second Odoo contact search.
• If the second check detects a duplicate, it creates another Odoo contact from the same WooCommerce shipping and customer details.
• If the order is not completed, the workflow takes no action.

Use cases

• You want Odoo CRM lead/contact records created from WooCommerce sales the moment orders are paid.
• Your store customers use varying identifiers, so you need configurable duplicate detection (e.g., email/phone matching criteria) during the sync.
• You’re building an e-commerce to CRM automation for SaaS operations and want consistent field mapping from WooCommerce shipping into Odoo.

Technical details

• WooCommerce: API credentials + webhook/event setup for order.updated when status changes to completed.
• Odoo: API access to res.partner for searching and creating contacts.
• Nodes/logic used: if, filter, split out, code, no op, and odoo.
• Field mapping: WooCommerce shipping_address, email, and phone into Odoo contact fields.

Configure the Odoo search nodes’ matching criteria to ensure the duplicate checks behave exactly as you need.