1. Documentation /
  2. Odoo for WooCommerce

Odoo for WooCommerce

Odoo for WooCommerce now brings powerful integration with your business management software. 

PHP8 Support: Odoo for WooCommerce now supports PHP 8. Currently this functionality is available as a free trial and does not require any actions to be taken. Based on customer usage and feedback we will introduce new features and functionality into tiered paid service package options. 

Do you offer a plugin demo? 

Click the button below to access a demo Odoo for WooCommerce Plugin: 

On the Demo site you will be taken to the WooCommerce plugins page with Odoo for WooCommerce plugin already installed.

Odoo Plugin Settings Page – To access the Odoo Plugin Settings Page navigate to:

WooCommerce > Settings > Integrations > Odoo Settings. 

Installation:

↑ Back to top
  1. Download the .zip file from your WooCommerce account.
  2. Go to: WordPress Admin > Plugins > Add New and Upload Plugin with the file you downloaded with Choose File.
  3. Install Now and Activate the plugin.

The following installation and configuration requires that you already have an Odoo account setup and are familiar with the which version of Odoo you are using. Integration with all versions of Odoo requires the following modules are installed and activated within your Odoo database: Sales, Invoicing, Accounting, and Inventory modules. 

If you need help with creating an Odoo account please refer to the section Creating an Odoo account located at the bottom of this documentation page. 

Quick Start Guide: Checkout our Odoo for WooCommerce video guides here. 

1. Creating an Odoo account:

↑ Back to top

1. Getting started with Odoo:

↑ Back to top

An Odoo account is required to use the Odoo for WooCommerce plugin.

If you not have an Odoo account please refer to our in-depth guide on creating an Odoo account found at the bottom of this page

For clients with an existing Odoo account, please read on to confirm your Odoo version and continue the plugin configuration. 

2. Debugging The Odoo Plugin

↑ Back to top


Introducing Odoo for WooCommerce debugging. All new debugging features and accurate results logging integrated natively into the Odoo plugin settings.

We have recently released Odoo Debug Logging with improved debugging error logging features. The Odoo for WooCommerce debugging features are available in the Odoo for WooCommerce plugin settings page, under the Logs sub-menu.

To navigate to the Odoo Logs Sub-menu navigate to the following: WooCommerce > Settings > Integrations > ODOO Integration > Logs

Important: When debugging the Odoo plugin ensure debugging is enabled prior to testing the feature you want to test. Enabling the debug logs after an incident will only log new information during the time the debugging is enabled. The logs cannot retrospectively log issues from prior to enabling this setting. 

3. What is Odoo and what are the different versions? 

Odoo is an open-source suite of business applications including sales, CRM, project management, manufacturing, inventory, and accounting in a single software solution. Odoo is available in three editions, each suited to different business needs. All versions of Odoo 13, 14, 15,16 and 17 are supported. The editions of  are as follows:

  1. Odoo Enterprise Edition: This is the full-featured, paid version. It can be self-hosted or hosted on Odoo’s own cloud platform for an additional fee. Follow Enterprise edition and use the API Key for your password. 
  2. Odoo.sh: This is a cloud platform for Odoo, providing hosting, scaling, and maintenance for your Odoo applications. It’s fully managed, meaning Odoo handles the server infrastructure for you. Follow Community edition and use the API Key for your password. Follow Community edition and use the API Key for your password found under ‘My Profile’ in older versions of Community edition.
  3. Odoo Community Edition: This is the free, open-source version with basic features. It’s typicaly self-hosted, meaning you’ll need your own server infrastructure. Follow Community edition and use the API Key for your password found under ‘My Profile’ in older versions of Community edition.

Note: Integration requires the following modules are installed and activated within your Odoo database: Sales, Invoicing, Accounting, and Inventory modules. Additionally, Odoo has recently disabled API options for demo accounts. You will need to be activate your account to connect to your WooCommerce store. 

4. Accessing the Plugin Settings in WooCommerce: 

Once you have installed the Odoo for WooCommerce Plugin on your WooCommerce site you will need to configure the plugin to connect to your Odoo server and access your Odoo database. 

Note: The plugin will trigger notifications relating to your connection status. The notifications seen in this image help get started and link directly to your Odoo for WooCommerce plugin settings page. This notification will disappear once the plugin is correctly configured.  

