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
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.