Sort products by "in stock"

[futuron]

Is it possible to add a option to sort/order the products by "in stock". I want to show products wich are out of stock on the website, but it is not very handy if these products stand at the top of the product list. 

Kind Regards
Rob van der Donk

[toivo]

I happened to post a mod today to Inventory Listing in 1.0.9 which adds an option to display the products in the order of 'in stock' or stock on hand.  Only the child products which can have stock are listed, the parent products are excluded.

[crackdaddy]

um are you gonna share your work..or what? i dont need it... but if you hae done if and posted it..it helps to give the link...if you havnt posted it then do it, cause otherwise whats the point....

and yes sort by in stock in very simple to code...and can be done in 5 min prob.. i dont need this functionality but if you find the code that make the sort...you should be able to add what you need...

if toivo doesnt post his..i mihgt take a minute to show you where it is...

[toivo]

Oops, here is the link:

http://virtuemart.net/index.php?option=com_smf&Itemid=71&topic=28857.0

[futuron]

Your hack is nice, but this is for the backend. What I'm looking for is a hack for the frontend. So the visitors of the webshop allways see the products in stock first!

Kind regards,
Rob van der Donk

[antivir]

shop_browse_queries.php
old:

$q .= "\n ORDER BY $orderbyField $DescOrderBy";

new:

$q .= "\n ORDER BY product_in_stock DESC, $orderbyField $DescOrderBy";

[vbarkouski]

Is there a solution to sort by product name and in stock together?

shop_browse_queries.php
old:

$q .= "\n ORDER BY $orderbyField $DescOrderBy";

new:

$q .= "\n ORDER BY product_in_stock DESC, $orderbyField $DescOrderBy";

[Template Designer]

I hope we can have these options in the backend. It's easy to make mistake if revising the code.

[killarney]

Hi,
i am new to virtuemart and i want to show in stock  product first and not in stock after that at the Front End.
can anyone can help me with it,
thanks in advance

[jenkinhill]

And you are using VirtueMart 1?  See this section heading:  VirtueMart Dev/Coding Central: VM1 (old version)