Hello bidtocart.

I am sorry but I don't quite understand what you're asking here.

Can you explain in a bit more detail?

How was the table created? Is it SQL query based table; or import from Excel, CSV or Google Spreadsheet; or link to one of these; is it a manual table? How many columns containing which data? Where would you display that user role - in another column?

Please share as much info as you can. Some screenshots would also be awesome.

Thanks in advance

Best regards.

Ah, I see bidtocart.

The thing is that you can't actually do this easily.

You would have to create an SQL query based table, and pull the info from the database.

User roles are stored in wp_options table and in wp_user_meta.

To check user roles, first, check out the user id in the table wp_users (Column name ID)

Now Go to table wp_usermeta and search where column user_id is equal to the ID that matches ID from wp_users table.

You will get a list of rows with metadata of the chosen user, the row with meta_key as wp_capabilities defines the user role.

The Value of wp_capabilities for

Admin : a:1:{s:13:"administrator";b:1;}
Woo Commerce Customer :  a:1:{s:8:"customer";b:1;}

That would require some custom query to be written.

Best regards.