Regenerate Best Sellers/Top Sellers

[Design2Please]

Hi,

 

I am currently building a site and I have imported all the orders from the old site into the new one, however when I navigate to the best sellers page https://www.sociablecook.co.uk/best-sellers it says that there are no top sellers at the moment.

 

Does anyone know if there is there a way to generate the best sellers based on the historic orders I have imported or does Prestashop only base best sellers on orders that have been placed through the current site?

 

Jon

Edited August 26, 2016 by Design2Please (see edit history)

[rocky]

Try calling the ProductSale::fillProductSales() function. That will copy data from the ps_order_detail table to the ps_product_sale table.

[Design2Please]

Hi Rocky,

 

Thanks for the reply. Are you able to let me know how I go about calling the ProductSale::fillProductSales() function ?

 

Thanks in advance

 

Jon

[rocky]

You could create a file like fill.php in PrestaShop's root directory with the following:

<?php

require(dirname(__FILE__).'/config/config.inc.php');
ProductSale::fillProductSales();

Then run it in your browser. Hopefully, that will execute the function. Then you can delete the file when you're done.

[Design2Please]

Hi Rocky,

 

Brilliant that has solved the issue.

 

Thanks for your help with this.

 

Jon

[rocky]

You're welcome. I'm happy it solved your problem.  

[neoshop]

You're welcome. I'm happy it solved your problem.

 

Thanks, it solved mine as well 

[m3442a]

Hello, the script working very well. Is there any possibility to take the bestsellers just from the last year? And update daily over Cron? Is that possible?