http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=3872 Posted: 2008-10-31 08:17:44
Category: Product
Version: 1.1.6
Priority: urgent
Status: closed
Reported By: Sharma Roshan

i have create new attribute featured and display featured product on home page using the following code:-

<?php

/**
* New products block
*
* @category Mage
* @package Mage_Catalog
*/
class Mage_Catalog_Block_Product_Featured extends Mage_Catalog_Block_Product_Abstract
{
public function __construct()
{
parent::__construct();

$storeId = Mage::app()->getStore()->getId();
$product = Mage::getModel('catalog/product');
/* @var $product Mage_Catalog_Model_Product */
$todayDate = $product->getResource()->formatDate(time());
$products = $product->setStoreId($storeId)->getCollection()
->addAttributeToFilter('featured', array('yes'=>true))
->addAttributeToSelect(array('name', 'price', 'small_image'), 'inner')
->addAttributeToSelect(array('special_price', 'special_from_date', 'special_to_date'), 'left');
/* @var $products Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection */
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($products);
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($products);

$products->setOrder('hot_deals')->setPageSize(9)->setCurPage(1);

$this->setLoadedProductCollection($products);
}
}
?>

---

]]> #1 / Comment by Sharma Roshan

but using this code, all product shows "out of stock"]]> #2 / Comment by Magento Team

Hello Sharma Roshan,

This issue was fixed. The changes will be available in the next bugfix release.

Thank you.]]>