Odoo Akeneo Connector module allows you to integrate your Odoo store with Akeneo PIM platform. With the help of this integration, you can manage your entire categories, products, product models, attributes, attribute options from Akeneo platform.
Please Note – Odoo Akeneo Connector is compatible with Community Edition, Enterprise Edition, and Cloud (PaaS/Flexibility) Edition of Akeneo.
- Export categories from Akeneo
- Create attributes from Akeneo
- Create attribute options from Akeneo to Odoo
- Send multiple product images
- Works with product variations
- Map Akeneo categories to Odoo categories
- Odoo product field mapping
- Add new mapping field
- Set default value for product field mapping
- Multiple export job profiles available – all, categories, attributes, attribute options, product models, products
- Filter exported products based on category, family, time conditions, status, completeness, language, currency, etc
- Export specific products using identifier (SKU)
- Update exported products for any new changes
- You can export Association(Alternative and Related) product
- More standard attributes can be mapped
- You can use two(Internal reference and Barcode) types of an identifier to export.
- Export categories to the eCommerce categories from Akeneo to Odoo
- Multiple import job profiles available – all, categories, attributes, attribute options, product models, products
- You can export the product with quick export
- While exporting product you can select the Odoo version
- You can export all category or you can filter and export the category attached to the configured channel.
- Export Variation based on select types, yes or no, and metric type.
- View mapped entries log in Akeneo
- Also compatible with the latest version of Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x and 3.2.x
Before installing this module, please see the requirements below:
This module works with Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x and 3.2.x you can download Akeneo from here
Following Odoo apps must be installed – Purchase Management, eCommerce, and Website Builder.
Check out the following video tutorials below:
Setup Credential in Odoo Akeneo Connector
How to Create and Export product from Akeneo to Odoo
For installing this module in Akeneo, please follow the below steps:
1 – Unzip the respective extension zip. Then merge “src” folder into akeneo project root directory.
2 – Goto app/AppKernel.php then add the line.
<span style="color: #ff0000;">new Webkul\OdooConnectorBundle\OdooConnectorBundle(),</span>
in function registerProjectBundles() 3 – Goto app/config/routing.yml then add these lines at top of the file.
<span style="color: #ff0000;">odoo_connector: </span><span style="color: #ff0000;">resource: "@OdooConnectorBundle/Resources/config/routing.yml"</span>
<span style="color: #ff0000;"> prefix: /</span>
4 – You have to navigate first to Akeneo installation directory (Ex: cd /opt/bitnami/apps/akeneo/htdocs). After SSH, you have to run the command to your Akeneo server by the terminal.
<span style="color: #ff0000;">rm -rf ./var/cache/** && php bin/console pim:install:asset --env=prod && php bin/console assets:install web --symlink && yarn run webpack && php bin/console d:s:u --force && php bin/console odoo:batch:quick_export</span>
5 – You have to restart your web server like Apache, Nginx. Run the command for Apache web server.
sudo service apache2 restart
6. If you are using php-fpm. Then you need to restart the php-fpm services.
sudo service php-fpm7.2 restart
Common Issues After Installation
It might happen that even after proper installation, upon opening your Akeneo admin dashboard, you see a loading screen. In that case, do check for the following solution:
Webpack Installation: If you get the below error It means that webpack is not installed in your system. Run the following command
npm install --save-prod webpack
Module routing.yml is not configured properly. Re-check the routing.yml file as mentioned in the 3rd step of Module Installation
Clear your browser cache.
Setup Odoo Credentials
After that login to your Akeneo panel then go to Odoo Connector>Server Credentials. The following page will appear, here you need to enter your Odoo server information:
- Database Name
- Login Username
- Login Password
After saving your Odoo credentials, please go to the Default Configuration tab. Here you need to define exported products locale, currency, and product identifier.
- Default Locale – Select a locale according to your Odoo store. Such as English (United States), Spanish (Brazil).
- Default Currency – Select the default currency of your Odoo store. Such as – US Dollar, Euro, British Pound.
- Default Attribute-Group – Select attribute to import product information from Odoo to Akeneo.
- Default Product Identifier – Select how exported products will be identified in Odoo store. There are two options available here:
- Internal Reference (default_code)
- Barcode (barcode)
- Odoo Version – You can select the Odoo version like 11, 12, 13.
- Category Export as eCommerce categories – Enable this to export categories to eCommerce category.
Product Field Mapping
When products are exported to Odoo, you can decide which all product information should be included in the product database. But first, you need to do the mapping of Odoo product fields with Akeneo attributes.
Default Value – In case you want to set any fixed value for a product field, you can enter it in Default Value. So that all the exported products will have this same product field value.
By default, the following product fields can be mapped between Akeneo and Odoo:
- Internal Reference
- Description for Internal
- Description for Quotations (description_sale)
- Description for Vendors (description_purchase)
- Description for Pickings (description_picking)
- Description of Delivery Orders
- Description for Receptions
- Sale Price (list_price)
- Cost (standard_price)
- Product Type
- Can be Sales
- Can be Purchased
Map More Standard Fields
In case you want to send more product information, then you can add more product fields here and map them with Akeneo attributes.
First, you need to enter an Odoo field code and click Add Field button, after that the new mapping field will appear above.
In this you can map association products like Alternative produts and Related products then export the association products from Akeneo to Odoo.
Map Attribute and Category
To avoid duplicacy of the data at the Odoo end on the first export mapping of category, attributes, attribute option, product, product model and eCommerce category get created.
In Odoo Connector Configuration, navigate to Product Field Mapping>Map Attribute/Category.
Mapped Attributes and Categories
Here, you can create mapping manually for category and attribue .
Then you can also filter, search, or delete the mapped categories and attributes.
Create Category Mapping
To create a new mapping for a category, click Create Mapping. The following pop-up window will appear, select Mapping Type as Category.
Create Attribute Mapping
To create a new mapping for an attribute, click Create Mapping and select Mapping Type as Attribute.
After that, select Akeneo Attribute and Odoo Attribute. Only one attribute can be mapped at a time.
In this module you will find the following types of export jobs for exporting catalog information to Odoo:
All Export –
- Odoo Export All
Attribute Export –
- Odoo Export Attribute
- Odoo Export Attribute Option
Category Export –
- Odoo Export Category
Product Export –
- Odoo Export Product
- Odoo Export Product Model
Association Export –
- Odoo Product and Product Model Association Export
1 – Create a product in Akeneo
Create a simple product (having no variations like- size, color) in Akeneo such as a t-shirt, go to Products>Create after that select Product option.
Please note – only the mapped attributes information will be sent to the Odoo store.
Upload multiple images, mention weight, customer lead time, routes, POS information, and much more.
Please make sure all the attributes are correctly mapped between Akeneo and Odoo.
Then, select a category from the left panel then click Save.
2. Odoo Product Export
Once you have created the products in Akeneo, we’ll now export them to Odoo store. Go to Exports>Create Export Profile, enter a unique code, and label.
Select Odoo Connector>Export Product then click Save.
Select a channel and locales for exporting products. Then you can even send content for multiple language translations.
You can decide which all products you want to export to Odoo. There are various filters available such as – family, status, completeness, time condition, category.
If you want to export only some specific products, you can enter their SKU in the Identifier section separated by a comma.
Once you have saved the information for the export profile, click Export Now button.
In the execution process, you can check the progress of the export job and view any errors.
As you can see the product created in Akeneo named ‘Red T-shirt’ has been exported to Odoo. Then you can also view and edit any information as you require and publish the product.
Check out the Odoo e-commerce storefront view. A customer can see the product name, images, price, buy now details etc.
Export Product Model
For exporting products that have variations, you need run Odoo Product Model Export job.
1. Creating Product with Variations
If you want to create a product in Akeneo having multiple variations such as- size, color. Then, go to Products>Create>Choose Product Model. Now, enter any unique code, select a family, and select on what basis variations will be created. In the following example, I have created a jacket product with two variations according to size – small and medium. Fill in all the product information required according to Odoo e-commerce store such as name, price, cost price, weight, product type, routes, POS details, customer lead time, etc.
Once you have entered all the product information that is common to all the variation products, now you need to create a variation product.
After that, click down-arrow icon near size, a small pop-up window will appear. Add variant product information, select a size then enter SKU. Follow the above step again for creating more variation products.Now you need to enter variant product information such as weight, barcode, etc.
Please note – the information which is common to all the variations must be entered in the ‘Common’ product only. There is no need to add same information again in variation products. After saving all the information, then you need to select a category for the product. You can select multiple categories also.
2. Exporting Product Variations
Now after you have created all the product models with their variations, it’s time to move on to export process. Go to Exports>Create Export Profile.
Enter any unique code, and label. Select Webkul Odoo Connector>Export Product Model and click Save.
Select channel and locales for exporting products.
In case you want to send only specific products to Odoo store, you can use various filters based on category, status, completeness, time condition, etc.
Then you can also enter SKUs in Identifier for sending some specific product(s).
After saving your export profile, click Export Now button to begin execution process.
The execution tracker will show you the process of the export job, in case there is an error it’ll appear here.
Once the export product model job finishes, you need to run export product job so that variations are correctly linked to the main product.
After running both the export jobs, the exported product can be seen in Odoo store including its variants.
If you want to make any changes to the product or its variations, you can simply click Edit then do it.
Check out the store front end and see how the product with variations appear.
The Import Job feature has been added to Odoo Akeneo Connector. Now you can directly import products, categories, attributes attribute optionand family variants from Odoo.
While importing new products, you need to select Attribut – Group in setup credential.
On the Product Field mapping has been done, go to Imports>Create Import Profile.
Import All –
Odoo Import All -You can import everything from Odoo like products, categories, attributes, and family.
Family Import Based on Variation – This will import family of Odoo into Akeneo and all the family variant into that family.
Odoo Import Product and Product Model – This will import all the simple and configurable products of Odoo.
Odoo Import Category – This will import all the Odoo categories to Akeneo.
Odoo Variant Import Attribute and Attribute Options – This will import all the attributes and atrribute options from Odoo to Akeneo.
Now, go to Content and select the appropriate channel, locale and currency for importing Odoo products to Akeneo.
After that, click the Import Now button to execute the import process.
Current Product Version - 1.2.6
Supported Framework Version - Odoo 10.x,11.x,12.x, 13.x|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x and 3.2.x