Skip to main content

How to bulk issue loyalty points with a CSV file.

You can add loyalty points to many customers at once by uploading a CSV file from Loyalty Points > Bulk Issue loyalty. The importer walks you through four short screens: upload, header row, column mapping and a final data check. Once you submit, the point

Before you start

  • You need access to the Loyalty Points section of your 99minds dashboard.

  • Prepare a CSV or Excel file with one row per customer. The only required column is points. Each row also needs a way to identify the customer, such as a card number, customer ID, email or phone.

  • Make sure any point_expiration_date is a future date in YYYY-MM-DD format. Rows with a date in the past can be rejected.

  • Not sure about the format? Download the sample file (issue_loyalty.csv) from inside the importer and fill it in.

Step-by-step instructions

Step 1: Open Bulk Issue loyalty

In the left menu, go to Loyalty Points > All Loyalty Points, then click + Bulk Issue loyalty at the top of the list.

Loyalty Points list with the Bulk Issue loyalty button highlighted

Step 2: Choose the CSV option and add notes

On the Bulk Issue Loyalty page, select CSV (Upload CSV with card information and points). You can click Download Sample CSV to get the template.

Optionally fill in:

  • Customer Note: shown to the customer, so keep it clear and friendly (for example, "Thanks for shopping with us").

  • Note: for internal use only, never shown to the customer.

Click Next.

Bulk Issue Loyalty page with the CSV option and Next button highlighted

Step 3: Upload your file

Click Upload CSV. In the Issue Loyalty Points window, drag your file onto the upload area or click it to browse. Excel and CSV files are accepted. You can also click Or click here to copy paste table data to paste rows directly.

Upload CSV button

Issue Loyalty Points upload window

Step 4: Select the header row

The importer previews your file. Select the row that contains your column names (usually row 1) and click Next. If your file has no header row, tick No headers in the sheet. If the data looks off, Transform with AI can clean it up for you.

Select Header Row screen with 10 sample rows and row 1 selected as the header

Step 5: Map your columns

Match each Template Field to a column in your file. Matching column names are mapped automatically. Points is required (marked with a red asterisk). Use Bulk Actions to change several mappings at once, then click Next.

Map Columns screen with the required Points field highlighted

Step 6: Verify your data and submit

Review every row in the Verify Data table. The Invalid tab at the top shows how many rows have problems, so make sure it reads 0. You can edit cells directly, use Find and Replace, add a row with Add, or remove one with X. When everything looks right, click Submit.

Verify Data screen with 10 sample rows, 0 invalid rows and the Submit button

Successful outcome

After you click Submit, the importer shows Processing Data with a progress bar. Keep the browser window open until it finishes.

Processing Data progress screen

When processing completes, the points are added to each customer in your file. To confirm, go back to Loyalty Points > All Loyalty Points: each customer's Balance includes the new points, and the Last transaction column shows the latest activity with its date in Created at.

Tips and FAQs

Can I issue points without a CSV?

Yes. Choose Manual in Step 2 and enter card numbers, customer IDs, customer emails or customer phone numbers (comma-separated), plus the points and an optional expiry date.

Which time zone is used for expiry dates?

The time zone shown next to Point Expiry on the Manual screen (for example, Asia/Calcutta). Set your expiry dates with that in mind.

How do I avoid rejected rows?

Check that every row has a points value, a valid customer identifier and, if used, a future expiration date. Fix anything flagged under the Invalid tab before you submit.

Can I go back and change something?

Yes. Use Prev on any importer screen to return to the previous step without losing your file.

Did this answer your question?