Plugin Author
RLDD
(@rermis)
Hi @e4deal,
Sorry to hear you’re seeing load issues.
Auto Coupons for WooCommerce is designed to avoid “scan every coupon on every page view” behavior, but it does need to evaluate eligible coupons when cart activity happens. On stores with a sudden large volume of visitors, or large number of coupons (especially lots of auto-apply / URL-apply / restricted coupons) that translates into heavier database work, and on basic hosting it can show up as high server load.
If you want, I’m happy to help confirm whether it’s configuration vs hosting limits. Please share:
- Total coupon count
- How many are set to auto-apply and/or apply via URL
- Hosting type (shared/VPS/dedicated)
- PHP + MySQL version
Thread Starter
e4deal
(@e4deal)
We currently have approximately 7,200 coupons in the system. However, 99.9% of these have not been used since 2023. We only have 3 or 4 coupon uses per day.
We have three coupons configured for auto-apply, and none of them are currently active or in use.
The site is hosted with Kinsta, running PHP 8.2.
Plugin Author
RLDD
(@rermis)
Hi @e4deal,
Thank you, that is helpful detail. Knowing this, I’ve released v3.0.44 today with potential efficiency improvements.
Expired coupons are excluded earlier in the root query, and coupons with email restrictions are no longer evaluated unless specific features are turned on, which should reduce load on large coupon datasets.
If performance issues continue, I recommend ensuring old coupons have an expiration date set or are moved out of published status.
Please update to 3.0.44 when you have the opportunity and let me know if any improvement is observed.
