Change sort order- Show In Stock items first

[tesefoti]

Does anyone has this working on v1.3.9h?

I also have Column Layout Grid for Product Listing installed, will it make any difference?

Thanks!

[Marco71]

I have product listing with quantity desc sort. This is almost what I want, but not quite because I don't want to show exact quantity.
I want to products with quantity >0 first, but order by model and after that quantity <= 0, order by model.
Normally I can you can do this sql with union, but I don't know how you can do it in Zen Cart.

Could anyone help me with this?

You can see what I have know from here:
http://shop.teamlaine.fi/index.php?m...sort=1d&page=1

Green is quantity>1, Yellow is quantity=1, Red is quantity=0