Modifying Mysql for images

[jwzumwalt]

I have 7000 products and images that need to be coordinated. I have already inserted the product information into Prestashop.

 

I am interested in doing bulk uploads of images and running Mysql queries to insert the image name and location. Does someone have the information on what tables and fields hold the image location for each product? It would be helpful to know how the image mechanism in PrestaShop works.

 

Thanks, JZ

Edited August 24, 2012 by jwzumwalt (see edit history)

[vekia]

I have 7000 products and images that need to be coordinated. I have already inserted the product information into Prestashop.

 

I am interested in doing bulk uploads of images and running Mysql queries to insert the image name and location. Does someone have the information on what tables and fields hold the image location for each product? It would be helpful to know how the image mechanism in PrestaShop works.

 

Thanks, JZ

 

The best way to understand how prestashop database works is Prestashop database schema:

http://www.borisov-bda.net/wp-content/uploads/2012/06/database-schema-prestashop.png

 

regards