[SOLVED] Get random products only with quantity greater than zero

[Piotr Kaczor]

Hello

I'm using method getProducts from object Category to get random products, but I need only products with quantity greater than zero. How to achieve that?

$category = new Category(Context::getContext()->shop->getCategory(), (int)Context::getContext()->language->id);
$nb = (int)Configuration::get('HOME_FEATURED_RND_NBR');
$products = $category->getProducts((int)Context::getContext()->language->id, 1, ($nb ? $nb : 8), null, null, false, true, true, ($nb ? $nb : 8));

Thank You for any advice

Best regards

[PascalVG]

In the file classes/Category.php, copy the function GetProducts and change the name to getAvailableProducts or so.

then add to the its SQL WHERE part something like this:

 

WHERE product_shop.`id_shop` = '.(int)$context->shop->id.'

AND cp.`id_category` = '.(int)$this->id

.($active ? ' AND product_shop.`active` = 1' : '')

.' AND stock.quantity > 0 '

.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '')

.($id_supplier ? ' AND p.id_supplier = '.(int)$id_supplier : '')

.' GROUP BY product_shop.id_product';

 

Save the file and use the new function to get the products with available quantity.

 

Hope that helps.

 

 

Merry Christmas!!

pascal

[Piotr Kaczor]

Thank You works well.

 

Merry Christmas

[PascalVG]

Perfect, I'll mark it as solved. :-)

pascal