You can access the plugin using the below-mentioned method also illustrated in the image above: 

  1. In your WordPress admin page, navigate to WooCommerce Settings by clicking on WooCommerce
  2. Next select Settings under WooCommerce to navigate to your WooCommerce settings page. 
  3. Click on the Integration to navigate to your integration settings page. 
  4. Next, on the integration page select the ODOO Integration tab. 
  5. You are now in the Odoo for WooCommerce settings section. Within this section there is three sub-sections, Settings, Import and Export. Ensure you are in the Settings section by selecting the Settings tab.

    You are now ready to configure your Odoo for WooCommerce plugin and connect your WooCommerce website with Odoo.

Note: The notification WooCommerce has detected that some of your active plugins are incompatible with currently enabled WooCommerce features’  indicates an issue with your site settings.

This may be due to HPOS being enabled. Currently HPOS is not supported, but the next released will include HPOS support. If you have HPOS enabled, please disable this before continuing.

2. Setup and Configuration

↑ Back to top

To configure the Odoo for WooCommerce plugin you will need to connect your store to your Odoo server. You will then need to allow access to your specified database. For configuration you will require the following to be entered into the Plugin settings: 

Use the following to enter into fields in your Odoo for WooCommere Plugin General Settings page. Check and ensure you have the correct information based on your specific Odoo version/edition: 

1. Settings Prerequisites: 

  1. For Enterprise Edition:
    1. Server URL: https://xyz.odoo.com
    2. Database: Use database name as demonstrated.
    3. Username: Use the default email username for your Odoo account. 
    4. Password: Do not use your Odoo account Password, use the API key instead.
    5. API Key: This is generated from your Odoo account page. 
  2. For Community Edition/Odoo.sh:
    1. Server URL: https://yoursite.com
    2. Database: Use database name as demonstrated.
    3. Username: Use the default email username for Odoo. 
    4. Password: Do not use your Odoo account Password, use the API key instead.
    5. API Key: This is generated from your Odoo account page. 

2. General Settings Configuration: 

Once you have verified the correct details for you Odoo version you can connect the plugin to your store. We will do this in the Odoo for WooCommerce General settings page. You will see the following fields in the General Settings page: 

To connect your WooCommerce site to Odoo enter the following fields. The status indicator at the top of the page will indicate if the current state of the connection: 

  1. Select Odoo Version: Select your specific Odoo version, Odoo versions 13, 14, 15 and 16 are currently supported. 
  2. Server URL: Enter your server URL. 
  3. Database Name: Enter your Odoo Database name.
  4. Username: Enter your Odoo account username. 
  5. Password: Enter your Odoo account Password/API. 
  6. Debug Log: Toggle this setting to enable debugging mode. In debugging mode the plugin will record and see events and API requests and save them to your debug logs. The logged debug file can be found by navigating to WooCommerce > Status > Log

The status indicator found at the top of the page will provide a visual and written confirmation of your current connection status. If your WooCommerce site is not connect to Odoo the status indicator will display the following text:

  • Not connected:Please provide valid Odoo credentials to connect.’ with text highlighted in yellow. 
  • Connected: ‘Odoo account is connected.’ with text highlighted in green.

Once you have entered the the required inputs into the fields, please save and reload the page to establish the connection to your Odoo accounts. Return to the General settings page to confirm the connection status by viewing the status indicator. 

General Settings Configuration – FAQ:

  1. What happens if we need to update the Odoo Server URL? Updating the Odoo server URL can be done in the Plugin Settings. To update to a new Odoo server URL, please deactivate the Odoo plugin and reactivate the plugin to ensure new authentication data is saved and updated. 
  2. What happens if we need to update the WooCommerce URL / change from Staging site to Live Site? The WooCommerce store URL is not included in the settings. As long as the Odoo Server URL is correct, and all other Odoo settings are correct the connection will be made. If there are any issues, resave the credentials page to refresh the connection to your Odoo server. 

3. Advanced General Settings: 

Once you have connected your WooCommerce site to your Odoo server and database you will see more input fields and options on the General settings page. These fields relate to the mapping of various elements between your WooCommerce site and Odoo database. 

