How to remove items that are out of stock at the end of the list?

Question

opencart

Hi guys! I'm trying to put out-of-stock items at the end of the list, to no avail.
It costs OcStore 2.3.0.2.3 and the theme Journal 3.0.46
I edit the files catalog/model/catalog/product.php and catalog/controller/product/category.php
I edit the examples from Google. The product has a balance of 0 and the corresponding status is set, but the product is on the second page, but according to the idea, it should be on the last one.

Maybe the theme has something to do with it?
Please advise.

Answer 1

Add to sql-query "ORDER BY quantity DESC" if in descending order of balances,
if just goods without residues at the end, then "IF (quantity > 0, 1, 0) DESC"