Magento Hot New Sale product tags

Magento Hot New Sale product tags

Magento Hot New Sale product tags: just follow below things to show stickers on category page /  search page or any custom listing page
Step1 : add below code on top

<?php 
 /* Best Seller */
$storeId = Mage::app()->getStore()->getId();
        $collection = Mage::getResourceModel('reports/product_collection')
            ->addOrderedQty()
            ->addAttributeToSelect('*')
            ->addAttributeToSelect(array('name', 'price', 'small_image'))
            ->setStoreId($storeId)
            ->addStoreFilter($storeId)
            ->setOrder('ordered_qty', 'desc'); // most best sellers on top
        Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($products);
        Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection); //filter only active products
        Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($collection); //filter only visible in catalog products
$bestseller = array(); 
foreach ($collection as $_product){
    $bestseller[] = $_product->getSku();    
}
/* Best Seller */
?>

Steps 2: now add below code in $product collection loop

<?php 
    /* NEW */
    $newProduct = ''; $onsaleProduct = '';
    $newFromDate = Mage::getModel('catalog/product')->load($_product->getID())->getNewsFromDate();
    $newToDate = Mage::getModel('catalog/product')->load($_product->getID())->getNewsToDate();
    $now = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT);
    
    if(($newFromDate< $now && $newFromDate != NULL) && ($newToDate> $now || $newToDate == '')){
        $newProduct =  "<div class='product_icon'>
                            <img class='new' alt='' src='".$this->getSkinUrl('images/new_product_img.png') ." '  />
                        </div>";
    }
?>
<?php 
    /* SALE */
    if ($_product->getPrice() > $_product->getFinalPrice()){
    $onsaleProduct =  "<div class='product_icon'>
                        <img class='onsale' alt='' src='".$this->getSkinUrl('images/sale_product_img.png') ." '  />
                      </div>";
} ?>
 
<?php echo $newProduct; ?>
<?php echo $onsaleProduct; ?>
<?php if(in_array($_product->getSku(),$bestseller)){ ?>
    <div class="product_icon">
        <img class="hot" src="<?php echo $this->getSkinUrl('images/hot_product_img.png'); ?>" alt=""> 
    </div>
<?php } ?>

Hope this is useful 😉

Regards