Can't find image file in database

[infinito62]

HELP!!!

I'm integrating Prestashop with my ERP. I have to sincronize products, but I can't find where Prestashop stores image filename in database: all image tables contain all kind of info but no filename and URL.

Can anyone help me?

Thanks inadvance!

Riccardo

[virtualgadjo]

hi,

 

prestashop has a funny way to deal with images...

for example, coming to the products images, they are renamed on the fly with a number (the id_image) and a size name

you'll find them in the prefix_images table that contains the id_image related to the id_product + their position and their cover fonction

 

finding them in the directories tree is quite a deal too...

img/p/5 and subdirectories with numbers for the site i'm working on...

 

good luck

 

have swing

[infinito62]

ouch! I understand now, it's pretty messy...

So, all produts img are in the same 'p' directorywhile categoryesd are in 'c'? In my case subdirs 1,2,3,4 contain only index.php.

 

Thank you very much... there's a lot of worh to do...

 

Riccardo

[Miha02]

I c this is little old but stil..

Can someone explain how do I find correct folder and subfolder based on id_image ? It makes almost no sense to me

All I can see is that file contains Id_image...jpg but folder 0/1/2/3... from where is the number ? :/