How to display bestselling products in Magento + source code

How to display bestselling products in Magento
Posted in: Magento 2 Guides

We’ve noticed that many store owners ask questions about methods of displaying bestselling products on their Magento stores. Say, you need to show the most popular items on your Home page or Category View page.

Unfortunately, there’s no such default feature in Magento, but you can easily do this yourself. Read on to see the instructions!

 Choose to display bestselling products to a specific customer group only with this Magento 2 Customer Groups extension.

STEPS TO DISPLAY BESTSELLING PRODUCTS ON A PAGE IN MAGENTO

1. Create a new file for Block:

Magento_root/app/code/local/Mage/Catalog/Block/Product/Bestseller.php

You can download the file for free at the end of the article. The file contains the algorithm of returning the necessary products collection, Bestsellers in our case.

2. Create a template file for the new block:

Magento_root/app/design/frontend/base/default/template/catalog/product/bestseller.phtml

You can download the file for free at the end of the article. This file works with visualization of our bestsellers collection on a given page. It is just an example; you are welcome to use the list.phtml template from your theme. Please do not forget to do that so the look of the collection is adjusted to your website’s design.

3. Now you need to call the created block, to do that go to Backend > CMS > Pages > Edit Page ‘Home page’ and add the following lines of code:

block type="catalog/product_bestseller" template="catalog/product/bestseller.phtml" header="Bestsellers" limit=4

Also you can add a new block via layout update:

<reference name="content">
<block type="catalog/product_bestseller" name="bestseller" template="catalog/product/bestseller.phtml" before="-">
<action method="setLimit"><limit>3</limit></action>
<action method="setHeader"><header>Best Sellers</header></action>
</block>
</reference>

For instance, try to add this block to the Category View page here:

Backend > Catalog > Manage Categories > Click needed category in the category tree > `Custom Design` horizontal tab > ` Custom Layout Update` field

Feel free to manipulate the result using the header and the limit variables.

If just adding a list of bestsellers is not enough, consider checking the Improved Sorting extension, which is also compatible with layered navigation. It lets your customers sort the products by Best Selling, Most Viewed, Top Rated, Reviews Count, and other parameters.
Please note that this solution doesn’t work with Flat Catalog. To make this work, please disable this option in your store settings.

SUPEE-6788 UPDATE

When adding the block to the CMS page or Static block and using the following code:

[php]block type=”catalog/product_bestseller” template=”catalog/product/bestseller.phtml” header=”Bestsellers” limit=4[/php]

you need to create a permission for this block:
Backend – > System – > Permissions – > Blocks – > `Add New Block` button

This manipulation is needed to be done for Magento 1.9.2.2 and higher or after installing SUPEE-6788 security patch.
Adding the block via Custom Layout Update works well in any situation:

[php]<reference name=”content”>
<block type=”catalog/product_bestseller” name=”bestseller” template=”catalog/product/bestseller.phtml” before=”-“>
<action method=”setLimit”><limit>4</limit></action>
<action method=”setHeader”><header>Best Sellers</header></action>
</block>
</reference>[/php]

26.01.2016 UPDATE

The code now works with flat catalog, plus the category variable is added, and you can use a certain category for the product selection.
Add Magento bestsellers via CMS block:

[php]block type=”catalog/product_bestseller” template=”catalog/product/bestseller.phtml” header=”Bestsellers” limit=4 category=24[/php]

Add Magento bestsellers via layout update:

[php]<reference name=”content”> <block type=”catalog/product_bestseller” name=”bestseller” template=”catalog/product/bestseller.phtml” before=”-“> <action method=”setLimit”><limit>4</limit></action> <action method=”setHeader”><header>Best Sellers</header></action> <action method=”setCategory”><category>24</category></action> </block> </reference>[/php]

To find out the bestselling products, you can use the Advanced Reports extension.

