CODEWITHSUNDEEP
magentomagmi
Caballero
Caballero

Reputation: 12101

Which magento table contains product image names?

The problem I'm having is that I import products with Magmi (magento product import open source solution), but I don't see the product image on the front end. I need to know which table in magento database contains image names so that I could maybe feed it somehow directly...

Upvotes: 7

Views: 37531

Answers (3)

ladle3000
ladle3000

Reputation: 101

catalog_product_entity_media_gallery_value_to_entity is what you'll have to use to reference which product ties to which image.

Upvotes: 0

user1589800
user1589800

Reputation: 372

catalog_product_entity_varchar references the attributes for base_image, small_image & thumbnail along with other attributes requiring an image.

To find all of the images associates with a product we found all of the images listed within catalog_product_entity_media_gallery. This helped us find all duplicate images uploaded

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

But as already mentioned, use with caution!

Upvotes: 15

Tom
Tom

Reputation: 1234

catalog_product_entity_varchar

The table above stores the values that will link your images, but you need check first with the eav_attribute table to find the correct attribute_id key that will reference the image. While this answers your question, I want to remind you that making database changes directly is strongly discouraged. Hope this makes sense.

Upvotes: 24

Related Questions