ML 7.0.2
In Admin | Show Products on Sale | you can set the sale price.
I need a way to display the products that are set ON Sale, selected from the left navigation, in the same way a Category is selected.
For now I have a category "Sale Items" The customer has to first set the sale price for the items that they want on sale, then go to edit that product and add the category mapping.
I'd need to eliminate the "Sale Items" category and have the behavior of displaying all items that have a non-zero sale price, in the same way entity.grid.xml displays categories. If there a no products on sale, then the left navigation "Sale Items" should go away.
How to ???? Thank you,
(Hum. Maybe keep the Category, but change the xml to something like "entityonsale.grid.xml and then in the xml change the sql?)