# 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 - Add new customer to Odoo - Create order in Odoo - Loop Through Line Items - Create order line items in Odoo ## 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: - Set custom delays - Chain multiple actions - Store data in tables - Deploy AI agents for smart decisions ## You're in good company Avg. App Store rating: 4.9/5 Merchant reviews: 157 Avg. time saved per week: 3.5 hrs ### Testimonials - "MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful." - "It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed." - "The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"