Product Listing page not sorting alphabetically?!?!

[jonw118]

I hope someone can help me.

 

I installed the column contribution- and the products are not displaying by alphabet of their name... can someone think of what I may need to do to fix this?

 

Take a look at this link to see what I mean: http://floramodern.com/catalog/index.php?cPath=24

 

Thanks SO much for any help!

[ozEworks]

They are being displayed by the product number. They always are as far as I am aware.

[jonw118]

oooh- hmm, is there a way to sort alphabetically i wonder?

[jonw118]

Does anyone know if this is possible?

[Guest]

search your catalog\index.php should be some default sort code like

 

if ( (!isset($HTTP_GET_VARS['sort']))

 

couple of lines below it is where the default sort order is defined. If that contribution moded the ordering you will have to find where it did so. Finally you change it to "order by p.products_name"

[jonw118]

OK, thanks! Here's what it says right now:

 

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

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;

}

}

 

Which line do I need to change, the one: $listing_sql .= " order by pd.products_name";??

 

Thanks again for the help!

 

 

search your catalog\index.php should be some default sort code like

 

if ( (!isset($HTTP_GET_VARS['sort']))

 

couple of lines below it is where the default sort order is defined. If that contribution moded the ordering you will have to find where it did so. Finally you change it to "order by p.products_name"

[Guest]

yes but it is already sorted by name, and I checked the page you gave earlier, ordering follows the products name.