Odoo General settings – advanced options explained:

  1. Odoo SKU Mapping: Internal Reference | Barcode.
    • Products are mapped between WooCommerce and Odoo using a unique ID. In WooCommerce a SKU is required for every product. This settings chooses to map this to either the Internal Reference or Barcode fields in Odoo. 
  2. Select Company: Company/Database Name.
    • Use this settings to select the correct Odoo database to connect too. If you have more than one company/database they will be listed here. 
  3. Select Sale Invoice Journal: List of Invoice Journals from Odoo.
    • Use this settings to select the correct Odoo invoice journal to map WooCommerce sales. If you have one or more invoice journals they will be listed here. 
    • Note: If you create a Invoice Journal after connecting the plugin, or do not see your Invoice Journal listed, please deactivate and reactivate the plugin and reconnect your store. This will reload the Odoo invoice journals and populate the list. 
  4. Select Tax Type: List of Tax Types from Odoo. 
  5. Select Shipping Tax Type: List of Shipping Tax Types from Odoo. 
  6. Use Fiscal Positions: Toggle this to enable use of Fiscal positions. 
  7. Select Fiscal Position: List of Fiscal Positions from Odoo, disabled using the above setting toggle.
    • Fiscal positions allow the creation of rules to adapt the taxes and accounts used for a transaction automatically. This is configured in your Odoo account by your accountant. 

Note: All product in Odoo should have either an Internal Reference or Barcode. For certainty, use input values into both.  Make sure to save changes by clicking on Save Changes button at the bottom of every tab to save your settings.

3. Import Settings Configuration: 

Once you have configured the Odoo for WooCommerce plugin with your Odoo account you will be able to access the Import and Export functions. Under the Import settings tab you will be able to see the following options. 

1. Product Functions: 

  1. Import Products Frequency:Select the frequency of for importing products via Cron jobs. 
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  2. Import Products:Toggle options to enable or disable the import product function feature. 
    • Toggle Options: Enabled, Disabled. 
    • Manual Import Products: Use this option to manually trigger import the products. 
  3. Exclude PoS Products: Option to exclude or include PoS Products. 
  4. Update Products: Toggle option to enable to sync of Product details. If this option is not enabled, then product details will not be updated. 
  5. Synchronize Stocks: Toggle this option to include the Stock Sync as part of the the product updates. 
  6. Synchronize Price: Toggle this option to include the Price Sync as part of the the product updates. 
  7. Import Categories Frequency:Select the frequency of for importing categories via Cron jobs. 
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  8. Import Categories: Toggle this option to enable the category update frequency. 
  9. Import Attribute Frequency:Select the frequency of for importing attribute via Cron jobs. 
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  10. Import Attribute: Toggle this option to enable the attribute update frequency. 

Product Functions – FAQs: 

  1. Our Odoo inventory system manages stock across various warehouse locations, is there a way to configure which stock level is imported? No unfortunately this is not a feature of the plugin. The stock sync pulls data based on the internal reference / barcode and the overall stock for that item. 

2. Discount Functions: 

  1. Import Coupon Frequency: Select the frequency for importing coupons via Cron jobs. 
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  2. Import Coupon: Toggle option to enable coupons. 
  3. Update Coupon: Toggle option to enable if coupons are updated coupons. 

3. Order Functions: 

  1. Customer Frequency: Select the frequency of for importing customers via Cron jobs.
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  2. Import/Update Customers: Toggle option to enable importing / updating customers. 
  3. Order Frequency: Select the frequency of for importing orders via Cron jobs.
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  4. Import Orders: Option to enable Importing Orders. To trigger the order import please enable the toggle option, select a date range and then save the page using the button at the bottom of the page. 
    • Calendar: Use the Calendar option to select the date period for the orders which you wish to import. 
    • Toggle: Use the toggle option to enable / disable the import orders feature. 
  5. Order Refund Frequency: Select the frequency of for importing order refunds via Cron jobs.
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  6. Import Refund Orders: Toggle options to enable the feature to import orders refund options. 
  7. Odoo Customer Sync: Option to enable Importing Customers. To trigger the order import please enable the toggle option, select a date range and then save the page using the button at the bottom of the page. 
    • Calendar: Use the Calendar option to select the date period for the orders which you wish to import. 
    • Toggle: Use the toggle option to enable / disable the import customers feature. 

4. Export Settings Configuration: 

Once you have configured the Odoo for WooCommerce plugin with your Odoo account you will be able to access the Import and Export functions. Under the Export settings tab you will be able to see the following options. 

