How to reset User counts

How can I reset the total number of users on my Users page? I did a small import from a CSV file. Worked well. I didn’t catch one small thing (role was not entered correctly, so system ignored it) before doing a much larger import of several hundred users. Rather than delete the users in groups of 20 from the Users page, I went to the SQL table and deleted them in one fell swoop. I was able to re-import the users correctly, but now my total User counts (All users, Level 1 users, Level 2, etc.) is double what it should be. How can I reset the counts to reflect the accurate numbers? I tried looking for additional SQL tables, but could not find them.

Hi there. Thanks for your inquiry.

It sounds like you deleted Users from the wp_users table, but left references to these Users in the wp_usermeta table. You’ll need to make sure that all related entries matching the user_id column in your wp_usermeta table are removed. Otherwise WordPress will think they still exist.

* Be sure to back things up before deleting :-)

Jason,
Thanks for your response. It was exactly what I needed. I was able to find the correlating offenders inside the wp_usermeta table. I was able to remove them, and now my counts line up.

Many thanks!
Jason O.

Very welcome Jason :-)