WooCommerce to Odoo Contact Synchronization with Duplicate Removal

Who it's for

This n8n workflow is designed for WooCommerce store owners and operations managers who use Odoo as their backend system. It is specifically tailored for businesses that need to strictly manage their CRM database, ensuring that every time a paid order comes in, the customer contact information in Odoo is verified, updated, or cleaned up to maintain data hygiene.

Features

• Order Trigger: Runs automatically when a WooCommerce order is paid (order.updated or processing/completed status).
• Customer Verification: Searches Odoo (res.partner) to check if the customer already exists.
• Smart Routing: Creates a new contact for new customers or handles existing contacts based on your workflow logic.
• Data Mapping: Syncs WooCommerce customer details, including name, email, phone, and shipping address, to Odoo.
• Efficient Processing: Supports batch handling and split processing for complex data operations.

Requirements

• WooCommerce Store: A live WooCommerce store with webhook access for paid order events (processing / completed).
• Odoo Instance: An Odoo instance with API access enabled to manage res.partner (Contacts).
• n8n Instance: A self-hosted or cloud n8n workflow automation tool.
• Access Credentials: Valid API credentials for both WooCommerce and Odoo.

Important Notes

• Shipping Data: Uses WooCommerce shipping address details to populate Odoo contact fields (street, city, postcode, etc.).
• Existing Contact Handling: Checks for existing contacts before creating or updating records; review delete logic to ensure it matches your requirements.
• Split Processing: Uses a Split Out node to process IDs or data segments individually for better duplicate handling and data management.

Support & Help

• WhatsApp: Chat on WhatsApp
• Discord: SpaGreen Community
• Facebook Group: SpaGreen Support
• Website: spagreen.net
• Developer Portfolio: Codecanyon SpaGreen