Complete WooCommerce to Odoo Integration: Sync Orders, Products & Customers

📖 Description (WooCommerce Version)

This workflow functions like the integration of WooCommerce products with Odoo products, WooCommerce customers with Odoo customers, and WooCommerce orders with Odoo sales orders containing multiple products.

🔔 Trigger (WooCommerce – Order Created)

The workflow starts when a new order is created in WooCommerce.

🔄 Loop Through Each Line Item in the Order
For each product in the WooCommerce order:
Check if Product Exists in Odoo (via Internal Reference/Default Code):
If the product exists, proceed.

If the product does not exist, create it in Odoo with:
Product Name
Description
Price
Internal Reference (Default Code)

👤 Check if Customer Contact Exists in Odoo (via Email)

If the contact exists, proceed.

If the contact does not exist, create a new contact in Odoo with:
Full Name
Email Address
Phone Number

Shipping or Billing Address (as available)

📝 Create a Sale Order in Odoo

Create a new Sale Order in Odoo using:
The matched or newly created Customer Contact
All the matched or newly created Products from the WooCommerce order (with correct quantities and pricing)
Each WooCommerce product in the order is matched to the corresponding Odoo product using the Internal Reference field.
👉 This ensures a seamless sync between WooCommerce and Odoo, keeping your orders, products, and customers aligned automatically.

Setup referecence:
https://docs.n8n.io/integrations/builtin/credentials/woocommerce/
https://docs.n8n.io/integrations/builtin/credentials/odoo/