kundan1947 Posted February 9, 2015 Share Posted February 9, 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...
bellini13 Posted February 10, 2015 Share Posted February 10, 2015 you do not show us what options you used on the first page of import. a true CSV file would have you use comma's to separate columns (comma separated value) so you should do this... value, value, value, value, value the problem with this, is that sometimes the values contain comma's, like the product description. so to get around that, you must use double quotes when the value can have a comma value, "value with, a comma", value, value, value for columns that have multiple values, like product categories, then you can use any delimiter you want, but I choose to use the semi-colon value, "value with, a comma", 9;45;52;53;54;56;57, value, value Now when you go to import this CSV you must ensure that the "Field Separator" is a comma, and the "Multiple Value separator" is a semi-colon 2 Link to comment Share on other sites More sharing options...
kundan1947 Posted February 10, 2015 Author Share Posted February 10, 2015 Yeh thanks for your reply, can i get a sample tested CSV file for bulk products uploading. Problem I am getting when I am upload CSV for bulk products uploading. 1) Its not taking multiple category, multiple images url, 2) and when i upload a CSV file its take all values in one Column, Like all the values showed in ID. Please help me If possible provide me a sample tested CSV file. Link to comment Share on other sites More sharing options...
bellini13 Posted February 10, 2015 Share Posted February 10, 2015 you can get sample CSV files directly from the back office. Link to comment Share on other sites More sharing options...
kundan1947 Posted February 10, 2015 Author Share Posted February 10, 2015 (edited) I downloaded that file, but its show some break in the file. Please give me a new CSV file for bulk products uploading. Edited February 10, 2015 by kundan1947 (see edit history) Link to comment Share on other sites More sharing options...
Guest Posted February 10, 2015 Share Posted February 10, 2015 What software are you using to view the CSV file you downloaded in? What software are you using to create your own CSV file and in what format are you saving the csv file? Can you attach the csv file here? Link to comment Share on other sites More sharing options...
kundan1947 Posted February 10, 2015 Author Share Posted February 10, 2015 I am using Microsoft excel for creating CSV file, First I am creating the excel then convert it to CSV with concatenation formula. Link to comment Share on other sites More sharing options...
kundan1947 Posted February 10, 2015 Author Share Posted February 10, 2015 Problem I am getting when I am upload CSV for bulk products uploading. 1) Its not taking multiple category, multiple images url, 2) and when i upload a CSV file its take all values in one Column, Like all the values showed in ID. Please help me If possible provide me a sample tested CSV file. Link to comment Share on other sites More sharing options...
Guest Posted February 10, 2015 Share Posted February 10, 2015 I find excel very poor with CSV files and use OpenOffice instead (free) Presumably when you save the file you are doing File > SAve As and then changing the file type to CSV (Comma Delimited) Can you attach it here for us to check? But really I would use OpenOffice Link to comment Share on other sites More sharing options...
kundan1947 Posted February 10, 2015 Author Share Posted February 10, 2015 (edited) Thank you bellini13 & haylau for your reply please help me with CSV. creating a CSV file for large data is a complex thing for prestashop, can anyone suggest me any simpler gateway for this. When I add multiple values with Prestashop sample CSV formate, Its shows me error. Its show all the values in ID column. One more thing, I have database of all products saved in Excel formate, does any one have any better solution so I can convert those Excel to Csv formate. This is the file sample.txt after uploading this I get this error only in first products because there I have enter multiple values for Category, Keywords, Thanks in advance Edited February 10, 2015 by kundan1947 (see edit history) Link to comment Share on other sites More sharing options...
Guest Posted February 10, 2015 Share Posted February 10, 2015 For a start, you need to give more information when asked, not the same information. Answer the questions asked 1) Uploading CSV files are problematic with Prestashop unless you have a very good high speed server. On our shared hosting we have to break it down and only upload less than 10 products at a time - and forget images 2) The file you attached was a txt file not a csv file. I converted it and it uploads just fine Make sure your settings are correct in the upload wizard 3) because of these issues I have bought Store manager which works brilliantly http://www.prestashopmanager.com Link to comment Share on other sites More sharing options...
kundan1947 Posted February 11, 2015 Author Share Posted February 11, 2015 Haylau thanks for your help,Right now I am testing this things on my localhost, and you said check all setting I check and try to upload the same file, But again I found the same error. For the first products in which I have added multiple values for keywords, categories, etc showing all entries in single ID column .Does there any module for this, I mean for better bulk uploading option? or any other optionOr any other may be I am missing, or anything which I should have to look?Please help me.And yeah I like your prestashop storemanager , But its costly for me. Link to comment Share on other sites More sharing options...
Guest Posted February 11, 2015 Share Posted February 11, 2015 I will try once more Attach the file you are trying to upload so we can see it! Not the prestashop sample file, the one you are actually trying to upload containing your products. Give us the actual CSV file. Link to comment Share on other sites More sharing options...
kundan1947 Posted February 12, 2015 Author Share Posted February 12, 2015 (edited) I wanted to add multiple value but I am unable to add multiple values. Like Multiple Categories, Multiple Tags, Multiple Keywords, Multiple Image Url I am unable to upload CSV file, so here I am attaching a text file of thatsample.txt Help me Edited February 12, 2015 by kundan1947 (see edit history) Link to comment Share on other sites More sharing options...
kaitzu Posted February 12, 2015 Share Posted February 12, 2015 Are you still using Excel?? Excel is very "complicated" software if saving file to CSV, with excel its too easy make mistake with save and this could make some problems. I recommend to test OpenOffice for CSV-files. Link to comment Share on other sites More sharing options...
bellini13 Posted February 12, 2015 Share Posted February 12, 2015 I took your sample.txt file, renamed it to sample.csv and it imports fine in PS v1.6.0.11 Link to comment Share on other sites More sharing options...
Enfys Posted March 11, 2015 Share Posted March 11, 2015 (edited) This link may be useful http://superuser.com/questions/606272/how-to-get-excel-to-interpret-the-comma-as-a-default-delimiter-in-csv-files Changing the default delimiter in Windows worked for my files (I'm on a UK computer which defaults to ; not , as the delimiter) Edited March 11, 2015 by Enfys (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts