{"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&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-265","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_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}]}}