Sort by Stock Quantity?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
3 years ago
I would like to have all items that have 0 qty show at the end of the product list when displaying products. I still want user to see then so they can click on notify when available. I am guessing it is a display sort by item qty descending order.

I would like to do this without changing source code just the cshtml if needed. this is in 4.10
3 years ago
I wrote a quick SQL script that I can run every couple of hours to change the display order. I do not see a display order table for Tags.
----- SQL Script-----
BEGIN TRANSACTION;
UPDATE Product_Manufacturer_Mapping
  SET Product_Manufacturer_Mapping.DisplayOrder = '999'
FROM Product_Manufacturer_Mapping T1, Product T2
WHERE T1.ProductId = T2.Id
and T2.StockQuantity = '0' and T2.Published ='true';

UPDATE Product_Category_Mapping
  SET Product_Category_Mapping.DisplayOrder = '999'
FROM Product_Category_Mapping T1, Product T2
WHERE T1.ProductId = T2.Id
and T2.StockQuantity = '0' and T2.Published ='true';
COMMIT;
---End SQL Script ------
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.