Jump to content

Best sellers module doesn't show products

Recommended Posts



I've got a problem with one of the websites i'm trying to make. I'm using PrestaShop


The 'best-sellers' module wich is standard deliverd by PrestaShop doesn't show any products on the home page and not on the best sellers page. 


After reading a lot of forums I could not find any answer which solves my problem. I already tries the following suggestions:


- Delete line 114 in /classes/ProductSale.php

 ' ORDER BY '.(!empty($order_table) ? '`'.pSQL($order_table).'`.' : '').'`'.pSQL($order_by).'` '.pSQL($order_way).'


- Checked if  SQL quarry 'ps_product_sale' is filled with products

 (Yes it is)


reinstallation of the module


Does anyone have another idea? 

Help would be great!

Share this post

Link to post
Share on other sites



Rules specific to the "Free modules" forum


This forum is not about the functionalities that are included for free in PrestaShop, but about the modules that you might give away to the Community for free.


All topics here should start with an answer, not a question.

You can use (almost) all other sections of the forum to ask for help or anything you need related to PrestaShop, but here you're the one who gives us tips and good practices.


Any module you may provide should be attached directly in your post 

Meaning: not with a link to an external website. The modules you are posting here are 100% free. Thus, you can share them just by attaching the ZIP file to the topic. Posts with an external link will be moderated and taken down.


Please use your common sense to make this section pleasant for everyone (respect others, be benevolent).

Share this post

Link to post
Share on other sites
This topic is now closed to further replies.
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More