Sort catalogue by quantity

[DanceVinylOnline]

I have tried to find a solution for this before posting so i apologise if i have missed it. We are running a catalogue which displays in stock and out of stock items. 50% of the catalogue is out of stock at the moement out of 7500 so we want the products in stock to display first when clicking on the genres. Is there a simple solution to this? I would prefer to have is displayed by buy now and then out of stock but if i have to do it by quantity to get the result then it wont be too much of a dilemma. The site can be viewed at www.dancevinylonline.com

 

Thanks

[ErollorD]

this is quite simple:D

 

you go to index.php and find

$listing_sql .= " order by pd.products_name";

where you replace pd.product_name with p.products_quantity so that you get

$listing_sql .= " order by p.products_quantity";

 

now this will order from smallest quantity to bigger one, if you want other way around then use this code

$listing_sql .= " order by p.products_quantity DESC";

 

where DESC means descending order, so from bigger to smaller..

[DanceVinylOnline]

this is quite simple:D

 

you go to index.php and find

$listing_sql .= " order by pd.products_name";

where you replace pd.product_name with p.products_quantity so that you get

$listing_sql .= " order by p.products_quantity";

 

now this will order from smallest quantity to bigger one, if you want other way around then use this code

$listing_sql .= " order by p.products_quantity DESC";

 

where DESC means descending order, so from bigger to smaller..

 

You bobby dazzler!!! Sweet as a nut!! Now heres a small challenge, that works perfect and looking at the result it would be nice to have them in althabetical order so the in stock is a-z and then the out of stock a-z....is it possible....oh and seeing as you have been so quick with the help do you have any idea where i can get the text for the wishlist faq.

 

Top banana

[ErollorD]

then add this code

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

 

where you set that second ordering is done by product name...

 

can you explain what you mean with the text??

[DanceVinylOnline]

then add this code

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

 

where you set that second ordering is done by product name...

 

can you explain what you mean with the text??

 

I just need the text that explains how to use the wishlist for the customers in wishlist_help.php. I have tried copying and pasting sort code but i am a bit of a newbie at this thing.

[DanceVinylOnline]

Right i have sorted the wishlist bit out.

 

The sort code above appeared to work perfect until i realised that when you go onto the 2nd page of results the sort reverts back to normal. Is there any way of adjusting this or should i just be happy that the 1st page of results looks good with all in stock. The site is www.dancevinylonline.com and the objective i want to achieve is that when a customer clicks on the genres they see whats in stock first in alphabetical order and then the out of stock in alphabetical order of which they can add to wishlist.

 

Any ideas anyone. Oh and by the way thanks to the oscommerce crew for all the help!