EasyPopulate Attributes In Reverse Order

[mj999]

I'm using EasyPopulate 2.71 with attribute support and have added product_retail_price. All works fine except that my attributes wind up in reverse order. For instance, what I would like to be the default selection is last and what I would like to be the last selection is the default selection. Can someone tell me how to work around this.

[VJ]

Find the following line in /catalog/product_info.php,

 

        $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)$HTTP_GET_VARS['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 . "'");

 

and replace it with something similar to,

 

        $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)$HTTP_GET_VARS['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.price_prefix, pa.options_values_price, pov.products_options_values_name");

 

depending on how exactly you'd like to order your atttibute choices.

 

HTH,

VJ

[mj999]

That did it. Thanks!