Issue vouchers to a customer list from CSV or Excel
Give each person on a list their own voucher: upload a CSV or Excel file, map the columns, and download each recipient's code, QR link and wallet link.
For: AdminsPrepare your file
- A
.csvfile (comma or semicolon separated) or an Excel.xlsxfile. For Excel, the first sheet is used. Save older.xlsfiles as.xlsxfirst. - The first row is the header with column names.
- One row per recipient, with an identifier (for example a customer or employee number), and optionally email, phone, first name and surname.
- Up to 500,000 rows.
Phone numbers start with the country code instead of 0, for example 27821234567 or +27 82 123 4567. Spaces, dashes, dots and brackets are fine. Email addresses must be complete (name@example.com); they are stored in lower case. Identifiers are at most 128 characters.
Phone numbers, email addresses or identifiers that don't fit are refused before upload, with the line numbers to fix.
Issue the vouchers
- Open the campaign, then Codes, and go to Issue vouchers from a file. Or click Import CSV on the Vouchers page and pick the Campaign.
- Under CSV or Excel file, click the box to choose your file, or drag it onto the box.
- Map the columns: Identifier column is required; email, phone, name and surname are optional. Check the preview of the first rows.
- Click Issue … vouchers.
The import runs on VoucherVerse's servers. You can close the page: it keeps going and stays under Recent imports for 7 days.
How customers are matched
- Each row is matched to an existing customer by email, then phone, then identifier. Otherwise a new customer is created.
- The name and surname name a new customer, or one without a name. An existing customer is never renamed.
- Each row with an identifier, email or phone gets an Allocated code for that customer.
Download the results
When it finishes, click Download results (or Results under Recent imports). The results file has one row per line of your file:
| Column | Contains |
|---|---|
row, identifier, name, email, phone | From your file. |
code | The voucher code issued. |
qr_url | Link to the code's QR image. |
wallet_url | Link that adds the voucher to Apple Wallet or Google Wallet (empty when wallet passes are off). |
error | Why the row failed, if it did. |
Send the codes and links to your customers with your own email, SMS or WhatsApp tools. If a very large import leaves some qr_url cells empty, export the campaign's codes with QR links to get them.