How to list products in stock first

Hi,

is there any code / setting how can I show products, which are on stock first and products out of stock bellow?

Thanks

Hi. You would want to change the order clause for the $products_query in func_catalog.inc.php.

order by
  if(p.quantity > 0, 0, 1) asc,
  ...

Thanks Tim for reply!

I found this in func_catalog.inc.php, but where to add this code?

$products_query = database::query($query);

    return $products_query;
  }

https://github.com/litecart/litecart/blob/2.5.5/public_html/includes/functions/func_catalog.inc.php#L64

Line 64-93 are the order by options.

Try replacing this line:

    $sql_outer_sort = [];

With this:

    $sql_outer_sort = ['if(p.quantity > 0, 0, 1) asc'];

That way this order goes before anything else following.

Perect, it works! Thanks Tim!

@megamiska don't forget to use vMod for core file modifications. Otherwise it will be replaced on the first update.

@dodo thanks for tip, done :)