Importing via cvs product with multiple images.

[ralph]

Maybe im not understanding this correctly but i followed the wiki for importing products using csv file but i can not figure out how to add multiple images for the same product. I can upload one image fine but i am not sure of the format to upload 2 or more images for the same product.

What should the csv file look like inside for this to work.

product name, price, descrition, http://www.mysite.com/import_images/imagex.jpg http://www.mysite.com/import_images/imagex.jpg

Anyone have any ideas on how to add multiple images in a csv file for the same product please let me know.

[rhaley]

I Have the same problem......not working at all with images. the rest of the data is good but images would be nice.

[jhnstcks]

Have you tried adding a comma after each image url, in the same way that multipule categories are imported?

Try reading through this thread here, where i posted working csv for categories and products.

[rhaley]

my problem is that I don't actually see the image.

[jhnstcks]

Ok i have just done a test Import with multipule images using a comma to separate the image url's.

When your importing your products are you adding an extra column for the id? For some reason the import function has difficulty linking the image to the product when it has to automatically create ids.

Try importing these 2 files into your site, they both work as I have just done it now. The categories file will need to be done first. When importing the products file use comma as the column separator.

test_category_CSV.csv

test_item_csv.csv

[rhaley]

Thanks....I had issues with the ftp client I used.....It dropped all the file names from TEST.jpg to test.jpg....AAAAHHHHHH!!!

so I re transferred the files and re-imported with the full url to an image and VOILA it worked.

[DanielP]

Thanks....I had issues with the ftp client I used.....It dropped all the file names from TEST.jpg to test.jpg....AAAAHHHHHH!!!

 

so I re transferred the files and re-imported with the full url to an image and VOILA it worked.

