This article contains information about the procedure to import new members to your loyalty program or to update attributes for any of the existing loyalty members.
- Currently, the member import functionality does not have the ability to send account creation emails to members imported in bulk. However, email notifications resulting due to activities henceforth will be sent.
- If you have enabled member information sync with Listrak or Bronto, please note that the information of members imported using this functionality will not be synced. However, the incremental updates to loyalty points information will be synced seamlessly.
- If you have implemented ‘Webhook’ for receiving event updates from Zinrelo, please note that webhook events for the bulk import of members will not be posted to your webhook URL. However, the incremental events will be posted to the webhook URL.
If you wish the notifications, CRM information sync, or webhook post events to happen for bulk member import, please contact Zinrelo Customer Support at firstname.lastname@example.org to discuss the alternatives.
Importing members into the program or updating the attributes of existing members is a simple process.
- Download the sample CSV file from the Members section.
- Add the member details to this CSV as per the format specified in the sample CSV.
- Upload the file.
- Wait for Zinrelo to run a validation scan.
- Receive a confirmation email after the import is complete.
1. Download the sample CSV file from the Members Section
- Log into your Zinrelo admin account and navigate to the Members tab as shown in the image below.
- On the Members page, you will see a button - Import Members. Click on it to open the interface to import members.
- Click on the link shown in the image above to download the sample CSV file.
2. Add the member details to this CSV as per the format specified in the sample CSV
- The sample file contains the columns expected by the member import process. Here is a snapshot of an example record that needs to be imported
- Add user records that you are going to import into ZInrelo to this file with the right values going into their respective columns.
Disclaimer : At this moment, Zinrelo can only process 100,000 records in one file. If you have more than 100,000 users, please break it down into multiple files with a maximum of 100,000 records in each file.
Below is an explanation for each of the columns :
- Please note that you can use the member import functionality to update the following fields for existing members - user_status, user_phone, tags, date_of_birth.
- ‘Points balance’ will not be updated for existing users. If you specify the points_balance value for a record that already exists in Zinrelo, the process will simply ignore this value and update the rest of the values.
3. Upload the file
- Once you are ready with the file, click on the upload button and browse and select the file you wish to upload.
- After you upload the file, the button “Validate File and Import” will become active.
- Enable the flag - Award points for account creation - if you wish to award points to the imported users for “account creation” activity. Please check the settings of the Account Creation activity under Program settings > Activities > Account Creation.
- Enable the flag - Assign Tiers to users based on their points - if you wish to drop the imported users in their respective tiers according to the points specified in the points_balance column . This flag will be visible only if you have opted to have a Tier based loyalty program. Please check your tier settings under Program settings > Tiers.
- Click on “Validate File and Import” to schedule the import job.
4. Wait for Zinrelo to run a validation scan
- Zinrelo will run a basic validation scan on the file. During this process, Zinrelo scans the entire file to run some checks. This may take a few seconds.
- If Zinrelo finds any of the columns missing or invalid values, an error popup will be shown. You will need to rectify the errors and do a fresh upload.
- If Zinrelo finds any non-fatal issues with the file, a popup will be shown with warnings and an option to “Continue” in spite of warnings or “Cancel” . Clicking on Continue will schedule the import job.
- If there are no errors or warnings during the scan, the import job will be scheduled . You will see an entry for your import job in the “Status” table below with the status - Scheduled
- The import job will be triggered at the time mentioned in the “Start Date” column. Clicking on the status will display a popup that mentions the details of the import job. The popup will also contain a button to cancel the scheduled job.
- Once the import job is triggered, the status of the job will change to Processing. You can click on refresh to check the latest status of the scheduled import jobs.
5. Receive a confirmation email after the import is complete.
- After the import job is complete, you will receive a confirmation email with the details of the import job.
- On the Zinrelo admin console, you can also click on the “Completed” button in the status column under Members > Import Members to check the details of the completed import job.