1. Product Functions: 

  1. Export Products Frequency: Select the frequency for exporting products via Cron jobs. 
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  2. Exclude Product by Categories: Select the product categories to be filtered when exporting Products by categories. 
  3. Export Products: Toggle options to enable or disable the export product function feature.
    • Toggle Options: Enabled, Disabled. 
    • Manual Export Products: Use this option to manually trigger export the products. 
  4. Update Products: Toggle this option export the product details from WooCommerce to Odoo. 
  5. Synchronize Stocks: Toggle this option export the product details from WooCommerce to Odoo. 
  6. Synchronize Price: Toggle this option include the product price export details from WooCommerce to Odoo. 
  7. Export Categories Frequency: Select the frequency of for importing customers via Cron jobs.
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  8. Export Categories: Toggle this option to enable the Categories export. 
  9. Export Attribute Frequency: Select the frequency of for exporting attributes via Cron jobs.
    • Frequency Options: Every Hour, Twice A Day, Once A Day
  10. Export Attribute: Toggle this options to enable the attribute export. 

2. Discount Functions: 

Coming Soon. Please reach out to OPMC directly for documentation regarding these features. 

3. Order Functions: 

  1. Export Order Sync: Option to enable Exporting Products. To trigger the order export please enable the toggle option, select a date range and then save the page using the button at the bottom of the page. 
    • Calendar: Use the Calendar option to select the date period for the orders which you wish to export. 
    • Toggle: Use the toggle option to enable / disable the export orders feature.
  2. Export Product Sync: Option to enable Exporting Products. To trigger the products export please enable the toggle option, select a date range and then save the page using the button at the bottom of the page. 
    • Calendar: Use the Calendar option to select the date period for the products which you wish to export. 
    • Toggle: Use the toggle option to enable / disable the export products feature. 
  3. Export Customer Sync: Option to enable Exporting Customers. To trigger the order import please enable the toggle option, select a date range and then save the page using the button at the bottom of the page. 
    • Calendar: Use the Calendar option to select the date period for the customers which you wish to export. 
    • Toggle: Use the toggle option to enable / disable the export customers feature. 

5. Work with Product Categories

↑ Back to top

Product categories can be imported, exported and synced with the Odoo for WooCommerce Plugin. 

  1. Importing/Exporting Product Categories.

    The process for enabling import and exporting of Product Categories is the same. There is an option to enable each on the Import Settings Page and the Export Settings page. To Import/Export Product Categories use the option found on the settings page. Enable the toggle setting which is either Import Import Categories for importing from Odoo to WooCommerce or Export Categories for exporting from WooCommerce to Odoo. 

    The image above shows the Export Categories option found on the Export Settings Page. 

  2. Filtering Imports / Exports using Product Categories.


    Filtering product Imports/Exports and Sync is can now be done with the Odoo plugin. This allows you to work with products on both systems which are not included in the imports / exports or automatic syncs. To use the filtering by Product Category feature access and select the required categories in the multi-line select input field on the Import Settings Page and Export Settings Page. Make sure you select the categories and then save the settings page. If the category is not highlighted once the page is refreshed then the settings have not saved. Please reselect and save the settings page

    Multiple categories can be selected by using the Shift or Select key on your keyboard and selecting the categories. 

6. Accessing the Plugin Settings – In-depth Guide for each Odoo Version. 

Enterprise Edition

↑ Back to top
  1. Click on the following link to go to the Official Odoo Website and to sign up and activate your free trial. You will need to update to a paid Odoo account to connect the plugin to your WooCommerce store. 
  2. Select the following Odoo Modules to integrate with your WooCommerce store: Sales, Invoicing, Accounting, and Inventory are essential apps and required for the plugin to work. Click Continue.

  1. Fill up your credentials and click Start Now.

  2. Respond to the confirmation email, set password and click Activate Your Database for account activation.

Community Edition

↑ Back to top

This is the free, open-source version with basic features. It’s typicaly self-hosted, meaning you’ll need your own server infrastructure. Download Community edition from here and for installation process click here

Server URL

↑ Back to top

For Enterprise Edition

  1. For Server URL sign in to odoo account select the name of your company displaying at the top right corner and click on My Databases.

  2. Select Connect in front of the Database you want to connect with your website.

  3. Copy the URL of the page, for example, https://xyz. odoo.com

  4. Paste it in Server URL tab.

For Community Edition

Copy and paste your default URL for the selected database of odd into Server URL.

For Example, In the below-mentioned case, it would be http:// testsite. com

