Hi,
I want to show in Stock products first and then out of stocks on CATEGORY LISTS
I think, if I can add the following line to the SQL line that's enough. but I don't know which files I need to change?
ORDER BY (CASE WHEN ps_product.quantity > 0 THEN 1 ELSE 0 END) DESC, ......... Prestashop's standard SQL string will continue
Hi,
I want to show in Stock products first and then out of stocks on CATEGORY LISTS
I think, if I can add the following line to the SQL line that's enough. but I don't know which files I need to change?
ORDER BY (CASE WHEN ps_product.quantity > 0 THEN 1 ELSE 0 END) DESC, ......... Prestashop's standard SQL string will continue
