How to Display Best Sellers in Prestashop?

user2092317 picture user2092317 · Mar 31, 2015 · Viewed 12.5k times · Source

I wanted to display the best selling products in the left column of the prestashop website. Installed best sellers modules and assigned it to the left column but still it dosent display the products in the left tab. Unable to figure out where the mistake is.

Answer

qant picture qant · Dec 24, 2015

For showing Best Sales there is a Prestashop native module blockbestsellers, so this module looking data from ps_product_sale table in database, if this is empty, there is no results and this is why you cant see nothing.

Check ps_product_sale, and if its empty Execute this SQL this for test if you see some result so there is.

INSERT INTO ps_product_sale
            (`id_product`, `quantity`, `sale_nbr`, `date_upd`)
            VALUES 1, 1, 1, NOW());

Also check classes/ProductSale.php there is some methods to add and get Best Sales Products.

I hope it helps.