Soft79

thanks, will look into this.

Actually, yes we don’t do updates anymore but chance is it still works due to its simplicity. Haven’t tried it for a long time ??

Yes, it’s still compatible.

ah, sorry, that option is only in the pro version.

If you’re comfortable with programming, you can use this: https://stackoverflow.com/a/66110248

Go to wp-admin > Settings > WC Extended Coupon Features.

Our plugin’s settings page has an option to ‘allow removal of auto coupons’.

Another option is using the WooCommerce woocommerce_apply_individual_use_coupon / woocommerce_apply_with_individual_use_coupon filters.

Hi @ramon-fincken, thanks for looking at this!

I think the performance issue is related to a missing meta_key index. So this line should do the trick:

ALTER TABLE 6703b96173268_postmeta ADD KEY meta_key (meta_key(191));

(where 6703b96173268_ is the table prefix)

Yes, it should’ve been done automatically by WP. Yes you need to create an index for meta_key column.

Maybe this page helps (I have not verified this, so run at your own risk. Create a backup of your database first!): WordPress database index fixer by ManagedWPHosting.nl – Add indexes, keys, primary keys again to your WordPress database tables

It looks like your wp_postmeta table is missing an INDEX on column meta_key.

I see you already mentioned the query in your starting post.

How long does the query take if you execute it directly in your database? What result do you get if you execute the query with EXPLAIN before it?

EXPLAIN SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (?,?,?) ORDER BY meta_id ASC

Replace the questionmarks with the post ids of your auto-coupons.

What is the query that is executed? It should look like this (xxx is the table prefix)

SELECT xxxposts.*
FROM xxxposts
INNER JOIN xxxpostmeta
ON ( xxxposts.ID = xxxpostmeta.post_id )
WHERE 1=1
AND ( ( xxxpostmeta.meta_key = '_wjecf_is_auto_coupon'
AND xxxpostmeta.meta_value = 'yes' ) )
AND xxxposts.post_type = 'shop_coupon'
AND ((xxxposts.post_status = 'publish'))
GROUP BY xxxposts.ID
ORDER BY xxxposts.post_title ASC

What is the result if you run the query prefixed by EXPLAIN ?

How long does the query take? Do you have information on how you profiled this? Do you have many auto coupons?

If ‘high performance’ mode is enabled on our plugin, the query is only called on a change in the cart. This shouldn’t have a large performance impact.

I don’t see any open tickets at WooCommerce Extended Coupon Features PRO – Soft 79 . Please send an url to your topic and I will take a look.

Hi, that is not possible.

No, we don’t support memberships.