insert profiles via SQL

Hi @fredyms

I don’t know a plugin that allows you to add 200 new roles in bulk, but you can install Code Snippets plugin and run PHP code snippet similar to the one below once. This code will loop over roles in the array and add multiple roles with the same capabilities as Subscriber role:

$roles = array(
    'basic' => 'Basic',
    'professional' => 'Professional',
    'advanced' => 'Advanced'
);
foreach( $roles as $role_name => $display_name ) {
    add_role( $role_name, $display_name, get_role( 'subscriber' )->capabilities );
}

I hope that helps.

Hi, thank you, it worked perfectly, the name of the role has completed ok, but the profile instead of role has put a sequential number.

I would like the role field to be filled in with the same name as the role name.

but it works and solved the problem.

thank you very much for your support