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 Price: $499 (one-time) License: Up to 3 domain activations

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)
  • An active ECOSIRE license for this module
  • 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
  6. Enter your ECOSIRE license key when prompted

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