October 6, 2016
October 11, 2016
September 25, 2016
Comments
Ashish @ MagikCommerce
October 14, 2014
We typically build this feature set in our themes only but separating the code out like you did for others is great. Especially for those theme which doesn't come powered with this functionality out of the box.
Reply
Ksenia Dobreva
October 16, 2014
Thanks for commenting, Ashish!
andrew
November 13, 2014
Thanks for sharing the script!
Reply
Ksenia Dobreva
November 14, 2014
Always welcome.
Cosimail
December 15, 2014
Hi, thank you for your post, which is great and works pretty well. I have a question: how can I choose how many products per row to display? I tried 5 but it does not works... Thank you very much
Reply
Ksenia Dobreva
December 16, 2014
Hi and thanks for reading! Try adding limit="3" where 3 is the quantity of products. ‘limit’ variable enables you to specify the number of products in the block. Please let me know if that helps.
Cosimail
December 17, 2014
Sorry, but there was an error in the comment: I wrote a string of code, but then appears only the number "5" instead of the code, I don't know why... My real question is: what code I must put to specify the number of products per row to display? I want to display 3 rows of 5 items: total 15 items. Thank you in advance
Reply
Ksenia Dobreva
December 18, 2014
Hi and sorry for the late answer! I just wanted to point out that this guide is an example of a solution. It shows data in 1 row using limit parameter, which contains the number of products for the selection. If you need to show more than 1 row (3 rows 5 products each), you need to edit your template bestseller.phtml, and pass limit=15. Hope that helps!
Cosimail
December 18, 2014
Hi, thank you for your kind answer! What means "pass limit=15"? This is what I get now: mycakesdecorating.com/best-seller-ever
Reply
Ksenia Dobreva
December 19, 2014
Hi again! From what I can see here, your script shows bestselling 15 items but you still need to customize the template so it shows the items in three rows, not one.
Cosimail
December 19, 2014
Thank you!!! :)
Reply
Ksenia Dobreva
December 30, 2014
Always welcome!
Alldo
December 30, 2014
When we add this code, there's no best selling products showing up? Where does Magento store this information? Do we need to enable something, maybe running an report refresh or similar?
Reply
Ksenia Dobreva
December 30, 2014
Hi and thanks for the question! Did you clear the cache (both in the browser and in Magento)? If not, please try that. Technically, bestsellers aren't stored anywhere in the database separately. The php code analyses the database and pulls the bestsellers, and the template shows them.
Alldo
December 30, 2014
Thanks Ksenia, and yeah, that's it, it's running now, sort of. I'm afraid there still are some sort of problem? We are on Magento 1.9.1 and MySQL 5.6. We now got this report when running the script? cat ../var/report/467165546016 a:5:{i:0;s:2267:"SELECT SUM(order_items.qty_ordered) AS ordered_qty ... ";i:1;s:6688:"#0 /usr/local/www/apache24/webroot/multistore/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) Any idea? Can't find any error messages in the report :-P
Ksenia Dobreva
December 31, 2014
Could you please provide us with the link you're trying to place bestsellers on? Also, we'd love to have a look at the full report file (if it's not convenient to place it here you're welcome to send me the full report at ksenia.dobreva(at)amasty.com)
alami
January 8, 2015
thanks lot of Dobreva .
Reply
Ksenia Dobreva
January 9, 2015
Always welcome!
Sundaramoorthy
January 14, 2015
Hi i am new to magento in my site its not working,where i want to put this {{block type="catalog/product_bestseller" template="catalog/product/bestseller.phtml" header="Bestsellers" limit=4}} in home page and also this 3 Best Sellers
Reply
Ksenia Dobreva
January 26, 2015
Hey! Could you please specify your answer so we could help you with this?
Sandeep
March 18, 2015
Can you let me know how to display the Category Products on a single row with Slider and no list grid tool bar Also I get the grey background if I try to display anything on homepage.
Reply
Ksenia Dobreva
March 19, 2015
Hi Sandeep! Thanks for stopping by. It's difficult to give answers when we can't see what exactly you are doing. In general, all the settings for catalog display can be found at System > Configuration > Catalog > Catalog. Home Page is changed at CMS > Pages > Home Page. If you need something that's not in the settings and there is no such extension, you'll probably need a customization made by a developer. Hope that helps.
Mikael
March 19, 2015
Thanks for nice guide, but this does not work if you have enabled flat catalog. You should put that into guide :)
Reply
Ksenia Dobreva
March 20, 2015
Oops! Thanks so much for pointing this out. Indeed, there's an issue with flat catalog, we will definitely correct this and update the downloadable code very soon.
Erwin
December 10, 2015
Hi Ksenia, very useful piece of code but can you update me if the code is updated to work with flat catalog on Magento 1.9.x? If not is this on your planning? Thank you in advance, Erwin.
Ksenia Dobreva
December 11, 2015
Hi Erwin, thanks for your interest. For now the code is not adapted to work with flat catalog, we will definitely consider the fact that even more people need this feature. Unfortunately, I can't promise any exact date here =)
David - objectsource
April 10, 2015
This is great - very useful for out latest project. Look clean and follows good practice as well.
Reply
Ksenia Dobreva
April 10, 2015
Glad it was useful for you, David! Thanks for your feedback.
zaw
April 22, 2015
"Magento_root/app/code/local/Mage/Catalog/Block/Product/Bestseller.php" this path do we have to create ourselves or was it already exist? because there is no local folder under magento_root/app/code where exactly is this layout update xml should we place in? "Also you can add a new block via layout update:" sorry i'm still very new to magento.. was just trying to add this to my home page Thanks!
Reply
Ksenia Dobreva
April 22, 2015
Hey! Thanks for your questions. “Magento_root/app/code/local/Mage/Catalog/Block/Product/Bestseller.php” this path do we have to create ourselves or was it already exist? because there is no local folder under magento_root/app/code" Yes, indeed, the local directory isn't included into Magento 1.9.1.0 installation by default, but this doesn't mean you can't use it, you can, don't hesitate to create it. For more information: http://www.magentocommerce.com/wiki/5_-_modules_and_development/0_-_module_development_in_magento/how_to_create_a_local_copy_of_app_code_core_mage#how_the_local_folder_works Now, to the second question. "where exactly is this layout update xml should we place in? Also you can add a new block via layout update:” Use the same path as in point 3 of the article: Backend > CMS > Pages > Edit Page ‘Home page’  Also, here's a <a href="https://amasty.com/blog/wp-content/uploads/2014/04/layout-update-xml.png" rel="nofollow">screenshot</a> for you as well. Hope that helps!
zaw
April 23, 2015
Hi Hi, Thanks a lot for helping me on this! So now I did created the local folder with all empty folders inside and put the Bestseller.php file in there. Still doesn't work.. actually it doesn't really load the bestseller.phtml .. i think it should at least show some html DIV like this one "" even if the $this->getCollection(); was failed right? I tried both method to print out the block "{{block type="catalog/product_bestseller" template="catalog/product/bestseller.phtml" header="Bestsellers" limit=4}}" in my home page content and layout update that you showed me.. both of them doesn't seem to work.. I am not sure if its because of the block type "catalog/product_bestseller" was not recognized or link to our class file?
Ksenia Dobreva
April 23, 2015
Hey! I'm sorry you faced some difficulties here. Thanks for providing the details! I'm afraid the developer needs to have a look at your installation to help you. Could you please shoot an email to support@amasty.com, please mark that the letter is about the free bestsellers script (so we could forward the ticket to the right developer) and give us your credentials. My colleague will have a look and help you. Cheers!
john nusom
April 25, 2015
I am looking to make the template for the bestseller products to be responsive.. is there sample .phtml you have that is responsive?
Reply
Ksenia Dobreva
April 27, 2015
Hey! Unfortunately, we don't have a responsive template available. But you can create your own using list.phtml template from your theme. Hope that helps.
Purushartha
June 18, 2015
Hi Ksenia, Did exactly as per your instruction and received the following "There has been an error processing your request SELECT SUM(order_items.qty_ordered) AS `ordered_qty`,...........). We are on CE 1.9. Will be great if you can lead me to the right direction. Thanks!
Reply
Ksenia Dobreva
June 18, 2015
Hello and thanks for your comment. Could you please send us the full error message?
Stephan
October 30, 2015
Hi, I have the exact same problem. How was this issue fixed?
pandiyan
June 26, 2015
When we add this code, there’s no best selling products showing up? It only display best selling name. please help me
Reply
Ksenia Dobreva
June 29, 2015
Hey, please check your email.
pandiyan
June 29, 2015
ya i got the mail.
Reply
pandiyan
June 30, 2015
Hi Ksenia, I am struggling with this concepts past four days, Please help me.
Reply
pandiyan
July 1, 2015
Hi Ksenia, Please check your email.
Reply
pandiyan
July 2, 2015
Hi Ksenia, I want to paste this script {{block type="catalog/product_bestseller" template="catalog/product/bestseller.phtml" header="Bestsellers" limit=4}} or add any other specific category id inside of this script ?
Reply
Ksenia Dobreva
July 2, 2015
Bestseller.php doesn't use categories. But you can customize this part of code: <img src="https://amasty.com/blog/wp-content/uploads/2015/07/code.png" alt="" />
savita
August 28, 2015
He, Please mail that code for increase limit of best selling products.... savita@b2cmarketing.in
Reply
Ksenia Dobreva
August 28, 2015
Hey, you can edit the code yourself. {{block type="catalog/product_bestseller" template="catalog/product/bestseller.phtml" header="Bestsellers" limit=4}} - limit is the parameter you need.
Luca Ricci
October 12, 2015
Hello Ksenia, thanks for sharing this. I tried your code but magento is throwing an "THERE HAS BEEN AN ERROR PROCESSING YOUR REQUEST" issue. From error log file i found the query and tried it directly from phpmyadmin and having this error: Unknown column 'e.cost' in 'field list' I'm using Magento CE 1.9.0.1 Best regards, Luca
Reply
Ksenia Dobreva
October 12, 2015
Hey Luca, thanks for asking. Unfortunately, it's complicated to say what's going on without seeing the code on the website. Feel free to send me (ksenia.dobreva@amasty.com) your FTP credentials, backend login and password and the link of the page you're using the code on. I'll ask my colleague to have a look.
Luca Ricci
October 12, 2015
Hello Ksenia, thank you very much. I've sent you an email with everything you need. Regards, Luca
Joe
October 23, 2015
Hey Ksenia, I have successfully added the bestseller script and it works nicely. I am however struggling with getting the star ratings for the products in the collection. Can you offer guidance on how to do this? Thank you
Reply
Ksenia Dobreva
October 23, 2015
Hey, thanks for asking. Please add the following line of code in the `bestseller.phtml` (somewhere in the foreach loop): <code> <?php echo $this->getReviewsSummaryHtml($p, true, true); ?> </code>
Abid Malik
November 2, 2015
Thank you, the "SUPEE-6788 update" section solved my problem. and saved the day finally.
Reply
Ksenia Dobreva
November 2, 2015
Glad it was helpful for you! We got to know about the issue thanks to our active readers, by the way.
xuannd
January 18, 2016
Thanks for sharing. For now the code is not adapted to work with flat catalog, and I fixed this issuse. @Ksenia Dobreva, please update this guide. 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
Ksenia Dobreva
January 26, 2016
Hi Xuannd, many thanks for your comment. We've finally updated the code.
Kico Zaninetti
January 27, 2016
Hi Ksenia, thanks for your code. I really don't know what's happening here. When I print_r() the collection it returns products, but the $products->getSize() is always 0 and the foreach($products as $p) don't iterate. Any clues?
Reply
Ksenia Dobreva
January 28, 2016
Hi Kico, thanks for your question. I'm afraid it's difficult to say what's wrong without seeing the installation. If you want, you could send me your credentials at ksenia.dobreva@amasty.com (ftp and backend), and we'll have a look. Cheers!
Nilesh
February 14, 2016
how to display most viewed product??
Reply
Ksenia Dobreva
February 16, 2016
Hi Nilesh, To answer your question, we actually need to write a new article, as for the most viewed products you'll need to take the data from another table, and therefore the code will be different.
Nilesh
March 5, 2016
thanks for code. It works fine here.. :)
shailendra
March 17, 2016
your code works fine for me thanks :)
Reply
Ksenia Dobreva
March 17, 2016
Glad it was useful for you!
Anooj Mathew Varghese
May 19, 2016
Hi Guys, Thank you for the code. This was working perfectly fine on my local host testing machine. However, when i uploaded the same to online one its not working. What could have gone wrong? Online version of Magento 1.9.2.4 Local Host version of Magento 1.9.2.3 Is the difference in version causing this issue. Can anyone help me out
Reply
Anooj Mathew Varghese
May 19, 2016
Hi Guys, I fixed the issue, Thank you for the code again working perfectly fine. If any of you guys are facing this issue. Go to system-> magento connect and reinstall only the mage core files.
Reply
Ksenia Dobreva
May 19, 2016
Hey Anooj, thanks for commenting, we're glad that it works for you!
Vipul
June 22, 2016
How to add pagination to this?
Reply
Ksenia Dobreva
July 1, 2016
Hey there and thanks for the question. Well, the article was more about creating a collection, and pagination is a different task, that's why we didn't describe it. You can use any jQuery slider for a fast result, and if you want to add real pagination, it's a good idea to dig into this: Magento_root\app\code\core\Mage\Catalog\Block\Product\List\Toolbar.php Hope that helps!
Magento_oCodewire
June 27, 2016
Nice script but have one question that how to add this script and where Magento store this information.
Reply
Ksenia Dobreva
July 1, 2016
Hey there and thanks for asking. 1) how to add this script Well, this process is described in the article. You create the necessary files and use one of the two ways of adding them (layout update or call CMS block) 2) where Magento stores this information Depends on which information you're talking about. 2.1) sales info is taken from sales_flat_order_item database 2.2) product info: а) if flat is included from the corresponding data base (depends on the store) - from catalog_product_flat_X (where X is the store id) b) if flat is not included, then the info is taken from EAV, I won't list all the tables because there's a lot of them. 2.3) stock status info is taken from the corresponding tables. Hope that helps.
Gags
November 16, 2016
Hi Ksenia, Does this work with Magento 2.1 ?
Reply
Ksenia Dobreva
November 17, 2016
Hello, no, it doesn't. It's only for Magento 1.
Stefan
January 12, 2017
How can i implement this with my theme called 'Ultimo'. I want the best sellers to show as i slider, check the page: frokungen . se . There you can see sliders on home page.
Reply
Ksenia Dobreva
January 12, 2017
Hey Stefan, thanks for the question, but it looks like the answer would be a whole new article =) It's quite difficult to answer your question in a single comment. Try modifying this template: Magento_root\app\design\frontend\base\default\template\amasty\amsorting\
Julian
March 10, 2017
Hi, Thanks for this. I've managed to get this working but it doesn't show products for some category ids. I've cerated a CMS page and called the code from layout xml. I can see the heading written out but no products. I can't see anything common across the categories that it works for and which it does not. Should it work with all product types and is there any config setting for a category that would make it not display best selling products from that category. Thanks Julian
Reply
Julian
March 10, 2017
further to this it looks as though simple products that are set to visibility='Not Visible Individually' and are part of a configurable or grouped product are not being pulled through with your code.
Ksenia Dobreva
March 27, 2017
Yes, you're right, the visibility setting is used in the collection code.
Ksenia Dobreva
March 27, 2017
Are you sure that you have products in those categories?
Selva
March 22, 2017
Hi, How can I use this script in specific category page?
Reply
Ksenia Dobreva
March 27, 2017
Hey there and thanks for the question. You can add this block to any category page pretty much the same way! Go to the category settings, and here https://prnt.sc/eoyajf after choosing Static Block and Products display mode you will be able to choose the necessary CMS block (which you should have previously created). Also, you can go here https://prnt.sc/eoyb5m and add the code from the article which starts from (layout update). Hope that helps!
Mekaeil
May 23, 2017
Thanks Ksenia , but it is not working for the configurable Products !
Reply
Robert
October 24, 2017
Hello Ksenia, Is it possible to show only product with more than 0 stock quantity ? Or only "on stock" products ? Thank you!
Reply
Razvan
November 14, 2017
Great stuff! I work on Magento 2.1.7, will the code still work?
Reply
Razvan
November 14, 2017
I have subscribed, but I can not download the code :(
Reply
Razvan
November 14, 2017
Can you update the article (if necessary) for Magento version 2.1.7?
Reply
Alina Bragina
January 22, 2018
Hi Ravzan! Thanks for commenting. Sorry, but it looks like it could be rather difficult to answer your question in this post. We'll try to see if we can cover this question in the future articles. Cheers!
mohamed
August 14, 2018
hi dude,style issue is not obeying the magento css
Reply
Guest
October 29, 2019
0.5
Reply
Guest
October 29, 2019
1.5
Reply
Leave your comment

Your email address will not be published

This blog was created with Amasty Blog Pro

This blog was created with Amasty Blog Pro

© 2009-2022 Amasty. All Rights Reserved.