No replies
VladRM's picture
Offline
Joined: 02/15/2008
Juice: 13
Was this information Helpful?

Hi folks,

I would like to sort the products this way: n.sticky desc, p.sell_price
- ordered(sorted) by price asccending but with the sticky ones first

What is the best way to do this?

I curently hacked uc_catalog.module's theme_uc_catalog_browse function:
changed the line:
$order = 'p.ordering, n.title';
to:
$order = 'n.sticky desc, p.sell_price, p.ordering, n.title';

I'm hoping there is a way to do the same thing via a custom module (not by hacking uc).
I also tried building views but i lose a lot of desired uc_catalog functionality