How to delete all old WooCommerce customers?

  • Resolved amymattian

    (@amymattian)


    8 years, 11 months ago

    After importing all old data from another site to WooCommerce, we noticed that the shop has 596 “ghost customers”. These are shown in users page but only as a number in CUSTOMERS, but when clicking the tab these are not shown.

    How can we delete these customers that were copied with the old data? Seems we cannot delete them from Users page since they are not visible when clicking CUSTOMERS tab.

    Problem these “ghost users” are creating is when a new user registers, they see user-details (address etc) of someone else in the database. This happens immediately after they have given their email-address + new password.

    HOw to delete these “ghost users” from Customers? How to delete all Customers?

    We’ve tried Buld Delete plugin but that only deletes those users that are new. Not the ghost users.

    – Anne

    https://www.ads-software.com/plugins/woocommerce/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Mike Jolley

    (@mikejolley)

    You’ll need to go inside the database (use phpmyadmin via your host control panel) and look at the wp_users and wp_usermeta table. Users stores user details, usermeta stores all the address information.

    Just bare in mind any new real accounts, and your own account, will be stored there too.

    Thread Starter amymattian

    (@amymattian)

    Hi Mike,

    thanks for the info. The wp_users has only 10 lines. But the “ghost-users are almost 600”. In the wp_usermeta there are lots of lines, but it all seems to be a big mess. Would you have a command which would clean the wp_usermeta?

    Looks like Wp_Posts and wp_postmeta would have some userdata. Can those be cleared without harming actual product details/data?

    – Anne

    Thread Starter amymattian

    (@amymattian)

    Hi,
    we found this command and it worked:

    DELETE FROM wp_usermeta WHERE user_id NOT IN (
    SELECT ID
    FROM wp_users
    )

    Thanks!

    – Anne

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to delete all old WooCommerce customers?’ is closed to new replies.