Showing posts with label How To Display Best Selling Products On Magento Store. Show all posts
Showing posts with label How To Display Best Selling Products On Magento Store. Show all posts

Friday 12 September 2014

Bestseller products in magento


Bestseller products in magento

<?php
$totalPerPage = ($this->show_total) ? $this->show_total : 5;
$cnt = 1;
$visibility = array(
 Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH,
 Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG
           );

$storeId = Mage::app()->getStore()->getId();
$_productCollection = Mage::getResourceModel('reports/product_collection')
                              ->addAttributeToSelect('*')
                              ->addOrderedQty()
                              ->addAttributeToFilter('visibility', $visibility)
                              ->setOrder('ordered_qty', 'desc');
?>
<?php foreach($_productCollection as $product): ?>
<?php if($cnt <= $totalPerPage): ?>
        <?php $productUrl =  $product->getProductUrl() ?>
        <a href="<?php echo $productUrl ?>" title="View <?php echo $product->name ?>">
          <h2><?php echo $product->name ?></h2>
        </a>
        <small><?php echo $this->__('Total soled qty') ?>: <?php echo (int)$product->ordered_qty ?></small><br />
     
        <a href="<?php echo $productUrl ?>" title="<?php echo $product->name ?>">
        <img src="<?php echo $this->helper('catalog/image')->init($product, 'image')->resize(220,300); ?>" alt=""  />
        </a> <br />
        <p><?php echo $product->short_description ?></p>
    <?php endif; $cnt++; ?>
<?php endforeach; ?>