How to Import Customers with Historical Loyalty Points
What Is This?
When you move to Pixalink, your regulars shouldn't lose the points they already earned. Bring in your customer list and their past point totals in two steps, so loyal customers see their old balance from day one.
Real-Life Example
Farah runs Petal & Stem florist in Subang and has 400 regulars in an old spreadsheet, each with points from her previous system. She worries switching to Pixalink means everyone starts back at zero. Farah uploads her customer list as a CSV, then asks Pixalink support to switch on point uploads for her account. She uploads a second file with each customer's past point total. Minutes later, her regulars open their loyalty page and see the same balance as before. Nobody feels like they lost anything.
How to Set It Up
-
Go to Admin Panel → CRM → Customers.

Customers is in the CRM group.
-
Click the three-dot menu at the top right and choose Import Customers.

Import Customers is in the three-dot menu next to Send Campaigns.
-
Match your spreadsheet columns to these fields. Phone Number is required. There's no Points column on purpose, since points come next.

If your business has its own required customer fields, map those too.
-
Go to Admin Panel → Loyalty Program → Point History. No upload option here? Ask Pixalink support to switch it on first.

Upload Transactions is in the three-dot menu at the top right of Point History.
-
Click Upload Transactions, upload your CSV, and map Amount (the points to add) and Customer (phone number). Turn on Skip unregistered customers, then click Import.

With the switch on, the upload can't create customers or send them welcome messages. Rows for numbers not in your list are skipped quietly, so check Step 6. For both options, see How to Bulk Upload Points from a CSV File.
-
Open Customers again. Click the column icon above the table to turn on Current Point, then check a few balances.

Current Point is each customer's balance. It can take a little while to update after the upload.
What Your Customers Will See
Your customers don't need to do anything. Next time they open their loyalty page, their balance includes the points you uploaded.
Good to Know
- The customer template never has a Points column. Import customers first, then add points second.
- Switching from another POS system (StoreHub, AutoCount, Loyverse) only brings your customer list, not old points.
- A tier point multiplier can multiply uploaded points. Check this before uploading exact totals.
- With point expiry on, points count down from the upload date, not when first earned.
Need Help?
If Upload Transactions isn't on the Point History page, point uploads aren't turned on for your business yet. Contact the Pixalink team and we'll switch them on.
What's Next?
- How to Import Customers from CSV — every customer field and import mode
- How to Set Up Point Expiry Rules — see how expiry affects uploaded points
- How to Record Points for a Customer — add points one at a time

