Menu Close
    Hire Us Request Quote Reading List Switch to Dark Mode

    Odoo Akeneo Connector

    Introduction

    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.

    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 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
    • 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, and 3.1.x

    Basic Requirements

    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, and 3.1.x you can download Akeneo from here
    • Following Odoo apps must be installed – Purchase Management, eCommerce, and Website Builder.

    Video Tutorials

    Check out the following video tutorials below:

    Setup Credential in Odoo Akeneo Connector-https://www.youtube.com/watch?v=koCbBUnyvIw

    How to Create and Export product from Akeneo to Odoo-https://www.youtube.com/watch?v=Iozx-ZFu5FQ

    Installation

    For installing this module in Akeneo, please follow the below steps: 1 – Unzip the respective extension zip and then merge “src” folder into akeneo project root directory. 2 – Goto app/AppKernel.php and add the line.

    new Webkul\OdooConnectorBundle\OdooConnectorBundle(),

    in function registerProjectBundles() 3 – Goto app/config/routing.yml and add these lines at top of the 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 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

    5 – You have to restart your web server like Apache, Nginx. Run the command for Apache web server.

    sudo service apache2 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
      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.

    Setup Odoo Credentials

    After that login to your Akeneo panel and go to Odoo Connector>Server Credentials. The following page will appear, here you need to enter your Odoo server information:

    • Server URL
    • Database Name
    • Login Username
    • Login Password

    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). Default Currency – Select the default currency of your Odoo store. Such as – US Dollar, Euro, British Pound. 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)

    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.

    You can map more attributes like Routes, Product type, Sale Price.

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

    • Internal Reference
    • Barcode
    • Name
    • Image
    • Weight
    • Volume
    • 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)
    • Routes
    • Product Type
    • Can be Sales
    • Can be Purchased

    Map More 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.

    Map Attribute and Category

    For avoiding duplicate category and attribute creation issue in Odoo, you must do the mapping of your existing categories and attributes of Odoo with the Akeneo. In Odoo Connector Configuration, navigate to Product Field Mapping>Map Attribute/Category.

    Mapped Attributes and Categories

    Here, you can find all the earlier mapped categories and attributes. 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. Then, select Akeneo Category and Odoo Category accordingly. Only one category can be mapped at a time.

    Create Attribute Mapping

    To create a new mapping for an attribute, click Create Mapping and select Mapping Type as Attribute. Then, select Akeneo Attribute and Odoo Attribute. Only one attribute can be mapped at a time.

    Export Categories

    1. If you want to create a new category in Akeneo, please go to Settings>Categories. For creating the main category, click Create New Category button and enter the information.

    Sub-Category

    For creating a sub-category, navigate to a category on the left and right-click, Create option will appear. Enter the required information such as code, label, translations and click Save. 2. If you have already created categories in Akeneo and want to export all the categories from Akeneo to Odoo, you can use Odoo Category Export job profile. To do that, please go to Exports>Create Export Profile. In Job, navigate to Webkul Odoo Connector>Export Category. Set any code and label for this export job and click Save. Select a channel and locales for the category export. It supports multiple language translations as well. After saving the export category profile, click Export Now. The export execution process will begin, you can see the status and view number of categories being exported. If there’s an error you can also see it here.

    Odoo Product Categories

    Once the export category job is finished, you can see the categories visible in Odoo. You can also edit the exported categories and make any changes accordingly. Category Translations All the category translations are also exported to Odoo database.

    Export Attribute

    Attributes are the basic properties of a product that defines it, such as- brand, material, specifications, etc. 1. To create a new attribute in Akeneo, please go to Settings>Attributes>Create Attribute.

    Select the type of attribute you want to create. After that, you need set any code for this attribute and then select Attribute Group from the list. Label Translations You can also provide translations for the attribute label. Options Now, you need to add some options for this new attribute, click Options tab. Even for the options, you can mention the translations in multiple languages. For displaying the new attribute in a product, you must assign it to a family. Go to Settings>Families select a family and go to Attributes tab. Search for your new attribute using its name, then tick the checkbox, and click Add. 2. If you want to export all the attributes from Akeneo to Odoo, please use Odoo Attribute Export job. To do that, please go to Exports>Create Export Profile. In Job, navigate to Webkul Odoo Connector>Export Attribute. Set any code and label for this export job and click Save. Select channel and locales for the attribute export job. It supports multiple language translations as well. After saving the profile, you can click Export Now button. Execution Process Once the export process begins, you can check the progress and see any errors and summary information. After the completion of the execution process, the attributes can be seen in Odoo store. Attribute Translations Even the translations are also exported to Odoo.

    Export Attribute Option

    In the above section, we created a new attribute with two options. Now we’ll export those attribute options from Akeneo to Odoo. To do that, please go to Exports>Create Export Profile. In Job, navigate to Webkul Odoo Connector>Export Attribute Option. Set any code and label for this export job and click Save.

    Select channel and locales from the Content section. After saving the profile, click Export Now butt0n. The execution process will start and display the progress of the attribute option export job. After the completion of an export job, the attribute options will be visible in Odoo Attribute Values. The translations will also be exported for the attributed options.

    Export Product

    In this section, I will explain to you how to export your products from Akeneo to Odoo eCommerce store. In case you have already created or imported the products in Akeneo, then please go to point 2.

    1. Creating Product in Akeneo

    To create a simple product (having no variations like- size, color) in Akeneo such as a t-shirt, go to Products>Create and select Product option.  Then, enter any unique SKU and select a family from the list.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. 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 and 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 Webkul Odoo Connector>Export Product and click Save. Select a channel and locales for exporting products. You can even send content for multiple language translations.

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

    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. Click down-arrow icon near size, a small pop-up window will appear. Add variant product information, select a size and 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, 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.

    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. 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 and do it. Check out the store front end and see how the product with variations appear.

    Support

    Thank you for reading this documentation. In case you find anything missing or not explained properly, or you have any customization requirements, then please send an email to support@webkul.com

    Current Product Version - 1.2.5

    Supported Framework 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

    . . .

    Comment

    Add Your Comment

    Be the first to comment.

    Back to Top
    css.php
    Hire Us!
    Brief us about your requirements and we'll get back to you.
    Woo! Hooy!
    We have just recieved your project brief and our expert will contact you shortly.
    Send Again
    Close

    Table of Content

    Hide Index