There are different functions that are called to get listing of products. This depends on the section that does listing.
Example:
public function getProductsByCategoryId($category_id, $sort = 'p.sort_order', $order = 'ASC', $start = 0, $limit = 20) {
There is a section that sets the sorting (order)
$sort_data = array(
'pd.name',
'p.sort_order',
'p.price',
'special',
'rating'
);
if (in_array($sort, $sort_data)) {
if ($sort == 'pd.name') {
$sql .= " ORDER BY LCASE(" . $sort . ")";
} else {
$sql .= " ORDER BY " . $sort;
}
} else {
$sql .= " ORDER BY p.sort_order";
}
if ($order == 'DESC') {
$sql .= " DESC";
} else {
$sql .= " ASC";
}
You need to let us know where exactly you need to change the sorting order. What page?