Odoo Integration for WooCommerce: The Complete 2026 Setup Guide

Integrating Odoo with WooCommerce is one of the most powerful ways to unify your e-commerce front end with a full-featured ERP back end. In this comprehensive guide, we walk you through every step of the Odoo integration for WooCommerce — from initial planning to going live.

Why Integrate Odoo with WooCommerce?

Running WooCommerce as your storefront and Odoo as your ERP gives you the best of both worlds:

• WordPress flexibility for SEO, content marketing, and design
• Odoo's unified back office for inventory, accounting, CRM, and manufacturing
• Automated data flow eliminating manual CSV imports and copy-paste errors
• Real-time stock accuracy preventing overselling across channels

Without integration, teams waste hours re-keying orders, updating stock in spreadsheets, and reconciling mismatched customer records. An Odoo WooCommerce integration removes those bottlenecks entirely.

Prerequisites

Before you begin, make sure you have:

1. Odoo 16+ or Odoo 17 instance (Community or Enterprise)
2. WooCommerce 8.x+ on WordPress 6.x
3. REST API access enabled in WooCommerce (Settings → Advanced → REST API)
4. Admin access to both platforms
5. SSL certificate on your WordPress site (required for secure API calls)

Step 1: Generate WooCommerce API Keys

Navigate to WooCommerce → Settings → Advanced → REST API and click "Add Key":

• Description: Odoo Integration
• User: Select an admin user
• Permissions: Read/Write

Save the Consumer Key and Consumer Secret — you'll need them in Step 3.

Step 2: Install the OdooSync Connector

The fastest way to connect Odoo to WooCommerce is through a purpose-built connector like OdooSync:

1. Download the OdooSync WordPress plugin from odoo-sync.io
2. Upload it via Plugins → Add New → Upload Plugin
3. Activate the plugin
4. Navigate to OdooSync → Settings to begin configuration

Step 3: Configure the Connection

In the OdooSync settings panel, enter:

• Odoo URL: Your Odoo instance URL (e.g., https://mycompany.odoo.com)
• Database Name: The Odoo database to connect to
• API Key: Your OdooSync API key (generated at odoo-sync.io/api-keys)
• WooCommerce Consumer Key / Secret: From Step 1

Click Test Connection to verify both endpoints are reachable.

Step 4: Map Your Data

Data mapping is the most critical step. You need to define how fields in WooCommerce correspond to fields in Odoo:

Products

WooCommerce Field	Odoo Field
Product Name	product.template → name
SKU	product.template → default_code
Regular Price	product.template → list_price
Stock Quantity	stock.quant → quantity
Categories	product.category → name

Orders

WooCommerce Field	Odoo Field
Order Number	sale.order → client_order_ref
Customer Email	res.partner → email
Line Items	sale.order.line → product_id, qty
Shipping Address	res.partner → street, city, zip

Step 5: Set Sync Direction and Frequency

Decide the data flow direction for each entity:

• Products: Odoo → WooCommerce (Odoo is your product master)
• Orders: WooCommerce → Odoo (orders originate on the storefront)
• Stock Levels: Odoo → WooCommerce (ERP is the inventory source of truth)
• Customers: Bidirectional (new customers can come from either side)

Set the sync frequency based on your volume:

• High-volume stores (100+ orders/day): Every 5 minutes or real-time webhooks
• Medium-volume (10-100 orders/day): Every 15 minutes
• Low-volume (<10 orders/day): Every 30-60 minutes

Step 6: Run an Initial Sync

Before going live, run a full initial synchronization:

1. Sync products first — this creates the product catalog in the target system
2. Sync customers — ensures order references resolve correctly
3. Sync orders — import historical orders if needed
4. Verify stock levels — confirm quantities match between systems

Step 7: Go Live and Monitor

Once the initial sync completes without errors:

1. Enable automatic scheduled syncs
2. Set up error notifications (email or Slack alerts)
3. Monitor the dashboard for sync health metrics
4. Keep an eye on API rate limits

Troubleshooting Common Issues

Products Not Syncing

• Verify SKU mapping is correct
• Check that the product is published in WooCommerce
• Ensure the Odoo product type is "Storable Product"

Order Import Failures

• Confirm the WooCommerce API user has Read/Write permissions
• Check that required Odoo fields (warehouse, pricelist) are configured

Stock Discrepancies

• Ensure only one system is the "source of truth" for inventory
• Check for pending stock moves in Odoo that haven't been validated

Best Practices

1. Always test in a staging environment before connecting production systems
2. Use webhooks for real-time order syncing instead of polling
3. Set up automated backups of both Odoo and WordPress databases
4. Document your field mappings for future reference and onboarding
5. Monitor API usage to stay within rate limits

Conclusion

Setting up an Odoo integration for WooCommerce doesn't have to be complicated. With the right connector and a methodical approach to data mapping, you can have both systems working in harmony within a day.

Ready to get started? Sign up for OdooSync and connect your Odoo and WooCommerce in minutes.