• wiseupmarketing

    (@wiseupmarketing)


    Is there not a way to bulk update (via the database) using an SQL query / command for Approve Membership of users? We have over 4000+ members we have migrated and that is alot of pages worth to Bulk Update in groups. Surely trying to do 100 or 200+ at once will break the system.

    Also where does it show on the user account they are an approved members or not? Try to make sure we are updating the setting correctly on each user.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support andrewshu

    (@andrewshu)

    Hello @wiseupmarketing

    Did you use bulk update from the admin dashboard (Users page)? There is an “Approve Membership” option in bulk action.

    Regards.

    Thread Starter wiseupmarketing

    (@wiseupmarketing)

    Again as mentioned we have over 4000+ member records imported that therefore need this action done. Can I even select all 4000+ records this way? Probably not.

    @wiseupmarketing

    You can set the “Number of items per page” to max 999
    in the WP All Users “Screen Options” at the upper right corner.

    Select all these 999 Users and apply the UM Action “Approve Membership”

    Thread Starter wiseupmarketing

    (@wiseupmarketing)

    Wont updating 999+ records at one time likely crash the system?

    Plugin Support andrewshu

    (@andrewshu)

    Hello @wiseupmarketing

    It all depends on your server.

    Regards.

    Thread Starter wiseupmarketing

    (@wiseupmarketing)

    Either way, how can I check which members have been Approved or not?

    Is there somewhere within the admin interface that will show me this information or via the backend MySQL database?

    Despite the information on this page of their site, it looks like all imported members are already set as “Approved Membership”. https://docs.ultimatemember.com/article/1549-export-import

    Plugin Support andrewshu

    (@andrewshu)

    Hello @wiseupmarketing

    There is a column “Status” in Users page in admin area.

    Regards.

    Thread Starter wiseupmarketing

    (@wiseupmarketing)

    Well if thats the case then all users have a status of “Approved” after import. So it looks like they dont need to be updated after an import as per the instructions on their website here: https://docs.ultimatemember.com/article/1549-export-import

    Though their website says “Users imported by third-party plugins are unapproved. Unapproved users can’t log in to the site. Member Directory doesn’t display unapproved members for regular members. You have to approve imported users manually. Use bulk action?Approve Membership?or bulk action?Reactivate?to approve members. The plugin will approve members and send them an email – an?Account Approved email?for members whose current status is “Pending Review” (awaiting_admin_review) or an?Account?Welcome email?for others.

    It looks like the “WordPress Users & WooCommerce Customers Import Export” plugin we are using provides the option for the user_status to be imported. It is one of the fields available in the field mapping screen.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Bulk Approve Membership after Import’ is closed to new replies.