Bestseller products in Magento

By: Damir Korpar, Last updated: Aug 28, 2023 | Published: May 07, 2014

Magento 1

Bestseller products is one of the features people tend to ask about and look for when it comes to Magento. Default installation already has bestseller products option included…but these are static ones defined in a CMS page. We’re going to take it to the next level and automate it.

Magento already uses bestseller products aggregation that can be checked under Admin > Reports > Products > Bestsellers. Thanks to this aggregated data we no longer need to determine the total of all the orders to see which products are sold the most. By the variety of aggregation data we’re able to get the most popular products not only from the beginning, but for each specific day, month or year.

There’s many ways of doing this. What I’ve found the most useful to me is to join product collection with the monthly bestseller aggregation. This way is fast and products can always be accessed even though the aggregation table is empty.

class Inchoo_Damir_Block_Bestsellers extends Mage_Core_Block_Template
{
public function getBestsellerProducts()
{
$storeId = (int) Mage::app()->getStore()->getId();
 
// Date
$date = new Zend_Date();
$toDate = $date->setDay(1)->getDate()->get('Y-MM-dd');
$fromDate = $date->subMonth(1)->getDate()->get('Y-MM-dd');
 
$collection = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
->addStoreFilter()
->addPriceData()
->addTaxPercents()
->addUrlRewrite()
->setPageSize(6);
 
$collection->getSelect()
->joinLeft(
array('aggregation' => $collection->getResource()->getTable('sales/bestsellers_aggregated_monthly')),
"e.entity_id = aggregation.product_id AND aggregation.store_id={$storeId} AND aggregation.period BETWEEN '{$fromDate}' AND '{$toDate}'",
array('SUM(aggregation.qty_ordered) AS sold_quantity')
)
->group('e.entity_id')
->order(array('sold_quantity DESC', 'e.created_at'));
 
Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($collection);
 
return $collection;
}
}

What the code does is that it returns a product collection joined with the aggregation table with the products sold the most in the last month. If this logic will be or is being used more than once, it’s recommended to place the join logic into catalog product collection file (by extending the file or by using the events) and to call it as a method when constructing the collection.

Now, when the product collection is ready, there are more ways to display them on the frontend. For the purposes of the article let’s replace the original html in the CMS page with a block call. As it can be seen from the code above, I’ve used my own block for the bestsellers logic. Open CMS > Pages, select the row with the identifier “home” and replace the content with the html below:

<div class="col-left side-col">
<p class="home-callout">&nbsp;</p>
<p class="home-callout"><img src="{{skin url='images/ph_callout_left_rebel.jpg'}}" alt="" border="0" /></p>
{{block type="tag/popular" template=“tag/popular.phtml"}}
</div>
<div class="home-spot">
<p class="home-callout"><img src="{{skin url='images/home_main_callout.jpg'}}" alt="" width="470" border="0" /></p>
<p class="home-callout"><img src="{{skin url='images/free_shipping_callout.jpg'}}" alt="" width="470" border="0" /></p>
{{block type="damir/bestsellers" template=“damir/bestsellers.phtml"}}
</div>

This html does nothing more than replace Magento’s div tag that contained static bestseller products with our block call. The next and the last thing that has to be done is to create a template file. The template file uses the same html structure as the CMS page:

<div class="box best-selling">
<h3>Best Selling Products</h3>
<table border="0" cellspacing="0">
<tbody>
<?php $counter=0; foreach ($this->getBestsellerProducts() as $product): ?>
<?php if ($counter%2 == 0): ?><tr class="<?php echo $counter%4 ? 'even' : 'odd'; ?>"><?php endif ?>
<td>
<a href="<?php echo $product->getProductUrl() ?>"><img class="product-img" src="<?php echo $this->helper('catalog/image')->init($product, 'small_image')->resize(99); ?>" alt="<?php echo $this->stripTags($this->getImageLabel($product, 'small_image'), null, true) ?>" width="95" border="0" /></a>
<div class="product-description">
<p><a href="<?php echo $product->getProductUrl() ?>"><?php echo $this->stripTags($product->getName(), null, true); ?></a></p>
</div>
</td>
<?php if ($counter++%2): ?></tr><?php endif ?>
<?php endforeach; ?>
</tbody>
</table>
</div>

This example uses monthly aggregation which I’ve found the most useful. There’s also daily aggregation that can be use and yearly, which is unlikely to be used often. Many Magento extensions can be found around that does the same thing, just a little bit nicely wrapped, but the logic is actually in one fairly simple method.

As it’s highly not recommended to modify the core files, each project basically has to have at least one module to place our own block. If you’re unfamiliar with how to create modules, there’s a nice article to read about the basics of creating a Magento module that I recommend.

Note: This is a revamp of the article originally written in December 2008

Published in:

Magento 1

90 comments

Mekaeil says:
May 23, 2017 at 12:01
Thank you so much Damir
Great Post and very helpfull.
Reply
avi chitranshu says:
May 19, 2017 at 8:42
Hi, Can you help me finding bestselling product in .phtml file .I am using Magento2 .
Reply
saad khan says:
Mar 01, 2017 at 7:44
how to disable out of stock items on best seller product slider plz help me
Reply
vish patel says:
Sep 14, 2016 at 14:49
Little confused as to why you are using SUM function on qty_ordered, seems to be doubling the totals.
```
array('SUM(aggregation.qty_ordered) AS sold_quantity')
```
Also, the query where clause has aggregation.store_id={$storeId} even though above ->addStoreFilter() is stated above?
Likewise, is the products meant to be different from Reports -> products -> bestsellersc?
Reply
xuannd says:
Jan 18, 2016 at 10:13
Thanks for sharing.
For now the code is not adapted to work with flat catalog, and I fixed this issuse.
class Mage_Catalog_Block_Product_Bestseller extends Mage_Catalog_Block_Product_Abstract {
protected function _beforeToHtml(){
// Get limit products
$limitProducts = $this->getLimit();
if($limitProducts == “”) $limitProducts = 12;
$storeId = Mage::app()->getStore()->getId();
$products = Mage::getResourceModel(‘reports/product_collection’)
->addAttributeToSelect(‘*’)
->addAttributeToSelect(array(‘name’, ‘price’, ‘small_image’))
->addOrderedQty()
->setStoreId($storeId)
->addStoreFilter($storeId)
->setOrder(‘ordered_qty’, ‘desc’); // Best sellers on top
// Enabled flat catalog product
if (Mage::helper(‘catalog/product_flat’)->isEnabled()) {
$products->getSelect()->joinInner(array(‘e2’ => ‘catalog_product_flat_’.$storeId), ‘e2.entity_id = e.entity_id’);
}
Mage::getSingleton(‘catalog/product_status’)->addVisibleFilterToCollection($products);
Mage::getSingleton(‘catalog/product_visibility’)->addVisibleInCatalogFilterToCollection($products);
// Get best sellers for specific category
if($categoryId = $this->getData(‘category_id’)){
$category = Mage::getModel(‘catalog/category’)->load($categoryId);
$products->addCategoryFilter($category);
}
// Set limit products
$products->setPageSize($limitProducts)->setCurPage(1);
$this->setProductCollection($products);
return parent::_beforeToHtml();
}
}
Reply
Fekadesilassie says:
May 13, 2015 at 16:55
That is one amazing work. I were performing a search and displaying results ordered by bestsellers in dropdown. Your code saved my day. Thank you very much.
Reply
PAJ says:
May 06, 2015 at 10:25
If you see strange results from this bestsellers collection remember that it is sorting on visible products, if your bestseller is a child of a grouped or configurable product which is not visible in the database then you will not see the product. To work around this you need to manually filter all results and detect child products and then load the parent into a new collection. Then you will see accurate bestseller data.
Reply
Chitvendra Kumar says:
May 02, 2015 at 18:39
our website take more time open
Reply
haunv says:
Mar 09, 2015 at 4:48
greate code i’m using for magento 1901 and it good work
Reply
Geoff Jackson says:
Dec 16, 2014 at 17:38
It would be great if this could be extended to join simple products with the configurables where sold¬quantity return NULL so that the configurable products (visible frontend) can show in the bestsellers block for their simple products (not visible in frontend) sales.
This modification currently doesn’t support that so can only really be used in a catalog where all products are visible in the frontend or those that don’t have product options.
Reply

How to get Beselling Product of an category (ex ID of that category is 35)????

Add category filter to product collection

$category = Mage::getModel('catalog/category')->load(35); // 35 is category id
$collection = Mage::getResourceModel('catalog/product_collection')
            ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
            ->addCategoryFilter($category)
            ->addStoreFilter()
            ->addPriceData()
            ->addTaxPercents()
            ->addUrlRewrite()
            ->setPageSize(6);

hong says:
Jun 19, 2014 at 5:04
I want to display products not bestseller in admin page of report sales, How to do?
Can you help me. thanks all
Reply
Santosh says:
Jun 13, 2014 at 8:43
i have applied this code on magento 1.7 but it is not working properly.
please help me..
Reply
Mayur says:
Jun 05, 2014 at 17:15
FYI – the star system isn’t working correctly 🙂
Reply
Adrian Matthews says:
May 29, 2014 at 7:47
It seems to be good however a solution with category id will go much better.
Reply
walker says:
Jun 07, 2013 at 16:45
hello
thank you for useful post, magneto gives us great base potential for ecommerce. But there are some cases when base magento functionality is not enough and i think that for bestsellers would be suitable use an extension with big potential. i’m speaking about http://amasty.com/improved-sorting.html
i think that it would be interesting to read some information.
thank you
Reply
Nhuchhe says:
May 23, 2013 at 13:34
Bestseller is not working for Bundled product. Can you please explain it.
Thanks.
Reply

On my last comment

if ($this->isEnabledFlat()) {

should have been

if (Mage::helper('catalog/product_flat')->isEnabled()) {

Works well, but I found that enabling flat products breaks this code, untill you add an innerjoin and move the visibility filter down…

e.g

        /* @var $products Mage_Reports_Model_Resource_Product_Collection */
        $products = Mage::getResourceModel('reports/product_collection')
            //->addAttributeToSelect('*')
            ->addAttributeToSelect(array('name','price','small_image'))
            ->addOrderedQty()
            ->setStoreId($storeId)
            ->addStoreFilter($storeId)
            ->setOrder('ordered_qty','desc'); //best sellers on top

            if ($this->isEnabledFlat()) {
                $products->getSelect()->joinInner(array('e2' => 'catalog_product_flat_'.$storeId), 'e2.entity_id = e.entity_id');
            }

            $products->addAttributeToFilter('visibility', $visibility);

daniel says:
Feb 11, 2013 at 10:00
Hi, I tried your code, but nothing was showed on my home screen. No data was displayed. I work with magento 1.7 and I have a lot of problems with it. Maybe you know something what went wrong. I used your latest bestseller.zip
Greetings
Daniel
Reply
kea says:
Dec 11, 2012 at 4:42
it works in magento 1.7.2, can you filter weekly seller?
Reply
Srdjan says:
Oct 16, 2012 at 14:55
Functionality is pretty much trivial, you can start from here:
http://www.netismine.com/magento/get-bestsellers-collection
Reply
zoran says:
Oct 16, 2012 at 13:50
Is anyone manage to get this to work on magento 1.7 ?
Reply
MARCOS says:
Aug 06, 2012 at 0:52
Hi
I have magento 1.6.2.0
where exatle a have to put the inchoo dir???
i put in
\app\design\frontend\base\default\template\inchoo…
in this case, the block is same????
{{block type=”core/template” template=”inchoo/bestseller.phtml”}}
Reply
mycon says:
Jul 30, 2012 at 17:10
When I Go to your Demo Admin interface
– System > Configuration > Catalog
– set Use Flat Catalog Category Yes
– set Use Flat Catalog Product Yes
– Reindex the tables
– Go to frontend end see the bugs…thats it!
SELECT SUM(order_items.qty_ordered) AS `ordered_qty`, `order_items`.`name` AS `order_items_name`, `order_items`.`product_id` AS `entity_id`, `e`.`entity_type_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`sku`, `e`.`has_options`, `e`.`required_options`, `e`.`created_at`, `e`.`updated_at`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`cost`, `e`.`created_at`, `e`.`enable_googlecheckout`, `e`.`gift_message_available`, `e`.`has_options`, `e`.`image_label`, `e`.`is_imported`, `e`.`is_recurring`, `e`.`links_exist`, `e`.`links_purchased_separately`, `e`.`links_title`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`msrp_enabled`, `e`.`name`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`price`, `e`.`price_type`, `e`.`price_view`, `e`.`recurring_profile`, `e`.`required_options`, `e`.`shipment_type`, `e`.`short_description`, `e`.`sku`, `e`.`sku_type`, `e`.`small_image`, `e`.`small_image_label`, `e`.`special_from_date`, `e`.`special_price`, `e`.`special_to_date`, `e`.`tax_class_id`, `e`.`thumbnail`, `e`.`thumbnail_label`, `e`.`updated_at`, `e`.`url_key`, `e`.`url_path`, `e`.`visibility`, `e`.`weight`, `e`.`weight_type`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`price`, `e`.`small_image`, `cat_index`.`position` AS `cat_index_position` FROM `sales_flat_order_item` AS `order_items`
INNER JOIN `sales_flat_order` AS `order` ON `order`.entity_id = order_items.order_id AND `order`.state <> ‘canceled’
LEFT JOIN `catalog_product_entity` AS `e` ON (e.type_id NOT IN (‘grouped’, ‘configurable’, ‘bundle’)) AND e.entity_id = order_items.product_id AND e.entity_type_id = 4
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = ‘1’ AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=’1′ AND cat_index.visibility IN(2, 4) AND cat_index.category_id=’2′ WHERE (parent_item_id IS NULL) GROUP BY `order_items`.`product_id` HAVING (SUM(order_items.qty_ordered) > 0) ORDER BY `ordered_qty` desc LIMIT 8
Trace:
#0 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Zend\Db\Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT SUM(orde…’, Array)
#4 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Varien\Db\Adapter\Pdo\Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT SUM(orde…’, Array)
#5 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Zend\Db\Adapter\Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(‘SELECT SUM(orde…’, Array)
#6 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Varien\Data\Collection\Db.php(687): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT SUM(orde…’, Array)
#7 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Eav\Model\Entity\Collection\Abstract.php(1007): Varien_Data_Collection_Db->_fetchAll(‘SELECT SUM(orde…’)
#8 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Eav\Model\Entity\Collection\Abstract.php(831): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 D:\xampp\htdocs\magentoma\ma_furniturestore\lib\Varien\Data\Collection.php(740): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 D:\xampp\htdocs\magentoma\ma_furniturestore\app\design\frontend\default\ma_furniturestore_orange\template\magentothem\bestsellerproductvertscroller\bestsellerleft.phtml(42): Varien_Data_Collection->count()
#11 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Template.php(241): include(‘D:\xampp\htdocs…’)
#12 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend\defaul…’)
#13 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Template.php(286): Mage_Core_Block_Template->renderView()
#14 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#15 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Text\List.php(43): Mage_Core_Block_Abstract->toHtml()
#16 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#17 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#18 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(‘left’, true)
#19 D:\xampp\htdocs\magentoma\ma_furniturestore\app\design\frontend\default\ma_furniturestore_orange\template\page\3columns.phtml(52): Mage_Core_Block_Abstract->getChildHtml(‘left’)
#20 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Template.php(241): include(‘D:\xampp\htdocs…’)
#21 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend\defaul…’)
#22 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Template.php(286): Mage_Core_Block_Template->renderView()
#23 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Block\Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#24 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Model\Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#25 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Controller\Varien\Action.php(391): Mage_Core_Model_Layout->getOutput()
#26 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Cms\Helper\Page.php(132): Mage_Core_Controller_Varien_Action->renderLayout()
#27 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Cms\Helper\Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘home’)
#28 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Cms\controllers\IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
#29 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Controller\Varien\Action.php(420): Mage_Cms_IndexController->indexAction()
#30 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
#31 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Controller\Varien\Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#32 D:\xampp\htdocs\magentoma\ma_furniturestore\app\code\core\Mage\Core\Model\App.php(347): Mage_Core_Controller_Varien_Front->dispatch()
#33 D:\xampp\htdocs\magentoma\ma_furniturestore\app\Mage.php(640): Mage_Core_Model_App->run(Array)
#34 D:\xampp\htdocs\magentoma\ma_furniturestore\index.php(80): Mage::run(”, ‘store’)
#35 {main}
Reply
Lenny says:
Jul 02, 2012 at 17:33
Great post though I can’t get it to work on grouped products, I can display the invisible items of course but it won’t link to grouped item or the item as it’s invisible (being part of the grouped!)!
Can you help?
Reply
tuba says:
Jun 04, 2012 at 21:37
if we disable the line :
->addAttributeToFilter(‘visibility’, $visibility)
then it works.
Reply
mahesh kalantre says:
Jun 04, 2012 at 16:15
hey this is very usefull block, let me know how to add “Add TO Cart ” button in this code
Reply
Amelie says:
Apr 28, 2012 at 3:57
Can you tell us where to create exactly the folder “inchoo” ?
Reply
Pravin says:
Apr 12, 2012 at 13:57
@Alexander
Can you please provide a hint about how you use categopry based solution.
In my case i have the same root category for both store
THanks
Reply
Alexander says:
Apr 08, 2012 at 18:36
A category id based solution will be good. On Magento 1.6.2.0 stable it works not. I developed now my own bestseller extension.
Reply
Teju says:
Mar 31, 2012 at 7:41
I have use magneto 1.6.2 it not working.
i have put the bestseller.phtml \www\e4hats\magento\app\design\frontend\default\e4hats\template\catalog\product
i have create block cms->static block
{{block type=”catalog/product_list”template=”catalog/product/bestseller.phtml”}}
Reply
Jones says:
Mar 26, 2012 at 17:04
On Magento 1.6.2 It is also not working.
I’ve inserted the file bestseller.phtml to mytemlate/inchoo/
is there anything else to do?
PLEASE HELP
Reply

On upgrade from 1.4 to 1.6 , it is not working.
It do not shows the addAttributeToSelect attributes in phtml as well as it do not even filter store wise.

Here is the query it is shoing

SELECT SUM(order_items.qty_ordered) AS `ordered_qty`, `order_items`.`name` AS `order_items_name`, `order_items`.`product_id` AS `entity_id`, `e`.`entity_type_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`sku`, `e`.`has_options`, `e`.`required_options`, `e`.`created_at`, `e`.`updated_at` FROM `tp_sales_flat_order_item` AS `order_items` INNER JOIN `tp_sales_flat_order` AS `order` ON `order`.entity_id = order_items.order_id AND `order`.state <> 'cancelled' LEFT JOIN `tp_catalog_product_entity` AS `e` ON (e.type_id NOT IN ('grouped', 'configurable', 'bundle')) AND e.entity_id = order_items.product_id AND e.entity_type_id = 4 WHERE (parent_item_id IS NULL) GROUP BY `order_items`.`product_id` HAVING (SUM(order_items.qty_ordered) > 0) ORDER BY `ordered_qty` desc LIMIT 4

Mike says:
Mar 08, 2012 at 13:00
Works flawlessly on 1.6.2.
Cheers Branko!
Reply
Magento says:
Feb 24, 2012 at 15:34
On 1.6.1 i get nothing … no errors and no bestseller … also after cache clearing.
{{block type=”core/template” template=”myTemplate/bestseller.phtml”}}
Reply

It drops an exception error in 1.5.1.0 on the line:

$_productCollection = Mage::getResourceModel('reports/product_collection')
                              ->addAttributeToSelect('*')
                              ->addOrderedQty()
                              ->addAttributeToFilter('visibility', $visibility)
                              ->setOrder('ordered_qty', 'desc');

any ideas?

Dragan Simonovic says:
Jan 10, 2012 at 14:29
Is it possible to include toolbar with pagination and everything?
Reply
Tejasvini says:
Oct 30, 2011 at 12:14
get price html using following code on bestesller.phtml:
$storeId = Mage::app()->getStore()->getId(); $_product= Mage::getModel(‘catalog/product’)->setStoreId($storeId)->load($product->entity_id);
$theProductBlock = new Mage_Catalog_Block_Product; echo $theProductBlock->getPriceHtml($_product, true);
Reply
Tejasvini says:
Oct 30, 2011 at 12:12
For using pricehtml on bestseller.phtml use the following code:
setStoreId($storeId)->load($product->entity_id); ?>
getPriceHtml($_product, true); ?>
Regards,
Tejasvini
Reply
Sunil says:
Oct 20, 2011 at 10:00
Bestsellers is not working.
Reply
sohail says:
Oct 19, 2011 at 14:49
This is amazing. Thanx
Reply
Erik says:
Oct 16, 2011 at 20:31
Hi Roman,
The issue regarding the adding in the cart and price display has been solved. I have uploaded a new bestseller.phtml to the zip file. Thank you for bringing up the bug!
Reply
Roman says:
Oct 15, 2011 at 18:31
Hi Erik,
your extended code looks great, but adding to the cart doesn’t work and there is no price shown. Any tips how to manage these issues?
Reply
Erik says:
Jul 06, 2011 at 18:28
Hi Chintan!
What I get is that you want to run bestseller calculation only once
and to set a bestseller flag attribute on products and when page loads the query is done by that attribute.
Yes it can be done. You have to access each bestseller product object and update the flag.
Reply
chintan says:
Jul 06, 2011 at 9:09
Hi.. Is there any way i can assign BEST SELLER sticker..
I have created attribute named sticker and its value is bestseller.. I want my code to update sticker (attribute value) of products every night.. and top 5 sold products gets sticker attribute value to Best Seller..
Any other option of getting this feature..?
Reply
chintan says:
Jul 02, 2011 at 7:50
Hello I Tried with this.. but Category: shows blank.. I mean if a product is under Furniture .. then product is shown but not its category name.. I am using magento 1.5.. and will try the same with 1.6
Reply
Erik says:
Jun 19, 2011 at 13:06
Hi! I have extended the code in order to show the bestseller for categories. Check out http://www.mage-contacts.com/magento-category-bestseller/
Reply
Ashief says:
May 18, 2011 at 6:31
i have used this code for my best seller product display in home page but the best seller product which displays in home page is different from the bestsellers which displays in admin dashboard.can anyone help me out to display correct product? may i know the table name which the ‘Quantity Ordered’ stores? thanks in advance please help.
Reply
testphp says:
May 03, 2011 at 13:39
Hi
I am working on magento project , I have a issue some product url setting in home, i have home page in my site which display the product from different
Category e.g best sell, hot deal, new, so i want to change url on home as after domain name e.g it should be ,http://sitename.com/best_sell/product_url.html but i want to same like http://sitename.com/product_url.html.. only on home page and inner catalog working is fine..
So is there any solution to fix the problem.?
Reply me it will be really appreciated.
Reply
Srdjan says:
Apr 08, 2011 at 13:39
You sure you can always get an up-to-date list from the reports table?
Reply
suvi says:
Nov 16, 2010 at 16:06
Hi
Is it also possible to show the quantity of sold items for this products?
Reply
fay says:
Oct 15, 2010 at 15:24
I want to show the bestseller right sidebar of homepage , any body help me ?
Reply
Sam says:
Sep 21, 2010 at 20:01
I was using this technique for a while now, but I just realised that it doesn’t work if caching is enabled? Any way around that?
Reply
muzafar says:
Aug 18, 2010 at 12:54
hi,
good work, i am facing a problem with this extension they fetch all prduct from all store/website, i want to limitize this extension to one store, how i can do that ..? :).
second thing is it possible from one or more categories.
Thanks
Muzafar Ali
Reply
ddjohn says:
Jun 01, 2010 at 5:06
why configurable products does not display?How to filter?thanks ~
Reply
Lolo says:
May 27, 2010 at 20:35
Very nice !
How can we add a button add to cart?
Thk’s
Reply
Pingback: Helpful Magento Tutorials from the Web | Jake Rutter - Front-End Developer and Designer, CSS, jQuery, PHP/mySQL, Magento
ali says:
May 18, 2010 at 14:02
when i research this situation , i saw that it works when i put blocks code in homepage cms , but when i try to use catalog xml , it cant get variable.
Reply
ali says:
May 18, 2010 at 12:18
here is my catalog.xml code;
Reply
ali says:
May 18, 2010 at 12:17
i’m using magento 1.4 but i couldnt success put variable (show total) to phtml file ,
in bestseller.phtml
$totalPerPage = ($this->show_total) ? $this->show_total : 6;
this code return always value 6 ,
whats wrong?
Reply
Quentin Peyramale says:
May 07, 2010 at 15:53
Hello
I want to give a title separably for a promotional product block and a bestseller block. How can I differences the two block?
Thanks
Reply
Sajid Iqbal says:
Apr 09, 2010 at 19:04
This doesn’t fully work. Currency sign not displayed and .0000 displayed. How to display it correctly.
Reply
Sajid Iqbal says:
Apr 08, 2010 at 12:14
oh I got it………?php echo $product->price ?
Reply
Sajid Iqbal says:
Apr 08, 2010 at 12:10
Hi,
First of all thanks for this wonderful module. It works for me perfectly under Magento 1.4. I need help regarding price, how can I display price along each product?
Reply
Joshua Lee says:
Apr 07, 2010 at 9:22
THX, i’m a primary learner of magento…But i’m not familiar with Zend framework method…
Reply
Rameez says:
Feb 09, 2010 at 1:52
Hi, Sorry but this code doesn’t work for me, Might be I m doing something wrong.
I hv created one directory call bestseller under the template directory in my theme.
so path for the bestseller.phtml is “C:\wamp\www\magento\app\design\frontend\default\mycustom\template\bestseller\bestseller.phtml” , is that right ???
and I hv put that block part in my homepage content section.. and i hv changed to {{block type=”core/template” show_total=”12? template=”bestseller/bestseller.phtml”}}
So what is the wrong here?
I couldn’t see anything on my homepage..
Plz help.
Reply
Johan Strand says:
Jan 22, 2010 at 23:13
Hi,
I wonder if it would, with the help of your code, be possible to add the product->ordered_qty in same way in the backend, to be able to see
how many of each products that has been ordered..
Thanks
Johan
Reply
Yasir says:
Oct 26, 2009 at 9:09
Excellent thanks for the tutorial that’s what i was looking for how i can integrate custom .phtml files to magento could’t think that would be that easy may i as how you get to know this 😉 so in future i will try to think your way 🙂 this is the only place except magento forum or wiki i can read about magento.
Thanks again.
Reply
Tanima says:
Aug 07, 2009 at 13:30
Where do I place the bestseller.phtml file? I mean to say which folder?
Reply
andrew says:
Jul 27, 2009 at 17:29
i prefer using this module than the new one as my products are not that much. i have it set on my front page and it is showing the best selling products in vertical form, how can i make it to show them like the best selling products html form table magento has by default?
Reply
Pingback: Colin Mollenhour’s Technical Blog » Adding Minimal Price To Any Product Collection in Magento
LE says:
May 29, 2009 at 9:13
i followed your code as it is.but still i couldn’t add bestseller to the homepage.can any one help me as soon as possible…
Thank you…
Reply
makku says:
Apr 25, 2009 at 6:31
thank u branko
Reply
Branko Ajzele says:
Apr 21, 2009 at 7:26
@Jakub
This is an old article an a old approach. Here is a new module (the real module) that is way more faster http://ajzele.net/magento-bestseller-module-extensions/
Reply
Jakub says:
Apr 17, 2009 at 11:08
Speed – currend module loads all products and than only displays specified number of products. That is very very slow on a website with thousands of products.
Just add ->setPageSize($totalPerPage) to the Mage::getResourceModel and it will be much faster.
Reply
Jakub Milata says:
Mar 24, 2009 at 16:28
1) It seems that it does not work for current store view. It displays products from another store.
2) I want to use this module to display newest products. Do you think that changing ->setOrder(‘ordered_qty’, ‘desc’); to ->setOrder(‘created_at’, ‘desc’); will work?
Reply
Mike says:
Mar 13, 2009 at 16:00
Yes, is it possible to implement getPriceHtml?
Cannot make it work 🙁
Please help,
thanks!
Reply
Apsy says:
Mar 08, 2009 at 16:16
How are you able to display the path to the template file ? Is it a module ? Or i’m missing an important feature of Magento… ?!
Thanks
Reply
Marc Falk says:
Feb 02, 2009 at 17:12
Is it possible for me to implement getPriceHtml($_product, true, ‘-best’) ?> in this piece of code? getPrice works, but I need getPriceHtml.
Thanks in advance 🙂
Reply
Danilo says:
Jan 26, 2009 at 11:50
Thanks for that 🙂
It works perfectly.
Reply
jdmoon says:
Jan 15, 2009 at 23:12
Hi,
Is it possible to get this block to work with configurable products also. I’m affraid that those lines:
Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH,
Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG
are pretty good at not taking single products which are a part of configurables into account. :/
Reply
Marco Conti says:
Jan 07, 2009 at 2:11
Maybe something happened to the Magento filesystem with the latest update, but I can’t find “bestseller.phtml anywhere. Given the depth of Magento’s file system, when referring to files it would hep if a full path was provided. Thanks.
Reply
quiche says:
Dec 18, 2008 at 7:39
@osdave: thanks, I had the same problem … but I did’nt have to think it ” ….
{{block type=”core/template” template=”inchoo/bestseller.phtml”}}
Reply
Robert says:
Dec 16, 2008 at 8:28
Of course my XML tag has bee eaten by WordPress :). But I’m sure you know what I mean?
Reply
Robert says:
Dec 16, 2008 at 8:26
Hey Branko, thanks once more for another good Magento tip. I’ve been learning a few things from your sites.
I have a question about your show_total property. You set it in the block description that goes in the content of the page. I was trying to do a similar thing in the layout xml files for some of my own blocks but it doesn’t seem to work in that case. I.e

Do you know why this is?
Also, if you’re preparing another tutorial, could you possibly do one about the various filter option when retrieving a collection (the add*Filter() methods)
Thanks a lot.
Reply
osdave says:
Dec 11, 2008 at 21:21
@Jack: if you copied the code from here and pasted it in the home page admin’s CMS management screen, you have to change the “, in: {{block type=”core/template” template=”inchoo/bestseller.phtml”}}
@Branko: thanx for this tutorial, very helpfull, as always.
I imagine you’re aware that configurable products don’t show up with this method. I’m going to look into it to see if I can manage them to appear, but if you have a hint for me I’d be please to read it 🙂
Reply
Jack says:
Dec 11, 2008 at 6:22
I actually tried using your technique to display the bestellers but nothing shows up on the page … And i’m pretty sure i followed your instructions exactly and i deactivated the cache in Magento. I’m using Magento 1.8. It’s really strange…
Reply
Jack says:
Dec 11, 2008 at 5:33
Thanks, this post is really useful!
Do you think that on the basis of this “bestseller” phtml file it would be possible to edit it so that it only displays the items with a stock lower than 10 instead of displaying the bestsellers?
Reply

You made it all the way down here so you must have enjoyed this post! You may also like:

Shell script for converting configurable to grouped products

Large number of input variables in Magento

Programmatically create bundle products in Magento

90 comments

Leave a Reply Cancel reply