Menu Close

    Odoo Akeneo Connector

    Introduction

    Odoo Akeneo Connector module allows you to integrate your Odoo store with the Akeneo PIM platform. With the help of this integration, you can manage your entire categories, products, product models, attributes, attribute options from the Akeneo platform.

    Please Note

    • Odoo Akeneo Connector is compatible with Community Edition, Enterprise Edition, and Cloud (PaaS/Flexibility) Edition of Akeneo.
    • We only support the Akeneo select type (Simple and Multi-select), Metric, and Boolean type of attributes from Akeneo to Odoo in export.

    Features

    • 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 attribute mapping
    • Add new mapping field
    • Set default value for attribute 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
    • Admin can create Manual Mapping Of Odoo Fields With Akeneo Fields To prevent Duplicacy(In case of already data present at od
    • Export specific products using an 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 then 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, 3.2.x, 4.0.x, 5.0.x and 6.0.x

    Basic Requirements

    Before installing Odoo Akeneo Connector module, please see the requirements below:

    Odoo Akeneo Connector module works with Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x, 5.0.x and 6.0.x you can download Akeneo from here

    Following Odoo apps must be installed – Purchase Management, eCommerce, and Website Builder.

    Searching for an experienced
    Akeneo Company ?
    Read More

    Odoo Apps

    Video Tutorials

    Check out the following video tutorials below:

    Setup Credential in Odoo Akeneo Connector

    koCbBUnyvIw

    How to Create and Export product from Akeneo to Odoo

    Iozx-ZFu5FQ

    Installation

    Two different types of module installation processes are available for the module.

    1. Composer Installation
    2. Manual Installation

    Installation using Composer Installation

    Read This Blog

    Before beginning the composer installation

    1: Get the ACCESS KEYS [Create a support ticket]
    2: In Akeneo composer.json, add our repository as well as the installation script.

    For Akeneo 6.x 

    "scripts": {
            "post-update-cmd": [
               "vendor/webkul/odooconnector/src/Webkul/OdooConnectorBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
            ],
            "post-install-cmd": [
               "vendor/webkul/odooconnector/src/Webkul/OdooConnectorBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
            ],
            "post-create-project-cmd": [
              "vendor/webkul/odooconnector/src/Webkul/OdooConnectorBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
           ]
       },
      "repositories": [{
        "type": "composer",
        "url": "https://akeneorepo.webkul.com/"
      }]
    }
    

    For Akeneo <=5.x 

    {
      "scripts": {
            "post-update-cmd": [
               
    "vendor/webkul/odooconnector/composer_install.sh"
            ],
            "post-install-cmd": [
               
    "vendor/webkul/odooconnector/composer_install.sh"
            ],
            "post-create-project-cmd": [
             
    "vendor/webkul/odooconnector/composer_install.sh"
           ]
       },
      "repositories": [{
        "type": "composer",
        "url": "https://akeneorepo.webkul.com/"
      }]
    }
    

    3: Use composer to install the extension.

    composer require webkul/odooconnector
    

    4: Complete the authentication form.

    5: Send a Message of Success

    6: Delete your browser’s cache.

    Manual Installation for Version 6.x

    • After unzipping the appropriate extension zip, merge the “src” folder into the akeneo project.
    • From the PIM directory, run the following command over the NO-DOCKER Instance.
    ./src/Webkul/OdooConnectorBundle/install/config.sh COMPOSER=false NO_DOCKER=true
    
    •  Run the command below over the PIM directory’s DOCKER instance.
    ./src/Webkul/OdooConnectorBundle/install/config.sh COMPOSER=false NO_DOCKER=false
    

     

    Manual Installation for Version 4.0.x to 5.0.x

    For installing Odoo Akeneo Connector module in Akeneo, please follow the below steps:

    1 – Unzip the respective extension zip. Then merge “src” folder into akeneo project root directory.

    src-oddo

    2 – After that goto config/Bundles.php then add line:

    Webkul\OdooConnectorBundle\OdooConnectorBundle::class => [ 'all'=> true],

    odoo

    in return array.

    3 – Then copy the “config” folder into akeneo project root directory for routing.

    conf-odoo

     

    To run the Quick export in Akeneo 5.0.x, you need to run the below command.

    Install composer dependency

    php -d memory_limit=4G /usr/local/bin/composer --prefer-dist --no-scripts require navneetbhardwaj/akeneo-quickexport-configurator;
    

    After that, register bundle in config/bundles.php

    Webkul\QuickExportConfiguratorBundle\QuickExportConfiguratorBundle::class => ['all' => true],
    

    Define routing to create a file in the config/routes/wk_quick_export.yml

    wk_quick_expoort:
            resource: "@QuickExportConfiguratorBundle/Resources/config/routing.yml"
            prefix:   /
    

    – Run this command after ssh to your akeneo server by the terminal

    rm -rf ./var/cache/** && php bin/console odoo:setup:install

    5. If you are using php-fpm. Then you need to restart the php-fpm services and apache web server.

    For Akeneo 5

    sudo service php-fpm7.4 restart

    For Akeneo 4

    sudo service php-fpm7.3 restart

    Docker Installation Command :

    For Akeneo 5

    alias docker_php='docker-compose run -u www-data --rm php php'; 
    alias docker_yarn='docker-compose run -u node --rm node yarn';
    docker_php bin/console cache:clear --env=prod;
    docker_php bin/console pim:installer:assets --symlink --clean --env=prod;
    docker_php bin/console d:s:u --force;
    docker_yarn run webpack;
    docker_yarn run update-extensions;
    docker_yarn run less;

    For Akeneo 4

    alias docker_php='docker-compose run -u www-data --rm php php';
    alias docker_yarn='docker-compose run -u node --rm node yarn';
    docker_php bin/console cache:clear --env=prod;
    docker_php bin/console pim:installer:assets --symlink --clean --env=prod;
    docker_php bin/console d:s:u --force;
    docker_yarn run webpack;
    docker_yarn run less;

    Manual Installation For Version 2.x to 3.x

    For installing Odoo Akeneo Connector module in Akeneo, please follow the below steps:

    1 – Unzip the respective extension zip. Then merge “src” folder into akeneo project root directory.

    src-oddo

    2 – After that goto app/AppKernel.php then add the line.

    Appkernel.php file in Akeneo

    new Webkul\OdooConnectorBundle\OdooConnectorBundle(),

    in function registerProjectBundles()

    3 – Then goto app/config/routing.yml then add these lines at top of the file. Routing.yml file

    odoo_connector:        
        resource: "@OdooConnectorBundle/Resources/config/routing.yml"        
        prefix:   / 

    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.

    rm -rf ./var/cache/** && php bin/console odoo:setup:install

    5. If you are using php-fpm. Then you need to restart the php-fpm services.

    sudo service php7.2-fpm 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 Webpack error It means that webpack is not installed in your system. Run the following command

    npm install --save-prod webpack
    npm install
    

    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.

    Uninstall Module: For Akeneo 6

    • From the PIM directory, run the command below over the NO-DOCKER Instance.
    ./src/Webkul/OdooConnectorBundle/uninstall/uninstall.sh COMPOSER=false NO_DOCKER=true
    • Run the command below over the PIM directory’s DOCKER instance.
    ./src/Webkul/OdooConnectorBundle/uninstall/uninstall.sh COMPOSER=false NO_DOCKER=false

    Setup Odoo Credentials

    After that login to your Akeneo panel then go to Odoo Connector>Setup Credentials>Add Credentials.

    Odoo-Configuration-6

     

    Then the following page will appear, here you need to enter your Odoo server information:

    • URL
    • Database Name
    • Login Username
    • Login Password

    Note : We have added validation so that if you enter a duplicate database name when creating credentials, an error will occur.

    Odoo-Configuration-1-1

    Default Configuration

    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).
    • 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 the Odoo store. There are two options available here:
    1. Internal Reference (default_code)
    2. Barcode (barcode)
    • Odoo Version – You can select the Odoo version like 13,14,15,16.
    • Category Export as eCommerce categories – Enable this to export categories to the eCommerce category.

    Edit-Server-Credential-5

    Edit-Server-Credential-4

     

    Attribute 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.

     

    Odoo-Configuration-7

    By default, the following product fields can be mapped between Akeneo and Odoo:

    • Internal Reference
    • Barcode
    • Name
    • Description for Internal
    • Description for Quotations (description_sale)
    • Image
    • Description for Vendors (description_purchase)
    • Weight
    • Description for Pickings (description_picking)
    • Description of Delivery Orders
    • Volume
    • Description for Receptions
    • Sale Price (list_price)
    • Cost (standard_price)
    • Routes
    • 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 then map them with Akeneo attributes.

    First, you need to enter an Odoo field code then click Add Field button, after that the new mapping field will appear above.

    Odoo-Configuration-3

    Map Association

    In this you can map association products like Alternative produts and Related products then export the association products from Akeneo to Odoo.

    Odoo-Configuration-4

    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 Attribute Mapping>Manual Mapping.

     

    Odoo-Configuration-7

    Mapped Attributes and Categories

    Here, you can create mapping manually for category and attributes .

    Then you can also filter, search, or delete the mapped categories and attributes.

    Odoo-Connector-Export-Mapping-Index-1

    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.

    Then, select Akeneo Category and Odoo Category accordingly. Only one category can be mapped at a time.

    image-11

    Create Attribute Mapping

    To create a new mapping for an attribute, click Create Mapping then select Mapping Type as Attribute.

    After that, select Akeneo Attribute and Odoo Attribute. Only one attribute can be mapped at a time.

    image-12

    Export Jobs

    In this module you will find the following types of export jobs for exporting catalog information to Odoo:

    All Export – 

    1. Odoo Export All – Using this job you can export all your product data from Akeneo to Odoo.

    Attribute Export – 

    1. Odoo Export Attribute – Once you will select this job you can export all the Akeneo attributes to Odoo
    2. Odoo Export Attribute Option – Once you will select this job you can export all the Akeneo attribute options to Odoo

    Category Export – 

    1. Odoo Export Category – Using this job you can export all the categories to Odoo.

    Product Export – 

    1. Odoo Export Product – If you want to export only products to Odoo you have to select the Odoo export product job.
    2. Odoo Export Product Model – Once you will select this job you can export all the Akeneo product models to Odoo

    Association Export –

    1. Odoo Product and Product Model Association Export – If you want to export association product and product model to Odoo then you have to select a job.

    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 the Product option. 


    select product
    After enter any unique SKU then select a family from the list.

    Products-20-1

    After that, you need to fill in the product information as required according to Odoo store.

    Please note – only the mapped attributes information will be sent to the Odoo store.

    Product-Bag-Edit-7

    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.

    Product-Bag-Edit-8

    After that select a category from the left panel then click Save.

    Product-Bag-Edit-9

    2. Odoo Product Export

    Once you have created the products in Akeneo, we’ll now export them to Odoo store. Then go to Exports>Create Export Profile.

    Export-profiles-management-9-2

    Then enter a unique code, and label.

    After that select Odoo Connector>Export Product then click Save.

    Please Note – Before exporting the product you need to export attribute, attribute option, family, and category from Akeneo to Odoo.

    Export-profiles-management-10-1

    Select a channel and locales for exporting products. Then you can even send content for multiple language translations.

    Export-profile-Odoo-Export-All-Edit

     

    Filter Products

    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.

    Export-profile-Odoo-Export-All-Edit-1

     

    Once you have saved the information for the export profile, click Export Now button.

    Export-profile-Odoo-Export-All-Show

    In the execution process, you can check the progress of the export job and view any errors.

    Process-tracker-Show-job-7-1

    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 then publish the product.

    Odoo-1111111171-Bag

     

    After that check out the Odoo e-commerce storefront view. A customer can see the product name, images, price, buy now details etc.

    Bag-My-Website

    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.product model Now, enter any unique code, select a family, then 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.

    Products-21-1

    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.

    Product-model-Braided-hat-Edit-2

    Adding Variations

    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.

    Product-model-Braided-hat-Edit-3

    Add variant product information, select a size then enter SKU. Follow the above step again for creating more variation products.

    Product-model-Braided-hat-Edit-4

    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.

    Product-Braided-hat-Edit

    After saving all the information, then you need to select a category for the product. Moreover, you can select multiple categories also.

    Product-Braided-hat-Edit-1

    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.

    After that enter any unique code, and label. Then select Webkul Odoo Connector>Export Product Model after that click Save.

    Export-profiles-management-12

     

    After that select channel and locales for exporting products.

    Export-profile-Odoo-Export-Product-Model-Edit

     

    Filter 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).

    Export-profile-Odoo-Export-Product-Model-Edit-1

    After saving your export profile, then click Export Now button to begin execution process.

    Export-profile-Odoo-Export-Product-Model-Show

     

    After that the execution tracker will show you the process of the export job, in case there is an error it’ll appear here.

    Process-tracker-Show-job-9

    Once the export product model job finishes, then 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.

    Odoo-Braided-hat

    If you want to make any changes to the product or its variations, then you can simply click Edit after that do it.

    Odoo-Product-Variants

    Check out the store front end and see how the product with variations appears.

    Braided-hat-My-Website

    Note: Only the selected channel category will be exported if you enable the Export Only Channel Mapped Category Tree option in the Odoo Export category.

    Export-profile-Odoo-Export-category-Edit

    Channel-Ecommerce-Edit

    If the option is disabled, all categories in the selected channel will be exported.

    Channel-Ecommerce-Edit-1

     

    Import Jobs

    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.

    Edit-Server-Credential-3

     

    On the Product Field mapping has been done, go to Imports>Create Import Profile.

    Import-profiles-management-7-1

    Import All –

    Odoo Import All -You can import everything from Odoo like  products, categories, attributes, and family.

    Family Import-

    Family Import Based on Variation – This will import family of Odoo into Akeneo and all the family variant into that family.

    Product Import-

    Odoo Import Product and Product Model – This will import all the simple and configurable products of Odoo.

    Category Import-

    Odoo Import Category  – This will import all the Odoo categories to Akeneo.

    Attribute Import-

    Odoo Variant Import Attribute and Attribute Options – This will import all the attributes  and attribute options from Odoo to Akeneo.

    Import-profiles-management-8

    After that go to Content then select the appropriate channel, locale and currency for importing Odoo products to Akeneo.

    Import-profile-Odoo-All-Import-Edit

    Then, click the Import Now button to execute the import process.

    Process-tracker-Show-job-10

    Note: While importing the product model, you can filter for the variant, and then you have to enter the id of the variant:

    Import-profile-Odoo-Product-Model-Import-Edit-1

    You can find the id as shown in the below image:

    Screenshot-from-2023-01-25-12-01-34-1200x637-1

    For Simple product and product model main product you can enter the product.product id.

    Import-profile-Odoo-Prodct-Import-Edit

    You can find the id as shown in the below image:

    Screenshot-from-2023-01-25-12-07-38

    Support

    Thank you for reading this documentation. So, that was much about the User Guide of Odoo Akeneo Connector for any queries or doubts reach out to us at [email protected]. You can also raise a ticket at our HelpDesk System.

    Please explore our Akeneo Development Services and Quality Akeneo Extensions.

    Current Product Version - Akeneo 2 to 5 || 2.2.0 and Akeneo 6 || 3.1.0

    Supported Framework Version - Odoo 13, 14, 15 and 16|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x, 5.0.x and 6.0.x

    Blog Version - Odoo 13, 14, 15 and 16|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x, 5.0.x and 6.0.x
    • Version Odoo 13, 14, 15|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x, 5.0.x and 6.0.x
    • Version Odoo 13, 14, 15|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x and 5.0.x
    • Version Odoo 13, 14, 15 and 16|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x, 5.0.x and 6.0.x
    • Version Odoo 113, 14, 15|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x and 5.0.x
    • Version Odoo 10.x,11.x,12.x|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, and 3.1.x
    • Version Odoo 10.x,11.x,12.x|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x and 3.2.x
    • 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, 3.2.x, and 4.0.x
    • 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
    • Version Odoo 10.x,11.x,12.x, 13.x, 14.x|| Akeneo 2.0.x, 2.1.x, 2.2.x, 2.3.x, 3.0.x, 3.1.x, 3.2.x, 4.0.x and 5.0.x
    . . .
    Discuss on Helpdesk

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    4 comments

  • Walter Stalder
    Hi,
    Does Odoo Akeneo Connector support Odoo multi website and multi company?

    Greetings
    Walter

    • Adarsh Shukla (Moderator)

      Hello Walter,

      Greetings of the day!!

      Does Odoo Akeneo Connector support Odoo multi-website and multi-company?

      –> Our Odoo Akeneo Connector supports only multi-website. For more information, please share your requirement at [email protected]

      Thanks & Regards,

      Webkul Team

  • Michał Kolodziej
    For Odoo -> Akeneo import how should we define the field mapping? The same as we do for export?
    I’m thinking about importing the SEO data like keywords.

    Otherwise your module seems very promising.
    Another question I have is regarding the tags. In Odoo we have a separate structure for product tags. 1 product can have multiple tag ids attached. Looking at Akeneo I believe that these tags are something similar to Akeneo’s multi-select attribute.
    In the Akeneo – Odoo connector we have to have an option to mark these special attributes and make them importable for Odoo. When the attribute is imported, it should be stored in Odoo not just like any other field, but by setting valid option ids to the product.product_tag_ids field of the Odoo product.

    This way, Odoo would display the corresponding product “tag” on the product page.
    For this to work, we would have some option to map these Odoo product_tags with Akeneo’s attribute options.

    • Adarsh Shukla (Moderator)

      Hello Michał,

      Greetings of the day!!

      For Odoo -> Akeneo import how should we define the field mapping? The same as we do for export? I’m thinking about importing the SEO data like keywords.

      –> For the import, we haven’t provided the mapping. You can import the attribute, attribute option, product, product model, and categories from Odoo into Akeneo. 

      This way, Odoo would display the corresponding product “tag” on the product page. For this to work, we would have some option to map these Odoo product_tags with Akeneo’s attribute options.

      –> It can be customized. Please share your requirement at [email protected]

      Thanks & Regards,

      Webkul Team

  • Back to Top

    Table of Content