OpenCart 2.x. How to create .CSV file for products import<\/a><\/p>\r\n Before we proceed, we need to install the program which will be used to edit the .CSV file. We recommend using OpenOffice Calc<\/strong> program.<\/p>\r\n\r\n Follow this link to download the OpenOffice<\/strong> program: https:\/\/www.openoffice.org\/<\/a>.<\/p>\r\n<\/li>\r\n Click on I want to download Apache OpenOffice<\/strong> link.<\/p>\r\n<\/li>\r\n On the next page, select your OS and language, then click on Download Full installation<\/strong> button:<\/p>\r\n In the next window, click on Save File<\/strong> button:<\/p>\r\n Once it is done, go to the file download location and proceed with OpenOffice program installation.<\/p>\r\n<\/li>\r\n<\/ol>\r\n Download the sample opencart_example_products.csv<\/strong> file using this link: opencart_import_products.csv<\/a>.<\/p>\r\n<\/li>\r\n Open opencart_example_products.csv<\/strong> file using OpenOffice Calc program.<\/p>\r\n The Character set should be Unicode (UTF-8)<\/strong>.<\/p>\r\n The Semicolon<\/strong> option should be checked by default.<\/p>\r\n Otherwise, please select the Semicolon<\/strong> option.<\/p>\r\n Click OK<\/strong> button to proceed:<\/p>\r\n The .CSV file should have the following fields. The following fields are required to import products:<\/p>\r\n Name (de)<\/strong> – full product’s name that will be used by your client for product selection in German (or other language). No specific requirements for this field except that it shouldn’t be empty.<\/p>\r\n<\/li>\r\n Name (en)<\/strong> – full product’s name that will be used by your client for product selection in English (or other language). No specific requirements for this field except that it shouldn’t be empty.<\/p>\r\n<\/li>\r\n Name (ru)<\/strong> – full product’s name that will be used by your client for product selection in Russian (or other language). No specific requirements for this field except that it shouldn’t be empty.<\/p>\r\n<\/li>\r\n Description (de)<\/strong> – should contain the information that advertises item and will help client learn about the product in German language. No specific requirements for this field.<\/p>\r\n<\/li>\r\n Description (en)<\/strong> – should contain the information that advertises item and will help client learn about the product in English language. No specific requirements for this field.<\/p>\r\n<\/li>\r\n Description (ru)<\/strong> – should contain the information that advertises item and will help client learn about the product in Russian language. No specific requirements for this field.<\/p>\r\n<\/li>\r\n Extra images<\/strong> – you can specify your additional images for each product.\tSeparate your images using a comma “,” and include a forward slash: \/new_image.jpg,\/new_image2.jpg<\/p>\r\n<\/li>\r\n Image<\/strong> – the main product image. The field value should be: \/main_image.jpg<\/p>\r\n<\/li>\r\n Meta title (de)<\/strong> – product(s) meta title in German (or other language).<\/p>\r\n<\/li>\r\n Meta title (en)<\/strong> – product(s) meta title in English (or other language).<\/p>\r\n<\/li>\r\n Meta title (ru)<\/strong> – product(s) meta title in Russian (or other language).<\/p>\r\n<\/li>\r\n Minimum<\/strong> – defines a minimum order amount.<\/p>\r\n<\/li>\r\n Model<\/strong> – the products model name\/identifier.<\/p>\r\n<\/li>\r\n Shipping<\/strong> – defines whether this product requires shipping or not. Use 0 for No and 1 for Yes.<\/p>\r\n<\/li>\r\n Price<\/strong> – the value the product is on sale for and for which it can be obtained by the shopper. Do not include the currency symbol. This field should not be empty.<\/p>\r\n<\/li>\r\n Quantity<\/strong> – required to be more than 0 in order to show your products.<\/p>\r\n<\/li>\r\n Status<\/strong> – defines whether this product is active\/enabled or not. Use 0 for disabled and 1 for enabled.<\/p>\r\n<\/li>\r\n Subtract<\/strong> – defines whether you want to subtract from stock or not. Use 0 for No and 1 for Yes:<\/p>\r\n The following field(s) are optional. Include the Category<\/strong> field(s) if you want to add Categories and\/or add products to Specific categories:<\/p>\r\n Category (de)<\/strong> – Category Name in German. You can put the category path in case you have multi-leveled categories and make sure that they are divided by vertical bar separator like Category|SubCategory.<\/p>\r\n If you need to include the product in various categories, make sure that they are divided by two vertical bars separator. For example: Parent Category One||Parent Category Two.<\/p>\r\n Example:<\/strong><\/p>\r\n We have a product which we want to include in the following categories:<\/p>\r\n Kids<\/p>\r\n Women -> subcategory for women<\/p>\r\n Women -> another subcategory for women<\/p>\r\n Lingerie<\/p>\r\n Men<\/p>\r\n Accessories<\/p>\r\n Your final value for the field will be:<\/p>\r\n Kids||Women|subcategory for woman||LINGERIE||Women|another subcategory for woman||Men||Accessories<\/p>\r\n In the above example, the product will not be included in the parent Women category. But will be added to the Kids, subcategory for woman, LINGERIE, another subcategory for woman, Men and Accessories.<\/p>\r\n Category (en)<\/strong> – Category Name in English (or other language).<\/p>\r\n Category (ru)<\/strong> – Category Name in Russian (or other language).<\/p>\r\n<\/li>\r\n When you are done, go to File -> Save As<\/strong>.<\/p>\r\n Keep the Text CSV (.csv)(*.csv)<\/strong> type. Check the Edit filter settings<\/strong> option.<\/p>\r\n Then click Save<\/strong> button:<\/p>\r\n In the popup window, make sure to select the Character set: UTF-8<\/strong>.<\/p>\r\n Select the semicolon<\/strong> field delimiter.<\/strong><\/p>\r\n Click OK<\/strong>:<\/p>\r\n![](\"\/help\/files\/banners\/zmz\/tmh\/en\/1_1.png\")
\r\n<\/div>\r\n\r\nDownloading required software<\/h3>\r\n
\r\n
![\"opencart_how_to_create_csv_1\"](\"\/help\/wp-content\/uploads\/2016\/02\/opencart_how_to_create_csv_1-300x210.jpg\")
<\/a>\r\n<\/li>\r\n![\"opencart_how_to_create_csv_2\"](\"\/help\/wp-content\/uploads\/2016\/02\/opencart_how_to_create_csv_2-300x149.jpg\")
<\/a>\r\n\t<\/li>\r\nCreating .csv files<\/h3>\r\n
\r\n
![\"opencart_how_to_create_csv_3\"](\"\/help\/wp-content\/uploads\/2016\/02\/opencart_how_to_create_csv_3-300x210.jpg\")
<\/a>\r\n\t<\/li>\r\n\r\n
![\"opencart_how_to_create_csv_4\"](\"\/help\/wp-content\/uploads\/2016\/02\/opencart_how_to_create_csv_4-300x64.jpg\")
<\/a>\r\n<\/li>\r\n<\/ul>\r\n<\/li>\r\n![\"opencart_how_to_create_csv_5\"](\"\/help\/wp-content\/uploads\/2016\/02\/opencart_how_to_create_csv_5-300x210.jpg\")
<\/a>\r\n<\/li>\r\n
![\"opencart_how_to_create_csv_6\"](\"\/help\/wp-content\/uploads\/2016\/02\/opencart_how_to_create_csv_6-300x210.jpg\")
<\/a>\r\n<\/li>\r\n<\/ol>\r\n