Is there a way to use a CSV file to upload permissions for the Membership plugin?

I am creating a CSV file in Apple Numbers (Excel) to upload 400 existing users to the database for our new WordPress site. Is there a way to use this CSV file to upload permissions for the Membership plugin? I would like to assign Access Levels and Subscriptions to each user with this CSV file.

Thanks!

  • Ash
    • WordPress Hacker

    Hello @Pdca Admin

    I hope you are well today.

    The permission is stored as capabilities and serialized value in wp_usermeta table.

    Step 1 (BACKUP!!!!) - backup your database
    Step 2 - Use PHPMyAdmin or similar tool to access your DB, find the wp_usermeta table and then sort by user_id. User #1 is for admin. Next find your wp_capabilities field and click edit.
    Step 3 - Add new values here for the users, compare with the admin or an user who has certain capabilities.

    Hope it helps :slight_smile: Please feel free to ask more question if you have.

    Cheers
    Ash

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.