I did update m2_catalog_eav_attribute set used_in_product_listing = 0; to reduce the size of flat table. Now the product image is not visible in category view.

enter image description here

The image is not being displayed because "Use in product listing" has been disabled for all attributes. I need to enable it again for the specific attribute. But I don't know which attribute. I tried to enable it for all attributes with "image" in its name, but no success.

Which attribute is for the product image?

enter image description here

  • please check my ans. Commented Jan 22, 2019 at 5:19

2 Answers 2


pls run command to resize images on frontend:

bin/magento catalog:image:resize

Solved my own question. The attribute for product images in category listing is small_image. However, it doesn't allow you to edit Used in product listing in admin pages. So I had to execute an SQL query update m2_catalog_eav_attribute set used_in_product_listing = 1 where attribute_id = xx.

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.