Automatically Sync Shopify Order and Customer Details to Odoo

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

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

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

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

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

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

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

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

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

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

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

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

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

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