pir81

Hi Shameen,

thank you for your reply

• the header includes “Content-Type” application/json
• I am using PUT (see inital post)
• I am using the full string (see inital post)

So I guess I have set up everyhting as it should be. Still something is wrong. I will try the Slack Channel. Thanks.

I also figured out, what the steps are to make them “undeletable”. The user registers through woocommerce my_account (does not show in customers). Then a LearnDash course is assigned to them through users > all users (now they show up as customers). Even if you than remove the course from their account, they remain in the woocommerce list.

I will submit a ticket with LearnDash as well.

Hi @xue28

I have spoken to our provider. He confirmed that all caching was flushed. I am also working with chrome developer open and always flush any local caching on closing the browser.

So it does not seem to be a caching issue.

I have tested the proposed solution from the supplied link to delete all customers https://www.wpservices.com/2022/02/01/how-to-delete-all-customers-in-woocommerce/

SELECT * from wp_users where wp_users.ID not in (
 
SELECT meta_value FROM wp_postmeta WHERE meta_key = '_customer_user'
 
) AND wp_users.ID not in (
 
select distinct(post_author) from wp_posts
 
)

It returns with only 1 user, which is our test user and that is expected, that is the only other user/customer (besides admin) under “users > all users” in wordpress. It does not find the other 16 that are shown in the woocommerce backend “woocommerce > customers”

I also checked the following proposal to delete all orders https://www.wpservices.com/2022/01/31/how-to-delete-all-orders-in-woocommerce/ and ran the following code as “test preview”

DELETE FROM wp_woocommerce_order_itemmeta;
 
DELETE FROM wp_woocommerce_order_items;
 
DELETE FROM wp_comments WHERE comment_type = 'order_note';
 
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' );
 
DELETE FROM wp_posts WHERE post_type = 'shop_order';

it came back with 0 actions as expected, as there are no orders under “woocommerce > orders”.

Any other suggestions on how to get rid of those customers?

Thanks