WooCommerce show ONLY items that are STILL on sale, NOT what HAVE been on sale

I’m using WooCommerce as a Booking System for a not-for-profit where users can purchase a free ticket (simple product) for any day of the year.
This has worked great all through COVID, but I have to manually delete old tickets for days that have passed. Eg: I have to delete last months Products each month to keep the site up to date.

I figured if I can ONLY show products that are STILL on sale, then the site will only show tickets for days in the FUTURE.

In the below screenshot, I only want to show Saturday, Sunday and Monday.

I’m using the shortcode

When I do this, I don’t see any products show up.

When I use

I see products that are both on sale, and not on sale. Eg: Thursday, Friday, Saturday, Sunday, Monday.

It’s really bizarre. What am I doing wrong here?

The page I need help with: [log in to see the link]

Source link