Importing gift vouchers from another system
If you’re moving to Nabooki from another booking or sales platform, you can import the gift vouchers you’ve already sold. Your customers can then redeem them using the codes they already have, just like vouchers issued in Nabooki.
This article explains how to prepare your file, upload it, and fix any rows that don’t import.
Before you start
- Only users with the Manager role can import gift vouchers.
- Gift vouchers must be enabled on your account. See Using gift vouchers.
- Export your vouchers from your previous system so you have the codes, remaining balances, expiry dates and purchaser details ready.
Download the template
- Go to Sales > Gift Vouchers.
- Click the arrow next to + Add new, then select Import gift vouchers.
- Click Download template to save the CSV file to your computer.
Fill in the template
Open the template in a spreadsheet program such as Excel or Google Sheets and copy your voucher details into it. Add one voucher per row.
⚠️ Warning: Don’t change or delete the column headings, or the file won’t import correctly.
| Column | Required? | Format and rules |
|---|---|---|
| Voucher code | Required | The code your customer already has. 3 to 64 characters, and each code must be unique. |
| Remaining balance | Required | The amount left on the voucher, as a number without a $ sign, with up to 2 decimal places. For example, 60 or 60.50. Must be greater than 0 and no more than 999999.99. |
| Expiry date | Required | dd/mm/yyyy format, for example 30/06/2029. Must be today or later. |
| Purchaser First Name | Required | |
| Purchaser Last Name | Required | |
| Purchaser mobile | Required | Up to 15 characters. |
| Purchaser email | Required | Must be a valid email address. |
| Sender name | Required | |
| Recipient name | Optional | Leave blank if you don’t have it. |
| Message | Optional | Up to 500 characters. Leave blank if you don’t have one. |
💡 Tip: If a customer has already used part of their voucher, enter only the amount that’s left in Remaining balance, not the original value.
File limits
- Your file must be a CSV (ending in .csv).
- You can upload up to 2,000 vouchers at a time, in a file no bigger than 1 MB. If you have more, split them across several files.
Upload your file
- On the Import Gift Vouchers page, click + Upload.
- Select your completed CSV file.
- Nabooki imports all valid rows and shows a summary of how many vouchers were imported and how many rows were skipped.
Fix skipped rows
If any rows couldn’t be imported, they’re listed below the summary with the line number and the reason. The line number matches the row number in your spreadsheet, where line 1 is the column headings.
To fix them:
- Correct the listed rows in your spreadsheet.
- Delete the rows that were already imported, so only the corrected rows remain.
- Upload the file again.
Existing vouchers are never overwritten or duplicated, so a row whose code already exists in your account will be skipped rather than imported twice.
After you import
- Imported vouchers appear under Sales > Gift Vouchers alongside vouchers sold online and created manually. They’re marked with a purple icon, labelled Imported when you hover over it.
- Customers aren’t emailed when you import vouchers, since they already have their codes. If a customer needs their voucher sent again, click ⋯ next to the voucher and select Resend.
- Imported vouchers work the same as any other voucher. Customers redeem them by entering the code at checkout, and you can view, resend or edit the expiry date in the same way.
Troubleshooting & FAQs
Need Help?
If you need assistance, contact our support team:
💬 Live Chat: Click the chat icon in the bottom-right corner of the screen.
📧 Email: support@nabooki.com