Introduction
There are times when you may need to update the points balances for many customers at once, such as launching your loyalty program, migrating from another provider, or issuing bonus points due to unexpected store downtime. The most efficient way to make these bulk changes is by importing a CSV (comma-separated values) file.
How to Update Customer Points Using a CSV File
Option 1: Download the Loloyal CSV template to adjust the data, and import the file when finished.
Please follow the steps below:
1. Go to the Customers section and select Import Customer Points.
2. Select how to identify customers and choose the points adjustment method. Then download the template file, fill in the required details, and save it.
3. Once your CSV file is ready, click Add files to upload it. Then click Import and follow the on-screen steps to complete the process.
Option 2: Export your existing customer list and modify the necessary fields.
If you'd like to start with your current customer data:
Navigate to Customers in your Loloyal Admin.
Export the list.
Retain only the
email
,phone
, andpoints
columns for modification.Save as CSV.
β οΈ Important: Do not use Macβs Numbers app for CSV creation, it does not export files in the correct format. Use Microsoft Excel or Google Sheets instead.
π Tips
General CSV Rules
Required fields:
email
orphone
, andpoints
No blank cells
Points must be integers from 0β100,000,000
Only upload emails or phone numbers that already exist in your Shopify customer list
Email-Specific Tips
Email must match an existing Shopify customer
Phone Number-Specific Tips
Must include country code
Do not include "+" or parentheses
β Correct:
18189750320
(U.S. example)β Correct:
8613800138000
(China example)
Common Questions:
1. What happens if there are errors in the CSV file?
If any row has errors, no points will be imported from that file.
2. How do I fix a failed import?
Loloyal will provide an error file detailing what went wrong.
Simply correct the issues and re-upload your CSV.
Note: For your convenience, please download the templates below.