Product list ordered by manufacturers in category page

[antwake]

Is there a way to display the products in others ways than their IDs in the category page?

 

I would like to display my products ordered by their manufacturers. (The option "Filter by category" in the back-office doesn't suit my needs)

 

thanks!

 

[NemoPS]

In the back office? Catalog > manufactures > click on one of them

[antwake]

in the front-office 

 

If I click on a category, the displayed products are ordered by their IDs. I would like to order them by manufacturer

Edited June 17, 2014 by antwake (see edit history)

[NemoPS]

You have to modify Category::getProducts. FInd the main query and instead of

 

$sql .= ' ORDER BY '.(!empty($order_by_prefix) ? $order_by_prefix.'.' : '').'`'.bqSQL($order_by).'` '.pSQL($order_way).'

 

 

Use

 

$sql .= ' ORDER BY m.manufacturer_name ASC';