How to adjust a customer loyalty balance


To add or remove loyalty points from customers in the event of incorrect accrual/deduction of loyalty points.


  • Retail POS for Mac or PC


Export customer(s) to be adjusted as a CSV file


  1. Navigate to Customers -> Customers
  2. Use the filters to locate the customer(s) to be adjusted
  3. Click Export List to download a CSV template

Adjust customer(s) loyalty on the CSV file

  1. Locate the CSV file you downloaded
  2. Open the file using Microsoft Excel or OpenOffice
  3. Delete all columns EXCEPT customer_code, first_name and last_name
  4. Add an additional column at the end and title it loyalty_adjustmentScreen_Shot_2021-02-05_at_9.25.24_AM.png
  5. The loyalty_adjustment column is an additive/subtractive field
    • To increase the loyalty balance, enter the value you wish to increase the balance by
    • To decrease the loyalty balance, enter - and the value you wish to decrease the balance by
  6. Save the file as a CSV

Import the CSV into Retail POS

  1. Navigate to Customers -> Customers
  2. Click Import Customers
  3. Click Choose a File to Upload...
  4. Locate and select the CSV file you created earlier
  5. Click Continue with Import

Once the import has been processed, you will receive a confirmation notification in the notification dropdown on the top right of your Retail POS screen. 

If successful, the message should read: "Your import of customer has completed: none were added, X were updated and none were ignored."

Additional Information

Adding Customers in Retail POS

Did this answer your question?
Have more questions? Contact us so that we can help you out.