How to Bulk Upload Points from a CSV File
What Is This?
Adding points one customer at a time is slow when you have a whole list. Upload Transactions adds points to many customers at once from one spreadsheet. Use it to bring over balances from an old system, or to give a group of customers the same bonus.
Video Walkthrough
Real-Life Example
Wei Lin runs a nail salon in Cheras. She ran a "bring a friend" week and promised 100 bonus points to 60 regulars. Typing them in one by one would take her whole evening. Instead, she downloads the example file, adds one customer per row and uploads it. All 60 customers get their points in one upload, and Wei Lin goes home on time.
How to Set It Up
-
Go to Admin Panel → Loyalty Program → Point History.

Point History is in the Loyalty Program group.
-
Click the three-dot menu at the top right and choose Upload Transactions.

The menu is the three dots next to the Record Points button.
-
Click Download example CSV file and open it in your spreadsheet app.

The example file already has the right column names.
-
Keep row one as it is. From row two down, add one customer per row: points in amount, phone number in customer.

Your file must be tall and thin, with one customer on each row. Tier and outlet point multipliers also apply to uploaded points.
-
Save the file and drag it into the upload box. Match Amount and Customer to your columns.

The Space (outlet) and Remarks fields are optional.
-
Choose whether to turn on Skip unregistered customers, then click Import.
- Off (the default): a phone number that isn't one of your customers yet becomes a new customer and gets the points. A new customer can also get your welcome reward and its WhatsApp message.
- On: rows for unknown phone numbers are dropped quietly. No error shows, their points aren't added, and the finished message still counts them as imported.

Turn it on when your file should only hold existing customers.
What Your Customers Will See
Each customer sees the new points in their points history, like any other points. Their balance updates after the upload finishes, which can take a little while.
Good to Know
- Check the phone numbers in your file before you import, whichever option you pick.
- Never upload the same file twice. The rows are usually added again, and customers get double points.
- A red message about duplicate column headers means two columns in row one have the same name, or are both empty. This often happens when the data is sideways in one row, or row one was deleted. Fix row one, then upload again.
- If your business only allows existing customers, unknown numbers are always skipped, even with the switch off.
- A balance can take a little while to catch up after the upload. See Why a Customer's Points Are Late After a Bulk Upload.
Need Help?
If Upload Transactions isn't in the three-dot menu, point uploads aren't turned on for your business. Contact the Pixalink team and we'll switch them on.

