Change sort order- Show In Stock items first

[kitten091182]

Hi, is there any way i can change the sort order for all my products in each category so that the in stock items are shown first and out of stock will be on the last pages of each category?
I know i will probably have to change code somewhere, i just dont know where?!
thanks in advance

[superprg]

All I can tell you to begin with is that you would have to do quite a bit of modification for this in the file includes\index_filters\default_filter.php

[kitten091182]

i thought i would have to do some modifications, that wouldnt be a problem. Do you know what i would have to modify/change?
Thanks.

[kitten091182]

i have found how to sort it by stock items. As i set my stock levels by using the products quantity field, and putting 100 for in stock, and 0 for out of stock, i changed this code:


// sort by products_sort_order when PRODUCT_LISTING_DEFAULT_SORT_ORDER ia 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;
}
}

to:


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



This worked great, but the only problem is, its sorting them with out of stock first, and in stock last!!!!

Any ideas how i would get it to swap around?
Thanks.

[kitten091182]

Ok, i have managed to get it right. For anybody else who would like to know:

You have to modify includes/index_filters/default_filter.php

Go to line 108 and change:

$listing_sql .= " order by p.products_sort_order , pd.products_name";

to

$listing_sql .= " order by p.products_sort_order , p.products_quantity desc";

This will sort the order showing in stock items first, and out of stock items last.

[greghays]

I had to change line 57 and 63 in my old version 2.67

[aworldofpets.co.uk]

Has anyone got this working in newer versions of zen cart?
Cheers!

[DigitalShadow]

Can't seem to get this to work with version 1.3.8a

Can anyone help?

[DigitalShadow]

Anyone?

[DigitalShadow]

I've tried changing this code

$_GET['sort'] = $i+1 . 'a';

$listing_sql .= " order by p.products_sort_order, pd.products_name";

break;

but nothing changes, when I search for something, the out of stocks aren't moved to the bottom, what am I doing wrong?