How to add "Discount first" sorting of products?

Question

opencart

I figured out how to add the sorting of goods by date, but I can’t figure out how to sort by "first with a discount", Engine version 2.3. was in ascending order from the smallest to the largest price tag, can anyone come across this? I will be very grateful)

Answer 1

make order by ps.price ASC
Push this option in the controller and in the product.php model in the function for obtaining information about products in the category and in the function for counting products