cancel
Showing results for 
Search instead for 
Did you mean: 

Get a list of all products currently on sale

Get a list of all products currently on sale

Hi,

 

Is it possible to generate a list of all products currently on sale on my store?

 

I was thinking that a widget could solve this for me so I tried setting up a "Catalog Product List" widget on a page and set condition to have Special Price greater than 0 but the page is showing, "We're sorry, an error has occurred while generating this content."

 

My issue is someone else in the office was managing the website and is now gone and there seems to be a lot of products that have special prices on them but there is no end date.

 

There's over 4000 products on the site so I don't want to have to check them individually.

 

Would be grateful for any advice that people can give.

 

Site is Magento v2.2.4