4

where is products images column in magento2 database? i want to make a querey to check those products who haven't images wont come and products with only images comes on my homepage product list .

please elaborate if anybody knows : i figured out this table

(select * from catalog_product_entity_media_gallery) 

there are some images inside this table , thanks

1 Answer 1

3

if you have flat table enabled then you can also search for image column in catalog_product_flat table.

Magento uploads images by creating multiple directories based on image name

For example:

My image name is 11000_3008x1990_a.jpg, magento will create 2 directory with starting initial name 1 and other directory with name 1 hence my image path would be

pub/media/catalog/product/1/1/11000_3008x1990_a.jpg

Similarly Check your images under this path

pub/media/catalog/product/.

Hope this helps!

4
  • this table doesn't exist brother , i am using codazon/product_filter extension Feb 6, 2018 at 8:29
  • That why I have mentioned that if flat table is enabled, to enable it you can go to Admin panel -> System-> Configuration->Catalog->Catalog->Frontend->Use Flat Catalog Product->Yes. You should enable it only it is suitable for your website.
    – Shireen N
    Feb 6, 2018 at 8:47
  • alright i enabled it but still that table is not present in my db Feb 6, 2018 at 9:24
  • For this you will need to run the indexing command
    – Shireen N
    Feb 6, 2018 at 9:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.