[#10173] We could not find the attachment you were attempting to view.

 

Hello, does somebody knows about a video tutorial because i can"t understand where the pictures go after the upload on img/p/1/3  and how can i do it automatically with the csv import ? I don't know where to find more details , i only find details about the csv categories but nothing explained about the multiple pictures uplouds. Prestashop 1.6

 

www.gigashop.es

[NemoPS]

In order to import images they have to be online already. You can create a temporary folder wherever you prefer on your server (even on another one, but it will be slower), then simply point to them in the csv file, remembering to separate multiple ones by comma

[DanielP]

In order to import images they have to be online already. You can create a temporary folder wherever you prefer on your server (even on another one, but it will be slower), then simply point to them in the csv file, remembering to separate multiple ones by comma

 

Thanks but i still can"t do it.I need a video tutorial to make it clear.The problem is that i create the folder, i give it the right permissions, i upload the pictures but when point them , its working just with one or none. I can"t understand why  in the folder /img are others folders as numbers /1/3 and in the final is the picture 13.jpg , and can"t find the rest of them that i"ve uploaded manually.

 

For a cvs that i exported to see the order i find something like: /img/2/7/27.jpg  this is why i don"t understand how and why ..... :/

 

Cheers and thanks for the help.

[nhieuquadi]

You have tried to direct the path of the picture yet? 

game iwin hoặc tai game ban ca

Edited May 10, 2014 by nhieuquadi (see edit history)

[DanielP]

You have tried to direct the path of the picture yet? 

Can you make an example ?

[NemoPS]

When you export, prestashop picks its own images. Ignore this. Use another path, you can upload pictures to img/mypictures if you want, then in the csv

 

 

 

etc...

[DanielP]

When you export, prestashop picks its own images. Ignore this. Use another path, you can upload pictures to img/mypictures if you want, then in the csv

 

 

 

etc...

I"m still looking for a video example. I think i am the problem.I"m doing somthing wrong ...Thank you all but with giving me ideas is not working.

[myselfidem]

Here is an example with french titles :

 

I put all images Inside a folder named : produit Inside: .\prestashop\produit

ID;"Actif (0/1)";Nom*;"Catégories (x,y,z...)";"Prix HT";"Prix TTC";"ID règles de taxes";Référence;"Fabricant";Quantité;Visibilité;Résumé;Description; "Afficher le prix (0 = Non, 1 = Oui)"; "URLs des images (x,y,z...)"; "Supprimer les images existantes (0 = non, 1 = oui)"
11;1;"""Rivière en crue""";46,9,2;;14.85;0;9782722200326;"CLC";1;both;"<p>BURNS Peggy.<br /> Puissance dans le sang de Jésus.</p>";;1;"..//produit/riviere.jpg";0
30;1;"""50 jours pour une vision élargie""";79,18,2;;25.00;0;9782914424097;"Aigles Publications";1;both;"<p>JOYNER Rick</p>";;1;"..//produit/jours.jpg";0

Edited May 1, 2014 by myselfidem (see edit history)

[DanielP]

 

Here is an example with french titles :

 

I put all images Inside a folder named : produit Inside: .\prestashop\produit

ID;"Actif (0/1)";Nom*;"Catégories (x,y,z...)";"Prix HT";"Prix TTC";"ID règles de taxes";Référence;"Fabricant";Quantité;Visibilité;Résumé;Description; "Afficher le prix (0 = Non, 1 = Oui)"; "URLs des images (x,y,z...)"; "Supprimer les images existantes (0 = non, 1 = oui)"
11;1;"""Rivière en crue""";46,9,2;;14.85;0;9782722200326;"CLC";1;both;"<p>BURNS Peggy.<br /> Puissance dans le sang de Jésus.</p>";;1;"..//produit/riviere.jpg";0
30;1;"""50 jours pour une vision élargie""";79,18,2;;25.00;0;9782914424097;"Aigles Publications";1;both;"<p>JOYNER Rick</p>";;1;"..//produit/jours.jpg";0

hello , thank you for the reply but my problem is with this "URLs des images (x,y,z...)" where i uploud the images and finaly it"s not working ...don"t know why and i am tired allready to try,Maybe i am the problem, that"s why i ask for a video tutorial stept to step , on how to uploud images trough CVS file ...somthin" like that ....

[myselfidem]

Exporting an CSV file, the values aren't the same using CSV file to import products about URLs images.

Using export, I have this link, on my localhost (example for one image):

 

Export as CSV :

"ID";"Photo";"Nom";"Référence";"Catégorie";"Prix de base";"Prix final";"État";
"9";"http://127.0.0.1/prestashop/img/p/8/8.jpg";""La perfection interdite"";"";"Nouveautés";"39.000000";"39";"1";
"45";"http://127.0.0.1/prestashop/img/p/4/2/42.jpg";""Comprendre L'ONCTION"";"";"Ministères, dons, charismes";"22.900000";"22.9";"1";

But, if you try my example, creating a folder with your images, this will work !

 

However, I use Categories ID , with another order, because there is a bug, and if I want the product on my Home page, I must add the ID 2 (Home) at last. ID 1 is Root. I will try using names for Categories !

 

You can try to use: ;"..//img/product/image_name.jpg";

 

And all images are inside the folder : product

Edited May 3, 2014 by myselfidem (see edit history)

[myselfidem]

Here is a small video :

 

http://www.mediafire.com/watch/ng9q5t4yx48p6yy/Import.avi

[DanielP]

 

Edited May 4, 2014 by DanielP (see edit history)

[DanielP]

Here is a small video :

 

http://www.mediafire.com/watch/ng9q5t4yx48p6yy/Import.avi

Thanks, but no.Not usefull...

[NemoPS]

Just to understand, what do you exactly expect the video to explain?

[DanielP]

Hello. I just want to see step by step how to uploud the pictures using the cvs .I know how to use the cvs to uploud products/categories, the problem that i have is the pictures will not uploud, because i do it wrong or whatever.I can"t find a video to see where is the problem, why they dont apear after the cvs import and wich steps they did to make it work.

 

Any tutorial that i"ve found its just about the cvs details but nothing about pictures uploud, creating directories, the order of the pictures inside those directories, to make the path (x,y,z) work , the 777 permisions on the hosting server...etc etc etc..

 

If there is no video to explain tat ill figure out my self and ill close this post.

 

Thanks for the help 

[NemoPS]

it's not complicated, really. Choose any folder you want. Say, a new one called myimages inside the root

 

 

Your site is http://mysite.com

 

THe images folder is therefore

 

http://mysite.com/myimages

 

 

Any image you put inside, considering its name, will be

 

http://mysite.com/myimages/imagename.jpg

 

 

As simple as that, just point to that url Check that you can actually see one of them before uploading, so you know whether they are accessible or not

[DanielP]

it's not complicated, really. Choose any folder you want. Say, a new one called myimages inside the root

 

 

Your site is http://mysite.com

 

THe images folder is therefore

 

http://mysite.com/myimages

 

 

Any image you put inside, considering its name, will be

 

http://mysite.com/myimages/imagename.jpg

 

 

As simple as that, just point to that url Check that you can actually see one of them before uploading, so you know whether they are accessible or not

Thank you all for the help but is better to close the post.Not solved and never like this in my case, there are things that i understand but others that simple dont match as solution with just do this, write that ..  i need a video example step to step , if is not existent, let"s leave it down..

[[email protected].]

it's not complicated, really. Choose any folder you want. Say, a new one called myimages inside the root

 

 

Your site is http://mysite.com

 

THe images folder is therefore

 

http://mysite.com/myimages

 

 

Any image you put inside, considering its name, will be

 

http://mysite.com/myimages/imagename.jpg

 

 

As simple as that, just point to that url Check that you can actually see one of them before uploading, so you know whether they are accessible or not

Hi Moderator, You ask people to point to the image folder, how to point it? and the image ID has to be matched with a particular product and how the product is looking for the right ID? The supplier already provided the image link, the image link has already linked it with their server, why should we create another folder for the image? The images has already link to an server already?

 

The problem is here, prestashop could not download the images link provided by supplier, this is the main problem.

• US Mode

[NemoPS]

Well of course, if images are online already you don't need to create any folder, just speficy the correct url.

 

US mode? You get that error? US Mode?