Effortlessly Sync Shopify Orders to Odoo Contacts & Remove Duplicates

Effortlessly Sync Shopify Orders to Odoo Contacts & Avoid Duplicates

Experience seamless integration and flawless data management with our "Sync Shopify Orders to Odoo Contacts & Remove Duplicates" n8n workflow. Automate the synchronization of shipping contact details from your Shopify orders directly into your Odoo Contacts, ensuring your contact database remains organized and duplicate-free.

What this workflow does

• Automatically triggers when a Shopify order is marked as paid, extracting the relevant order details.
• Performs a search in Odoo Contacts (res.partner) to locate any existing contact that matches the shipping details.
• If a matching contact is identified, updates or creates a new Odoo contact with the Shopify shipping address, email, and phone information.
• Simultaneously, the workflow splits out the order ID to perform an additional duplicate-check in Odoo for comprehensive matching.
• Generates a new Odoo contact if duplicates are found in this second search, ensuring your contact records are current and unduplicated.

Use cases

• For e-commerce stores using Shopify, this workflow keeps your customer information in Odoo up-to-date and consolidated without manual data entry.
• SaaS operators can optimize their contact management processes, reducing redundancy and improving operational efficiency.
• Automation engineers seeking robust solutions for syncing multi-system data will find this workflow essential for maintaining clean and accurate databases across platforms.

Technical details

• Integrations/Nodes Used: Shopify Trigger, Odoo API, Filter, Split Out, Sticky Note, and Code.
• Setup Requirements: Shopify Access Token, Odoo API credentials with permissions to access Contacts (res.partner), and review of Odoo search criteria for accurate duplicate detection.
• Ensure correct mapping from Shopify shipping_address, email, and phone to relevant Odoo fields to fit your data model requirements.