Here's what we're covering:

• How to import points with a CSV file

CSV files are the best way to adjust your customers' points balances in bulk.  

You can adjust points balances in 2 ways:

Add points to an existing balance
Reset an existing balance to a new value

You can either download a points balance CSV template or build your own using Microsoft Excel or Google Sheets.


Using a Smile CSV template.

On your Customers page, click "Adjust points total."

Choose the "Import point balances from CSV" option and choose the reason you're importing points from the "Import points to" dropdown.

You will then have the option to download a sample CSV template.


Using Microsoft Excel or Google Sheets.

In order to import points balances to Smile, your CSV file needs to be formatted properly.

Create 2 columns with the headers "email" and "points."  Enter your customers' emails into the email column, and the points balance in the points column.

📝   Pro Tip:

Email addresses are case sensitive, so make sure each customer's email address is written exactly the same as how it appears in your store Admin to guarantee a successful import.

Once your CSV has been compiled and saved, you can import it to your Smile Admin in the Customers section with the "Adjust points totals" button.

Choose "Import point balances from CSV."

You will then be prompted to choose what you would like to do with the imported points.  This is where you decide whether to add points or reset your customers' points balances.

You also have the option to add internal or customer-facing notes on the reason for making the points adjustment.

Choose the option you'd like and click "Import points."  You will receive an email notifications once the import is complete.

Did this answer your question?