Invisible users

This error happens when the users role isn’t properly set in the CSV.
To delete the users you need to access the database via a tool like PHPMyAdmin and delete them from the users table.

Hi. I have this exact same issue and they are not showing in the users table wp_users in the PHPMyAdmin ? but I have 62 “users” ??

I was able to fix it. There were no entries on wp_users either but there was a table called users_meta that has all the entries missing. I deleted all them except the first entries that were already there. It’s kind of easy to figure, go for the user id and delete all the entries that users are not showing.

Hope you fix it!

Thanks for the update.

How do you fix the user’s role in the CSV file so that the import happens successfully?

The CSV file contains the following:

wp_capabilities
a:1:{s:8:”customer”;b:1;}
a:1:{s:10:”subscriber”;b:1;}
a:1:{s:10:”subscriber”;b:1;}
a:1:{s:10:”subscriber”;b:1;}
a:1:{s:8:”customer”;b:1;}

I assume those are the roles.

I am using the latest version of WooCommerce.

I’m also having the same problem and was able to delete the invisible entries in the usermeta table.
After that I tried to import again and the same problem. Anyone found what is causing it or how to make it work.

My users are properly set before I export them, at least I think so.

Ok so i have the same problem but i cannot find the users_meta table?
I did find wp_usermeta is that it?