Magento: product information (small, large, and so on), where in the database?

Question

I am trying to find a place in the Magento database where it stores information about which image is a large and small version, etc. I checked catalog_product_entity_media_gallery, catalog_product_entity, catalog_product_entity_varchar and catalog_product_entity_media_gallery_value, not in these tables. Any ideas? I have a DB Magento 1.4.

Thanks!

Answer 1

Magento save your thumb, small_image, and thumbnail in the catalog_product_entity_varchar table.

Since Magento uses the eav architecture, the thumbnail, small_image and large image are stored in catalog_product_entity_varchar with the link identifiers from the eav_attribute table.

In the catalog_product_entity_varchar table, entity_id represents the product identifier, and attribute_id represents the reference identifier from the attribute table.

Typically, the id 74 attribute is image , 75- small_image and 76- thumbnail . You can check the corresponding identifier in the eav_attribute table.

For example, if a product with entity_id 1,

If we check the value for the catalog_product_entity_varchar table, the value with respect to id 74 represents its image, 75 represents its small image, and 76 represents its thumbnail.

Hope this helps.

Answer 2

The values ​​refer to the catalog_product attributes and therefore are stored in catalog_product_entity_varchar .

Answer 3

This is just a products_temp table where you can check the image path of all products