Product image not visible in category listing

[phantonym]

Hi,

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.

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?

[happy_shopper]

There is the Base attribute 'image', but there is no option for 'used in product listing' and there is 'gallery', perhaps it can be managed there.

[phantonym · Accepted solution]

I have solved it. The attribute which decides product image in category listing is small_image. However it doesn't allow to edit Use in product listing through admin pages. So I had to set update used_in_product_listing = 1 through SQL.