Search on sale items?

[momaro20 (deleted)]

Is there a specific search that will bring up sale items only?

[support]

What's wrong with the "Show only sale items" checkbox at the top next to your search? Should do what you want.

[momaro20 (deleted)]

This still isn't working for me (or has stopped working... not sure). When I check the box to show only sale items it still shows everything. Items not on sale show a 0% discount.
I've attached a sample of what it looks like.

Monique

[support]

This problem is caused by the sale_price column being set to the same as the price column, in your private database. When the item is not on sale, it should not have a value in sale_price, rather it should be NULL.