Jump to content

why the best seller moudle does not work well?


Recommended Posts

I used the prestatshop for more than one year.but what the problem i found is that the best seller model can not work well.all of our customers make the order online,but always can not show the best seller products automatically.what happened to this model,is there anybody know how to solve it,tks a lot for your attention and solution suggestion from everyone.

tks &best;regards !

Share this post

Link to post
Share on other sites

I also found this modules quantities wasn't being updated when products were sold so I did a small script that I run at the end of every day. Can set up a cron job to do this on a daily basis. This updates the quantities for the table that the best sellers module uses.

Use the following code, save it as a php file, name is something like sync_sales.php and stick it on your server, and call it from a browser when you need to (will show a blank/white page)



return Db::getInstance()->Execute('
   REPLACE INTO '._DB_PREFIX_.'product_sale
   (`id_product`, `quantity`, `sale_nbr`, `date_upd`)
   SELECT od.product_id, COUNT(od.product_id), SUM(od.product_quantity), NOW()
       FROM '._DB_PREFIX_.'order_detail od 
       GROUP BY od.product_id');


In my opinion the best sales should be those products that have sold the most quantities, but Prestahop does not figure it that way, it counts how many times the product was sold on a per order basis, so you need to alter the code in "classes/ProductSale.php" to change this.


ps.`quantity` AS sales

replace with

ps.`sale_nbr` AS sales

This code occurs twice in that file, once for the block and the other for the best-sales page.

Hope this helps. :)

Share this post

Link to post
Share on other sites

It works fine, it displays the best sellers in order of how many have sold, these can be compared to the Best Products Stats block in the BO to match the figures. What else do you want?

Are you using the latest version?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

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