Odoo for WooCommerce

How to enable Variable Product Support in Odoo?

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

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://woocommerce.com/my-account/create-a-ticket/ and mention you have disabled other plugins, so, we can take the next steps necessary. 

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. 

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.

Importing Products from Odoo to your WooCommerce store should be easy. Occasionally, 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.

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.

Read this section if you are having issues with exporting products to Odoo. This includes not being 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.

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 exported / 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.