Hi all,
I have products that have two custom fields I want to order by - dollars and cents. I want to order them firstly by category, then dollars, then cents.
I’ve tried this by using Orderby, but it doesn’t seem to work. I’ve also tried writing a SQL query, which partially worked, but I figured there must be a better way.
Any help with this would be SO appreciated, as I assumed that ORDERBY would be relatively simple in EE, and found this out right before launching my project.
Thanks
Lisa