So I created a custom attribute,
shipping, which is a drop down menu taking on three possible values. In its attribute settings I set the field
Used in Product Listing to 'Yes', did a reindexation, and now it is correctly added in the products' flat table
catalog_product_flat_1 such that I have the attribute_id field called
shipping and its value
Now in the frontend product page (view) I am trying to access the value of
shipping_value but only
shipping (the id of the attribute) is loaded in my current product - so it doesn't work..
It looks like Magento only loads a subset of the flat table columns into the product object. But I can't find where this is defined.
How can I load my flat table column
shipping_value + value into my product so I can use it in my frontend view?
Edit: I want to avoid doing another database lookup on the product view page. I'd like to just access the data like