How can I sort This ?

[DVBHardware]

I am inputing the attributes by ID & Sort order the way I want but the os is changing its sort order.

 

[241]

the os will be using default sort of alphabetic, go into the file and change the sort order to what you require.

[DVBHardware]

I dnn't know how to do it, can it be done in phpmyadmin so the sort orded will be the same when inputing new products. And how to do it.

The sort order that I have is correct when displaying product info (101 102 etc.

[DVBHardware]

Steve Took me 3 hrs but I found it . I think ?

 

admin/product_attributes

 

order by products_options_sort_order

 

$attributes = "select pa.* from " . TABLE_PRODUCTS_ATTRIBUTES . " pa left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pa.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_options_sort_order";//order by pd.products_name

[241]

I see you have commented out pd.products_name, was this the original sort order.

 

Are you trying to order by product attribute id which would be order by pa.products_id

or you could have

order by pa.products_id ASC

 

or you could have

order by pa.products_id, pd.products_name DESC

 

etc etc etc.

[DVBHardware]

pd.products_name was the original order by so if I messed up I knew what to replace to original ( the comments). I felt the sort order would be good so if I ever define a new attribute it would put it in the correct ordrer for each group as to never go crazy looking for everything spread out all over the place.