Getting this error when trying to use a custom filter inside a custom theme.
I set the new attribute is_featured and its attribute set. I made a product that designated it as recognized (yes / no)
My homepage (in the CMS section) includes the following "panel"
<block type="catalog/product" name="catalog.product_featured_list" template="catalog/product/featured_list.phtml" after="-"/>
featured_list.phtml is as follows:
<?php $storeId = Mage::app()->getStore()->getId(); $_productCollection=Mage::getResourceModel('reports/product_collection') ->addAttributeToSelect(array('name', 'url', 'small_image', 'price', 'short_description')) ->addAttributeToFilter('is_featured', 1) ->addAttributeToFilter('status', 1) ->setPageSize(3) ->setStoreId($storeId) ->addStoreFilter($storeId); $_helper = $this->helper('catalog/output'); ?> <?php if($_productCollection->count()): ?> <section class="content-box clearfix"> <header> <h2>Featured products</h2> </header> <ul class="featured-products"> <?php foreach ($_productCollection as $_product): ?> <?php $_productNameStripped = $this->stripTags($_product->getName(), null, true); ?> <li> <h3> <a href="<?php echo $_product->getProductUrl(); ?>" title="<?php echo $_productNameStripped; ?>"> <?php echo $_helper->productAttribute($_product, $_product->getName() , 'name'); ?> </a> </h3> <a href="<?php echo $_product->getProductUrl(); ?>" title="<?php echo $_productNameStripped; ?>"> <img src="<?php echo $this->helper('catalog/image')->init($_product, 'small_image')->resize(212); ?>" width="200" height="200" alt="<?php echo $this->stripTags($this->getImageLabel($_product, 'small_image'), null, true) ?>" /> </a> <div> <ul class="clearfix"> <li>From £<?php echo number_format($_product->price, 2) ?></li> <li> <?php $desct = nl2br($this->htmlEscape($_product->getShortDescription())); $desct = strip_tags($_product->getShortDescription()); ?> <p> <? echo Mage::helper('core/string')->truncate($desct, '100'); ?> <a href="<?php echo $_product->getProductUrl(); ?>" title="<?php echo $_productNameStripped; ?>"> <?php echo $this->__('more details'); ?> </a> </p> </li> <li> <form action="<?php echo $this->helper('checkout/cart')->getAddUrl($_product); //echo $this->getAddToCartUrl($_product); ?>" class="product-list-add-to-cart" method="get" id="product_addtocart_form_<?php echo $_product->getId()?>"<?php if($_product->getOptions()): ?> enctype="multipart/form-data"<?php endif; ?>> <?php if(!$_product->isGrouped()): ?> <label for="qty"><?php echo $this->__('Qty') ?>:</label> <input type="text" class="input-text qty" name="qty" id="qty" maxlength="12" value="<?php echo ($this->getMinimalQty($_product)?$this->getMinimalQty($_product):1) ?>" /> <input type="hidden" name="product" value="<?php echo $_product->getId()?>" /> <?php endif; ?> <button type="button" class="button" onclick="this.form.submit()"><span><span><?php echo $this->__('Add to Cart') ?></span></span></button> </form> </li> </ul> </div> </li> <?php endforeach; ?> </ul> </section> <?php endif; ?>
It seems the problem is with the collection at the beginning of the block. (I can remove this panel from the home page and the site will load fine)
I am sure that all available attributes are available (is_featured looks like a single user attribute)
(This topic was inherited, so I’m not 100% versed in how it works! I just copy it)
Mr Pablo
source share