Automated Shopify to Odoo Contact Synchronization with Duplicate Removal

Who it's for

This n8n workflow is designed for Shopify 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 Shopify order is paid (orders/paid webhook).
• 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 Shopify customer details, including name, email, phone, and shipping address, to Odoo.
• Efficient Processing: Supports batch handling and split processing for complex data operations.

Requirements

• Shopify Store: A live Shopify store with webhook access for orders/paid.
• 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 Shopify (Access Token) and Odoo.

Important Notes

• Shipping Data: Uses Shopify shipping address details to populate Odoo contact fields (street, city, zip, 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