The attributes in the catalog - dropdown are sorted by ID and can be resorted using Admin -> Catalog -> Product Attributes but this is a long and slow process when there are many attributes. eg 20 attributes with 200 products.
Use of Easypopulate overwrites all the sorting and it is lost and needs to be resorted each time.
Anyone selling clothing, shoes etc with sizing will want attributes sorted alphanumerically eg, 10a, 10b, 10c, 12a, 12b......
order by popt.products_options_sort_order, popt.products_options_name
Would appear that this should be sorting by sort_order then products_options_name which should mean alphanumerically.
Edit: Just tested this and the sort does not seem to work.
Here is a link to my site showing the issue,
I have fixed the problem short term using phpadmin to manipulate the data so it no longer shows on the live site.
It looks like the second query on line 413 needs another "order by"
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.products_options_sort_order, pa.options_values_price");
Should be able to add pov.products_options_values_name before pa.options_values_price in order by.
Thanks pgmarshall for that fix.
I used it in my localhost installation and it work perfectly so I will now use it on the live site.