{"id":294238,"date":"2021-07-09T13:09:05","date_gmt":"2021-07-09T13:09:05","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=294238"},"modified":"2025-12-24T05:42:10","modified_gmt":"2025-12-24T05:42:10","slug":"akeneo-custom-xlsx-connector","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/","title":{"rendered":"User Guide for Akeneo Custom XLSX Connector"},"content":{"rendered":"\n<p><strong><a href=\"https:\/\/store.webkul.com\/akeneo-custom-xlsx-connector.html\" target=\"_blank\" rel=\"noreferrer noopener\">Akeneo Custom XLSX Connector <\/a><\/strong>enables seamless <strong>export and import of product and product model data<\/strong> using customizable XLSX files.<\/p>\n\n\n\n<p>It allows you to map Akeneo attributes to XLSX header columns for sharing product information with third-party platforms, suppliers, or external systems.<\/p>\n\n\n\n<p>In addition to export, the connector supports <strong>importing simple and <a href=\"https:\/\/help.akeneo.com\/serenity-take-the-power-over-your-products\/serenity-create-products#create-a-product-model\" target=\"_blank\" rel=\"noreferrer noopener\">product model<\/a><\/strong>.<\/p>\n\n\n\n<p>This ensures a smooth, two-way data exchange with accurate and structured product information management.<\/p>\n\n\n\n<p>You can also use the <strong><a href=\"https:\/\/store.webkul.com\/akeneo-template-connector.html\" target=\"_blank\" rel=\"noreferrer noopener\">Akeneo Template Connector<\/a><\/strong>  to dynamically generate product attribute values using templates.<\/p>\n\n\n\n<p>Check a brief overview of the plugin &#8211;  <\/p>\n\n\n\n<div class=\"wp-block-wk-block-youtube-video wp-block-wk-block--yt-video components-placeholder\"><div class=\"wk-block--yt-video-frame\"><div class=\"wk-block--yt-video-frame-request\" data-plyr-provider=\"youtube\" data-plyr-embed-id=\"Z1WstMvMrXg\"><div class=\"components-placeholder__instructions\">Z1WstMvMrXg<\/div><\/div><\/div><\/div>\n\n\n\n<p><strong>Basic Requirements:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>This module works with Akeneo 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&nbsp;<a href=\"https:\/\/www.akeneo.com\/download\/\">here<\/a><\/li>\n\n\n\n<li>Node and Yarn packages need to be installed.<\/li>\n\n\n\n<li>This module is compatible with the Akeneo community and Enterprise(Flexibility) edition.<\/li>\n\n\n\n<li>If you want to use this extension on Akeneo EE Serenity mode, please&nbsp;<a href=\"mailto:support@webkul.com\" target=\"_blank\" rel=\"noreferrer noopener\">contact us<\/a>.<\/li>\n\n\n\n<li>For the Akeneo installation, your Akeneo server should meet these&nbsp;<a href=\"https:\/\/docs.akeneo.com\/7.0\/install_pim\/manual\/system_requirements\/system_requirements.html\" target=\"_blank\" rel=\"noreferrer noopener\">system requirements<\/a>.<\/li>\n<\/ul>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Features<\/h3>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Import products and product models into Akeneo using XLSX import mapping templates.<\/li>\n\n\n\n<li>Export products and product models from Akeneo into XLSX files.<\/li>\n\n\n\n<li>Product export variations from Akeneo into Xlsx file.<\/li>\n\n\n\n<li>Export <strong>multiple product images<\/strong> from Akeneo to XLSX (as image links).<\/li>\n\n\n\n<li>Use a&nbsp;fixed value for some fields when exporting data.<\/li>\n\n\n\n<li>Mapping of Akeneo fields with Xlsx field code.<\/li>\n\n\n\n<li>Create multiple stores.<\/li>\n\n\n\n<li>Create dynamic custom fields for every store.<\/li>\n\n\n\n<li>Select types that the custom field support at the time of creating.<\/li>\n\n\n\n<li>Support option to the export category, attribute, and select type attribute option label.<\/li>\n\n\n\n<li>Export category and family with a product.<\/li>\n\n\n\n<li>Variant product mapping is also available.<\/li>\n\n\n\n<li>This module is compatible with the latest Akeneo version 7.0.x.<\/li>\n\n\n\n<li>Filter Data to be exported based on Category, Family, Completeness, Time conditions, Identifier (SKU), Language, and Currency.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Composer Installation<\/h2>\n\n\n\n<p><a href=\"https:\/\/webkul.com\/blog\/how-to-install-webkul-akeneo-connector-via-composer\/\"><strong>Read This Blog<\/strong><\/a><\/p>\n\n\n\n<p>Before beginning the composer installation<\/p>\n\n\n\n<p><strong>1<\/strong>: Get the&nbsp;<strong>ACCESS KEYS<\/strong>&nbsp;[Create a&nbsp;<a href=\"https:\/\/webkul.uvdesk.com\/en\/customer\/create-ticket\/\" target=\"_blank\" rel=\"noreferrer noopener\">support ticket<\/a>]<br><strong>2<\/strong>: In Akeneo&nbsp;<strong>composer.json<\/strong>, add our repository as well as the installation script.<br><br><strong>For Akeneo 6<\/strong> <strong>and 7<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">{\n  &quot;scripts&quot;: {\n        &quot;post-update-cmd&quot;: &#091;\n           &quot;vendor\/webkul\/webkulcustomxlsxbundle\/src\/Webkul\/WebkulCustomXlsxBundle\/install\/config.sh COMPOSER=true NO_DOCKER=true&quot;\n        ],\n        &quot;post-install-cmd&quot;: &#091;\n           &quot;vendor\/webkul\/webkulcustomxlsxbundle\/src\/Webkul\/WebkulCustomXlsxBundle\/install\/config.sh COMPOSER=true NO_DOCKER=true&quot;\n        ],\n        &quot;post-create-project-cmd&quot;: &#091;\n          &quot;vendor\/webkul\/webkulcustomxlsxbundle\/src\/Webkul\/WebkulCustomXlsxBundle\/install\/config.sh COMPOSER=true NO_DOCKER=true&quot;\n       ]\n   },\n  &quot;repositories&quot;: &#091;{\n    &quot;type&quot;: &quot;composer&quot;,\n    &quot;url&quot;: &quot;https:\/\/akeneorepo.webkul.com\/&quot;\n  }]\n}<\/pre>\n\n\n\n<p><strong>For Akeneo &lt;=5.x&nbsp;<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">{\n  &quot;scripts&quot;: {\n        &quot;post-update-cmd&quot;: &#091;\n           \n&quot;vendor\/webkul\/webkulcustomxlsxbundle\/composer_install.sh&quot;\n        ],\n        &quot;post-install-cmd&quot;: &#091;\n           \n&quot;vendor\/webkul\/webkulcustomxlsxbundle\/composer_install.sh&quot;\n        ],\n        &quot;post-create-project-cmd&quot;: &#091;\n         \n&quot;vendor\/webkul\/webkulcustomxlsxbundle\/composer_install.sh&quot;\n       ]\n   },\n  &quot;repositories&quot;: &#091;{\n    &quot;type&quot;: &quot;composer&quot;,\n    &quot;url&quot;: &quot;https:\/\/akeneorepo.webkul.com\/&quot;\n  }]\n}<\/pre>\n\n\n\n<p><strong>3<\/strong>: Use composer to install the extension.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">         composer require webkul\/webkulcustomxlsxbundle<\/pre>\n\n\n\n<p><strong>4<\/strong>: Complete the authentication form.<br><strong>5<\/strong>: Send a Message of Success<br><strong>6<\/strong>: Delete your browser\u2019s cache.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Installing Module for Version 6.0.x and 7.0.x<\/h3>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;After unzipping the appropriate extension zip, merge the \u201csrc\u201d folder into the akeneo project.<\/li>\n\n\n\n<li>From the PIM directory, run the following command over the NO-DOCKER Instance.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/WebkulCustomXlsxBundle\/install\/config.sh COMPOSER=false NO_DOCKER=true<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;Run the command below over the PIM directory\u2019s DOCKER instance.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/WebkulCustomXlsxBundle\/install\/config.sh COMPOSER=false NO_DOCKER=false<\/pre>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Installing Module for Version 4.0.x to 5.0.x<\/h3>\n<\/div><\/div>\n\n\n\n<p>Please follow these steps for installing the Custom Xlsx Connector for the Akeneo module in your Akeneo PIM platform.<\/p>\n\n\n\n<p>1 \u2013 Unzip the respective extension zip then merge the \u201csrc\u201d folder into the Akeneo project root directory.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1120\" height=\"294\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png\" alt=\"csv-src-1\" class=\"wp-image-294554\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png 1120w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1-300x79.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1-250x66.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1-768x202.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>2 \u2013 Goto config\/Bundles.php then add line:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">Webkul\\WebkulCustomXlsxBundle\\WebkulCustomXlsxBundle::class =&gt; &#091;&#039;all&#039; =&gt; true],<\/pre>\n\n\n\n<p>in the return array.<\/p>\n\n\n\n<p><strong>3 \u2013<\/strong>&nbsp;Copy the \u201cconfig\u201d folder into the akeneo project root directory for routing.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1117\" height=\"290\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-conf-1.png\" alt=\"csv-conf-1\" class=\"wp-image-294556\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-conf-1.png 1117w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-conf-1-300x78.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-conf-1-250x65.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-conf-1-768x199.png 768w\" sizes=\"(max-width: 1117px) 100vw, 1117px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>4&nbsp;<\/strong>\u2013 Run this command after ssh to your akeneo server by the terminal<br><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">rm -rf var\/cache\/ &amp;&amp; php bin\/console customxlsx:setup:install<\/pre>\n\n\n\n<p><strong>5 \u2013&nbsp;<\/strong>If you are using php-fpm. Then you need to restart the php-fpm services and apache web server.<\/p>\n\n\n\n<p><strong>For Akeneo 5<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">sudo service php-fpm7.4 restart<\/pre>\n\n\n\n<p><strong>For Akeneo<\/strong>&nbsp;<strong>4<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">sudo service php-fpm7.3 restart<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Docker Installation Command :<\/h2>\n\n\n\n<p><strong>For Akeneo 5<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">alias docker_php=&#039;docker-compose run -u www-data --rm php php&#039;;\nalias docker_yarn=&#039;docker-compose run -u node --rm node yarn&#039;;\ndocker_php bin\/console cache:clear --env=prod;\ndocker_php bin\/console pim:installer:assets --symlink --clean --env=prod;\ndocker_php bin\/console d:s:u --force;\ndocker_yarn run webpack;\ndocker_yarn run update-extensions;\ndocker_yarn run less;<\/pre>\n\n\n\n<p><strong>For Akeneo<\/strong>&nbsp;<strong>4<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">alias docker_php=&#039;docker-compose run -u www-data --rm php php&#039;;\nalias docker_yarn=&#039;docker-compose run -u node --rm node yarn&#039;;\ndocker_php bin\/console cache:clear --env=prod;\ndocker_php bin\/console pim:installer:assets --symlink --clean --env=prod;\ndocker_php bin\/console d:s:u --force;\ndocker_yarn run webpack;\ndocker_yarn run less;<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Installing Module for Version 2.x to 3.x<\/h3>\n<\/div><\/div>\n\n\n\n<p>Please follow these steps for installing the Custom XLSX Connector for Akeneo module in your Akeneo PIM platform.<\/p>\n\n\n\n<p>1 \u2013 Unzip the respective extension zip then merge the \u201csrc\u201d folder into the Akeneo project root directory.<\/p>\n\n\n\n<p>2 \u2013&nbsp;Goto&nbsp;<strong>app\/AppKernel.php<\/strong>&nbsp;then add the line<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">new Webkul\\WebkulCustomXlsxBundle\\WebkulCustomXlsxBundle(),<\/pre>\n\n\n\n<p><br>3 \u2013&nbsp;Goto&nbsp;<strong>app\/config\/routing.yml<\/strong>&nbsp;then add these lines at top of the file<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">webkul_xlsx:\n    resource: &quot;@WebkulCustomXlsxBundle\/Resources\/config\/routing.yml&quot;\n    prefix:    \/<\/pre>\n\n\n\n<p><br>4 -You have to navigate to Akeneo Installation Directory(Ex.&nbsp;<strong>cd \/opt\/bitnami\/apps\/akeneo\/htdocs<\/strong>&nbsp;). Run this command after ssh to your akeneo server by the terminal.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">rm -rf var\/cache\/ &amp;&amp; php bin\/console customxlsx:setup:install<\/pre>\n\n\n\n<p>5 \u2013&nbsp;You have to restart your web server like Apache, Nginx. Run the command for the Apache webserver.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">sudo service php-fpm7.2 restart<\/pre>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Common Issues After Installation<\/h3>\n<\/div><\/div>\n\n\n\n<p>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:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Webpack Installation: If you get the below error<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"734\" height=\"211\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Webpack-error.png\" alt=\"Webpack-error\" class=\"wp-image-294672\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Webpack-error.png 734w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Webpack-error-300x86.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Webpack-error-250x72.png 250w\" sizes=\"(max-width: 734px) 100vw, 734px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>It means that web pack is not installed in your system. Run the following command<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\">npm install --save-prod webpack\nnpm install<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Module routing.yml is not configured properly. Re-check the routing.yml file as mentioned&nbsp;in the 3rd step of Module Installation<\/li>\n\n\n\n<li>Clear your browser cache.<\/li>\n<\/ul>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Uninstall Module: For Akeneo 6 and 7<\/h3>\n<\/div><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From the PIM directory, run the command below over the NO-DOCKER Instance.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/WebkulCustomXlsxBundle\/uninstall\/uninstall.sh COMPOSER=false NO_DOCKER=true<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Then run the command below over the PIM directory\u2019s DOCKER instance.<\/li>\n<\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\">.\/src\/Webkul\/WebkulCustomXlsxBundle\/uninstall\/uninstall.sh COMPOSER=false NO_DOCKER=false<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Configure Akeneo Custom XLSX Mapping Template<\/h2>\n<\/div><\/div>\n\n\n\n<p>After installing the connector in Akeneo, the <strong>Webkul Custom XLSX Connector<\/strong> icon will appear on the Akeneo dashboard.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"612\" height=\"480\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/customxlsxakeneoicon.webp\" alt=\"xlsx icon\" class=\"wp-image-518458\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/customxlsxakeneoicon.webp 612w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/customxlsxakeneoicon-300x235.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/customxlsxakeneoicon-250x196.webp 250w\" sizes=\"(max-width: 612px) 100vw, 612px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">XLSX Connector Product Mapping Fields<\/h3>\n\n\n\n<p>By clicking the <strong>Connector<\/strong> icon, you can configure the connector and create multiple XLSX mapping templates as required.<\/p>\n\n\n\n<p>To create a new template, click on Create Template.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"465\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx2-1200x465.png\" alt=\"Akeneocustomxlsx2\" class=\"wp-image-343301\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx2-1200x465.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx2-300x116.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx2-250x97.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx2-768x297.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx2.png 1361w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After that, it will redirect you to the new page in which you have to enter the name of the template.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"612\" height=\"481\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/createtemplate.webp\" alt=\"createtemplate\" class=\"wp-image-518462\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/createtemplate.webp 612w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/createtemplate-300x236.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/createtemplate-250x196.webp 250w\" sizes=\"(max-width: 612px) 100vw, 612px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Then click on to Save button.<\/p>\n\n\n\n<p>Now to map the attributes in that template click on the template.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Export Mapping<\/h2>\n<\/div><\/div>\n\n\n\n<p>Once the <strong>mapping template is created<\/strong>, you will be redirected to the <strong>Export Mapping page<\/strong>. Here, you must first add the XLSX fields (XLSX column header) and then map them with Akeneo attributes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Add XLSX Fields<\/h3>\n\n\n\n<p>To start mapping, you must <strong>add fields<\/strong> that will be column headers in the exported XLSX file.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter the <strong>XLSX Field Header Name<\/strong> (this will be the column name in the XLSX file)<\/li>\n\n\n\n<li>Select the <strong>Akeneo Attribute Type<\/strong> from the dropdown.<\/li>\n\n\n\n<li>Enable or disable the following options based on the attribute configuration:\n<ul class=\"wp-block-list\">\n<li><strong>Attribute Localizable<\/strong> \u2013 enable if the attribute is locale-based.<\/li>\n\n\n\n<li><strong>Attribute Scopable<\/strong> \u2013 enable if the attribute is channel-based.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Click <strong>Add Field<\/strong> to save the field<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>These settings must match the actual configuration of the Akeneo attribute.<\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1856\" height=\"856\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addfield.webp\" alt=\"addfield\" class=\"wp-image-518466\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addfield.webp 1856w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addfield-300x138.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addfield-1200x553.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addfield-250x115.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addfield-768x354.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addfield-1536x708.webp 1536w\" sizes=\"(max-width: 1856px) 100vw, 1856px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Map Akeneo Attributes (Simple Products)<\/h3>\n\n\n\n<p>After successfully adding the fields:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the corresponding <strong>Akeneo attribute<\/strong> for each XLSX field from the dropdown<\/li>\n\n\n\n<li>This mapping applies to <strong>simple product attributes<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>This ensures the correct product data is exported into the XLSX file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"534\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple-1200x534.webp\" alt=\"simplemapping\" class=\"wp-image-518469\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple-1200x534.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple-300x134.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple-250x111.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple-768x342.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple-1536x684.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple-604x270.webp 604w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mapsimple.webp 1857w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"534\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-173-1200x534.png\" alt=\"image-173\" class=\"wp-image-344494\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-173-1200x534.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-173-300x133.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-173-250x111.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-173-768x341.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-173-604x270.png 604w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-173.png 1363w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: <strong>Variant Product Mapping \u2013<\/strong><\/h3>\n\n\n\n<p>In Akeneo Variant Product Mapping. You can export the variant product information along with the parent product information.<\/p>\n\n\n\n<p><strong>Example:<\/strong>&nbsp;If you have a variant product with a variant like color \u2013 Red, White. Then, you can send the product information, like the price for the variant product.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"573\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/varaintmap-1200x573.webp\" alt=\"varaintmap\" class=\"wp-image-518477\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/varaintmap-1200x573.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/varaintmap-300x143.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/varaintmap-250x119.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/varaintmap-768x367.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/varaintmap-1536x734.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/varaintmap.webp 1856w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"530\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-175-1200x530.png\" alt=\"image-175\" class=\"wp-image-344496\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-175-1200x530.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-175-300x132.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-175-250x110.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-175-768x339.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-175.png 1364w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Default Value (Optional)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can define a <strong>default value<\/strong> for any mapped field.<\/li>\n\n\n\n<li>If an attribute value is missing on product data, the default value will be exported .<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"552\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/default-1200x552.webp\" alt=\"defaultmap\" class=\"wp-image-518478\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/default-1200x552.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/default-300x138.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/default-250x115.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/default-768x353.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/default-1536x707.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/default.webp 1861w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Example:<br>If a <strong>quantity<\/strong> attribute is empty, a fixed quantity value can be exported.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Other Mapping<\/h3>\n\n\n\n<p>Use the <strong>Other Mapping<\/strong> section to configure system-level XLSX fields:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Category Field<\/strong> \u2013 In this section you have to enter the category header name as entered in the XLSX file.<\/li>\n\n\n\n<li><strong>Family Field<\/strong> \u2013 In this section you have to enter the family header name as entered in the XLSX file.<\/li>\n\n\n\n<li><strong>Product Parent Field<\/strong> \u2013  you can save the Akeneo product parent field in this which you want to export.<\/li>\n\n\n\n<li><strong>Family Variant Field<\/strong> \u2013 Export the family variant code<\/li>\n\n\n\n<li><strong>Multiple Value Separator<\/strong> \u2013 Define separator for multi select attributes (e.g. <code>,<\/code>).<\/li>\n\n\n\n<li><strong>Export Unit with Metric Attributes<\/strong> \u2013 Enable this option if you want to export metric attributes.<\/li>\n\n\n\n<li><strong>Separate product family code from dash(-)<\/strong> \u2013 When enabled during export, the family code is split into multiple cells . for example <code>display_camera<\/code> is exported as <code>display<\/code> and <code>camera<\/code> in two cells . When disabled, the family code is exported as-is in a single cell.<\/li>\n\n\n\n<li><strong>Product Enabled Field<\/strong> \u2013 In this section, you have to enter the status name as entered in the XLSX file.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"584\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermapping-1200x584.webp\" alt=\"othermapping\" class=\"wp-image-518489\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermapping-1200x584.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermapping-300x146.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermapping-250x122.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermapping-768x374.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermapping-1536x747.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermapping.webp 1858w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>These mapping configurations ensure that the Excel sheet is generated exactly as configured, with correct header names and data for both simple products and product models.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"530\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-172-1200x530.png\" alt=\"image-172\" class=\"wp-image-344493\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-172-1200x530.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-172-300x133.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-172-250x111.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-172-768x340.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-172.png 1364w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>Note:<\/strong> While adding fields, ensure the header names are entered exactly as you want them to appear in the exported XLSX file. You can click the <strong>hint icon<\/strong> next to any field to view guidance on its usage.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Import Mapping<\/h2>\n<\/div><\/div>\n\n\n\n<p>The <strong>Import Mapping<\/strong> section is used to import product data from an XLSX file into Akeneo.<br>Before running an import job, users must <strong>add and configure XLSX fields<\/strong>, then map them with the appropriate Akeneo attributes.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"532\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-178-1200x532.png\" alt=\"image-178\" class=\"wp-image-344500\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-178-1200x532.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-178-300x133.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-178-250x111.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-178-768x340.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-178.png 1361w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Add Fields <\/h3>\n\n\n\n<p>Before importing data, you must add fields that match the <strong>header names in your XLSX file<\/strong>.<\/p>\n\n\n\n<p>While adding a field:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter the <strong>XLSX Field Header Name<\/strong> exactly as it appears in the xlsx file.<\/li>\n\n\n\n<li>Select the <strong>Product Field Value Type<\/strong><\/li>\n\n\n\n<li>Select the <strong>Product Field Format<\/strong><\/li>\n\n\n\n<li>Repeat the same steps for <strong>Variant Field<\/strong><\/li>\n\n\n\n<li>Select the <strong>Akeneo Field Type<\/strong><\/li>\n\n\n\n<li>Click <strong>Add Field<\/strong><\/li>\n\n\n\n<li>Configure both <strong>Simple Product Mapping (Common)<\/strong> and <strong>Variant Product Mapping (Optional)<\/strong> if required.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>The Akeneo Field Type you select controls same Akeneo attributes type are available for mapping.<\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"626\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importaddfield-1200x626.webp\" alt=\"importaddField\" class=\"wp-image-518537\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importaddfield-1200x626.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importaddfield-300x157.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importaddfield-250x131.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importaddfield-768x401.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importaddfield-1536x802.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importaddfield.webp 1839w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Product Field Value Types for Import<\/h3>\n\n\n\n<p>The connector supports <strong>three product field value types<\/strong> during import:<\/p>\n\n\n\n<p><strong>1. Single Attribute Field Type<\/strong><\/p>\n\n\n\n<p>Use this type when the XLSX column contains <strong>only a single value<\/strong> for one attribute.<\/p>\n\n\n\n<p><strong>Configuration steps:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select <strong>Single Attribute Field<\/strong> as the Product Field Value Type<\/li>\n\n\n\n<li>In <strong>Product Field Format<\/strong>, select <strong>Attribute Value<\/strong><\/li>\n\n\n\n<li>Select the correct <strong>Akeneo Field Type<\/strong> (e.g. Number, Text, Date)<\/li>\n<\/ul>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>XLSX Header: <code>quantity<\/code><\/li>\n\n\n\n<li>Value in XLSX: <code>50<\/code><\/li>\n\n\n\n<li>Akeneo Attribute Type: Number<\/li>\n<\/ul>\n\n\n\n<p>Repeat the same steps for <strong>Product Variant Field Value Type<\/strong>, if variant data is required.<\/p>\n\n\n\n<p>After adding the field:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Map the corresponding <strong>Akeneo attribute<\/strong> under:\n<ul class=\"wp-block-list\">\n<li><strong>Simple Product Mapping (Common)<\/strong><\/li>\n\n\n\n<li><strong>Variant Product Mapping (Optional)<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"625\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addsimpleimport-1200x625.webp\" alt=\"addsimpleimport\" class=\"wp-image-518720\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addsimpleimport-1200x625.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addsimpleimport-300x156.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addsimpleimport-250x130.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addsimpleimport-768x400.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addsimpleimport-1536x800.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/addsimpleimport.webp 1847w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"625\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importmapping-1200x625.webp\" alt=\"importmap\" class=\"wp-image-518727\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importmapping-1200x625.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importmapping-300x156.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importmapping-250x130.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importmapping-768x400.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importmapping-1536x801.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/importmapping.webp 1838w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>2. Multiple Attribute Field Type<\/strong><\/p>\n\n\n\n<p>Use this type for <strong>multi-select attributes<\/strong> that contain multiple values in one cell.<\/p>\n\n\n\n<p><strong>Configuration steps:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select <strong>Multiple Attribute Field<\/strong> as the Product Field Value Type<\/li>\n\n\n\n<li>In <strong>Product Field Format<\/strong>, select:\n<ul class=\"wp-block-list\">\n<li><strong>Separator<\/strong> and <\/li>\n\n\n\n<li><strong>Attribute Value<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>In <strong>Other Mapping<\/strong>, set:\n<ul class=\"wp-block-list\">\n<li><strong>Multiple Value Separator<\/strong> (e.g. <code>,<\/code>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>XLSX Header: <code>material<\/code><\/li>\n\n\n\n<li>XLSX Value: <code>cottton,polyster,synthetic<\/code><\/li>\n\n\n\n<li>Separator: &#8216;<code>,<\/code>&#8216;<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Note: Multi-select attributes can also be imported using the <strong>Single Attribute Field Type<\/strong>.<\/p>\n<\/blockquote>\n\n\n\n<p>After adding the field, map the relevant Akeneo multi-select attribute for simple and variant products.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"475\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/multifieldmaterialimport-1200x475.webp\" alt=\"multifieldmaterialimport.\" class=\"wp-image-518728\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/multifieldmaterialimport-1200x475.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/multifieldmaterialimport-300x119.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/multifieldmaterialimport-250x99.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/multifieldmaterialimport-768x304.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/multifieldmaterialimport-1536x608.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/multifieldmaterialimport.webp 1845w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"520\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mappingmultifield-1200x520.webp\" alt=\"mappingmultifield.\" class=\"wp-image-518729\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mappingmultifield-1200x520.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mappingmultifield-300x130.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mappingmultifield-250x108.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mappingmultifield-768x333.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mappingmultifield-1536x666.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/mappingmultifield.webp 1839w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>3. Concatenate Attribute Field Type<\/strong><\/p>\n\n\n\n<p>Use this type when <strong>multiple attributes are combined in a single XLSX column<\/strong> as key\u2013value pairs.<\/p>\n\n\n\n<p><strong>XLSX Format Example:<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ean:101010;camera_model_name:sonyA6700;max_image_resolution:1200\n<\/pre>\n\n\n\n<p><strong>Configuration steps:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select <strong>Concatenate Attribute Field<\/strong> as the Product Field Value Type<\/li>\n\n\n\n<li>In <strong>Product Field Format<\/strong>, add:\n<ul class=\"wp-block-list\">\n<li>Attribute Code<\/li>\n\n\n\n<li>Separator<\/li>\n\n\n\n<li>Attribute Value<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"448\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/concatenateimport-1200x448.webp\" alt=\"concatenateimport\" class=\"wp-image-518730\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/concatenateimport-1200x448.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/concatenateimport-300x112.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/concatenateimport-250x93.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/concatenateimport-768x287.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/concatenateimport-1536x573.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/concatenateimport.webp 1843w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"562\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/maopingconcatenateimporrt-1200x562.webp\" alt=\"maopingconcatenateimporrt\" class=\"wp-image-518731\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/maopingconcatenateimporrt-1200x562.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/maopingconcatenateimporrt-300x140.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/maopingconcatenateimporrt-250x117.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/maopingconcatenateimporrt-768x359.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/maopingconcatenateimporrt-1536x719.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/maopingconcatenateimporrt.webp 1863w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p><strong>Other Mapping configuration <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add value on field <strong>Combined Attribute Separator<\/strong> as &#8216;<code>;<\/code>&#8216;.<\/li>\n\n\n\n<li>Add value on field <strong>Attribute Value Separator<\/strong> as &#8216;<code>:<\/code>&#8216;.<\/li>\n<\/ul>\n\n\n\n<p>This tells the system how to split attribute codes and values correctly.<\/p>\n\n\n\n<p>After adding the field:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Map the respective Akeneo attributes for:\n<ul class=\"wp-block-list\">\n<li>Simple products<\/li>\n\n\n\n<li>Variant products (if applicable)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Map Akeneo Attributes<\/h3>\n\n\n\n<p>Once fields are added:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Map the corresponding <strong>Akeneo attributes<\/strong> under:\n<ul class=\"wp-block-list\">\n<li><strong>Akeneo Simple Product Mapping (Common)<\/strong><\/li>\n\n\n\n<li><strong>Akeneo Variant Product Mapping (Optional)<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Only attributes matching the selected <strong>Akeneo Field Type<\/strong> will be available for selection.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Configure Other Mapping<\/h3>\n\n\n\n<p>In the <strong>Other Mapping<\/strong> section,<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>XLSX Category Field<\/strong>: Enter the xlsx column header that contains product category.<\/li>\n\n\n\n<li><strong>Combined Attribute Separator<\/strong>: Used to separate multiple attributes in a single cell (e.g. <code>ean:red;modelName:M<\/code>).<\/li>\n\n\n\n<li><strong>Attribute Value Separator<\/strong>: Defines the separator between attribute code and its value (e.g. <code>:<\/code> in <code>ean:p011<\/code>).<\/li>\n\n\n\n<li><strong>Multiple Value Separator<\/strong>: Used to separate multiple values of the same attribute (e.g. <code>red,blue<\/code>).<\/li>\n\n\n\n<li><strong>XLSX Family Field<\/strong>: Specify the column header that contains the simple product family code.<\/li>\n\n\n\n<li><strong>Family Variant Field<\/strong>: Required for product models; enter the column header containing the family variant code.<\/li>\n\n\n\n<li><strong>XLSX Product Type Field<\/strong>: Column that defines whether the row is a simple product or a product model.<\/li>\n\n\n\n<li><strong>Simple \/ Model Product Type Value<\/strong>: Values that identify simple products and product models in the XLSX.<\/li>\n\n\n\n<li><strong>XLSX Product Enabled Field<\/strong>: Column header used to enable or disable products (<code>true\/false<\/code>).<\/li>\n\n\n\n<li><strong>Parent Code Field<\/strong>: Required for variants; enter the column header containing the parent product code.<\/li>\n\n\n\n<li><strong>Category Fields Contains Code<\/strong>: Enable this if category values in XLSX are category codes instead of labels.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"628\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermappingimport-1200x628.webp\" alt=\"othermappingimport\" class=\"wp-image-518735\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermappingimport-1200x628.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermappingimport-300x157.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermappingimport-250x131.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermappingimport-768x402.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermappingimport-1536x804.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/othermappingimport.webp 1830w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Enter XLSX header names (for field like category, family etc.) exactly as defined in the xlsx file.Configure required separators as guided by the hint icons<\/p>\n\n\n\n<p>Ensure all headers (category, family, parent, variant, enabled field, etc.) are correctly filled<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>For <strong>Concatenate field type<\/strong>, if no separator is configured, the Excel sheet must follow the default format: &#8216;<code>:<\/code>&#8216; for key\u2013value pairs and &#8216;<code>;<\/code>&#8216; to separate attribute codes.<br>The same behavior applies to <strong>Multiple Attribute field type<\/strong>\u2014by default, &#8216;<code>,<\/code>&#8216; is used for multiple values.<\/p>\n<\/blockquote>\n\n\n\n<p>Note:  Parent header is required for the import of variants, while family variant header is required for the import of product models.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"423\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-179-1200x423.png\" alt=\"image-179\" class=\"wp-image-344503\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-179-1200x423.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-179-300x106.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-179-250x88.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-179-768x271.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-179.png 1364w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Create Product<\/h3>\n<\/div><\/div>\n\n\n\n<p>For creating the product in Akeneo, you can follow our user guide.&nbsp;<a href=\"https:\/\/webkul.com\/blog\/create-product-and-product-model-in-akeneo\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create Product and Product Variant in Akeneo&nbsp;<\/a><\/p>\n\n\n\n<p>To create a product in Akeneo, go to navigate to Products then click the Create button. Now, you need to choose the product type \u2013 Product or Product Model.<\/p>\n\n\n\n<p><strong>Product<\/strong>&nbsp;\u2013 Select this type for creating simple and virtual products.<\/p>\n\n\n\n<p><strong>Product Model<\/strong>&nbsp;\u2013 Select this type for creating a configurable product with variation<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"556\" height=\"294\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx12.png\" alt=\"Akeneocustomxlsx12\" class=\"wp-image-343393\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx12.png 556w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx12-300x159.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx12-250x132.png 250w\" sizes=\"(max-width: 556px) 100vw, 556px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Now to enter the required SKU, choose a family, then click the Save button.<\/p>\n\n\n\n<p><strong>SKU<\/strong>\u2013 Fill in the product&#8217;s unique code.<\/p>\n\n\n\n<p><strong>Product Family<\/strong>&nbsp;\u2013 A family is a set of attributes that will be the same for all products belonging to a family. <\/p>\n\n\n\n<p>The product family represents product type, imposes product information structure, and defines the list of attributes for a product that it belongs to.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1007\" height=\"416\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx13.png\" alt=\"Akeneocustomxlsx13\" class=\"wp-image-343394\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx13.png 1007w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx13-300x124.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx13-250x103.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx13-768x317.png 768w\" sizes=\"(max-width: 1007px) 100vw, 1007px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Add Product Details<\/h3>\n\n\n\n<p>Now you need to provide information about the product. First, select the Channel and Locale then enter the price, name, and description.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"459\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx14-1200x459.png\" alt=\"Akeneocustomxlsx14\" class=\"wp-image-343395\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx14-1200x459.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx14-300x115.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx14-250x96.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx14-768x294.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/Akeneocustomxlsx14.png 1364w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h2 class=\"wp-block-heading index-title\">Export Profile<\/h2>\n<\/div><\/div>\n\n\n\n<p>Now to export your product data you need to create a export job profile then execute it.<\/p>\n\n\n\n<p>First, go to&nbsp;<strong>Exports&gt;Create Export Profile<\/strong>&nbsp;after that enter a unique code, the label then select a job profile.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"898\" height=\"479\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx15.png\" alt=\"akeneocustomxlsx15\" class=\"wp-image-343396\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx15.png 898w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx15-300x160.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx15-250x133.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx15-768x410.png 768w\" sizes=\"(max-width: 898px) 100vw, 898px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After that, you have to select the Job profile. for simple product export, select job type as <strong>Product export in custom XLSX<\/strong>.<\/p>\n\n\n\n<p>And for Product model export, select job type as (<strong>Product model export in custom xlsx<\/strong>).<\/p>\n\n\n\n<p>and finally click on the Save button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1856\" height=\"919\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/exportxlsxjob.webp\" alt=\"\" class=\"wp-image-518737\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/exportxlsxjob.webp 1856w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/exportxlsxjob-300x149.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/exportxlsxjob-1200x594.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/exportxlsxjob-250x124.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/exportxlsxjob-768x380.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/exportxlsxjob-1536x761.webp 1536w\" sizes=\"(max-width: 1856px) 100vw, 1856px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After clicking on the save button, you can see the export profile.<\/p>\n\n\n\n<p><strong>Properties<\/strong>:<\/p>\n\n\n\n<p>In this, you have to select the storage type and enter the file path.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-2-1200x675.png\" alt=\"Export-profile-Product-export-in-custom-XLSX-Edit-2\" class=\"wp-image-383021\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-2-1200x675.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-2-300x169.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-2-250x141.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-2-768x432.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-2.png 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Global Settings:<\/strong><\/h4>\n\n\n\n<p>In this, you have to fill in the details given below in the image like decimal separator, data formate, etc.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-1200x675.png\" alt=\"Export-profile-Product-export-in-custom-XLSX-Edit\" class=\"wp-image-383017\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-1200x675.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-300x169.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-250x141.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit-768x432.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Export-profile-Product-export-in-custom-XLSX-Edit.png 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Setup Store Template:<\/strong><\/h4>\n\n\n\n<p>In this, you can select the template, and after that click&nbsp;the <strong>Save<\/strong>&nbsp;button and follow the next step to execute this profile.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"436\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-124-1200x436.png\" alt=\"image-124\" class=\"wp-image-344242\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-124-1200x436.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-124-300x109.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-124-250x91.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-124-768x279.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-124.png 1364w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Now go to the&nbsp;<strong>Content<\/strong>&nbsp;section then select the following options:<\/p>\n\n\n\n<p><strong>Channel<\/strong>&nbsp;\u2013 Each export job can only be linked to one channel, please select the relevant channel of products to export.<\/p>\n\n\n\n<p><strong>Locales<\/strong>&nbsp;\u2013 Select one or more Locales depending on your requirements.<\/p>\n\n\n\n<p><strong>Currency \u2013&nbsp;<\/strong>You have to select here one currency.<\/p>\n\n\n\n<p><strong>Attributes<\/strong>&nbsp;\u2013 You can select which product attributes you want to export all or a few of them. Click the Edit button to select the attributes.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"644\" height=\"544\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-125.png\" alt=\"image-125\" class=\"wp-image-344244\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-125.png 644w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-125-300x253.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-125-250x211.png 250w\" sizes=\"(max-width: 644px) 100vw, 644px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Edit Attributes<\/h3>\n\n\n\n<p>To make your own attribute selection, click on the left side to select a specific attribute group (or All groups to display all attributes). <\/p>\n\n\n\n<p>The selected attributes will be displayed as columns in your export file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"458\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx21-1200x458.png\" alt=\"akeneocustomxlsx21\" class=\"wp-image-343402\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx21-1200x458.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx21-300x115.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx21-250x95.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx21-768x293.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/akeneocustomxlsx21.png 1364w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"filter-the-products\">Filter The Products<\/h3>\n\n\n\n<p>Now you need to decide which products to export an Xlsx file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"531\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-126-1200x531.png\" alt=\"image-126\" class=\"wp-image-344245\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-126-1200x531.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-126-300x133.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-126-250x111.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-126-768x340.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-126.png 1359w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Family<\/h3>\n\n\n\n<p>After that one or more product families to export in the Xlsx file. <\/p>\n\n\n\n<p>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, t-shirts.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_4-2.png\"><img decoding=\"async\" width=\"478\" height=\"97\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_4-2.png\" alt=\"Filter with family\" class=\"wp-image-106943\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_4-2.png 478w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_4-2-250x51.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_4-2-300x61.png 300w\" sizes=\"(max-width: 478px) 100vw, 478px\" loading=\"lazy\" \/><\/a><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\">Status<\/h3>\n\n\n\n<p>You can also filter on the status of your products, three options available:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_6.png\"><img decoding=\"async\" width=\"478\" height=\"235\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_6.png\" alt=\"Filter with status \" class=\"wp-image-106945\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_6.png 478w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_6-250x123.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_6-300x147.png 300w\" sizes=\"(max-width: 478px) 100vw, 478px\" loading=\"lazy\" \/><\/a><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>All \u2013 to export all products whatever their status is<\/li>\n\n\n\n<li>Enabled (default option) \u2013 only to export enabled products<\/li>\n\n\n\n<li>Disabled \u2013 to only export enabled products<\/li>\n<\/ul>\n\n\n\n<p><strong>Completeness<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_7.png\"><img decoding=\"async\" width=\"479\" height=\"278\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_7.png\" alt=\"Filter with completeness\" class=\"wp-image-106946\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_7.png 479w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_7-250x145.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_7-300x174.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" loading=\"lazy\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>This enables you to filter on the completeness of selected locales. Four options on completeness are proposed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>No condition on completeness<\/strong>&nbsp;\u2013 all products will be exported whatever their completeness is.<\/li>\n\n\n\n<li><strong>Complete on at least one selected locale (default option)<\/strong>&nbsp;\u2013 products must be complete on at least one locale<\/li>\n\n\n\n<li><strong>Not complete on all selected locales<\/strong>&nbsp;\u2013 In these products must not be complete on all locales (if you have selected more than one locale).<\/li>\n\n\n\n<li><strong>Complete on all selected locales<\/strong>&nbsp;\u2013 products must be complete on all locales (if you have selected more than one locale).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Time Condition<\/h3>\n\n\n\n<p>You can now export your product on a specific time condition.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_8.png\"><img decoding=\"async\" width=\"471\" height=\"278\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_8.png\" alt=\"Filter with time condition\" class=\"wp-image-106948\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_8.png 471w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_8-250x148.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_8-300x177.png 300w\" sizes=\"(max-width: 471px) 100vw, 471px\" loading=\"lazy\" \/><\/a><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Updated products over the last n days (e.g. 6) \u2013<\/strong>&nbsp;To filter the products that were updated during the last six days, enter 6 value.<\/li>\n\n\n\n<li><strong>No date condition (default option) \u2013<\/strong>&nbsp;Products are not filtered using time conditions.<\/li>\n\n\n\n<li><strong>Updated products since this date \u2013<\/strong>&nbsp;To filter the products that were updated during a specific date, select a date.<\/li>\n\n\n\n<li><strong>Updated products since last export \u2013<\/strong>&nbsp;It will export the product updated since the last export.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Category<\/h3>\n\n\n\n<p>You can configure the categories&nbsp;of the channel tree you want to export. For example, you want to export the clothing products to update.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_9.png\"><img decoding=\"async\" width=\"478\" height=\"93\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_9.png\" alt=\"Category\" class=\"wp-image-106952\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_9.png 478w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_9-250x49.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_9-300x58.png 300w\" sizes=\"(max-width: 478px) 100vw, 478px\" loading=\"lazy\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>By default, all categories are exported. To select a category, click n the&nbsp;<strong>Edit<\/strong>&nbsp;button the categories of the channel tree are displayed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"590\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Export-profile-Xlsx-Product-Edit-4-1200x590.png\" alt=\"Export-profile-Xlsx-Product-Edit-4\" class=\"wp-image-295007\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Export-profile-Xlsx-Product-Edit-4-1200x590.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Export-profile-Xlsx-Product-Edit-4-300x148.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Export-profile-Xlsx-Product-Edit-4-250x123.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Export-profile-Xlsx-Product-Edit-4-768x378.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/Export-profile-Xlsx-Product-Edit-4.png 1301w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Identifier<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_10.png\"><img decoding=\"async\" width=\"481\" height=\"206\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_10.png\" alt=\"Identifier\" class=\"wp-image-106955\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_10.png 481w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_10-250x107.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/12\/Screenshot_10-300x128.png 300w\" sizes=\"(max-width: 481px) 100vw, 481px\" loading=\"lazy\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>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, separated them by using comma, space, or line breaks.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"product-export\">Product Export<\/h3>\n\n\n\n<p>After creating and filtering data in the Export profile, you can see the&nbsp;<strong>Export Now<\/strong>&nbsp;button in Akeneo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"493\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-127-1200x493.png\" alt=\"image-127\" class=\"wp-image-344246\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-127-1200x493.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-127-300x123.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-127-250x103.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-127-768x315.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-127.png 1364w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Now after clicking on the <strong>Export Now<\/strong> button, Wait for the execution process to complete and check the errors.<\/p>\n\n\n\n<p>After the completion of the export job, click on <strong>Download Generated File<\/strong> .The products will appear in the Xlsx file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"474\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-128-1200x474.png\" alt=\"image-128\" class=\"wp-image-344248\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-128-1200x474.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-128-300x119.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-128-250x99.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-128-768x304.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-128.png 1361w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Import Xlsx Product<\/h3>\n<\/div><\/div>\n\n\n\n<p>Now to import your product data you need to create an import job profile and then execute it.<\/p>\n\n\n\n<p>First, go to&nbsp;<strong>Imports&gt;Create Import profile<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"477\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-129-1200x477.png\" alt=\"image-129\" class=\"wp-image-344251\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-129-1200x477.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-129-300x119.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-129-250x99.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-129-768x305.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-129.png 1361w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After that, enter a unique code, the label, then select the Job profile as required .<br>Select job type as Product import in custom XLSX <strong>(import Simple Product) <\/strong>and Product model import in custom XLSX<strong>(import product model)<\/strong>. <\/p>\n\n\n\n<p>To create an import profile, you have to click on the Save button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"917\" height=\"513\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-130.png\" alt=\"image-130\" class=\"wp-image-344252\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-130.png 917w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-130-300x168.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-130-250x140.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-130-768x430.png 768w\" sizes=\"(max-width: 917px) 100vw, 917px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"603\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/xlsximport-1200x603.webp\" alt=\"xlsximport\" class=\"wp-image-518738\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/xlsximport-1200x603.webp 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/xlsximport-300x151.webp 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/xlsximport-250x126.webp 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/xlsximport-768x386.webp 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/xlsximport-1536x772.webp 1536w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/xlsximport.webp 1839w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>After clicking on the save button, you can see the import profile.<\/p>\n\n\n\n<p><strong>Properties<\/strong>:<\/p>\n\n\n\n<p>In this, you have to select the storage type and enter the file path.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1200x675.png\" alt=\"Import-profile-Product-import-in-custom-XLSX-Edit\" class=\"wp-image-383008\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1200x675.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-300x169.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-250x141.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-768x432.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit.png 1366w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Global Settings:<\/strong><\/h4>\n\n\n\n<p>In this, you have to fill in the details given below in the image like  decimal separator, and data formate.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"585\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1-1200x585.png\" alt=\"Import-profile-Product-import-in-custom-XLSX-Edit-1\" class=\"wp-image-383009\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1-1200x585.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1-300x146.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1-250x122.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1-768x375.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-1.png 1304w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Setup Store Template:<\/strong><\/h4>\n\n\n\n<p>In this, you can select the template, and after that click&nbsp;the <strong>Save<\/strong>&nbsp;button and follow the next step to execute this profile.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"585\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-2-1200x585.png\" alt=\"Import-profile-Product-import-in-custom-XLSX-Edit-2\" class=\"wp-image-383010\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-2-1200x585.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-2-300x146.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-2-250x122.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-2-768x375.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Edit-2.png 1304w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"product-export\">Product Import<\/h3>\n\n\n\n<p>After creating and adding data to the Export profile, you can see the&nbsp;<strong>Import Now<\/strong>&nbsp;button in Akeneo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"585\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Show-1200x585.png\" alt=\"Import-profile-Product-import-in-custom-XLSX-Show\" class=\"wp-image-383012\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Show-1200x585.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Show-300x146.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Show-250x122.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Show-768x375.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Import-profile-Product-import-in-custom-XLSX-Show.png 1304w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>As well as you can add upload xlsx files for import.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"440\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-133-1200x440.png\" alt=\"image-133\" class=\"wp-image-344255\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-133-1200x440.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-133-300x110.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-133-250x92.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-133-768x282.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2022\/07\/image-133.png 1357w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<p>Now, after clicking on the<strong> Import Now<\/strong> button, wait for the execution process to complete and check the errors if they occur. After the completion of the import job, products will appear on the Products Page in Akeneo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1200\" height=\"585\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Process-tracker-Show-job-1-1200x585.png\" alt=\"Process-tracker-Show-job-1\" class=\"wp-image-383014\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Process-tracker-Show-job-1-1200x585.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Process-tracker-Show-job-1-300x146.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Process-tracker-Show-job-1-250x122.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Process-tracker-Show-job-1-768x375.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2023\/05\/Process-tracker-Show-job-1.png 1304w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" loading=\"lazy\" \/><\/figure>\n\n\n\n<div class=\"wk-index-wrap\"><div class=\"block-wrap\">\n<h3 class=\"wp-block-heading index-title\">Support<\/h3>\n<\/div><\/div>\n\n\n\n<p>That was all about the&nbsp;<strong>&nbsp;<strong>Custom Xlsx Connector for Akeneo<\/strong><\/strong>. <\/p>\n\n\n\n<p>Moreover, if you have any doubts or queries regarding the connector get back to us at&nbsp;<strong>support@webkul.com<\/strong>&nbsp;or create a ticket at our&nbsp;<a href=\"https:\/\/webkul.uvdesk.com\/en\/customer\/create-ticket\/\" target=\"_blank\" rel=\"noreferrer noopener\">HelpDesk<\/a>&nbsp;system.<\/p>\n\n\n\n<p>You can also check the&nbsp;<a href=\"https:\/\/webkul.com\/akeneo\/\" target=\"_blank\" rel=\"noreferrer noopener\">Akeneo Development Services<\/a>&nbsp;and Quality&nbsp;<a href=\"https:\/\/store.webkul.com\/Akeneo.html\" target=\"_blank\" rel=\"noreferrer noopener\">Akeneo Extensions<\/a>.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Akeneo Custom XLSX Connector enables seamless export and import of product and product model data using customizable XLSX files. It allows you to map Akeneo attributes to XLSX header columns for sharing product information with third-party platforms, suppliers, or external systems. In addition to export, the connector supports importing simple and product model. This ensures <a href=\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":273,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5709],"tags":[3649,7702,8329],"class_list":["post-294238","post","type-post","status-publish","format-standard","hentry","category-akeneo","tag-akeneo","tag-akeneo-pim","tag-akeneo-product-information-management"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import\/Export Products with Akeneo Custom XLSX Connector<\/title>\n<meta name=\"description\" content=\"Akeneo Custom XLSX Connector helps you to import\/export your online store products and product modal into a customized XLSX file.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import\/Export Products with Akeneo Custom XLSX Connector\" \/>\n<meta property=\"og:description\" content=\"Akeneo Custom XLSX Connector helps you to import\/export your online store products and product modal into a customized XLSX file.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-09T13:09:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-24T05:42:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png\" \/>\n<meta name=\"author\" content=\"Kavita Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kavita Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"25 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\"},\"author\":{\"name\":\"Kavita Singh\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1\"},\"headline\":\"User Guide for Akeneo Custom XLSX Connector\",\"datePublished\":\"2021-07-09T13:09:05+00:00\",\"dateModified\":\"2025-12-24T05:42:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\"},\"wordCount\":3220,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png\",\"keywords\":[\"Akeneo\",\"Akeneo PIM\",\"Akeneo Product Information Management\"],\"articleSection\":[\"Akeneo\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\",\"url\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\",\"name\":\"Import\/Export Products with Akeneo Custom XLSX Connector\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png\",\"datePublished\":\"2021-07-09T13:09:05+00:00\",\"dateModified\":\"2025-12-24T05:42:10+00:00\",\"description\":\"Akeneo Custom XLSX Connector helps you to import\/export your online store products and product modal into a customized XLSX file.\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png\",\"width\":1120,\"height\":294,\"caption\":\"csv-src-1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"User Guide for Akeneo Custom XLSX Connector\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1\",\"name\":\"Kavita Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"caption\":\"Kavita Singh\"},\"description\":\"Kavita, a seasoned Business Manager, drives growth in e-commerce solutions by implementing strategic management and innovative solutions, ensuring superior performance, and elevating digital commerce for exceptional results.\",\"url\":\"https:\/\/webkul.com\/blog\/author\/kavitasingh-bd984\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import\/Export Products with Akeneo Custom XLSX Connector","description":"Akeneo Custom XLSX Connector helps you to import\/export your online store products and product modal into a customized XLSX file.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/","og_locale":"en_US","og_type":"article","og_title":"Import\/Export Products with Akeneo Custom XLSX Connector","og_description":"Akeneo Custom XLSX Connector helps you to import\/export your online store products and product modal into a customized XLSX file.","og_url":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2021-07-09T13:09:05+00:00","article_modified_time":"2025-12-24T05:42:10+00:00","og_image":[{"url":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png","type":"","width":"","height":""}],"author":"Kavita Singh","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Kavita Singh","Est. reading time":"25 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/"},"author":{"name":"Kavita Singh","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1"},"headline":"User Guide for Akeneo Custom XLSX Connector","datePublished":"2021-07-09T13:09:05+00:00","dateModified":"2025-12-24T05:42:10+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/"},"wordCount":3220,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png","keywords":["Akeneo","Akeneo PIM","Akeneo Product Information Management"],"articleSection":["Akeneo"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/","url":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/","name":"Import\/Export Products with Akeneo Custom XLSX Connector","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png","datePublished":"2021-07-09T13:09:05+00:00","dateModified":"2025-12-24T05:42:10+00:00","description":"Akeneo Custom XLSX Connector helps you to import\/export your online store products and product modal into a customized XLSX file.","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/07\/csv-src-1.png","width":1120,"height":294,"caption":"csv-src-1"},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/akeneo-custom-xlsx-connector\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"User Guide for Akeneo Custom XLSX Connector"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/64d84d43c524cac89bfe9b55d0cfcee1","name":"Kavita Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/273ffe6996d44655ce6645d4b2ea5ff879f07db24c60888f32a2d611749a853e?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","caption":"Kavita Singh"},"description":"Kavita, a seasoned Business Manager, drives growth in e-commerce solutions by implementing strategic management and innovative solutions, ensuring superior performance, and elevating digital commerce for exceptional results.","url":"https:\/\/webkul.com\/blog\/author\/kavitasingh-bd984\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/294238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/273"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=294238"}],"version-history":[{"count":57,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/294238\/revisions"}],"predecessor-version":[{"id":518739,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/294238\/revisions\/518739"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=294238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=294238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=294238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}