Update 30 October 2023: Script tested and confirmed working on WooCommerce 8.2.1.
Coupons are amazing, who does not like a discount? A very common way to give coupons to customers is to create one automatically after their first order, or something like that.
The issue with that though is that usually these coupons expire after a specific period, and by default, WooCommerce will not delete them. They have no reason to stay in your database though, so how do we delete expired coupons automatically?
With a snippet of course.
Before implementing any code changes, always ensure your site is backed up. This will help you restore things in case of unforeseen errors. I recommend using Jetpack Backup for real-time backups and one-click restores.
Open your functions.php file in wp-content/themes/your-child-theme-name/ and add this code at the end of the file:
This snippet will automatically move to the Trash all the expired coupons in your store so you can go and delete them permanently with one click, regardless if they have been used or not.
If you want to permanently delete the coupons directly instead of trashing them, you can change this code:
wp_trash_post( $coupon->ID );
wp_delete_post( $coupon->ID, true );
but beware that once you permanently delete a coupon it cannot be recovered.
Note that it works on WordPress cron jobs. If you disabled them or for any reason, they are not working, this snippet will not work as well.
It will also add a Delete Expired Coupons button in Marketing > Coupons. Beware though, this button might run into timeout issues if you have too many coupons to delete!