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-DDformat. 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.
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.
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.
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.
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.
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.
Successful outcome
After you click Submit, the importer shows Processing Data with a progress bar. Keep the browser window open until it finishes.
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.