Note: Do not add a forward slash at the end of your URL “/”

Database Name

↑ Back to top

Enterprise Edition

Goto: Odoo website > My Databases page.

Community Edition

Click on Manage Databases from the main login window.

Copy database name you want to connect.

Now, insert database name in Database Name tab associated with Server URL.

Username

↑ Back to top

Enterprise Edition

You can find the username here.

Community Edition

For Community Edition, the default email will be your username.

Now, Copy and paste the username associated with your odoo account.

Password / API Key

↑ Back to top

Password

Insert password of your Odoo account 

API Key Access

For API Access goto Settings > General settings

Scroll at the bottom of the tab and click on Activate the developer mode.

On the top-right corner click on your Profile name and select preferences ( or My Profile in older version of Community edition ) from the dropdown menu.

Select Account Security and click on NEW API KEY

Enter your default password if asked.

If asked enter the purpose of the API key. Could be anything and then click GENERATE KEY button.

Copy API Key and save it to a secure place for future use.

 

Now, paste API key in Password/API key tab

Debug Log

↑ Back to top

Debug log allows you to record and see events and API requests. Useful for developers while debugging any event. 

Logged file can be found at WooCommerce > Status > Log

WooCommerce SKU to Barcode Mapping (Internal Reference) 

Odoo SKU Mapping tab is used to export SKU as an odoo’s internal reference or barcode, or import barcode or internal reference as an SKU. Select the one that is preferable for your odoo CRM. 

Note: All product in Odoo should have either an Internal Reference or Barcode. For certainty, use input values into both.  Make sure to save changes by clicking on Save Changes button at the bottom of every tab to save your settings.

Enable Inventory Sync

↑ Back to top

To Enable Inventory Sync you will need to configure the settings on the Import section of the settings page. Your wooCommerce product inventory is synched into your odoo inventory app according to the frequency set with Cron Frequency.

Note: The inventory sync is manages through the Import and Export settings page of the Odoo plugin. You can enable the Cron job which will automatically trigger the inventory import, or use the manual import products button to trigger a manual import. 

7. Other Account Settings

↑ Back to top

These accounts may load based on your settings in odoo after successful integration based on your settings in odoo and country settings. Choose the default option for your wooCommerce store that best describe your accounts, debtor accounts, tax types and so on. 

Note: If these don’t load, the plugin has already selected the default settings from your odoo CRM based on your country.  

1. Select GST/ Tax / Shipping Tax Type

↑ Back to top

These tabs appear based on the country or state you are dealing in, taxes are imported from your odoo account and you can select the one from the dropdown menu according to your need. And click Save changes.

2. Select Account Type

↑ Back to top

Select an account type for your customers buying at your WooCommerce store according to your suitability for your odoo account.

3. Select Debtors Account

↑ Back to top

Select debtors account for your odoo account based on the intent of your customers and products or services you are providing. 

8. Import Settings

↑ Back to top

9. Export Settings

↑ Back to top

Note: To trigger the manual export of products to Odoo enable the setting ‘Export Products’ and when you click ‘Save’ the page will reload and trigger the export. 

10. FAQs

↑ Back to top

How do I import or update products from Odoo automatically?

↑ Back to top

There is an import setting that should be enabled to import products automatically. 

This is accessed here:

WooCommerce → Settings →Integration → odoo Integration →  Import tab

Enable following:

  • Import products
  • Update products
  • Synchronise stocks
  • Synchronise price
  • Import categories
  • Import Attributes

Also, set the frequency to initiate the cron job. 

To trigger the import manually, use the ‘Manual Import Products’ button found under the import tab. 

How do I export or update  products from Odoo automatically?

Export settings should be enabled to export products automatically. 

This is accessed here:

WooCommerce → Settings →Integration → odoo Integration →  Export tab

Enable following:

  • Export products
  • Update products
  • Synchronise stocks
  • Synchronise price
  • Export categories
  • Exportt Attributes

Also, set the frequency to initiate the cron job. 

To trigger the manual export of products to Odoo enable the setting ‘Export Products’ and when you click ‘Save’ the page will reload and trigger the export. 

How to enable Variable Product Support in Odoo?

You can enable Product Variants under the Odoo Inventory Settings:
Odoo Settings > Inventory > Products > Variants

Error code 404 issues showing up or redirecting you to another page?

↑ Back to top

