kundan1947 Posted February 10, 2015 Share Posted February 10, 2015 Hi i am facing some problem while uploading bulk products using csv file. As you know, values for different columns must be end with a semicolon i.e ; and multiple values in one column are separated with a comma i.e , Now the problem i'm facing is that when i use comma to separate multiple values in one column (eg red,blue,white;), and then upload that csv file in presatshop, all values comes in one column. And i'm unable to proceed. I'm attaching image of this problem. Please help me to solve this problem. Please tell me how to solve and why it is not taking commas. 2nd Query: i also want to use any other special character to seprate values instead of comma. Is this possible ? if yes tell me how. Link to comment Share on other sites More sharing options...
Enfys Posted March 11, 2015 Share Posted March 11, 2015 Have you checked what the default delimiter is on your machine? I'm on a U.K. computer (UK default delimiter is , rather than the default ; used in France ) and I had to change the settings in the control panel, else my columns did end up being merged into one. To change the default setting follow the steps outlined here http://superuser.com/questions/291445/how-do-you-change-default-delimiter-in-the-text-import-in-excel Link to comment Share on other sites More sharing options...
Recommended Posts