{"id":21411,"date":"2024-05-05T16:53:20","date_gmt":"2024-05-05T14:53:20","guid":{"rendered":"https:\/\/belvg.com\/blog\/?p=21411"},"modified":"2026-05-05T08:56:55","modified_gmt":"2026-05-05T06:56:55","slug":"how-to-import-export-products-in-magento-2","status":"publish","type":"post","link":"https:\/\/belvg.com\/blog\/how-to-import-export-products-in-magento-2.html","title":{"rendered":"How to Import and Export Products in Magento 2 in 2026"},"content":{"rendered":"\n<p>Instead of adding or extracting product data one by one from the admin panel, there is a way to save time and effort by Magento product export and import with a CSV product upload sheet. Currently, there are a number of Magento modules that facilitate this process, yet in this article, I will describe the standard method of Magento 2 import and export of products.<!--more--><\/p>\n<p>You will learn how to work with product information in Magento 2, in particular, how to import and export products. Moreover, you will find the list of the most common import validation errors together with the example of import tables.<\/p>\n<p><strong>Table of contents:<\/strong><\/p>\n<p><a href=\"#step_1\">How to Get Magento 2 Export Products in CSV<br>\n<\/a><a href=\"#step_2\">How to Import Product Magento 2 in CSV<br>\n<\/a><a href=\"#step_3\">Magento 2 Import Common Validation Errors<\/a><\/p>\n\n<div class=\"request__platform\">\n    <picture>\n        <source srcset=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-srcset=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2020\/07\/small-devices-sales.jpg\" media=\"(max-width: 640px)\" class=\"lazy\"><\/source>\n        <source srcset=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-srcset=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2023\/12\/bg_request_magento.png\" media=\"(min-width: 641px)\" class=\"lazy\"><\/source>\n        <img decoding=\"async\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2023\/12\/bg_request_magento.png\" class=\"lazy\" width=\"786\" height=\"300\" loading=\"lazy\" alt=\"bg request magento\" title=\"Request block (Platform)\">\n    <\/picture>\n    <div class=\"content_part\">\n        <span class=\"title h3\"> Get a consultation from the BelVG team <\/span>\n        <span class=\"sales_after_content_text\">Contact us and we&rsquo;ll help you improve your Magento store.<\/span>\n        <a href=\"\/contact\" data-link class=\"contact_with_sales call-to-action\" target=\"_blank\">\n            Contact us        <\/a>\n    <\/div>\n<\/div>\n\n<style>.request__platform { position: relative; } .request__platform .content_part { position: absolute; top: 50%; left: 0; margin: 0 calc(var(--belvg-space__base) * 3); max-width: 50%; transform: translateY(-50%); } .request__platform img { width: 100%; object-fit: cover; } @media screen and (max-width: 640px) { .request__platform img { min-height: 250px; } .request__platform .content_part { color: var(--belvg-color__white); text-align: center; left: 50%; transform: translate(-50%, -50%); width: 100%; max-width: unset; padding: 0 var(--belvg-space__md); } } <\/style>\n\n<h2 id=\"step_1\">How to Get Magento 2 Export Products in CSV<\/h2>\n<p>Magento has a default module for importing and exporting products &ndash; <strong>Magento_CatalogImportExport<\/strong>. In addition to it, there are many modules from third-party developers that allow you to set up a more flexible import and export of products (for example, Google \/ Facebook and other product processing systems). Here is what you need to do for Magento 2 export products.<\/p>\n<p><strong>Step #1<\/strong>: Log in to the admin panel and navigate to <strong>System -&gt; Data Transfer -&gt; Export<\/strong>.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image.webp\" alt=\"image\" width=\"329\" height=\"473\" class=\"lazy aligncenter size-full wp-image-28236\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step #2<\/strong>: Select <strong>Entity Type -&gt; Products<\/strong>. Export <strong>File Format<\/strong> is available in CSV format.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-1.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-1.webp\" alt=\"image 1\" width=\"1480\" height=\"452\" class=\"lazy aligncenter size-full wp-image-28237\" title=\"Request block (Platform)\"><\/a><\/p>\n<p><strong>Step #3<\/strong>: Set <strong>Fields Enclosure<\/strong> at <strong>Checked <\/strong>to prevent the export of incorrect symbols, like equal sign, more and less characters, single and double quotes, backslashes, space characters and ampersands. The system will enclose them in double quotes to avoid data export problems.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-2.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-2.webp\" alt=\"image 2\" width=\"929\" height=\"459\" class=\"lazy aligncenter size-full wp-image-28238\" title=\"Request block (Platform)\"><\/a><\/p>\n<p><strong>Step #4<\/strong>: Set up export configurations.<\/p>\n<p>When using the Magento 2 export database, it is possible to filter products by the list of attributes. For instance, if you set up the <strong>SKU <\/strong>field at <strong>TEST<\/strong>, only products that have the word <strong>TEST<\/strong> in their <strong>SKU<\/strong> will be exported.<\/p>\n<p>You can also exclude certain attributes from export by checking the <strong>Exclude<\/strong> checkbox to the left of the name.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-3.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-3.webp\" alt=\"image 3\" width=\"1580\" height=\"517\" class=\"lazy aligncenter size-full wp-image-28239\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>Bear in mind that currently you can not make Magento export products for a certain website or store, because the platform exports all products.<\/p>\n<p><strong>Step #5<\/strong>: Press the <strong>Continue <\/strong>button and export a product CSV file.<\/p>\n\n<h2 id=\"step_2\">How to Import Product Magento 2 in CSV<\/h2>\n<p><strong>Step #1<\/strong>: Log in to the admin panel and navigate to <strong>System -&gt; Data Transfer -&gt; Import<\/strong>.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/how-to-import-magento.png\"><img decoding=\"async\" loading=\"lazy\" class=\"lazy aligncenter size-full wp-image-21456\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/how-to-import-magento.png\" alt=\"how to import magento\" width=\"498\" height=\"647\" title=\"Request block (Platform)\"><\/a><\/p>\n<p><strong>Step #2<\/strong>: In the <strong>Entity Type<\/strong> field select <strong>Products<\/strong>.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-4.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-4.webp\" alt=\"image 4\" width=\"1163\" height=\"727\" class=\"lazy aligncenter size-full wp-image-28240\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step #3<\/strong>: Create a product CSV file.<\/p>\n<p>Click <strong>Download Sample File<\/strong> to upload the sample of how to fill in the CSV product import file. Use the UTF-8 coding while creating or editing CSV file to avoid validation issues during the import.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-5.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-5.webp\" alt=\"image 5\" width=\"1492\" height=\"895\" class=\"lazy aligncenter size-full wp-image-28241\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-6.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-6.webp\" alt=\"image 6\" width=\"1841\" height=\"213\" class=\"lazy aligncenter size-full wp-image-28242\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>Magento has several scenarios of product import:<\/p>\n<ul>\n<li><strong>Add\/Update<\/strong> &ndash; Magento checks the availability of products with the specified SKU. If no match to the SKU is detected then new values are added to the product, and in case no such product exists, the system creates it.<\/li>\n<li><strong>Replace <\/strong>&ndash; product attribute values are substituted for the new ones.<\/li>\n<li><strong>Delete <\/strong>&ndash; if there is a product with a certain SKU in the import file, the product is deleted from Magento.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-7.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-7.webp\" alt=\"image 7\" width=\"1510\" height=\"891\" class=\"lazy aligncenter size-full wp-image-28243\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Moreover, Magento implements several error processing algorithms. When you use the <strong>Stop on Error<\/strong> option, any file validation error will not allow to run the import. There is a Skip error entries function allowing to specify the variety of errors you can run the import with.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-8.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-8.webp\" alt=\"image 8\" width=\"1576\" height=\"653\" class=\"lazy aligncenter size-full wp-image-28244\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>By default, Magento uses a comma to separate values in a CSV file (Field separator), yet you can specify another separator you used to create or edit an import file. Similar to this, you can set up a Multiple value separator.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-9.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-9.webp\" alt=\"image 9\" width=\"1576\" height=\"653\" class=\"lazy aligncenter size-full wp-image-28245\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>To prevent incorrect data import, like equal sign, more and less characters, single and double quotes, backslashes, space characters and ampersands, check the <strong>Fields Enclosure<\/strong>. This way Magento will add additional double quotes to prevent special symbol import.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-10.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-10.webp\" alt=\"image 10\" width=\"1538\" height=\"670\" class=\"lazy aligncenter size-full wp-image-28246\" title=\"Request block (Platform)\"><\/a><\/p>\n<p><strong>Step #4<\/strong>: Specify the CSV file in the <strong>Select File to Import<\/strong> field.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-11.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-11.webp\" alt=\"image 11\" width=\"1595\" height=\"864\" class=\"lazy aligncenter size-full wp-image-28247\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Magento allows to import files with a limited number of fields, only the required ones. If you do not need to fill in all the fields you got as a result of Magento 2 product export, specify only the required ones: sku, product_websites, product_type, attribute_set_code, categories, name, price, qty, additional_attributes.<\/p>\n\n<p>In case you need to import images as well, you need to specify the path to the folder with media files. If you import images from the local server, specify the path relative to the current Magento installation, for example, var\/media\/import_products or the standard pub\/media\/import.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-12.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-12.webp\" alt=\"image 12\" width=\"1163\" height=\"307\" class=\"lazy aligncenter size-full wp-image-28248\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>The folder should have the same image path structure as the import file (if in the import file the path is \/9\/4\/94111017_2_5.png, them physically the picture is located at var\/import\/mages\/9\/4\/94111017_2_5.png.) When you import from the cloud server, you specify the complete image address.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-13.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-13.webp\" alt=\"image 13\" width=\"1600\" height=\"816\" class=\"lazy aligncenter size-full wp-image-28249\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>When importing products, it is also possible to create the structure of categories specified in the categories field. Bear in mind that the categories must be created in accordance with the specified hierarchy, for instance if you have a value for categories field All Products \/ Main \/ Second, then Magento will create the All Products category first, then create the Main one as a child for her and after that Second as a child for Main and assign a product for these categories. If there is a parent category, then Magento will add children for her. If all categories exist, then the product will simply be added to these categories without creating new ones.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-14.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-14.webp\" alt=\"image 14\" width=\"1187\" height=\"161\" class=\"lazy aligncenter size-full wp-image-28250\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Some products require additional attributes import, for example, the ones created by the admin. During the CSV export the fields are united in a single <strong>additional_attributes<\/strong> field. Such format is not very useful for editing or adding new attributes, therefore, it is better to create separate columns for each attribute and specify their values there.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-15.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-15.webp\" alt=\"image 15\" width=\"1177\" height=\"453\" class=\"lazy aligncenter size-full wp-image-28251\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>If you want to make Magento import product groups, you need to specify SKU values in the associated_skus field, like in the example below. For configured products, fill in the <strong>configurable_variations<\/strong> fields (in the format sku=PRODUCT_SKU, attribute=value|sku=PRODUCT_SKU2, attribute=value2) and configurable_variation_labels). Similarly, specify the values for bundle items in the <strong>bundle_values<\/strong> field.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-16.webp\" alt=\"image 16\" width=\"1179\" height=\"658\" class=\"lazy aligncenter size-full wp-image-28252\" title=\"Request block (Platform)\"><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-17.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-17.webp\" alt=\"image 17\" width=\"1191\" height=\"189\" class=\"lazy aligncenter size-full wp-image-28253\" title=\"Request block (Platform)\"><\/a><\/p>\n<p><strong>Step #5<\/strong>: Press <strong>Check Data<\/strong> to validate the import file.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-18.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-18.webp\" alt=\"image 18\" width=\"1600\" height=\"792\" class=\"lazy aligncenter size-full wp-image-28254\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step #6<\/strong>: In case there are no errors or they are included into <strong>Allowed Errors Count<\/strong>, you can import Magento CSV product file.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-19.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-19.webp\" alt=\"image 19\" width=\"1232\" height=\"545\" class=\"lazy aligncenter size-full wp-image-28255\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-20.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-20.webp\" alt=\"image 20\" width=\"1193\" height=\"717\" class=\"lazy aligncenter size-full wp-image-28256\" title=\"Request block (Platform)\"><\/a><\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-21.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-21.webp\" alt=\"image 21\" width=\"1193\" height=\"544\" class=\"lazy aligncenter size-full wp-image-28257\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-22.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-22.webp\" alt=\"image 22\" width=\"1188\" height=\"565\" class=\"lazy aligncenter size-full wp-image-28258\" title=\"Request block (Platform)\"><\/a><\/p>\n<h2 id=\"step_3\">Magento 2 Import Common Validation Errors<\/h2>\n<p>1.<strong>Incorrect value of the select fields<\/strong>. To resolve it, find the values of the attribute at <strong>Stores -&gt; Attributes -&gt; Product<\/strong> and compare with the ones specified in the CSV file.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-23.webp\" alt=\"image 23\" width=\"1168\" height=\"355\" class=\"lazy aligncenter size-full wp-image-28259\" title=\"Request block (Platform)\"><\/p>\n<p>&nbsp;<\/p>\n<p>2. <strong>Images loading errors<\/strong>. The reason may lie in the physical absence of images at the server (in the specified Images File Directory folder), or in incorrect rights for the files and folders, or in the incorrect path.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-24.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-24.webp\" alt=\"image 24\" width=\"1187\" height=\"416\" class=\"lazy aligncenter size-full wp-image-28260\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>3. <strong>Different number of fields and product info<\/strong>. This happens because Magento processed the CSV file incorrectly. Check the separators and double quotes in the CSV file and if some of them are absent, add the missing signs.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-25.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-25.webp\" alt=\"image 25\" width=\"1187\" height=\"421\" class=\"lazy aligncenter size-full wp-image-28261\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>4. <strong>Errors with URL Rewrites<\/strong>. This error occurs when another product has the same URL rewrite as we try to import or other custom URL rewrite. The solution is to add any postfix into the import file or delete the conflicting URL Rewrite.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-26.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-26.webp\" alt=\"image 26\" width=\"1173\" height=\"378\" class=\"lazy aligncenter size-full wp-image-28262\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>5. <strong>Incorrect product_type<\/strong>. One of the reasons the issue occurs is the use of third-party modules for defining new product types or incorrect values in the <strong>product_type<\/strong> field. The solution is to check the data in the import file or install a third-party module that this type of product adds (if not installed).<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-27.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-27.webp\" alt=\"image 27\" width=\"1168\" height=\"291\" class=\"lazy aligncenter size-full wp-image-28263\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>6. <strong>Incorrect visibility<\/strong>. The reason for it is using invalid values for the visibility field. The solution is to use standard Magento text values (Not Visible Individually =&gt; 1 \/ Catalog =&gt; 2 \/ Search =&gt; 3 \/ Catalog, Search =&gt; 4).<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-28.webp\" alt=\"image 28\" width=\"1208\" height=\"348\" class=\"lazy aligncenter size-full wp-image-28264\" title=\"Request block (Platform)\"><\/p>\n<p>&nbsp;<\/p>\n<p>7. <strong>Incorrect store<\/strong>. Occurs due to the absence of the configured store or an error in the field data. The solution is to check if this store exists and create the store if it does not. Moreover, check whether the values of field and store identifier values correspond.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-29.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-29.webp\" alt=\"image 29\" width=\"1200\" height=\"425\" class=\"lazy aligncenter size-full wp-image-28265\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>8. <strong>Incorrect separator or format<\/strong>. The error occurs when the file is created with the separators different from the ones specified in the import. The solution is to check what separator is in the CSV file and specify the same in the import configuration.<\/p>\n<p><a href=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-30.webp\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/belvg.com\/wp-content\/uploads\/2019\/06\/pixel.png\" data-src=\"https:\/\/belvg.com\/blog\/wp-content\/uploads\/2019\/04\/image-30.webp\" alt=\"image 30\" width=\"1180\" height=\"197\" class=\"lazy aligncenter size-full wp-image-28266\" title=\"Request block (Platform)\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>Wrapping it up<\/h2>\n<p>Working with CSV import and export in Magento 2 is a fast way to manage large product catalogs. When done correctly, it keeps your data consistent and saves hours of manual work.<\/p>\n<p><strong>Here are the key points to keep in mind:<\/strong><\/p>\n<ul>\n<li>CSV import\/export saves time and reduces manual mistakes.<\/li>\n<li>A clean file structure (UTF-8, correct separators, proper formatting) prevents most errors.<\/li>\n<li>SKU is the key field, so it must stay accurate and consistent.<\/li>\n<li>File validation helps catch issues before they affect the catalog.<\/li>\n<li>Import modes (Add\/Update, Replace, Delete) should match your task.<\/li>\n<li>Start with a small test import to avoid large-scale issues.<\/li>\n<\/ul>\n<p>If you are looking for a functional Magento extension, go to <a href=\"\/\/store.belvg.com\/\">https:\/\/store.belvg.com\/<\/a>.<\/p>\n<div class=\"acf-field acf-field-message acf-field-656de52505dd5\">\n<div class=\"acf-input\">\n\n<div class=\"after_content__request\" style=\"background-color:\">\n    <div class=\"content_part\">\n        <span class=\"title h3\">\n                    <\/span>\n        <span class=\"sales_after_content_text\">\n                    <\/span>\n        <a href=\"https:\/\/belvg.com\/contact?utm_source=blog&amp;utm_campaign=request_&amp;utm_content=bottom%20\" data-link class=\"contact_with_sales call-to-action\" target=\"_blank\">\n             Get started <\/a>\n    <\/div>\n<\/div>\n\n<style>.after_content__request .title { margin-bottom: var(--belvg-space__md); } .after_content__request .content_part { margin: 0; padding: var(--belvg-space__2xl) clamp(var(--belvg-space__md), 10vw, 100px); justify-content: center; text-align: center; } <\/style>\n\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"Instead of adding or extracting product data one by one from the admin panel, there &#8230;","protected":false},"author":42,"featured_media":29204,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[14,491,389,471,546],"tags":[],"class_list":["post-21411","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento","category-magento-2","category-magento2-development","category-magento-developer","category-magento-warehouse-integration"],"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/belvg.com\/blog\/?custom_blocks=request-block-platform\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/?custom_blocks=request-block-platform#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/belvg.com\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/category\\\/magento#listItem\",\"name\":\"Magento\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/category\\\/magento#listItem\",\"position\":2,\"name\":\"Magento\",\"item\":\"https:\\\/\\\/belvg.com\\\/blog\\\/category\\\/magento\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/how-to-import-export-products-in-magento-2.html#listItem\",\"name\":\"How to Import and Export Products in Magento 2 in 2026\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/how-to-import-export-products-in-magento-2.html#listItem\",\"position\":3,\"name\":\"How to Import and Export Products in Magento 2 in 2026\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/category\\\/magento#listItem\",\"name\":\"Magento\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/#organization\",\"name\":\"BelVG Blog\",\"description\":\"Magento and Prestashop articles\",\"url\":\"https:\\\/\\\/belvg.com\\\/blog\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/?custom_blocks=request-block-platform#webpage\",\"url\":\"https:\\\/\\\/belvg.com\\\/blog\\\/?custom_blocks=request-block-platform\",\"name\":\"Request block (Platform) | BelVG Blog\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/?custom_blocks=request-block-platform#breadcrumblist\"},\"datePublished\":\"2023-12-01T17:48:24+02:00\",\"dateModified\":\"2023-12-04T19:12:57+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/belvg.com\\\/blog\\\/\",\"name\":\"BelVG Blog\",\"description\":\"Magento and Prestashop articles\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/belvg.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Request block (Platform) | BelVG Blog","description":"","canonical_url":"https:\/\/belvg.com\/blog\/?custom_blocks=request-block-platform","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/belvg.com\/blog\/?custom_blocks=request-block-platform#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/belvg.com\/blog\/#listItem","position":1,"name":"Home","item":"https:\/\/belvg.com\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/belvg.com\/blog\/category\/magento#listItem","name":"Magento"}},{"@type":"ListItem","@id":"https:\/\/belvg.com\/blog\/category\/magento#listItem","position":2,"name":"Magento","item":"https:\/\/belvg.com\/blog\/category\/magento","nextItem":{"@type":"ListItem","@id":"https:\/\/belvg.com\/blog\/how-to-import-export-products-in-magento-2.html#listItem","name":"How to Import and Export Products in Magento 2 in 2026"},"previousItem":{"@type":"ListItem","@id":"https:\/\/belvg.com\/blog\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/belvg.com\/blog\/how-to-import-export-products-in-magento-2.html#listItem","position":3,"name":"How to Import and Export Products in Magento 2 in 2026","previousItem":{"@type":"ListItem","@id":"https:\/\/belvg.com\/blog\/category\/magento#listItem","name":"Magento"}}]},{"@type":"Organization","@id":"https:\/\/belvg.com\/blog\/#organization","name":"BelVG Blog","description":"Magento and Prestashop articles","url":"https:\/\/belvg.com\/blog\/"},{"@type":"WebPage","@id":"https:\/\/belvg.com\/blog\/?custom_blocks=request-block-platform#webpage","url":"https:\/\/belvg.com\/blog\/?custom_blocks=request-block-platform","name":"Request block (Platform) | BelVG Blog","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/belvg.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/belvg.com\/blog\/?custom_blocks=request-block-platform#breadcrumblist"},"datePublished":"2023-12-01T17:48:24+02:00","dateModified":"2023-12-04T19:12:57+02:00"},{"@type":"WebSite","@id":"https:\/\/belvg.com\/blog\/#website","url":"https:\/\/belvg.com\/blog\/","name":"BelVG Blog","description":"Magento and Prestashop articles","inLanguage":"en-US","publisher":{"@id":"https:\/\/belvg.com\/blog\/#organization"}}]}},"aioseo_meta_data":{"post_id":"21411","title":"2026 Magento 2 Import &amp; Export of Items in CSV | #site_title","description":"Find out how to import and export products in Magento 2: standard export &amp; import, CSV files and others in the step-by-step user guide.","keywords":null,"keyphrases":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-11-03 18:36:49","updated":"2026-11-03 18:36:49"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/belvg.com\/blog\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/belvg.com\/blog\/category\/magento\" title=\"Magento\">Magento<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to Import and Export Products in Magento 2 in 2026\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/belvg.com\/blog\/"},{"label":"Magento","link":"https:\/\/belvg.com\/blog\/category\/magento"},{"label":"How to Import and Export Products in Magento 2 in 2026","link":"https:\/\/belvg.com\/blog\/how-to-import-export-products-in-magento-2.html"}],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/posts\/21411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/comments?post=21411"}],"version-history":[{"count":21,"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/posts\/21411\/revisions"}],"predecessor-version":[{"id":30513,"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/posts\/21411\/revisions\/30513"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/media\/29204"}],"wp:attachment":[{"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/media?parent=21411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/categories?post=21411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/belvg.com\/blog\/wp-json\/wp\/v2\/tags?post=21411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}