Skip to main content

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

  1. Go to Admin Panel → Loyalty Program → Point History.

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

    Point History is in the Loyalty Program group.

  2. Click the three-dot menu at the top right and choose Upload Transactions.

    Point History menu with Upload Transactions and Bulk Deduct Point.

    The menu is the three dots next to the Record Points button.

  3. Click Download example CSV file and open it in your spreadsheet app.

    Point History import dialog with Download example CSV file highlighted.

    The example file already has the right column names.

  4. Keep row one as it is. From row two down, add one customer per row: points in amount, phone number in customer.

    Step 4: A spreadsheet named bulk-points.csv: row one holds the column names amount, customer, space_slug and remarks (amount and customer required). Each following row is one customer, with points in amount and a 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.

  5. Save the file and drag it into the upload box. Match Amount and Customer to your columns.

    Import Point Histories column mapping with Amount and Customer mapped, Skip unregistered customers off, and Import.

    The Space (outlet) and Remarks fields are optional.

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

    Point History import dialog with Skip unregistered customers switched off.

    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.

What's Next?

Video transcript: Bulk Upload Points with a CSV
Bringing your customers points into Pixalink takes one spreadsheet. The trick is the shape of the file. This video shows the layout that works, and the red warning to watch for. In the Admin Panel, open the Loyalty Program group, then Point History. The top right is where the tools live. Record Points handles one customer. Beside it, the actions menu holds the bulk options. Open it and choose Upload Transactions. This upload box appears. From here, you can download an example file to start from. If your points and phone numbers run sideways across one row, Pixalink reads them as column titles, and shows a duplicate column headers error. Reshaping the file is what fixes it. Think of it like a spreadsheet. The first row is the column names, exactly as shown. Then one customer per row going down. Amount is the points to add, and Customer is the phone number. The last two columns are optional, so you can leave them blank. Fill the example in that shape, drag it into the upload box, check that the Amount and Customer columns are matched, then click Import. Each balance goes up on its own within a few minutes. When the import finishes, Pixalink shows a green success message with the number of transactions added. Every customer balance updates on its own, so there is nothing else to do.

Was this article helpful?

Thank you for your feedback!

0 found this helpful 0 did not

Search