This usually occurs when another plugin is interfering with the plugin operations. To solve this, simply disable all plugins temporarily and continue by activating plugins one-by-one. 

If this error is still occurring, please reach out to our support team by raising a WooCommerce ticket here- https://woo.com/my-account/create-a-ticket/ and mention you have disabled other plugins, so, we can take the next steps necessary. 

Having configuration issues? 

The most common mistake is initially setting up the plugin. It is very easy to get the API keys wrong, so please ensure these steps are done accurately via the document below.

How this plugin sync orders?

↑ Back to top

Orders are synced directly to the Odoo account when customers have processed them. When an order is placed in your WooCommerce store, the invoice is generated automatically in Odoo.

For cron job, make sure you have enabled Order Functions from export, and/or import tabs as per your preference and save changes. There are certain settings based on your odoo CRM settings for orders in the odoo integration settings such as Select Account Type, Select Debtors Account and Select Tax Type explained above

Do you offer a plugin demo? 

Click the button below to access a demo Odoo for WooCommerce Plugin: 

  1. On the Demo site you will be taken to the WooCommerce plugins page with Odoo for WooCommerce plugin already installed.
  2. Access the Odoo for WooCommerce Plugin Demo Site and test the following main workflows to get started with the Plugin:
    1. Odoo Plugin Settings Page – To access the Odoo Plugin Settings Page navigate to:

      WooCommerce > Settings > Integrations > Odoo Settings. 

      Please note some settings will be hidden until you configure your Odoo Account under the Connection Settings.
    2. Odoo on Order Pages – To access the Odoo Plugin Sync features create an order and navigate to the Order page. On the right hand side you will see additional features under the order actions drop down relating to syncing your Orders with Odoo: 

      WooCommerce > Orders > 
      Resync order to Odoo (Meta Box Dropdown: Order Actions )
    3. Sync Odoo Products using the Plugin – Clicking the Sync Product button will sync/import products between Odoo and your Store. This can be found under the Odoo settings page:  
      WooCommerce
        > Settings > IntegrationsOdoo Integrations.

Sync Process taking too long?

↑ Back to top

Syncing your WooCommerce store to your Odoo Database is easily done with the plugin installed.

If you are having issues with the sync process, or experiencing long sync (import / export times) please try these steps to diagnose the root cause.

1. First, check your CRON jobs and ensure this is configured correctly. Check with your hosting provider if this is configured to use WP Cron or Server Level Cron Jobs. Server level is preferred. Have your hosting provider also provide a log of the Cron Jobs so you can accurately track these during debugging.

2. Next, check your import / export process and confirm what the issues are on the admin section of your WooCommerce store. When importing / exporting products you will be notified of the correct progress using the Odoo Progress Notification Box. This number will update with the progress in real-time, however, you can refresh your page if there are any issues viewing the updated count.

Please test a sample product set and document the time taken. Try changing your server limits/settings and confirm if this improves performance.

3. Try benchmarking this with another server. Install the Odoo for WooCommerce plugin on another server and repeat the import process, if you find the import times vary greatly then this might indicate a conflict causing the sync process to slow.

You can easily use the demo link below to quickly create and test this against a new WooCommerce instance. This will come configured with the Odoo for WooCommerce plugin installed already.

4. Next check the bug logs on the Odoo Plugins Settings page, under the logs section. For more information about Odoo Plugin, please view our Debugging tutorial video here. Also read the documentation on Debugging the Odoo Plugin above.

Please look for unusual errors or debug messages that may display when testing the sync process.

Finally, if the above steps do not resolve the issues, please raise a support ticket via the WooCommerce Official Support Channel. We will request that you share the outcome of the testing steps above so please include this with the ticket, specifically:

(1) Which steps have been completed? Checking CRON, Timing the Import, Benchmarking Process, and Debugging.
(2) Your Odoo Account / DB Details.
(3) Sample Product List (Names, SKUS, Images)
(4) Debug Logs.

Sync Process – Help I am having issues with Importing Products?

↑ Back to top

Importing Products from Odoo to your WooCommerce store should be easy. Sometimes, unexpected things come up. If you are having issues with the import process, not able to import all products, or just some products and details, read this section.

