I am having a problem with the product sort order. My goal is to have all of the products sorted by manufacturer name followed by product name (Ex. Sony AAA, Sony BBB, Sony CCC). I changed the following code in index.php:
if ($column_list[$i] == 'PRODUCT_LIST_MANUFACTURER') {
$HTTP_GET_VARS['sort'] = $i+1 . 'a';
$listing_sql .= "order by m.manufacturers_name";
This got all of the products in order by manufacturer name, but they are still not sorting by product name per each manufacturer name. It's doing something like this Sony BBB, Sony AAA, Sony DDD, Sony CCC. The only time it sorts correctly is when I click a results page, like results page 2 or even page 1. But each time I click a category, the products get scrambled again.
Any help would be GREATLY appreciated!