Products displayed by price ascending OS 2.3.3

[themuir]

Hi guys, I posted this over year ago but still haven't found a solution. 

 

Hopefully someone will pick up on this.

 

Currently when I add products to the website they are being displayed in alphabetical order across the website.

 

I really want this to be in price order by default. so £1, £3, £5 sort of thing. I'm not fussed about giving people the option of changing this themselves.

 

I have read you can change the index page but only on version 2.2 which will allow for this. The 2.3 version has a different index.

 

Does anyone know of anything I can change please? Where the file is located?

 

Thanks in advance.

 

Tom.

[themuir]

Anyone come across this please?

[auzStar]

@@themuir

 

in "catalog\advanced_search_result.php" around lines 275 to 281 change:

    for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
      if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
        $HTTP_GET_VARS['sort'] = $i+1 . 'a';
        $order_str = " order by pd.products_name";
        break;
      }
    }

to:

    for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
      if ($column_list[$i] == 'PRODUCT_LIST_PRICE') {
        $HTTP_GET_VARS['sort'] = $i+1 . 'a';
        $order_str = " order by final_price";
        break;
      }
    }

then in "catalog\index.php" around lines 159 to 165 change:

      for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
        if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
          $HTTP_GET_VARS['sort'] = $i+1 . 'a';
          $listing_sql .= " order by pd.products_name";
          break;
        }
      }

to:

      for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
        if ($column_list[$i] == 'PRODUCT_LIST_PRICE') {
          $HTTP_GET_VARS['sort'] = $i+1 . 'a';
          $listing_sql .= " order by final_price ";
          break;
        }
      }