media attribute in product flat data

[speerio]

Hello,

I have added an extra media attribute in magento (1.8.1) an need this attribute in the  product flat data table.

( the  option "use in product listing" is not available on this type)

I found some answers on the internet but none of them worked.

How can i get a media attribute into the product flat data?

[speerio · Accepted solution]

OK, solved the issue my self. Just set the value "used in product listing" to 1 directly in the database.

Re-index en cleared the cache and everything works as hoped.

[yoursownme10c0]

The Solis Solar Inverter combines advanced solar technology with reliable power conversion, ensuring maximum energy efficiency for residential and commercial setups. Designed for durability, it offers seamless connectivity, smart monitoring, and eco-friendly performance. With compact design and robust safety features, Solis delivers consistent power output, reducing energy costs while supporting sustainable living. Ideal for modern energy systems, it enhances reliability and performance across diverse applications.