First the principles around importing.

  • The import is considered to be sync products from your Odoo Database to WooCommerce.
  • These products will be imported including Product Name, Product Description, Product Images, Product Price, Product Stock, Attribute, and Category.
  • Note, that some of these are required and others can be toggled from the Import settings menu.
  • All products in Odoo should have either an Internal Reference or a Barcode. For certainty, use input values into both.  Make sure to save changes by clicking on the Save Changes button at the bottom of every tab to save your settings.

Once you set the Import Products toggle to Enabled and save the settings the import will occur based on the selected frequency selected on the same page. At this stage, you can wait for the next Cron job to trigger at the frequency, or choose to manually import the products.

Testing the Import: Getting your first Import Complete

The import should now have started or be completed. If not, go back and save the page, then trigger the import using the manual import button.

Once the import has started, the Import Notification Bar will present itself at the top of the settings page and other WordPress admin pages.

Common Issues:

  1. Not all products are showing / Some products are missing: If you have more products than the amount showing in the notification bar this may mean some products do not have the required Internal Ref/Barcode, or you are filtering by categories.
  2. I have a set of products in Odoo. I only want to import a sub-set to WooCommerce: Using categories you can import one, a few, or many products from Odoo. In the categories section a selectable box will allow you to filter the categories imported. You can use this to select and filter the categories imported.

    Since Odoo allows one product to multiple categories, you can also create a new WooCommerce Online Products category and only import the products you want on your online store.
  3. The import process is taking too long: Please see the above section about how to debug this issue.
  4. Variable Products not importing: Some products or product variations may not import as expected. The common cause and solution is to ensure each product and variation has a unique and valid SKU (Internal Code, Barcode) assigned in Odoo.
  5. Products are being duplicated: If you believe the import and/or export process is duplicating products, first check that all products have the defined SKU and matching Internal Reference / Barcode number. This should match and assign products correctly, if you still experience this issue please complete the Odoo debugging steps believe.

Once your product import has completed you should be able to view the products in the WooCommerce products section.

Once the first product import is complete you should be all set up to keep your products updated.

Automated Imports: Keeping your products updated

Based on the Frequency setting in the import settings page, a Cron Job will be used to trigger the import function at the appropriate time.

 If the import process does not successfully run this may be due to an issue with the Cron scheduling. Please check with your hosting provider, request the Cron Job logs and confirm if this is configured and actioning the jobs as expected. Feel free to reach out to OPMC via WooCommerce Support for assistance with this.

Debugging the Odoo Import Process: Odoo import is not working.

At any point, if this Odoo Import process is not working, or you are unsure if it is working, you can use the following steps to test this:

  1. First, enable Debugging under the Odoo Settings page.
  2. Next, filter the category of products to import so you can test one category. Save the page. Use the manual import button to trigger the import.
  3. Finally, wait until the import is completed. If this is not completed after some time, note this and share it with the OPMC support team. Additionally, head to the Debug Logs section, and review the logs. Make sure to select the appropriate date and view the latest logs.
  4. Finally reviewing the logs should provide an indication of the process run and any potential issues. The most common errors and solutions are provided in the Q&A section below. If you require help reach out to OPMC Support.

Sync Process – Help I am having issues with Exporting Products.

↑ Back to top

Read this section if you are having issues with exporting products to Odoo. This includes not able to export all products, issues with exporting some products and details, and issues with product data or fields missing or being exported wrongly.

First the principles around exporting products using the Odoo for WooCommerce Plugin.

  • The Export is considered to sync products from your WooCommerce Database to your Odoo Database
  • These products will be Exported including Product Name, Product Description, Product Images, Product Price, Product Stock, Attribute, and Category.
  • Note, some of these are required and others can be toggled from the Import settings menu.
  • All products in WooCommerce are required to have a unique SKU. This includes all variations for variable products. This unique SKU will map to the Internal Reference or Barcode fields in Odoo.
  • Product images will be exported. Not Odoo versions below 16.6 do not support WebP images. Therefore you will need to convert these to a supported format. For new Odoo versions, WebP images are supported.
  • Variable Products and Exporting Product Variations are supported. All product variations are required to have a valid and unique SKU. Additionally, you need to enable the Variable Product support in your Odoo settings page before exporting products.
  • Products are being duplicated: If you believe the import and/or export process is duplicating products, first check that all products have the defined SKU and matching Internal Reference / Barcode number. This should match and assign products correctly, if you still experience this issue please complete the Odoo debugging steps believe.

Testing the Export: Getting your first Export Complete

