Oscommerce

User Rating: / 0
PoorBest 

Most of you might have noticed in your Oscommerce Catalog that Attributes for every products don't come up in sorted order. Which looks very awkward. There's a simple modification to get rid of it.

1. Edit product_info.php file under your catalog's main folder.

2. Search for

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

3. Replace with

""""""" $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id 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.options_values_price, pa.products_attributes_id");  """""""""

*** IGNORE/DONT COPY """""""""

What it actually does

1st - It sorts by price
2nd - if price is same or 0(zero) it sorts on basis of order the option was entered.

4. Save the page and you are done.

Don't forget to post your comments.

Freelance jobs on Freelancer.com

Find more freelance jobs