Attribute sort in Admin

[jhdesign]

I'd like to sort in ADMIN ONLY the attributes listing on the bottom. Currently it lists all set attributes by "product name" I'd like to use "Option name" as the sort field instead.

 

Any help is appreciate.

 

jacob

[jhdesign]

anyone? been searching around and found nothing.

 

It is now sorted by product name and Id like it to be sorted by Option name.

 

tia

[Mary B.]

Find this query on or abour line 640 of admin/products_attributes.php:

 

  $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 = '" . (int)$languages_id . "' order by pd.products_name";

 

 

Change it to this:

 

  $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 = '" . (int)$languages_id . "' order by pa.options_id ";

 

 

This will order them by the products_options_id in the products_options table. Since the options aren't in alphabetical order in the database, the display won't be in alphabetical order by product option, but at least all the items with those options will be grouped together in your list.

[jhdesign]

Thank you very much!