Woocommerce - Delete customers who haven't ordered in the last year

pasta_paul

I am trying to clean up my woocommerce shop. We have 13,000 customers. I would like to delete all customers who have not ordered within the last year. I'm running into several problems though. (mostly, ignorance!) In the Woocommerce/customers section I can filter by last active but there is no way to delete users from this area. I tried using this code: add_filter( 'manage_users_columns', 'prefix5487_modify_user_columns' ); function...

Originally asked by rudtek on Stack Exchange (stackoverflow) (CC BY-SA 4.0).

uphilltech

Great question — answering as the UphillTech team:

I had around 17,000+ spam users in my WordPress account. I ran a SQL query through phpMyAdmin, and it successfully removed all the fake users. DELETE FROM wp_users WHERE ID IN ( SELECT ID FROM ( SELECT u.ID FROM wp_users u LEFT JOIN ( SELECT DISTINCT CAST(meta_value AS UNSIGNED) AS user_id FROM wp_postmeta WHERE meta_key = '_customer_user' AND meta_value != '0' ) customers ON u.ID = customers.user_id WHERE customers.user_id IS NULL AND u.ID > 1 AND u.ID NOT IN ( SELECT user_id FROM wp_usermeta WHERE meta_key = 'wp_capabilities' AND ( meta_value LIKE '%administrator%' OR meta_value LIKE '%editor%' OR meta_value LIKE '%author%' OR meta_value LIKE '%shop_manager%' ) ) ) AS temp );

Full answer by Dilanka Fernando: https://stackoverflow.stackexchange.com/a/79926745 (CC BY-SA 4.0).

Need it done for your business? UphillTech.