Sync paid Shopify order contacts with Odoo and remove duplicates

Quick Overview

This workflow triggers on paid Shopify orders and syncs the order’s shipping contact details into Odoo Contacts (res.partner) by searching for existing contacts and creating new ones, with a secondary duplicate-check branch that splits out IDs for additional matching.

How it works

1. Triggers when a Shopify order is marked as paid and retrieves the order payload.
2. Searches Odoo Contacts (res.partner) for an existing matching contact and flags whether a record is found.
3. If a matching Odoo contact exists, creates a new Odoo contact using the Shopify shipping address, email, and phone.
4. In parallel, splits out the incoming order’s id field and uses it to run an additional Odoo contact search for potential duplicates.
5. If a contact is found in the duplicate-check path, creates another Odoo contact from the same Shopify shipping and customer fields.

Setup

1. Add Shopify Access Token credentials and enable the Shopify orders/paid trigger for your store.
2. Add Odoo API credentials with access to read and create records in Contacts (res.partner).
3. Review the Odoo search criteria in both contact search steps and adjust them to match your intended duplicate-detection key (for example, email or phone rather than the order id).
4. Confirm the field mappings from Shopify shipping_address and order email/phone to Odoo res.partner fields match your Odoo data model and required fields.