Sort products not by name...

[riccardino]

Hi... :P

Default OSC configuration have sort products by name. ;)

Where/How I can chage it if I want sort my products by "model" :)

 

Regards. :rolleyes:

[gazzzzzza]

search for

 

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

 

in your index page

i believe this is the default order statement

 

change it to

 

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

 

this should order by model then name

 

or for just model try

 

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

 

:D

[str33k]

if its okay id like to tag along and add a question

 

 

i basicly have his same problem with Available Options. id like it to sort by like id number or some thing so i can have it in the order i want it to have the drop downs in. for example i have say memory processors and hard drives as options. id like for processors to be the first option they can select atm it aranges them alphabetically. any ideas?

[bglkk]

attrib_sort_v1.0

 

http://www.oscommerce.com/community/contributions,1822

[str33k]

thanks alot :)

[241]

no problem and if an occasssion requires it you can add limits to the number of items shown on a given page.

[riccardino]

GREAT!!!

 

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

 

This is perfect!!!

[str33k]

alright the contrib link u linked me to wasnt really what i was looking for yet i would be lookign for it down the road so thanks i just in stalled it. but im looking to sort the option name not the option value in the drop down i want to beable to have what it says for name sorted not the order of the drop down.

any idea on that one?

[Guest]

and if one wanted to sort by price?

[gazzzzzza]

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

[Guest]

got it working. Just for the record incase someone reads this, its actually:

 

 

p.products_price

 

 

Thanks

[Guest]

There are two places in index.php that have to be changed in order for the second and subsequent pages to be sorted by model. If you only change the first of these, the first page gets sorted by model, but other pages don't. I changed these two sections and it works fine:

 

change pd.products_name to p.products_model in

 

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

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

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

break;

 

and change pd.products_name to p.products_model in

 

case 'PRODUCT_LIST_NAME':

$listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '');