How can I import images of products? Where are the product images stored?

[henryyao]

Hi,

 

I am trying to use import feature to create products for my shop, but I can't find a way to import images. Does anyone know how to do that? If the back office doesn't support that, I can write some script to do it myself if I know where the images are stored. It doesn't seem to be in the database...

 

Any help is really appreciated!

 

Thanks,

Henry

[razaro]

Check http://doc.prestashop.com/display/PS16/CSV+Import+Parameters. 

So images can be imported from foolder on your server (full path like in example)

"Enabled";"Name";"Categories";"Price";"Tax rule ID";"Buying price";"On sale";"Reference";"Weight";"Quantity";"Short desc.";"Long desc";"Images URL"
1;"Test";"1,2,3";130;1;75;0;"PROD-TEST";"0.500";10;"'Tis a short desc.";"This is a long description.";"http://www.myprestashop/images/product1.jpg"

[RogueWaveLimited]

You can have a "picture" field in the import CSV. This field would contain just the source URL for the image. 

[henryyao]

cool, thanks guys. just curious, do you know where are the images stored on server? In DB or some special folder?

[henryyao]

I have a further question: is there a way to escape the deliminators? To be more specific, I want to import html descriptions, but it will contain all kinds of characters.

[razaro]

Images are stored in img folder, for example img/p/ contains product images. And in database there are image id's.

When you upload/import image it gets new id for example 256 and then Prestashop creates images for all types defined in

Back Office > Preferences > Images, and those images are stored in img/p/2/5/6/ folder , for example img/p/2/5/6/256-home_default.jpg.

 

For HTML try to wrap between double quotes or/ and use html codes for those characters. 

And test on local with small csv file.

[thunda]

thanks @razaro!