23 Feb 2016, 1:23 PM
Zen Follower
- Join Date:
- Jul 2006
- Posts:
- 309
- Plugin Contributions:
- 0
Sort products by new and most popular
I'd like to sort my products listing, for certain categories only, by new and most popular. So first it would show the new products in the last 60 days, along with some kind of "NEW" badge, and then list the most popular in descending order. The popular count might be by orders or views, but assume I already have the data in another table.
Is this possible?
I think i would use a couple ORDER BY clauses in the SQL command. What file should I be changing?
Adamant Barbell - Home & commercial gym equipment - Since 2007
www.adamantbarbell.com