Skip to main content

WooCommerce Store Management

The ECOSIRE WooCommerce Store Management module delivers a robust integration between your WooCommerce-powered WordPress store and Odoo ERP using the WooCommerce REST API v3. Sync variable and grouped products, manage subscriptions, and handle multi-store environments with advanced attribute mapping. Webhook-driven updates ensure near-instant data flow between your online store and Odoo, keeping inventory, orders, and customer records in perfect alignment.

Compatibility: Odoo 17/18/19 Current shipped version: 17.0.2.3.1 · 18.0.2.3.1 · 19.0.2.3.1 Price: $499 (one-time) License: OPL-1 -- installs and runs on its own, with nothing to switch on afterward

2.3.1 (19.0.2.3.1) — company boundaries

In a multi-company database the WooCommerce dashboard and sync endpoints now work only with the connections of the companies you are working in, and starting a sync is reserved for WooCommerce Managers. The same release imports orders whose product is new to Odoo instead of losing them, exports coupons once and updates them in place, shows the dashboard in your company currency, and adds GPSR, EU OSS / US tax and HPOS compatibility screens. See the full module page for every change.

Key Features​

  • REST API v3 integration
  • Variable and grouped product support
  • Subscription support
  • Multi-store management
  • Advanced attribute mapping
  • Coupon sync
  • Tax class mapping
  • Shipping method sync
  • Customer group sync
  • Webhook-driven updates

Prerequisites​

  • Odoo 17, 18, or 19 (Community or Enterprise edition)
  • A WooCommerce store running WooCommerce 7.0 or later with REST API v3 enabled

Installation​

  1. Download the module ZIP from your ECOSIRE Dashboard
  2. Extract to your Odoo addons directory: 
    unzip ecosire-woocommerce-*.zip -d /opt/odoo/addons/
  3. Restart the Odoo service: 
    sudo systemctl restart odoo
  4. Navigate to Apps, click Update Apps List
  5. Search for "ECOSIRE WooCommerce Store Management" and click Install

Configuration​

Step 1: Obtain WooCommerce API Credentials​

  1. Log in to your WordPress admin dashboard
  2. Navigate to WooCommerce then Settings then Advanced then REST API
  3. Click Add key
  4. Enter a description (e.g., "ECOSIRE Odoo Integration")
  5. Select the user account for API access
  6. Set permissions to Read/Write
  7. Click Generate API key
  8. Copy the Consumer key and Consumer secret (shown only once)
  9. Ensure your site uses HTTPS (required for REST API authentication)
  10. If using webhooks, verify that your WordPress cron is running or configure a real system cron

Step 2: Connect in Odoo​

  1. Navigate to WooCommerce Store Management then Configuration
  2. Enter your WooCommerce store URL, Consumer key, and Consumer secret
  3. Click Test Connection to verify
  4. Configure your default warehouse and company mapping

Step 3: Configure Sync Settings​

Product Sync​

  • Choose sync direction: WooCommerce to Odoo, Odoo to WooCommerce, or bidirectional
  • Set sync interval: Real-time (webhook) or scheduled (5/15/60 minutes)
  • Configure product field mapping and category mapping
  • Map WooCommerce attributes to Odoo product attributes

Inventory Sync​

  • Map Odoo warehouses to WooCommerce stock locations
  • Set buffer stock quantities if needed
  • Enable real-time stock updates

Order Sync​

  • Enable automatic order import
  • Map WooCommerce payment gateways to Odoo payment journals
  • Configure fulfillment sync to push tracking numbers
  • Sync WooCommerce coupons and discount rules

Initial Sync​

  1. Go to WooCommerce Store Management then Operations then Initial Import
  2. Select data types to import (Products, Customers, Orders)
  3. Set date range for historical orders
  4. Click Start Import and monitor progress in the sync log

Dashboard​

The OWL 2 dashboard provides:

  • 6 KPI cards showing real-time sales, orders, and sync metrics
  • Interactive Chart.js sales analytics with date filtering
  • Top products ranking by revenue
  • Live activity feed of recent sync operations
  • Quick action buttons for common tasks

Troubleshooting​

IssueSolution
Connection failedVerify API credentials and check network connectivity
Sync not runningCheck Odoo scheduled actions (cron jobs) are enabled
Duplicate productsReview product mapping settings and matching rules
Orders not importingVerify order status filters and date range settings

Support​

Last updated on