Author Topic: display products in stock  (Read 451 times)

MKI-Miro

  • Jr. Member
  • **
  • Posts: 132
display products in stock
« on: August 20, 2017, 11:28:49 am »
Hi

Is it possible to display all products that are currently in stock?

I expected it in Virtuemart Products Module but it is not there.

Thanks

Edit: it should not hard to add someting like this to com_virtuemart/models/product.php in sortSearchListQuery function

Code: [Select]
case 'featured':
$where[] = 'p.`product_special`="1" ';
$orderBy = 'ORDER BY RAND()';
break;
case 'instck':
$where[] = 'p.`product_in_stock`="1" ';
$orderBy = 'ORDER BY RAND()';
break;

hmm ? :)

MKI-Miro

  • Jr. Member
  • **
  • Posts: 132
Re: display products in stock
« Reply #1 on: August 24, 2017, 14:27:03 pm »
is there any chance that it will be included in next version?