![](\"\/help\/files\/banners\/zmz\/tmh\/en\/1_1.png\")
\r\n<\/div>\r\n\r\nDownloading required software<\/h3>\r\n\r\n\r\n\tFollow this link to download the OpenOffice<\/strong> program: https:\/\/www.openoffice.org\/<\/a>.<\/p><\/li>\r\n\tClick on I want to download Apache OpenOffice<\/strong> link.<\/p>\r\n\t<\/li>\r\n\tOn the next page select your OS and language and press the Download Full installation<\/strong> button.\r\n\t\r\n![\"\"](\"\/help\/wp-content\/uploads\/2017\/06\/woocommerce_how_to_create_csv_1.jpg\")
<\/a>\t\r\n\t\r\n\t<\/li>\r\n\tThen click on Save File<\/strong> button.<\/p>\r\n\t\r\n\t\r\n![\"\"](\"\/help\/wp-content\/uploads\/2017\/06\/woocommerce_how_to_create_csv_2.jpg\")
<\/a>\t\t\r\n\t\t\r\n\t\t\r\n\t<\/li>\r\n\tOnce it’s done, go to the file download location and proceed with OpenOffice program installation.<\/p><\/li>\r\n<\/ol>\r\n\r\n
Creating .csv files<\/h3>\r\n\r\n\r\n\tDownload the sample woocommerce_example_products.csv<\/strong> file using this link<\/a>.<\/p><\/li>\r\n\tOpen woocommerce_example_products.csv<\/strong> file using OpenOffice Calc program.<\/p>\r\n\t\tThe Character set should be Unicode (UTF-8)<\/strong><\/p>\r\n\t\tPlease, select the comma<\/strong> option.<\/p>\r\n\t\tClick OK<\/strong> button to proceed.<\/p>\r\n\t\t\r\n\t\t\r\n![\"\"](\"\/help\/wp-content\/uploads\/2017\/06\/woocommerce_how_to_create_csv_3.jpg\")
<\/a>\t\t\r\n\t\t\r\n\t<\/li>\r\n\t\r\n\tThe .CSV file should have the following fields (they are required to import products):<\/p>\r\n\t\t
\r\n\t\t\tpost_title<\/strong> – specify the name of your product;<\/p><\/li>\r\n\t\t\tpost_content<\/strong> specify the product description;<\/p><\/li>\r\n\t\t\tpost_status<\/strong> – specify whether you wish to enable or disable the product, such as publish<\/strong>;<\/p><\/li>\r\n\t\t\tregular_price<\/strong> – specify the product price. This field should not be empty;<\/p><\/li>\r\n\t\t\tvisibility<\/strong> – specify where you want to display your product(s), such as visible<\/strong>;<\/p><\/li>\r\n\t\t\tmanage_stock<\/strong> – such as yes<\/strong> or no<\/strong>;<\/p><\/li>\r\n\t\t\t\t\t\tImage<\/strong> – should contain the URL to your image(s). For example: http:\/\/domain.com\/images\/name.jpg <\/p>\r\n\t\t\t\tNote:If you do not have Product Images, simply leave “Image” field empty. You can add images via WordPress admin panel later for each product.<\/p>\r\n\t\t\t<\/li>\r\n\t\t\t
tax:product_type<\/strong> – specify the type of your product, such as simple<\/strong>;<\/p><\/li>\r\n\t\t\ttax:product_cat<\/strong> – specify the category name;<\/p><\/li>\r\n\t\t\ttax:product_tag<\/strong> – specify your product brand or manufacturer.<\/p><\/li>\r\n\t\t<\/ul>\r\n\t\t\r\n\t\t\r\n![\"\"](\"\/help\/wp-content\/uploads\/2017\/06\/woocommerce_how_to_create_csv_4.jpg\")
<\/a>\t\t\r\n\t\t\r\n\t<\/li>\t\t\r\n\t\tWhen you are done, go to File -> Save As<\/strong>. Keep the Text CSV (.csv)(*.csv)<\/strong> type. Check the Edit filter settings<\/strong> option.<\/p>\r\n\t\t\tThen click on the Save<\/strong> button.<\/p>\r\n\t\t\t\r\n\t\t\t\r\n![\"\"](\"\/help\/wp-content\/uploads\/2017\/06\/woocommerce_how_to_create_csv_5.jpg\")
<\/a>\t\t\t\r\n\t\t\t\r\n\t\t\t\r\n\t\t\tNext, click on the Keep Current Format<\/strong> button.<\/p>\r\n\t\t\t\r\n![\"\"](\"\/help\/wp-content\/uploads\/2017\/06\/woocommerce_how_to_create_csv_6.jpg\")
<\/a>\t\t\t\r\n\t\t<\/li>\r\n\t\tMake sure to select the Caracter set: UTF-8<\/strong> in the popup window. Select the comma<\/strong> field delimiter and click OK<\/strong>.<\/p>\r\n\t\t\t\r\n![\"\"](\"\/help\/wp-content\/uploads\/2017\/06\/woocommerce_how_to_create_csv_7.jpg\")
<\/a>\t\t\t\r\n\t\t\t\r\n\t\t\t<\/li>\r\n\t\t<\/ol>\r\n\t\t
Follow this link to download the OpenOffice<\/strong> program: https:\/\/www.openoffice.org\/<\/a>.<\/p><\/li>\r\n\t Click on I want to download Apache OpenOffice<\/strong> link.<\/p>\r\n\t<\/li>\r\n\t On the next page select your OS and language and press the Download Full installation<\/strong> button.\r\n\t\r\n Then click on Save File<\/strong> button.<\/p>\r\n\t\r\n\t\r\n Once it’s done, go to the file download location and proceed with OpenOffice program installation.<\/p><\/li>\r\n<\/ol>\r\n\r\n Download the sample woocommerce_example_products.csv<\/strong> file using this link<\/a>.<\/p><\/li>\r\n\t Open woocommerce_example_products.csv<\/strong> file using OpenOffice Calc program.<\/p>\r\n\t\t The Character set should be Unicode (UTF-8)<\/strong><\/p>\r\n\t\t Please, select the comma<\/strong> option.<\/p>\r\n\t\t Click OK<\/strong> button to proceed.<\/p>\r\n\t\t\r\n\t\t\r\n The .CSV file should have the following fields (they are required to import products):<\/p>\r\n\t\t post_title<\/strong> – specify the name of your product;<\/p><\/li>\r\n\t\t\t post_content<\/strong> specify the product description;<\/p><\/li>\r\n\t\t\t post_status<\/strong> – specify whether you wish to enable or disable the product, such as publish<\/strong>;<\/p><\/li>\r\n\t\t\t regular_price<\/strong> – specify the product price. This field should not be empty;<\/p><\/li>\r\n\t\t\t visibility<\/strong> – specify where you want to display your product(s), such as visible<\/strong>;<\/p><\/li>\r\n\t\t\t manage_stock<\/strong> – such as yes<\/strong> or no<\/strong>;<\/p><\/li>\r\n\t\t\t\t\t\t Image<\/strong> – should contain the URL to your image(s). For example: http:\/\/domain.com\/images\/name.jpg <\/p>\r\n\t\t\t\t Note:If you do not have Product Images, simply leave “Image” field empty. You can add images via WordPress admin panel later for each product.<\/p>\r\n\t\t\t<\/li>\r\n\t\t\t tax:product_type<\/strong> – specify the type of your product, such as simple<\/strong>;<\/p><\/li>\r\n\t\t\t tax:product_cat<\/strong> – specify the category name;<\/p><\/li>\r\n\t\t\t tax:product_tag<\/strong> – specify your product brand or manufacturer.<\/p><\/li>\r\n\t\t<\/ul>\r\n\t\t\r\n\t\t\r\n When you are done, go to File -> Save As<\/strong>. Keep the Text CSV (.csv)(*.csv)<\/strong> type. Check the Edit filter settings<\/strong> option.<\/p>\r\n\t\t\t Then click on the Save<\/strong> button.<\/p>\r\n\t\t\t\r\n\t\t\t\r\n Next, click on the Keep Current Format<\/strong> button.<\/p>\r\n\t\t\t\r\n Make sure to select the Caracter set: UTF-8<\/strong> in the popup window. Select the comma<\/strong> field delimiter and click OK<\/strong>.<\/p>\r\n\t\t\t\r\n<\/a>\t\r\n\t\r\n\t<\/li>\r\n\t<\/a>\t\t\r\n\t\t\r\n\t\t\r\n\t<\/li>\r\n\tCreating .csv files<\/h3>\r\n\r\n
\r\n\t
<\/a>\t\t\r\n\t\t\r\n\t<\/li>\r\n\t\r\n\t\r\n\t\t\t
<\/a>\t\t\r\n\t\t\r\n\t<\/li>\t\t\r\n\t\t<\/a>\t\t\t\r\n\t\t\t\r\n\t\t\t\r\n\t\t\t<\/a>\t\t\t\r\n\t\t<\/li>\r\n\t\t<\/a>\t\t\t\r\n\t\t\t\r\n\t\t\t<\/li>\r\n\t\t<\/ol>\r\n\t\t