Best seller module: show only available products

[Maria Gonzalez]

Hi,

I'll like to show only products with stock available. It's possible to do that? Someone know how to?

I have prestashop 1.6

Thanks

[NemoPS]

Where exactly? Inside categories only or throughout all the store?

[Maria Gonzalez]

In the best sellers module, in the home page tab.

[NemoPS]

Ah, sorry I missed the title.
You need to modify the sql query of ProductSale::getBestSalesLight

You can find the class file inside classes/

See this part

		$sql.= '
		WHERE product_shop.`active` = 1
		AND p.`visibility` != \'none\'
		GROUP BY product_shop.id_product
		ORDER BY sales DESC
		LIMIT '.(int)($page_number * $nb_products).', '.(int)$nb_products;

add the following

 

AND stock.quantity > 0

Right after the first AND

[Maria Gonzalez]

Thanks for your reply.

 

It worked!! 

Thanks!

Edited June 17, 2015 by Maria Gonzalez (see edit history)