{"id":258020,"date":"2020-07-17T08:01:48","date_gmt":"2020-07-17T08:01:48","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=258020"},"modified":"2022-03-22T09:52:55","modified_gmt":"2022-03-22T09:52:55","slug":"pimcore-custom-xlsx-import","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/","title":{"rendered":"Pimcore Custom XLSX Import"},"content":{"rendered":"\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Introduction<\/h3><\/div>\n\n\n\n<p>With the <a href=\"https:\/\/webkul.com\/pimcore-development\/\">Pimcore<\/a> Custom XLSX import plugin, the user can import the product, categories, Brand, and Manufacturer using an XLSX file. The plugin allows the user to create the custom mapping of their XLSX file with the Pimcore Data Objects. <\/p>\n\n\n\n<p>In the past, most of the eCommerce companies were managing their product catalog using CSV\/XLSX file but now most of them are moving towards PIM because it is easier to manage the product information with the PIM at a single place. <\/p>\n\n\n\n<p>Now in the PIM, it is also easier to make the integration with third-party eCommerce platforms, ERP systems, POS, and Print Catalog. In the Pimcore XLSX import, you can create custom mapping and import the products feed.<\/p>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Basic Requirements<\/h3><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>This module works with Pimcore 5.5.x, 5.6.x, and 6.x.<\/li><\/ul>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Features<\/h3><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Import Products using XLSX file<\/li><li>Object configuration for the product, categories, attributes, manufactures, and brands<\/li><li>Configuration for the import<\/li><li>Import Categories with XLSX file<\/li><li>Import manufactures and Brands <\/li><li>Create and save the mapping templates<\/li><li>Map XLSX fields with Pimcore Objects<\/li><\/ul>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Module Installation<\/h3><\/div>\n\n\n\n<p>Please follow these steps for installing the&nbsp;Pimcore&nbsp;XLSX Module in Pimcore:<\/p>\n\n\n\n<p>1 &#8211; Download the zip file of our Pimcore XLSX Module then merge the src folder with the src folder available at the root in the Pimcore project directory.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png\" alt=\"Merge the src folder to Pimcore installation directory\" class=\"wp-image-259255\" width=\"747\" height=\"246\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-300x99.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-250x83.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-768x254.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx.png 1223w\" sizes=\"(max-width: 747px) 100vw, 747px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<p>2 &#8211; After uploading the zip, you have to go to your Pimcore admin panel then navigate&nbsp;<strong>Tools<\/strong>&nbsp;-&gt;&nbsp;<strong>Extensions<\/strong>. In the extension list, you will get the \u201c<strong>WebkulImporterBundle<\/strong>\u201c.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-85.png\" alt=\"Install the Pimcore XLSX Connector\" class=\"wp-image-259261\" width=\"710\" height=\"365\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-85.png 1147w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-85-300x155.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-85-250x129.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-85-768x396.png 768w\" sizes=\"(max-width: 710px) 100vw, 710px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<p>3 &#8211; By clicking on the \u201c<strong>+<\/strong>\u201d icon, you can install the connector. After that, you can see the installed connector on the extension list.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-86.png\" alt=\"Click on the icon to install the connector\" class=\"wp-image-259264\" width=\"648\" height=\"372\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-86.png 1029w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-86-300x173.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-86-250x144.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-86-768x442.png 768w\" sizes=\"(max-width: 648px) 100vw, 648px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<p>4 &#8211; After installation, you can click on the button\u201d<strong>Clear cache and reload<\/strong>\u201d to clear the cache and reload the Pimcore server.<\/p>\n\n\n\n<p>5 &#8211; You can see the installed plugin in the menu bar.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-88.png\" alt=\"Pimcore XLSX connector installed\" class=\"wp-image-259266\" width=\"725\" height=\"410\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-88.png 1115w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-88-300x170.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-88-250x141.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-88-768x435.png 768w\" sizes=\"(max-width: 725px) 100vw, 725px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Module Configuration<\/h3><\/div>\n\n\n\n<p>After installing the Pimcore XLSX import connector, the user will get two option.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Configuration<\/li><li>Import<\/li><\/ul>\n\n\n\n<p>Here the admin can make the configuration to import the Product, Category, Attribute, Manufacturer, and Brand. The user can map the <a href=\"https:\/\/webkul.com\/blog\/data-objects-in-pimcore\/\" target=\"_blank\" aria-label=\"undefined (opens in a new tab)\" rel=\"noreferrer noopener\">object<\/a> with the Pimcore.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-89-1200x587.png\" alt=\"Configuration in Pimcore XLSX Import Connector\" class=\"wp-image-259379\" width=\"648\" height=\"317\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-89-1200x587.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-89-300x147.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-89-250x122.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-89-768x376.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-89.png 1298w\" sizes=\"(max-width: 648px) 100vw, 648px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Import Configuration<\/h3><\/div>\n\n\n\n<p>The user can click on the &#8220;<strong>Import<\/strong>&#8221; for making the import configuration and importing the XLSX file. After click on the &#8220;<strong>Import<\/strong>&#8220;, the user will get two options. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What are you importing? <\/h3>\n\n\n\n<p>In this option, the users can map the object that they are going to import. They can map the <a href=\"https:\/\/webkul.com\/blog\/how-to-add-product-in-pimcore\/\" target=\"_blank\" aria-label=\"undefined (opens in a new tab)\" rel=\"noreferrer noopener\">Product<\/a>, Category, Attribute, Manufacturer, and Brand in this field.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-90-1200x593.png\" alt=\"import configuration in Pimcore XLSX Import Connector\" class=\"wp-image-259391\" width=\"624\" height=\"308\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-90-1200x593.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-90-300x148.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-90-250x123.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-90-768x379.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-90.png 1296w\" sizes=\"(max-width: 624px) 100vw, 624px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">File<\/h3>\n\n\n\n<p>In this section, the user can upload the XLSX file that he\/she want to import in the Pimcore. The user can click on the &#8220;<strong>Browse<\/strong>&#8221; to select the file. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-91-1200x593.png\" alt=\"upload the file in Pimcore XLSX Import Connector\" class=\"wp-image-259392\" width=\"656\" height=\"324\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-91-1200x593.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-91-300x148.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-91-250x123.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-91-768x379.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-91.png 1296w\" sizes=\"(max-width: 656px) 100vw, 656px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<p>After uploading the files, the user can click on the &#8220;<strong>Proceed<\/strong>&#8221; button for the next process. Now a new section will be open for the &#8220;<strong>Existing Mapping<\/strong>&#8221; and &#8220;Import Panel&#8221; where the user can map the XLSX fields with Pimcore Object and save the mapping for future use. <\/p>\n\n\n\n<p>In the Import Panel, after object mapping with the XLSX fields, the user can click on the &#8220;<strong>Save Mapping<\/strong>&#8221; button. A new pop-up window will be open and where the user can put the new mapping name. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-94-1200x593.png\" alt=\"image-94\" class=\"wp-image-259399\" width=\"729\" height=\"360\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-94-1200x593.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-94-300x148.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-94-250x123.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-94-768x379.png 768w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/image-94.png 1296w\" sizes=\"(max-width: 729px) 100vw, 729px\" loading=\"lazy\" \/><\/figure><\/div>\n\n\n\n<p>In this process, the user doesn&#8217;t have to create the mapping again and again for the existing XLSX file. The user can use the already created mapping.<\/p>\n\n\n\n<p>After completing the mapping setup, the user can click on the &#8220;<strong>Import<\/strong>&#8221; button to import the products from XLSX into Pimcore. <\/p>\n\n\n\n<div class=\"wk-index-wrap\"><h3 class=\"index-title\">Support<\/h3><\/div>\n\n\n\n<p>That&#8217;s all about the Pimcore XLSX Import Connector. <\/p>\n\n\n\n<p>I hope you have enjoyed this article. For any query in Pimcore, you can send us an email at&nbsp;<a href=\"mailto:support@webkul.com\" target=\"_blank\" rel=\"noreferrer noopener\">support@webkul.com<\/a>. Please let me know if you want to discuss your Pimcore project, you can ping us anytime at our skype:&nbsp;<a rel=\"noreferrer noopener\" target=\"_blank\" href=\"https:\/\/bit.ly\/Akeneo-Shopware-Pimcore\">https:\/\/bit.ly\/Akeneo-Shopware-Pimcore<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the Pimcore Custom XLSX import plugin, the user can import the product, categories, Brand, and Manufacturer using an XLSX file. The plugin allows the user to create the custom mapping of their XLSX file with the Pimcore Data Objects. In the past, most of the eCommerce companies were managing their product catalog using CSV\/XLSX <a href=\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":219,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8189],"tags":[6234,8201,8486,8202,8203],"class_list":["post-258020","post","type-post","status-publish","format-standard","hentry","category-pimcore","tag-import-products","tag-pimcore","tag-pimcore-connector","tag-pimcore-pim","tag-pimcore-product-information-management"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pimcore Custom XLSX Import | PIM Customized Data Extension<\/title>\n<meta name=\"description\" content=\"With the Pimcore Custom XLSX Import, the user can create the mapping for XLSX files and import the Product and Category.\" \/>\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\/pimcore-custom-xlsx-import\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pimcore Custom XLSX Import | PIM Customized Data Extension\" \/>\n<meta property=\"og:description\" content=\"With the Pimcore Custom XLSX Import, the user can create the mapping for XLSX files and import the Product and Category.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/\" \/>\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=\"2020-07-17T08:01:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-22T09:52:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png\" \/>\n<meta name=\"author\" content=\"Adarsh Shukla\" \/>\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=\"Adarsh Shukla\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/\"},\"author\":{\"name\":\"Adarsh Shukla\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/24b3f1db9e67779ee3db881cae1ecbb5\"},\"headline\":\"Pimcore Custom XLSX Import\",\"datePublished\":\"2020-07-17T08:01:48+00:00\",\"dateModified\":\"2022-03-22T09:52:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/\"},\"wordCount\":633,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png\",\"keywords\":[\"Import Products\",\"Pimcore\",\"Pimcore connector\",\"Pimcore PIM\",\"Pimcore Product Information management\"],\"articleSection\":[\"PimCore\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/\",\"url\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/\",\"name\":\"Pimcore Custom XLSX Import | PIM Customized Data Extension\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png\",\"datePublished\":\"2020-07-17T08:01:48+00:00\",\"dateModified\":\"2022-03-22T09:52:55+00:00\",\"description\":\"With the Pimcore Custom XLSX Import, the user can create the mapping for XLSX files and import the Product and Category.\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx.png\",\"width\":1223,\"height\":404,\"caption\":\"pimcore-xlsx\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pimcore Custom XLSX Import\"}]},{\"@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\/24b3f1db9e67779ee3db881cae1ecbb5\",\"name\":\"Adarsh Shukla\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb1b01aa3e81f8e9c96f2a73887e0dc95e47f085c0b41c5dfeeae1b6849850ee?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fb1b01aa3e81f8e9c96f2a73887e0dc95e47f085c0b41c5dfeeae1b6849850ee?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"caption\":\"Adarsh Shukla\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/adarshshukla-bd370\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pimcore Custom XLSX Import | PIM Customized Data Extension","description":"With the Pimcore Custom XLSX Import, the user can create the mapping for XLSX files and import the Product and Category.","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\/pimcore-custom-xlsx-import\/","og_locale":"en_US","og_type":"article","og_title":"Pimcore Custom XLSX Import | PIM Customized Data Extension","og_description":"With the Pimcore Custom XLSX Import, the user can create the mapping for XLSX files and import the Product and Category.","og_url":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2020-07-17T08:01:48+00:00","article_modified_time":"2022-03-22T09:52:55+00:00","og_image":[{"url":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png","type":"","width":"","height":""}],"author":"Adarsh Shukla","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Adarsh Shukla","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/"},"author":{"name":"Adarsh Shukla","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/24b3f1db9e67779ee3db881cae1ecbb5"},"headline":"Pimcore Custom XLSX Import","datePublished":"2020-07-17T08:01:48+00:00","dateModified":"2022-03-22T09:52:55+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/"},"wordCount":633,"commentCount":2,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png","keywords":["Import Products","Pimcore","Pimcore connector","Pimcore PIM","Pimcore Product Information management"],"articleSection":["PimCore"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/","url":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/","name":"Pimcore Custom XLSX Import | PIM Customized Data Extension","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage"},"thumbnailUrl":"https:\/\/webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx-1200x396.png","datePublished":"2020-07-17T08:01:48+00:00","dateModified":"2022-03-22T09:52:55+00:00","description":"With the Pimcore Custom XLSX Import, the user can create the mapping for XLSX files and import the Product and Category.","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2020\/07\/pimcore-xlsx.png","width":1223,"height":404,"caption":"pimcore-xlsx"},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/pimcore-custom-xlsx-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Pimcore Custom XLSX Import"}]},{"@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\/24b3f1db9e67779ee3db881cae1ecbb5","name":"Adarsh Shukla","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fb1b01aa3e81f8e9c96f2a73887e0dc95e47f085c0b41c5dfeeae1b6849850ee?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fb1b01aa3e81f8e9c96f2a73887e0dc95e47f085c0b41c5dfeeae1b6849850ee?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","caption":"Adarsh Shukla"},"url":"https:\/\/webkul.com\/blog\/author\/adarshshukla-bd370\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/258020","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\/219"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=258020"}],"version-history":[{"count":18,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/258020\/revisions"}],"predecessor-version":[{"id":325748,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/258020\/revisions\/325748"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=258020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=258020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=258020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}