Efficiently Manage Member Status with Bulk Updates Using the Import Feature
Path: Member Management >> Import tab >> Members Status
Bulk upload member status helps you in updating or changing the status of multiple existing members in a jiffy. Whether a member is in Pending approval, Approved or Banned status, you can modify it by uploading an Excel sheet and assigning them a new status.
In case there is a malicious content, virus or malware during the upload it will show an error and the upload will fail.
Instructions:
-
The excel sheet should be .xls and .xlsx format only.
-
The columns in the sheet are fixed first being the Email and second as Membership Status.
-
While uploading the Excel sheet you would need to mention the New status as Pending for pending approval, Member for approved member and Banned to ban a member.
For instance you could upload the Excel Sheet with new status in the following format.
Email Status:
- Unknown: This status indicates that the member has not been verified, and no verification email has been sent to them. (During a silent upload, no verification email is sent from the community)
- Sent: This status indicates that the member is not verified, but a verification email has been sent from the community to that member.
- Verified: This status indicates that the member is verified. A verification email was sent, and the member used it to verify themselves.
- Assumed: This status indicates that the member is verified from the backend by the support team or trusted domain (for SSO Community).
- Pending: The member needs to be approved by the Admin/Global Moderator.
- Member: Approved member.
- Banned: Banned from community.