secondary sort order on product listing?

Hey All,

Is it possible to put a secondary sort on an item in the product listing?

..I'm currently sorting on manufacturer - then within each manufacturer, I need to sort on the model (or perhaps some other field). anyone know if this is possible?

...much thanks, monk

You would need to alter the ORDER on the SELECT statement where manufacturer is used ...

thank you Ajeh for the pointer. you put me in the correct direction.

in case anyone else needs something like this, here's the solution i took:

• you'll find the SQL that's used for the product listing in :
  <install path>/includes/index_filters/default_filter.php
• there's a variety of filters (order by) sql you'll find here.. i needed a primary sort on manufacturer (which can be done via the admin : configuration->product listing->display product listing default sort) and a secondary sort on model (vs. the default secondary sort on product name).
  -- so i altered around line 122 from:
  $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
  to:
  $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", p.products_model";

...that did the trick.

thanks- javaMonk();

Thanks for posting the solution that worked for you ... :smile: