eloy1812 Posted May 4, 2018 Share Posted May 4, 2018 Hi, How can I order the products shown in the categories by two columns? I need the product listings to be ordered first by brand and within this alphabetical order of product name PS: 1.7 Theme: default I tried to manually add the order by brand in the category class and leave it in the admin sort by name if ($random === true) { $sql .= ' ORDER BY RAND() LIMIT '.(int) $randomNumberProducts; } else { $sql .= ' ORDER BY m.`name`,'.(!empty($orderByPrefix) ? $orderByPrefix.'.' : '').'`'.bqSQL($orderyBy).'` '.pSQL($orderWay).' LIMIT '.(((int) $p - 1) * (int) $n).','.(int) $n; } But no result. It seems that the result product array is rearranged in the front by ajax But I can not find where it can be. thx Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now