Skip to main content
Updated Nov 8, 2026
Zu Wei
3 min read
16 views

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

  1. Go to Admin Panel → CRM → Customers.

    Admin Panel with CRM expanded, Customers highlighted and its landing page visible.

    Customers is in the CRM group.

  2. Click the three-dot menu at the top right and choose Import Customers.

    Customers action menu open with Import Customers highlighted.

    Import Customers is in the three-dot menu next to Send Campaigns.

  3. Match your spreadsheet columns to these fields. Phone Number is required. There's no Points column on purpose, since points come next.

    Import Customers column mapping with mandatory Phone Number highlighted and optional Name and Email mappings.

    If your business has its own required customer fields, map those too.

  4. Go to Admin Panel → Loyalty Program → Point History. No upload option here? Ask Pixalink support to switch it on first.

    Admin Panel with Loyalty Program expanded, Point History highlighted and its landing page visible.

    Upload Transactions is in the three-dot menu at the top right of Point History.

  5. 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.

    Import Point Histories column mapping with Amount and Customer mapped, Skip unregistered customers off, and 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.

  6. Open Customers again. Click the column icon above the table to turn on Current Point, then check a few balances.

    Customers column manager with Current Point before enabling its column.

    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?

Video transcript: How to Import Customers with Historical Loyalty Points — Pixalink
When you move to Pixalink, your regulars should not lose the points they already earned. Here is how to bring in your customers and their points. Go to Admin Panel, then CRM, then Customers. Click the three dot menu at the top right, and choose Import Customers. Match your spreadsheet columns to the fields shown. Only phone number is required. There is no points column here, on purpose. Go to Loyalty Program, then Point History. If you do not see an upload option, ask Pixalink support to switch it on. Your file needs just two columns. Amount is the points to add. Customer is the phone number in international format. Space and Remarks are optional. Click Upload Transactions, upload your CSV, and map the Amount column to your point total and the Customer column to the phone number. Open Customers again, turn on the Current Point column, and check a few balances.

Was this article helpful?

Thank you for your feedback!

0 found this helpful 0 did not

Search