{"id":172,"date":"2011-02-17T10:24:24","date_gmt":"2011-02-17T10:24:24","guid":{"rendered":"http:\/\/webkul.com\/blog\/?p=172"},"modified":"2017-05-19T15:07:26","modified_gmt":"2017-05-19T15:07:26","slug":"how-to-import-csv-into-magento","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/","title":{"rendered":"How to Import CSV into Magento"},"content":{"rendered":"

This is very common question in magento that how to import csv files in magento .so lets start<\/p>\n

1-login to your admin panel and go to system->import\/export->profiles.<\/p>\n

2-Now click on the import all product .<\/p>\n

3-choose upload file and select your CSV file and press continue and edit .<\/p>\n

4-After that click on the “Run Profile” and select the imported file .<\/p>\n

5-finally click on the run profile in Popup simple hunhh but the main problem came when your CSV doesn’t match with the magento CSV format for that purpose procedure is as below<\/p>\n

Step 1 \u2013 Add a new product manually<\/strong><\/p>\n

Add a new product manually to the catalog, assign it to a category, and fill out all fields that will be necessary to your store. The obvious ones are price, description, quantity etc. It\u2019s important that you fill out all fields that you know you are going to need for all the products you import.<\/p>\n

Step 2 \u2013 Export Your Products<\/strong><\/p>\n

Now we want to export your product to a .csv file so that we can view the fields that are required to import. Go to System >> Import\/Export >> Profiles. Now click on Export All Products then Run Profile. Click on the \u201cRun Profile in Popup\u201d button. Once the export is completed, go to your var\/export directory on your Magento install and you will find the .csv file there for you to download.<\/p>\n

Step 3 \u2013 Analyze The .CSV File<\/strong><\/p>\n

Now if you look at your .csv export file you will see the field names that you need to match up. Now just start filling yours in and creating your csv file ready for import. This step is extremely important. Otherwise Magento cannot match what you are trying to import and the importing will fail. At a most basic level, here are the fields that I imported:<\/p>\n

    \n
  1. store<\/li>\n
  2. attribute_set<\/li>\n
  3. type<\/li>\n
  4. sku<\/li>\n
  5. category_ids<\/li>\n
  6. status<\/li>\n
  7. visibility<\/li>\n
  8. tax_class_id<\/li>\n
  9. weight<\/li>\n
  10. price<\/li>\n
  11. name<\/li>\n
  12. description<\/li>\n<\/ol>\n

    Step 4 \u2013 Import Your New .CSV File<\/strong><\/p>\n

    Now go to System >> Import\/Export >> Profiles. Now click on Import All Products. Change \u201cType\u201d under Data Format to CSV\/Tab Seperated. Now click on Upload File, and browse for your .csv file and click \u201cSave and Continue Editing\u201d. Now go to \u201cRun Profile\u201d and select your file from the dropdown menu. Click the button underneath to run the import.<\/p>\n

    We are not done yet on Magento there is still a lot on Magento this is just a start . Thanks for enjoying this article ,If you have any question or suggestion please drop a mail in our mailbox or just comment on the post . enjoy \ud83d\ude09<\/p>\n

    WebKul<\/a><\/p>\n

    Related Links :<\/strong><\/p>\n

    1 – http:\/\/webkul.com\/magento-tutorial<\/a><\/p>\n

    2- http:\/\/webkul.com\/magento-tutorial\/magento<\/a><\/p>\n

    3 – http:\/\/webkul.com\/magento-tutorial\/nginx-in-magento <\/a><\/p>\n

    4 – http:\/\/webkul.com\/magento-tutorial\/magento-in-localhost<\/a><\/p>\n

    5 – http:\/\/webkul.com\/magento-tutorial\/how-to-import-csv-into-magento<\/a><\/p>\n

    6 – http:\/\/webkul.com\/magento-tutorial\/method-varien-object-tostring-cannot-take-arguments-in-magento<\/a><\/p>\n

    1 –\u00a0http:\/\/webkul.com\/psd-to-joomla-services<\/a>
    \n2 –\u00a0    http:\/\/webkul.com\/html-to-joomla-services<\/a>
    \n3 –\u00a0    http:\/\/webkul.com\/joomla-tutorial\/how-site-optimization-helps-in-seo-search-engine-optimization<\/a>
    \n4 –\u00a0    http:\/\/webkul.com\/joomla-tutorial\/joomla-web-services-and-extension-module-component-plugins-development-concept<\/a>
    \n5 –\u00a0    http:\/\/webkul.com\/joomla-tutorial\/easy-tips-to-improve-your-google-rank-with-joomla<\/a>
    \n6 –\u00a0    http:\/\/webkul.com\/joomla-tutorial\/how-to-add-xmap-sitemap-in-google-webmaster-tool<\/a>
    \n7- \u00a0    http:\/\/webkul.com\/kunena\/search-engine-optimization-seo\/joomla-seo<\/a>
    \n8 –    http:\/\/webkul.com\/joomla-seo-services<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    This is very common question in magento that how to import csv files in magento .so lets start 1-login to your admin panel and go to system->import\/export->profiles. 2-Now click on the import all product . 3-choose upload file and select your CSV file and press continue and edit . 4-After that click on the “Run […]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-172","post","type-post","status-publish","format-standard","hentry","category-magento"],"yoast_head":"\nHow to Import CSV into Magento - Webkul Blog<\/title>\n<meta name=\"description\" content=\"There's a little confusion among some on how to import products into a Magento ecommerce store. I spent some time today researching and trying to find the best\" \/>\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\/how-to-import-csv-into-magento\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Import CSV into Magento - Webkul Blog\" \/>\n<meta property=\"og:description\" content=\"There's a little confusion among some on how to import products into a Magento ecommerce store. I spent some time today researching and trying to find the best\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:author\" content=\"http:\/\/facebook.com\/webkul\" \/>\n<meta property=\"article:published_time\" content=\"2011-02-17T10:24:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-19T15:07:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vipin Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/vipinsahu\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vipin Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/\"},\"author\":{\"name\":\"Vipin Sahu\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/8ed13bf168e6e8fe92fe499c470111f1\"},\"headline\":\"How to Import CSV into Magento\",\"datePublished\":\"2011-02-17T10:24:24+00:00\",\"dateModified\":\"2017-05-19T15:07:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/\"},\"wordCount\":531,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"articleSection\":[\"magento\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/\",\"url\":\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/\",\"name\":\"How to Import CSV into Magento - Webkul Blog\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"datePublished\":\"2011-02-17T10:24:24+00:00\",\"dateModified\":\"2017-05-19T15:07:26+00:00\",\"description\":\"There's a little confusion among some on how to import products into a Magento ecommerce store. I spent some time today researching and trying to find the best\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import CSV into Magento\"}]},{\"@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\/8ed13bf168e6e8fe92fe499c470111f1\",\"name\":\"Vipin Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/98597dd669d66735fc160e891e1207c749a444ebea1b172de18a92f1435045c0?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\/98597dd669d66735fc160e891e1207c749a444ebea1b172de18a92f1435045c0?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"caption\":\"Vipin Sahu\"},\"description\":\"Executionist and Hardcore Planner to drive out best of the best. Want to boost up the E-Commerce industry with his concoct conception.\",\"sameAs\":[\"http:\/\/webkul.com\",\"http:\/\/facebook.com\/webkul\",\"https:\/\/x.com\/https:\/\/twitter.com\/vipinsahu\"],\"url\":\"https:\/\/webkul.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import CSV into Magento - Webkul Blog","description":"There's a little confusion among some on how to import products into a Magento ecommerce store. I spent some time today researching and trying to find the best","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\/how-to-import-csv-into-magento\/","og_locale":"en_US","og_type":"article","og_title":"How to Import CSV into Magento - Webkul Blog","og_description":"There's a little confusion among some on how to import products into a Magento ecommerce store. I spent some time today researching and trying to find the best","og_url":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_author":"http:\/\/facebook.com\/webkul","article_published_time":"2011-02-17T10:24:24+00:00","article_modified_time":"2017-05-19T15:07:26+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png","type":"image\/png"}],"author":"Vipin Sahu","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/vipinsahu","twitter_site":"@webkul","twitter_misc":{"Written by":"Vipin Sahu","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/"},"author":{"name":"Vipin Sahu","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/8ed13bf168e6e8fe92fe499c470111f1"},"headline":"How to Import CSV into Magento","datePublished":"2011-02-17T10:24:24+00:00","dateModified":"2017-05-19T15:07:26+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/"},"wordCount":531,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"articleSection":["magento"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/","url":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/","name":"How to Import CSV into Magento - Webkul Blog","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"datePublished":"2011-02-17T10:24:24+00:00","dateModified":"2017-05-19T15:07:26+00:00","description":"There's a little confusion among some on how to import products into a Magento ecommerce store. I spent some time today researching and trying to find the best","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/how-to-import-csv-into-magento\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Import CSV into Magento"}]},{"@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\/8ed13bf168e6e8fe92fe499c470111f1","name":"Vipin Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/98597dd669d66735fc160e891e1207c749a444ebea1b172de18a92f1435045c0?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\/98597dd669d66735fc160e891e1207c749a444ebea1b172de18a92f1435045c0?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","caption":"Vipin Sahu"},"description":"Executionist and Hardcore Planner to drive out best of the best. Want to boost up the E-Commerce industry with his concoct conception.","sameAs":["http:\/\/webkul.com","http:\/\/facebook.com\/webkul","https:\/\/x.com\/https:\/\/twitter.com\/vipinsahu"],"url":"https:\/\/webkul.com\/blog\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/172","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=172"}],"version-history":[{"count":2,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/172\/revisions"}],"predecessor-version":[{"id":174,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/172\/revisions\/174"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}