search option or list by product model instead of id number in featured products?

[rickiesdiscount]

im trying to add featured products and specials by its taking forever because stuff is listed in alphabetical order by the title of the product...is there anyway to list by model number or a way to have a search box in the admin section?

i dont understand why its not listed by model number to begin with in the admin section....anybody have a way it would be greatly appreciated thanks

[Ajeh]

In the featured.php for the Admin, you could alter the order statement:

// order of display
  $order_by = " order by pd.products_name "; 

In the specials.php for the Admin, you could alter the order statement:

// order of display
  $order_by = " order by pd.products_name "; 

Many do not utilize products_model in a manner that makes it efficient for them to work with this sort order ...

[rickiesdiscount]

In the featured.php for the Admin, you could alter the order statement:

// order of display
  $order_by = " order by pd.products_name "; 

In the specials.php for the Admin, you could alter the order statement:

// order of display
  $order_by = " order by pd.products_name "; 

Many do not utilize products_model in a manner that makes it efficient for them to work with this sort order ...

thank you so much for your help

[rickiesdiscount]

thank you so much for your help

I did alter the order statement as you said but i didnt do anything it still placed them in the same order not sure whats going on thanks for the help though any other suggestions?

[rickiesdiscount]

does anyone know how to do this?

[Ajeh]

What file are you changing?