Which magenta table contains product image names?

Question

The problem I am facing is that I import products with Magmi (the open source import solution for magento), but I do not see the product image on the front side. I need to know which table in the magento database contains image names so that I can somehow fix it ...

Answer 1

catalog_product_entity_varchar

The above table stores the values ​​that will bind your images, but first you need to check the eav_attribute table to find the correct attribute_id key that will reference the image. Although this answers your question, I want to remind you that directly modifying the database is highly discouraged. Hope this makes sense.

Answer 2

catalog_product_entity_varchar refers to the attributes for base_image , small_image and thumbnail along with other attributes requiring an image.

To find all the images associated with the product, we found all the images listed in catalog_product_entity_media_gallery . This helped us find all duplicate images uploaded.

- We also used this post to find / fix missing images after downloading the product http://www.blog.magepsycho.com/tag/catalog_product_entity_media_gallery/

But, as already mentioned, use with caution!

Answer 3

catalog_product_entity_media_gallery_value_to_entity is what you will need to use to refer to which products are associated with which image.