StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I just came to this issue the other day. Same Magento version (1.7.0.2) although different symptoms. I was actually seeing the images correctly on my site. My problem was that my custom reports with number of products (total, active, without description/shortdescription, without images/small/thumbnails) started to give incorrect results and found that it was since I activated flat product tables.</p> <p>It turns out that the Magento API (Mage::getModel('catalog/product')->getCollection()) automatically uses the flat tables, and there isn't the same amount of information there, but only the one strictly necessary.</p> <p>For instance, not all attributes are copied, but only those that are classified as "Used in product listing". In my case, both description and image were not copied, so I went to the admin and set to Yes "Used in product listing" for both.</p> <p>In case of the image it wasn't quite easy, as its "Catalog input type for store owner" (Media image) effectively hides the "Used in product listing" field. So I needed a browser developer tool (like Firebug or Chrome Dev tools) to first remove the disabled="disabled" HTML attribute from the "Catalog input type for store owner" field, and change it to some other value. Now the "Used in product listing" field is visible, set it to Yes. And finally revert the "Catalog input type for store owner" value back to "Media image".</p> <p>If you inspect the flat table (catalog_product_flat_) then you'll see the image and description attributes and you.</p> <p>This process worked for me. I then rechecked my catalog listings and similar pages just to avoid any nasty side effect... Hope it works for you</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload