Menu Close
    Searching for an experienced eCommerce & Marketplace Development Company ?

    How to Import CSV in Akeneo?

    Akeneo Custom CSV Import: With this connector, you can upload product information in Akeneo by importing product data from a customized CSV file.

    You may import product information, as well as catalog elements such as families, categories, and characteristics.

    The extension enables you to map Akeneo fields with the CSV fields (columns).

    Basic Requirements:

    • This module works with Akeneo 3.0.x, 3.1.x, 3.2.x 4.0.x and 5.0.x. Download Akeneo from here.
    • Node and Yarn packages need to be installed.
    • This module is compatible with the Akeneo community and Enterprise(Flexibility) edition.
    • If you want to use this extension on Akeneo EE Serenity mode, please contact us.
    • For the Akeneo installation, your Akeneo server should meet these system requirements.

    Features

    • Import products from CSV file into Akeneo.
    • Support product and product model import in CSV.
    • Product import variations from CSV into Akeneo.
    • Import multiple images of a product from CSV to Akeneo.
    • Fields in Akeneo are mapped to CSV field codes.
    • Create dynamic custom fields for every store.
    • At the time of creation, select the kinds that the custom field supports.
    • Support option to the import category, attribute, and select type attribute option label.
    • import category and family with a product.
    • Support concatenate, multiple and simple fields.
    • Variant product mapping is also available.
    • This module is compatible with the latest Akeneo version 5.0.x

    Installing Module for Version 4.0.x to 5.0.x

    Please follow these steps for installing the Akeneo Custom CSV Import module in your Akeneo PIM platform.

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

    csv-src

    2 – Goto config/Bundles.php then add line:

    Webkul\WebkulCsvImportBundle\WebkulCsvImportBundle::class => ['all' => true]
    Screenshot-from-2021-07-29-18-42-23

    in the return array.

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

    csv-conf

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

    rm -rf var/cache/ && php bin/console csvimport: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;
    

    Installing Module for Version 3.x

    Please follow these steps for installing the Akeneo Custom CSV Import module in your Akeneo PIM platform.

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

    csv-src

    2 – Goto app/AppKernel.php then add the line

     new Webkul\WebkulCsvImportBundle\WebkulCsvImportBundle(),
    Screenshot-from-2021-07-29-18-43-05

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

    webkul_csv:
         resource: "@WebkulCsvImportBundle/Resources/config/routing.yml"
         prefix:    / 
    Screenshot-from-2021-07-29-18-44-17

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

    sudo service php-fpm7.2 restart

    Common Issues After Installation

    Webpack error

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

    Akeneo CSV Mapping

    The Akeneo Custom CSV Import connector symbol appears in the Akeneo dashboard when the connector is installed as seen in the screenshot given below.

    screenshot-192.168.1.74_8082-2021.07.24-17_48_13-1

    Product Mapping Fields in the CSV Connector

    To set up a CSV connector you need to click on the Akeneo Custom Csv import icon. In this multiple templates can be created and mapped.

    To create a new template you need to click on Create Template button.

    screenshot-192.168.1.74_8082-2021.07.24-18_13_24-1

    After that, it will take you to a new screen where you must input the template’s name and click on SAVE Button.

    screenshot-192.168.1.74_8082-2021.07.24-18_23_20

    Then you may view the additional fields, such as the Akeneo fields. These fields may be utilized to map product attributes appropriately for your Akeneo and eCommerce product fields.

    screenshot-192.168.1.74_8082-2021.07.25-14_30_31

    You can map Akeneo characteristics fields to eCommerce shop CSV fields in Akeneo fields. You may use the dropdown to choose the qualities you’ve generated and want to transfer.

    Mapping Variant Products in Akeneo Custom CSV Import

    You may export the variation product information as well as the parent product information using this mapping.

    For example, if you have a variant product with a color variant such as Red or White. Then you can send product details, such as the price of the variant product.

    screenshot-192.168.1.74_8082-2021.07.25-15_22_15-1

    Add Mapping CSV Feilds

    Create a new mapping with the Map more fields option if you want to map more CSV fields to Akeneo fields.

    screenshot-192.168.1.74_8082-2021.07.25-15_37_50

    CSV Variant Field Value Type and CSV Simple / Model Product Field Value Type

    You can choose from three fields here:

    • Simple Field – You can use this field to map a single attribute to CSV attribute fields.
    • Multiple Selection Field – Multiple product attributes can be selected and mapped using this option.
    • Concatenate Field – Multiple product attributes in Akeneo fields can be concatenated using this option.
    Screenshot-from-2021-07-25-16-10-43-e1627209763724-1200x534-1

    If you choose Yes/No for Akeneo Field Type, you’ll have two more options to choose from when it comes to value format.
    The attribute code can be seen in the CSV mapping after clicking on the Add field button.

    screenshot-192.168.1.74_8082-2021.07.25-16_30_40

    Other Mapping in Akeneo Custom CSV Import

    • CSV Category Field – Here you can store the Akeneo product categories.
    • CSV Family Field – The Akeneo product family can be added here.
    • Multiple Value Separator – You can use multiple value separators, such as (,) to separate food, clothing, and accessories.
    • CSV Simple / Model Product Field Format Separator – If you wish to separate the name and value of an attribute, use a separator like (/).
    • CSV Variant Field Format Separator – Use a separator like (/) to separate the name and value of a variation product attribute.
    • Parent Code Field – You can add Akeneo parent code here.
    • CSV Product Type Field – Here you may save your Akeneo product type.
    • Family Variant Feild – You can add Akeneo family variant here.
    • Simple Product Type Value – Here you need to enter the value of simple product type .
    • Model Product Type Value – Here you need to enter the value of model product type.
    • Category Feilds Contains Code – You can enable or disable category feild contains code in Akeneo.
    • Attribute Name Field Contains Attribute Code – You can enable or diabale attribute name field contain attribute code.
    screenshot-192.168.1.74_8082-2021.07.28-08_46_11

    Create Import profile

    To import your product information, you must first create a job profile and then run it.
    To begin, navigate to Imports > Create Import Profile, then enter a unique code, a label, and a job profile.

    screenshot-192.168.1.74_8082-2021.07.25-17_21_20

    After that, you have to select the Job profile and click on the Save button and see your export profile.

    screenshot-192.168.1.74_8082-2021.07.25-17_42_59

    Global Settings

    You must fill in the details shown in the image below, such as file path, decimal separator, delimiter, Enclosure, and so on.

    screenshot-192.168.1.74_8082-2021.07.25-17_44_33

    Afterward, Go to the Content section now and choose from the following options:

    • Channel – In this you have to select the relevant channel of product to export.
    • Currency – You must choose one currency here.
    • Locales – Depending on your needs, choose one or more Locales.
    screenshot-192.168.1.74_8082-2021.07.25-17_49_40

    Setup CSV Template

    You can select the template here, then click the Save button and proceed to the next step to run this profile.

    screenshot-192.168.1.74_8082-2021.07.25-17_57_47

    Product Import

    You must click the Upload A File button in Akeneo after creating and filtering data in the import profile.

    screenshot-192.168.1.74_8082-2021.07.25-18_17_35

    Afterward, you need to drop your CSV file below and click on Upload and Import Now button.

    screenshot-192.168.1.74_8082-2021.07.25-18_21_00

    After clicking on Upload and Import now button wait for the execution process to complete.

    download-7-1

    After the completion of the import job, the products will appear in the Akeneo product list as seen in the screenshot given below.

    screenshot-192.168.1.74_8082-2021.07.26-18_45_56

    Support

    So, that was much about the User guide of Akeneo Custom CSV Import for any queries or doubts reach out to us at [email protected] . You can also raise a ticket at our HelpDesk system webkul.uvdesk.com

    Current Product Version - 1.0.0

    Supported Framework Version - 3.x.x & 4.x.x & 5.x.x

    . . .
    Discuss on Helpdesk

    Leave a Comment

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


    Be the first to comment.

    Back to Top