Once you set the Export Products toggle to Enabled and save the settings the Export will occur based on the selected frequency selected on the same page. At this stage, you can wait for the next Cron job to trigger at the frequency, or choose to manually export the products.

The export should now have started or be completed. If not, go back and save the page, then trigger the export using the manual export button.

Once the export has started, the export notification bar will present itself at the top of the settings page and other WordPress admin pages.

Common Issues:

  1. Not all products are exporting / some products are missing: Please ensure all products have SKUs, all variations have SKUs, and category filtering is not applied.
  2. Can I filter the products exported to Odoo: Using categories you can export one, a few, or many products from Odoo.
  3. The Export process is taking too long: Please see the above section about how to debug this issue.
  4. Variable Products not exporting: Some products or product variations may not export as expected. The common cause and solution is to ensure each product and variation has a unique and valid SKU (Internal Code, Barcode) assigned in Odoo.
  5. Some Product images are not exporting: Note Odoo versions below 16.6 do not support WebP images. Therefore you will need to convert these to a supported format. For new Odoo versions, WebP images are supported. Please check this if images are not exporting/exported correctly.
  6. Products are all exporting with incorrect prices / Products are all exporting with a price of $1:
    The common cause of pricing mismatch or pricing not exporting correctly is due to not having both Odoo and WooCommerce set to the same currency. Please check your currency setting and ensure both are set to the same currency.

Once your product export has completed you should be able to view the products in the Odoo products section. Head to your product pricelist section to review your pricelist in Odoo to view all products and variations.

Once the first product export is complete you should be all set up to keep your products updated. This will trigger based on the selected frequency.

QuestionsAnswer
Q: Can the Odoo Plugin support Product Bundles from WooCommerce when syncing with OdooNo – at this stage this is not a feature supported by the plugin.
Q: Can the Odoo Plugin Sync Variable Products from WooCommerce to Odoo? Version 3.6+: Yes, Odoo Version 3.6.0 and above now fully supports Variable Product Sync.

Version below 3.6:
Yes – The plugin will sync variable products from WooCommerce to Odoo. Within Odoo these will be each variation of the product will be a separate product in the Odoo Database.
Q: Can the Odoo Plugin Sync Variable Products from Odoo to WooCommerce? Yes, Odoo Version 3.6.0 and above now fully supports Variable Product Sync.

Older versions of Odoo (< v3.6.0) will not sync variable products correctly. The plugin will not sync variable products from Odoo to WooCommerce. As Variable products is not enabled by default this is not supported by the plugin.
Q: Does the OPMC WooCommerce connector add any code to the Odoo system, or is it hosted exclusively on WooCommerce?A: The OPMC WooCommerce connector is designed to operate exclusively on your WooCommerce server. It does not add any code to the Odoo system. The connector works by utilizing the provided APIs of Odoo and managing all interactions and processes from the WooCommerce side. This design ensures that all plugin-related activities and data exchanges occur within your WooCommerce environment, without the need to modify or add code to the Odoo system itself.
Q: Will the OPMC WooCommerce connector be updated to support Odoo version 17, and what is the current status of this compatibility?
A: As of now,(Version 3.7.0) the OPMC WooCommerce connector is only tested and compatible up to Odoo version 16.

We are actively working to ensure compatibility with Odoo version 17.

Our team is dedicated to understanding the changes in Odoo’s APIs and making necessary adjustments to our plugin. We will provide updates as soon as we confirm compatibility with Odoo version 17.
Q1: What should I do if I receive an error during the Order Export process in Odoo?
A1: When you encounter an error during the Order Export process, the first step is to check the error log for details. In many cases, such as the one reported, the issue may be related to an invalid SKU (Stock Keeping Unit) for a product or its variants. Ensure that all products and their variations have valid SKU numbers, as these are critical for item syncing.
Q: How important is it to have SKU numbers for products in Odoo?
A: SKU numbers are essential in Odoo as they serve as unique identifiers for syncing items between different systems or modules. Without a valid SKU, products or their variants may not be exported correctly, leading to errors in processes like Order Export.
Q: What does the following error mean and how do I solve this?

Error: “Object sale.order doesn’t exist
A: The error indicates that the Odoo database does not have the Sales module issue installed or configured correctly. Start by confirming if you have Odoo Sales modules enabled and have enabled variable products under the Odoo settings page.

If you need any further assistance, please reach out to support.