How to reset bestsellers?

[renamed_account_13401]

Does anyone know how to reset the bestsellers module? I would like to start again from zero products listed there. Is it possible? Should I try to delete the sales from backoffice? Or?....

[Ostfarsan]

Hi,
I'm also interested to know if this is possible. Regards

[rocky]

The best sellers module queries the number of sales from the ps_product_sale table, so I guess deleting all the entries or changing the sale_nbr of each product to 0 will reset the best sellers module.

[viktorsundberg]

Please tell me how it's done, in admin or dowloaded file?

Also, how do I reset the Cart stats on the first page of "Stats" ?

[positivezero]

This is an old topic but i'd like to post reply for this. In case i forget how to redo it.

• Go to your database in phpMyAdmin
  
• Find [ps_product_sale] table
  
• Browse into the table
  
• You will find "id_product", "quantity", "sale_nbr", and "date_upd"
  
• Change / delete according to your needs
  

[ecentury]

Also remember that you will have to clear cache after you have updated your ps_product_sale table

It uses the cached version of best sellers as can be seen in the code

BlockBestSellers::$cache_best_sellers