Multiple sortby items in a category

[DKM84]

Hi,

 

I have a lot of items in my shop and if possible I would like them to be sorted by quantity and out-of-stock

 

in stock items first.

then the 0 in stock but still available for ordering

and last the 0 in stock and unavailable for ordering.

 

I have set PS_PRODUCTS_ORDER_BY to 6 in phpmyadmin

 

I am gonna remove the dropdown menu on the front-end, so manual sorting is no longer possible.

 

I now have al items that are in stock on top, but after that it's a mess

 

I tried editing classes/product.php -> getAllProducts

 

ORDER BY '.(isset($orderByPrefix) ? pSQL($orderByPrefix).'.' : '').'`'.pSQL($orderBy).'` '.pSQL($orderWay).'
		LIMIT '.intval($pageNumber * $nbProducts).', '.intval($nbProducts));

 

But I have been unsuccesfull, anybody got some advice on this?

 

//add prestashop 1.3.1

[outlet.ee]

Hello, did you get anywhere with this? I need almost same thing: in stock first, then newest.