Out of stock items in the end of lists - how to do?

[rafcamera]

Hi!
Is it possible to setup the shop or hack a code to put out-of-stock products in the end of lists?
I have many out-of-stock products, but I don't want to remove them from shop since they help to drive traffic to site, and many of them quite rare so other people links to them in forums etc.
But it is not good to browse three pages of out-of-stock items just to see 3-5 available products. So, if there is a way to AUTOMATICALLY put available items in the beginning of category and search results, this would be great.
Thanks.

[RescoCCC]

If I followed a link to a rare item I was interested in only to find that it wasn't available I would not be a happy customer.

[rbarbour]

A common misleading marketing route for most e-tailers but it works.

90% of your customers will just hit the back button and look elsewhere

but to each their own!

easiest way is to set the sort order to like 99 on out of stock items

[rafcamera]

Yes, I know that I can manipulate sort order manually. But is it possible to automate this?
As to 'misleading', it is not always true. Say, I had rare lens recently, and unable to fine any info on it in the Internet. I think that someone interested will be happy to see at least it's pictures and description rather than find nothing at all.
Thanks.

[rbarbour]

Haven't done this in awhile, so not sure but it will put you in right direction

/includes/index_filters/default_filter.php

find:

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
//       $listing_sql .= " order by p.products_sort_order desc, pd.products_name";
          $listing_sql .= " order by p.products_sort_order, pd.products_name";
          break;

change to:

// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER is left blank
// for reverse, descending order use:
//       $listing_sql .= " order by p.products_sort_order desc, p.products_quantity desc";
          $listing_sql .= " order by p.products_sort_order, p.products_quantity desc";
          break;

[rafcamera]

Thanks, rbarbour.
This is better already, but products sorted by quantity now. I would like to have them sorted alphabetically in both parts of a list ('in stock' and 'out-of-stock'). I'll try to modify sql query to accomplish this. Thank for pointing to right part of code :-)

[rafcamera]

I did it :-)

$listing_sql .= " order by IF( p.products_quantity >0, 1, 0 ) DESC , p.products_sort_order , pd.products_name";

Thanks once again for pointing in right direction :-)

[rbarbour]

Thank you for posting the solution that worked for you!

[buzltyr]

IS there a way to change the "sold Out" to out of stock when quantity set to zero?

[rbarbour]

Are you referring to the "sold out" button (image)?