changing order of items in dropdown ...

[DonnaNJ]

To keep is simpl e - say I have a size option...

 

Sizes : S,M,L, Child Small, Child Med, etc...

 

But I want them ordered a certainway. (child's first or something etc..)

 

I put them in - in order - but they still seem to appear in the pulldown in a different order.

 

How can I set the order of items ?

 

Thanks

 

Donna

[Guest]

It's based on the query used. Sometimes there's a default and sometimes the query has a statement like "order by products_name" at the end which will ask it to go by alphabet no matter how you put them in there on the admin. The way around it is to change it to "order_by products_id" and place the products by id number in the database the way you want them. I found it good to do this directly in the database using phpmyadmin. There may be a version of this right in your host's control panel or you can load a copy of it onto your server and configure it yourself (as easy as loading osCommerce).

You'll have to find the query that loads the dropdown. i don't use product attributes, but it shoudn't be too hard to locate.