Please Help! Using STS and Sorting Attributes by Price

[jonw118]

I've read a ton of threads on changing the product_info.php file and switching the "order by".

 

I have done it exactly as it says- but it's not sorting right. It's putting the most expensive option first. I really need for the lowest option to be first.

 

I'm thinking maybe it has something to do with STS.

 

Has anyone been able to do this?

 

Thanks so much!

[jonw118]

I've narrowed it down to the issue is I am using the STS Product Info option. I know it has something to do with this line:

 

 // Select the list of attribute (option) names
 $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");

 

When I change "order by popt.products_options_name" to "order by pa.options_values_price" I get this error:

 

1054 - Unknown column 'pa.options_values_price' in 'order clause'

 

select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where patrib.products_id='37' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by pa.options_values_price

 

[TEP STOP]