How to mass change member info using excel template

There is no Mass Update function for members' setting in our back office. However, there is still a more efficient way to manage member info via the use of "Export" & "Import" option.

Follow the steps below to create a category:

1. After you have logged in to your back office, click on "CRM" category
2. Next, click on the "Member Information" sub-category
   
3. Click on "Export" to export list of current active members out in Microsoft Excel format
   
   
   
4. To modify the data, simply replace the data within the green field. Do not modify any data in the "Do Not Edit" column.
   
5. Once done with the modification of data, remember to click on "Save" to save the changes made.
6. Click on "Import" to upload the newly saved Excel file to override the existing data.
7. Click on "Select" to choose your newly modified document.
   
8. After selection, click on "Upload".
   

9. Successful data importation, old data has been replaced with the new changes.