Sync Shopify Orders and Customers to Odoo | Automate Data Transfer

Automatically Sync Shopify Order and Customer Details to Odoo

14 min setup
No coding required
Runs automatically

Streamline your operations by automatically sending Shopify order details and customer information to Odoo. This MESA workflow template updates Odoo whenever a new Shopify order is created, saving you time and ensuring accurate data across platforms. Simplify your workflow and maintain consistent records without the hassle of manual data entry.

New Shopify Order

How it works

14 steps to automate this task automatically.

New Shopify Order

App connector: [Shopify](/content/apps/shopify/integrate "View Shopify integration page"/index.html) • Time to complete: 1 minute

The workflow begins whenever a new order is created in Shopify, making sure all relevant details are captured immediately.

Retrieve product variants from Odoo

App connector: [Odoo](/content/apps/odoo/integrate "View Odoo integration page"/index.html) • Time to complete: 1 minute

Query Odoo to retrieve product variants that match the SKUs from the Shopify order line items.

Validate product matches

App connector: [Filter](/content/apps/filter/integrate "View Filter integration page"/index.html) • Time to complete: 1 minute

Compare Shopify SKUs with Odoo product codes to ensure proper alignment. Skip unmatched products to prevent errors.

Retrieve customer details from Odoo

App connector: [Odoo](/content/apps/odoo/integrate "View Odoo integration page"/index.html) • Time to complete: 1 minute

Query Odoo to find a customer matching the Shopify order details, including email, shipping address, and customer rank.

Avoid duplicate customer records

App connector: [Filter](/content/apps/filter/integrate "View Filter integration page"/index.html) • Time to complete: 1 minute

Check if the customer already exists in Odoo. Skip the creation process if a match is found.

Retrieve country details

App connector: [Odoo](/content/apps/odoo/integrate "View Odoo integration page"/index.html) • Time to complete: 1 minute

Query Odoo for country details based on the customer's shipping country code to ensure proper alignment.

Retrieve state details

App connector: [Odoo](/content/apps/odoo/integrate "View Odoo integration page"/index.html) • Time to complete: 1 minute

Query Odoo for state information using the country ID and province code from the Shopify order.

Add new customer to Odoo

App connector: [Odoo](/content/apps/odoo/integrate "View Odoo integration page"/index.html) • Time to complete: 1 minute

If no matching customer exists, create a new customer in Odoo with detailed Shopify order information, including address and contact details.

Assign customer ID for order sync

App connector: [Transform](/content/apps/transform/integrate "View Transform integration page"/index.html) • Time to complete: 1 minute

Map the customer ID from either an existing or newly created Odoo record for use in the order creation process.

Create order in Odoo

App connector: [Odoo](/content/apps/odoo/integrate "View Odoo integration page"/index.html) • Time to complete: 1 minute

Create a new order in Odoo using Shopify order details, including subtotal, tax, and total amounts.

Prepare order line items for Odoo

App connector: [Transform](/content/apps/transform/integrate "View Transform integration page"/index.html) • Time to complete: 1 minute

Map Shopify order line items to Odoo's format, including product details, discounts, taxes, and shipping information.

Loop Through Line Items

App connector: [Loop](/content/apps/loop/integrate "View Loop integration page"/index.html) • Time to complete: 1 minute

Iterate through each line item in the Shopify order to create corresponding records in Odoo.

Map product IDs for order line items

App connector: [Transform](/content/apps/transform/integrate "View Transform integration page"/index.html) • Time to complete: 1 minute

Map product IDs from Odoo to Shopify order line items for accurate order creation.

Create order line items in Odoo

App connector: [Odoo](/content/apps/odoo/integrate "View Odoo integration page"/index.html) • Time to complete: 1 minute

Create detailed order lines in Odoo for each Shopify item, including quantities, prices, and tax details.

Frequently asked questions

What is a template?

MESA templates are fully pre-configured workflows built and vetted by Shopify Experts. Unlike competitor templates that provide basic scaffolds requiring extensive setup, MESA templates come with all data variables properly mapped, required fields configured, and steps ready to activate. You can turn them on immediately and start automating.

Can I customize a template?

Absolutely! While our templates work out-of-the-box, every step can be personalized to match your exact business requirements. Add conditional logic, integrate additional apps, or build more sophisticated workflows. MESA's templates provide a solid foundation that you can expand as needed.

Are templates free?

Yes! Our entire library of expert-built, production-ready templates is free to use. Unlike platforms that charge for premium templates or provide only basic scaffolds, MESA gives you access to hundreds of fully-configured, vetted workflows at no additional cost.

Make this template your own!

Customize this workflow even further:

You're in good company

Avg. App Store rating: 4.9/5
Merchant reviews: 157
Avg. time saved per week: 3.5 hrs

Testimonials