Post by TomSut » Wed Apr 10, 2019 9:42 pm

Currently have Ascending (A to Z) as the default. Is it possible to have both Ascending (A to Z) and Price (low to high) at the same time?
It could just be an extra line in product.php.

Thanks
Tom

Opencart 3.0.2.0
Journal 3 theme

New member

Posts

Joined
Wed Nov 01, 2017 10:41 pm

Post by D3MO » Wed Apr 10, 2019 10:22 pm

You need to change SQL to :

ORDER BY name, price


that is to pass 2 sort fields instead of one.

Opencart Expert | voldemaras@gmail.com
Skype - programanija | Gtalk - voldemaras@gmail.com
Extensions for Opencart @ https://www.opencartextensions.eu / or Opencart Marketplace

Need Custom Module? debug third party module or simply have any question related to Opencart? feel free to contact directly for a live chat session:) - INSTANT LIVE CHAT


User avatar
Active Member

Posts

Joined
Mon Apr 04, 2011 6:57 am

Post by thekrotek » Thu Apr 11, 2019 2:58 am

Same way you can order by multiple table fields. Just separate them with comma.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by letxobnav » Thu Apr 11, 2019 9:05 am

you can have that but not dynamic without changing some code.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by D3MO » Fri Apr 12, 2019 4:02 pm

can be dinamic:) with ocmod:)) installed with changes :)

Opencart Expert | voldemaras@gmail.com
Skype - programanija | Gtalk - voldemaras@gmail.com
Extensions for Opencart @ https://www.opencartextensions.eu / or Opencart Marketplace

Need Custom Module? debug third party module or simply have any question related to Opencart? feel free to contact directly for a live chat session:) - INSTANT LIVE CHAT


User avatar
Active Member

Posts

Joined
Mon Apr 04, 2011 6:57 am
Who is online

Users browsing this forum: fegdeed and 35 guests