Need help with CSV Import.

[George b.]

I need some help with csv import. i'm affraid i'm not too savy at this point and in need of a walk through. I have a excel spread sheet with product info. Can anyone help?

[RogueWaveLimited]

Have you read anything on how to do an import?

 

http://doc.prestashop.com/display/PS14/Exploring+PrestaShop%27s+Tools#ExploringPrestaShop%27sTools-CSVImport

 

And here is another link:

 

http://blog.dh42.com/prestashop-importing-csv-files/

[pszilard]

Thanks Richard, - I am also in need of help and will explore the links you listed.

[nienha]

Some links i have harvested..

 

http://www.file2cart.com/blog/6589-prepare-your-csv-file-for-prestashop-import

http://nemops.com/prestashop-import-csv/

http://www.prestashop.com/forums/topic/56689-module-fast-csv-or-xml-import-of-thousands-products-in-a-few-seconds/?hl=%2Bcsv+%2Bimport

http://www.prestashop.com/forums/topic/279647-solvedcant-import-csv-special-characters-to-prestashop-15/?hl=%2Bcsv+%2Bimport

http://www.prestashop.com/forums/topic/246167-solvedimporting-products-in-subcategories-with-the-same-name-using-csv-import/?hl=%2Bcsv+%2Bimport

[George b.]

I will give these links a try. Thank you! I was able to import some data but some was not configured correctly upon import. I will continue to read on.

[nienha]

Oh, and the latest version of prestashop, 1.5.6.1, have got new import csv files and som other fixes.

 

http://www.prestashop.com/es/versiones-para-programadores/registro-de-cambios/1.5.6.1

[George b.]

ok i am able to import most of the data. However, some of my data such as the manufacturer cannot be seen when arranging the columns. why is this? also when saving from excel to csv i only have the option to save as csv deliminated or csv ms dos. which should i choose?

[pszilard]

Not sure if you are falling into the same problem that I had, but I wrongly assumed that the 1st line in my CSV file, DEFINED the fields!

 

This is NOT the case! They are there purely to aid the admin so that he can manually select the correct field mapping, using the drop-down fields. Once this is matched, the configuration mapping can be save to a file and then Loaded during the next import.

 

Does this help?

[George b.]

i actually got that part right. but for some reason the first column does not show up at all. i have thus saved the excel file as csv ms-dos and now it shows up. now i cant get the product price to import. i'm beginning to think the entire csv file i got from the supplier is corrupt. im trying to figure a way to fix this file.

[pszilard]

Perhaps I can ask you to help with a question for me? I am very new to Prestashop.

 

I can't find where to change the shop details that show in the gray/black footer of the standard template, under CONTACT US. I have edited all the shop details, but they have no effect on this. Thanks in advance,

[George b.]

modules>front office features>block contact info. I believe this is what you are looking for.

[pszilard]

Thanks George! You are a legend, have a virtual beer on me

 

Back to CSV; I found that the exported CSV was not much good to use as a starting point, so I am constructing one from scratch for my shop. Let us know if you fix your problem.

 

Good luck...

[George b.]

I have a csv file from a supplier. I cannot see some of my columns when i try to import them. BUT when i save my csv file as CSV MS_DOS then i can see all my columns. Another thing is i cannot import my product cost column. Does anyone know why??