Akeneo Custom CSV Export

DEMO Buy Now

Akeneo Custom CSV Export allows to extract product data into a customized CSV file and use it for uploading product information to third-party platforms, suppliers, or other applications.

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

Check a brief overview of the plugin –

Basic Requirements:

This 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, 6.0.x and 7.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

Export products from Akeneo into CSV file
Product export variations from Akeneo into CSV file
Export multiple images of a product from Akeneo to CSV as a link
Use a fixed value for some fields when exporting data.
Mapping of Akeneo fields with CSV field code
Create multiple stores
Create dynamic custom fields for every store
Select types that the custom field support at the time of creating
Support option to the export category, attribute, and select type attribute option label
Export category and family with a product
Support concatenate, multiple and simple fields
Export CSV products using quick export.
Variant product mapping is also available
This module is compatible with the latest Akeneo version 7.0.x
Filter Data to be exported based on Category, Family, Completeness, Time conditions, Identifier (SKU), Language, and Currency.
Export Product Images From Akeneo to CSV as Public URL.

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

{
"scripts":{
"post-update-cmd":[
"vendor/webkul/webkulcsvbundle/src/Webkul/WebkulCsvBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
],
"post-install-cmd":[
"vendor/webkul/webkulcsvbundle/src/Webkul/WebkulCsvBundle/install/config.sh COMPOSER=true NO_DOCKER=true"
],
"post-create-project-cmd":[
"vendor/webkul/webkulcsvbundle/src/Webkul/WebkulCsvBundle/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/webkulcsvbundle/composer_install.sh"
      ],
      "post-install-cmd":[
         "vendor/webkul/webkulcsvbundle/composer_install.sh"
      ],
      "post-create-project-cmd":[
         "vendor/webkul/webkulcsvbundle/composer_install.sh"
      ]
   },
   "repositories":[
      {
         "type":"composer",
         "url":"https://akeneorepo.webkul.com/"
      }
   ]
}

3: Use composer to install the extension.

composer require webkul/webkulcsvbundle

4: Complete the authentication form.
5: Send a Message of Success
6: Delete your browser’s cache.

Installing Module for Version 6.0.x and 7.0.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/WebkulCsvBundle/install/config.sh COMPOSER=false NO_DOCKER=true

Run the command below over the PIM directory’s DOCKER instance.

./src/Webkul/WebkulCsvBundle/install/config.sh COMPOSER=false NO_DOCKER=false

Installing Module for Version 4.0.x to 5.0.x

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

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

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

Webkul\WebkulCsvBundle\WebkulCsvBundle::class => ['all' => true]

in return array.

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

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

Install composer dependency

composer require navneetbhardwaj/akeneo-quickexport-configurator

After that, register the bundle in config/bundles.php

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

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

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

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

php bin/console csv: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 2.x to 3.x

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

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

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

new Webkul\WebkulCsvBundle\WebkulCsvBundle(),

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

webkul_csv: resource: "@WebkulCsvBundle/Resources/config/routing.yml" prefix: /

4 -You have to navigate to Akeneo Installation Directory(Ex. cd /opt/bitnami/apps/akeneo/htdocs ). Run this command after ssh to your akeneo server by the terminal.

php bin/console csv:setup:install

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

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

Uninstall Module: For Akeneo 6 and 7

From the PIM directory, run the command below over the NO-DOCKER Instance.

./src/Webkul/WebkulCsvBundle/uninstall/uninstall.sh COMPOSER=false NO_DOCKER=true

Run the command below over the PIM directory’s DOCKER instance.

./src/Webkul/WebkulCsvBundle/uninstall/uninstall.sh COMPOSER=false NO_DOCKER=false

Set Up in Akeneo

After installation of the module in Akeneo, You have to edit the user role in Akeneo. Then you have to navigate System -> Roles-> Permission and then enable permissions in Akeneo Custom CSV Export.

A user can provide permissions for the following,

Activate/Deactivate Template
Create Template
Delete Template
Documentation
Edit Template
Support
Template Mapping

Akeneo CSV Mapping

After installing the connector in Akeneo, You can see the Webkul CSV connector icon at the Akeneo dashboard.

CSV Connector Product Mapping Fields

You can click on the Webkul CSV connector icon to set up a CSV connector. In this you can create map multiple templates.

To create a new template click on create a template.

After that, it will redirect you to the new page in which you have to enter the name of the template.

Then click to Save button.

Now to map the attributes in that template click to the template.

After that, you can see the other fields like Akeneo fields. With these fields, you can do the correct mapping of the product attributes for your Akeneo and eCommerce products fields.

Akeneo Fields –

In Akeneo fields, you can map the Akeneo attributes fields with the eCommerce store CSV fields. You can select the attributes in the dropdown as you have created and want to map.

Default Value –

In the default value fields, you can fix the default value of the attributes. Example: If you have a product quantity attribute then you can fix the size of the quantity.

Variant Product Mapping –

In this mapping, you can export the variant product information along with the parent product information.

Example: If you have a variant product with a variant like color – Red, White. Then, you can send the product information like the price for the variant product.

Note: Mapping should be the same as the CSV to export the values error-free.

Add Mapping CSV Fields

If you want to map the more CSV fields with the Akeneo fields then you can create a new mapping with the Map more fields option.

In the variant export mapping fields, you can mention the attribute for the variant product name. Example: You have a variant name “color” and value “Red” then you can mention the variant code and value in Variant Export Mapping fields name.

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

Here you can select the three fields:

Simple Field – Here, you can map a single attribute with CSV attribute fields.

Multiple Selection Field – With this option, you can select and map multiple product attributes.

Concatenate Filed – With this option, you can concatenate multiple products attributes in Akeneo fields.

If you have selected the Akeneo Field Type Yes/No then there will be two more options in which you can select their value format.

After clicking on the Add field, you can see the attribute code in the CSV mapping.

Other Mapping:

CSV Category Field – In this you can save the Akeneo product categories.
Multiple Value Separator – You can add multiple value separator ex- (,) food, clothes, accessories.
Export root category – You can export the categories along with root category.
CSV Simple / Model Product Field Format Separator – If you want to separate attribute name and attribute value with a separator like (/)
Export unit with metric attributes – In this you can export metric attribute.
Export category label – In this you can export the categories label instead of code.
Csv Family Field – In this you can add Akeneo product family.
Export attribute label – You can export attributes label instead of code.
Export select option as label – If you want to export simple/multi select attribute option label.

Create Export Profile

For creating the product in Akeneo, you can follow our user guide. Create Product and Product Variant in Akeneo

To create a product in Akeneo, go to navigate to Products then click the Create button. Now, you need to choose the product type – as Product or Product Model.

Product – Select this type for creating simple and virtual products.

Product Model – Select this type for creating a configurable product with variation Now to enter the required SKU, choose a family, then click the Save button.

SKU– Fill the product unique code.

Product Family – A family is a set of attributes that will be the same for all products belonging to a family. The product family represents product type, imposes product information structure, and defines the list of attributes for a product that it belongs to.

Add Product Details

Now you need to provide information about the product. First, select the Channel and Locale then enter the price, name, and description.

Export Profile

Now to export your product data you need to create a job profile and then execute it. Click on Create Export Profile.

First, go to Exports>Create Export Profile after that enter a unique code, the label then select a job profile.

After that, you have to select the Job profile. For creating an export profile, you have to click on the Save button.

After clicking on the save button, you can see the export profile.

Global Settings:

In this, you have to fill the details given below in the image like file path, decimal separator, data formate, etc.

Now go to the Content section then select the following options:

Channel – Each export job can only be linked to one channel, please select the relevant channel of products to export.

Locales – Select one or more Locales depending on your requirements.

Currency – You have to select here one currency.

Attributes – You can select which product attributes you want to export all or a few of them. Click the Edit button to select the attributes.

Edit Attributes

To make your own attribute selection, click on the left side to select a specific attribute group (or All groups to display all attributes). The selected attributes will be displayed as columns in your export file.

Filter The Products

Now you need to decide which products to export in a CSV file.

Family

After that one or more product families to export in the CSV file. If you want to export products belonging to specific families, click on the drop-down list then click on the families to add in the field like clothing, shoes, and t-shirts.

Status

You can also filter on the status of your products, three options available:

Note: While exporting the CSV you have to set the status all.

All – to export all products whatever their status is
Enabled (default option) – only to export enabled products
Disabled – to only export enabled products

Completeness

This enables you to filter on the completeness of selected locales. Four options on completeness are proposed:

No condition on completeness – all products will be exported whatever their completeness is.
Complete on at least one selected locale (default option) – products must be complete on at least one locale
Not complete on all selected locales – In these products must not be complete on all locales (if you have selected more than one locale).
Complete on all selected locales – products must be complete on all locales (if you have selected more than one locale).

Time Condition

You can now export your product on a specific time condition.

Updated products over the last n days (e.g. 6) – To filter the products that were updated during the last six days, enter 6 value.
No date condition (default option) – Products are not filtered using time conditions.
Updated products since this date – To filter the products that were updated during a specific date, select a date.
Updated products since last export – It will export the product updated since the last export.

Identifier

You can make a selection of identifiers to export by adding them to the SKU field. You can copy and paste a list of identifiers, and separate them by using commas, space, or line breaks.

Setup Store Template:

In this you can select the template and after that click the Save button and follow the next step to execute this profile.

Product Export

After creating and filtering data in the Export profile, you can see the Export Now button in Akeneo.

Now after clicking on the Save button, Wait for the execution process to complete and check the errors. After the completion of the export job, the products will appear in the CSV file.

Products In CSV

After the click on the Download Generated files, you can download the CSV files.

You can upload this CSV file on eCommerce channels to import the product.

Upload CSV in E-commerce

After generating the CSV files, you can upload this CSV file in the eCommerce Channel. For example, you have generated the CSV file for the Shopify store.

Now, you have to log in to your Shopify store admin panel. After that, you have to navigate the Products -> All Products. Then you have to click on the Import.

After the successful import, you can see the products in the Shopify product list.

Support

For any issues related to this module, please create a support ticket at- https://webkul.uvdesk.com/en/customer/create-ticket

Also, for any pre-sales queries or customization discussion, please drop an email to support@webkul.com

Please explore our Akeneo Development Services and Quality Akeneo Extensions.

Categories: Akeneo

Adarsh Shukla 15-January-2025

View Comments (2) Comment or Ask a Question

Quick Links