Which magento table contains product image names?

magento magmi
Caballero picture Caballero · Aug 14, 2011 · Viewed 34.5k times · Source

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...

Answer

Tom S picture Tom S · Aug 14, 2011

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.

Related questions

Change Magento product's attribute set.

I want to change the attribute set of Magento. I searched through, and everyone suggested to delete the product and re-import it with new attribute set. I did the same however after importing the data I could not see product …

Read More
Magmi csv format?

I can 't seem to find an example of the format Magmi wants for the csv data. Could someone please provide a one-line example of a successful product import? Edit: Magmi Wiki: http://sourceforge.net/apps/mediawiki/magmi/index.php?…

Read More
how to use magmi for importing in magento?

I want to import simple products by magmi, installed already and the csv created with one sample product, magmi can read it but not inserting it, the csv is the default but with media_gallery column i don't know what …

Read More