{"id":265,"date":"2018-12-17T12:37:51","date_gmt":"2018-12-17T12:37:51","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/2018\/12\/17\/import-products-in-magento-2\/"},"modified":"2025-07-22T16:46:20","modified_gmt":"2025-07-22T11:16:20","slug":"import-products-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/import-products-in-magento-2\/","title":{"rendered":"How to Import Products in Magento 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Do you own a Magento 2 store with a large number of products? Do you wish to add a large database related to the products in your backend? Do you want to update the products data? And, are you lazy just like me?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Look no more, because this post is for you! Get the time-saving method that helps import products in Magento 2.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Magento 2 Import Products CSV: an easy solution to save you from going through all the troubles of managing a large database of products in the backend!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Follow the stepwise method given below and you&#8217;re done<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Method to Import Products in Magento 2:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1. Login to <strong>Admin Panel<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Navigate to<strong> System &gt; Import.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2018\/12\/import-products-in-magento.png\" alt=\"Magento 2 Admin panel with browsing product import option\" class=\"wp-image-64272\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. Select <strong>Products<\/strong> in the<strong> Entity Type<\/strong> drop-down and click Download Sample File.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2018\/12\/2_Import-Settings-1024x404.png\" alt=\"2_Import-Settings\" class=\"wp-image-3931\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4. You&#8217;ll get the CSV file like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2018\/12\/3_CSV-File-Sample-1024x126.png\" alt=\"3_CSV File Sample\" class=\"wp-image-3933\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2018\/12\/3_Add_Update.png\" alt=\"4_Add_Update\" class=\"wp-image-3932\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">8. Select the <strong>Choose file<\/strong>&nbsp;option and type <strong>\/pub\/media\/import<\/strong>&nbsp;in the <strong>Image File Directory<\/strong>&nbsp;text field. Then choose the <strong>Check Data<\/strong>&nbsp;option.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">9. After receiving the validation results notification, click <strong>Import<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">10. When the product import is finished go to <strong>Catalog &gt; Products <\/strong>and check the products with the images are displayed on the product grid. Don\u2019t forget to make the products live in-store &#8211;&nbsp;<strong>Enable Product Toggle<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2018\/12\/5_Enable-product-1024x469.png\" alt=\"5_Enable product\" class=\"wp-image-3934\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">11. You can manage all the import and export activities from the <strong>Import History<\/strong> tab. For that, navigate to <strong>System&gt;Data Transfer&gt;Import History.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2018\/12\/6_Import-History-1024x276.png\" alt=\"6_Import History\" class=\"wp-image-3935\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to import products with images in bulk, delete all the sample products from the CSV file and insert your own ones with all the attribute details.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With the help of this tutorial, one should be able to import products in Magento 2 easily!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can also refer to the video tutorial to Import Products in Magento 2 from our <a href=\"https:\/\/www.youtube.com\/playlist?list=PLBTOxSAJzwEjM5MilmEqj98Ib80tKBu7r\" target=\"_blank\" rel=\"noreferrer noopener\">Magento 2 video tutorial<\/a> series:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to Import Products in Magento 2\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/7gzQg7baWCI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you own a Magento 2 store with a large number of products? Do you wish to add a large database related to the products in your backend? Do you want to update the products data? And, are you lazy just like me? Look no more, because this post is for you! Get the time-saving [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"class_list":["post-265","post","type-post","status-publish","format-standard","hentry","category-magento"],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=265"}],"version-history":[{"count":3,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/265\/revisions"}],"predecessor-version":[{"id":15544,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/265\/revisions\/15544"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}