{"id":42201,"date":"2015-02-09T07:43:27","date_gmt":"2015-02-09T12:43:27","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=42201"},"modified":"2018-02-14T08:25:40","modified_gmt":"2018-02-14T13:25:40","slug":"woocommerce-how-to-import-data-from-csv-files","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/woocommerce-how-to-import-data-from-csv-files.html","title":{"rendered":"WooCommerce. How to import data from CSV files"},"content":{"rendered":"<p>\r\n<p>Hello, this tutorial shows how to  <strong>import data<\/strong> from a CSV file to your WooCommerce catalog.<\/p>\r\n<p><a href=\"http:\/\/www.youtube.com\/watch?v=b8Vc-bmZ028?width=1280&amp;height=720\" rel=\"prettyPhoto\">WooCommerce. How to import data from CSV files<\/a><\/p>\r\n\r\n<div class=\"inline-banner\">\r\n\t<img src=\"\/help\/files\/banners\/zmz\/tmh\/en\/1_1.png\" onclick=\"showChat()\">\r\n<\/div>\r\n\r\n<p>In order to import products to your WooCommerce store, you need to have an Import plugin installed. You can find a <strong>Woocommerce CSV importer<\/strong> plugin on the official WordPress <a href=\"https:\/\/wordpress.org\/plugins\/woocommerce-csvimport\/\" target=\"_blank\">Plugin Directory<\/a>.<\/p>\r\n<p>In order to install the plugin, navigate to <strong>Plugins > Add new<\/strong>. You can either upload the plugin downloaded from the resource above, or search for the plugin using a <strong>Search Form<\/strong>:<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-1.png.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-1.png-300x168.jpg\" alt=\"{WooCommerce_How_to_import_data_from_CSV_files-1.png}\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-42202\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-1.png-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-1.png-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-1.png-1024x576.jpg 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-1.png.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\r\n<p>After you install and activate the plugin, you will see the <strong>CSV Import<\/strong> tab in your admin panel. To start the import process, you should perform the following:<\/p>\r\n<ol>\r\n<li>\r\n<p>In the WordPress dashboard navigate to <strong>CSV Import <\/strong> tab and check the Documentation:<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-2.png.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-2.png-300x168.jpg\" alt=\"{WooCommerce_How_to_import_data_from_CSV_files-2.png}\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-42203\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-2.png-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-2.png-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-2.png-1024x576.jpg 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-2.png.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<li>\r\n<p>Prepare your .csv file or use the example .csv :<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-3.png.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-3.png-300x168.jpg\" alt=\"{WooCommerce_How_to_import_data_from_CSV_files-3.png}\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-42205\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-3.png-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-3.png-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-3.png-1024x576.jpg 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-3.png.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<li>\r\n<p>Go to the <strong>Settings<\/strong> tab and check the available options. Save the changes in case you do any modifications:<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-4.png.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-4.png-300x168.jpg\" alt=\"{WooCommerce_How_to_import_data_from_CSV_files-4.png}\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-42204\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-4.png-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-4.png-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-4.png-1024x576.jpg 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-4.png.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<li>\r\n<p>Go to the <strong>Header<\/strong> tab and browse your file:<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-5.png.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-5.png-300x168.jpg\" alt=\"{WooCommerce_How_to_import_data_from_CSV_files-5.png}\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-42206\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-5.png-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-5.png-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-5.png-1024x576.jpg 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-5.png.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<li>\r\n<p>Check if all the fields match. You can set some fields to be skipped during the import process. Save the changes:<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-6.png.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-6.png-300x168.jpg\" alt=\"{WooCommerce_How_to_import_data_from_CSV_files-6.png}\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-42207\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-6.png-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-6.png-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-6.png-1024x576.jpg 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-6.png.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n <\/li>\r\n<li>\r\n<p>Navigate to <strong>Import<\/strong> tab and browse the same .csv file. Check if all the information is correct and start the Import: <\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-7.png.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-7.png-300x168.jpg\" alt=\"{WooCommerce_How_to_import_data_from_CSV_files-7.png}\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-42208\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-7.png-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-7.png-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-7.png-1024x576.jpg 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/01\/WooCommerce_How_to_import_data_from_CSV_files-7.png.jpg 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<li>\r\n<p>You can check your newly imported products in the <strong>Products <\/strong> tab, and the media files in the <strong>Media Library<\/strong>.<\/p>\r\n<\/li>\r\n<\/ol>\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n<p><a href=\"http:\/\/www.youtube.com\/watch?v=b8Vc-bmZ028?width=1280&amp;height=720\" rel=\"prettyPhoto\">WooCommerce. How to import data from CSV files<\/a><\/p>\r\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>This tutorial shows how to  import data from a CSV file to your WooCommerce catalogue.<\/p>\n","protected":false},"author":64,"featured_media":43678,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1556],"tags":[703,706,2418],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/42201"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/64"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=42201"}],"version-history":[{"count":1,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/42201\/revisions"}],"predecessor-version":[{"id":84124,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/42201\/revisions\/84124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/43678"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=42201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=42201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=42201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}