Overview
The Gift Card Import tool lets you create many gift cards at once from a spreadsheet instead of entering them one at a time. It's most useful when you're moving to Singenuity from another system and need to carry over customers' existing gift card balances, or when you need to issue a large batch of cards in one go.
Each row in your file becomes one fully-paid, immediately redeemable gift card — exactly as if it had been sold and paid for in full. For how gift cards work in general, including settings and redemption, see the Gift Cards article.
Before You Start
You'll need a CSV file — a plain spreadsheet saved in "comma-separated" format. Both Excel and Google Sheets can save to this format. The easiest way to build one correctly is to download the template from the import page itself, which already has the right column headers set up:
Navigate to manage.singenuity.com and go to Import → Gift Cards.
Click the Template button to download a blank CSV with the correct headers.
Open it in Excel or Google Sheets and fill in your data.
Save or export it as a CSV.
Building Your CSV File
Each row is one gift card.
Required columns
Column | What to put here |
Code | The gift card's unique code — what the customer enters or scans to redeem it. Every code must be different; no duplicates. |
Balance | The dollar amount on the card. 25 or $25.00 both work. |
Optional columns
Column | What to put here |
Recipient Name | Name of the person the gift card is for, if known. |
Recipient Email | The recipient's email address, if you want the system to be able to notify them. |
Example
Code | Balance | Recipient Name | Recipient Email |
GIFT-1001 | $50.00 | Jane Smith | |
GIFT-1002 | 25.00 | ||
GIFT-1003 | $100 | John Doe |
Dollar signs and commas in the Balance column (for example $1,000.00) are fine — they're stripped out automatically.
Recipient Name and Recipient Email can be left blank.
Don't rename, remove, or reorder the header row.
The Two Import Options
The import page has two toggles that control how your file is processed:
Import zero-balance gift cards: When off (the default), rows with a $0.00 balance are skipped and no card is created. When on, $0.00 rows are imported like any other card, just starting at a $0 balance.
Send email to recipients: When off (the default), no email is sent even if a row has a Recipient Email. The card is still created and fully usable — the recipient just isn't notified. When on, every row with a Recipient Email triggers a notification email.
Tip: Leave Send email to recipients off for large migration batches so you don't send a flood of unexpected emails to customers who already have their cards.
Running the Import
Set the two toggles to match what you want.
Choose your prepared CSV file.
Click Import.
A progress bar tracks the import row by row.
When finished, a summary banner shows how many rows succeeded, were skipped, and had errors.
How Your Data Gets Imported
For each row, in plain terms:
The system checks that the code doesn't already exist and that the balance is a valid dollar amount.
If it checks out, a brand-new gift card is created with that code and balance — immediately active and redeemable, exactly as if it had been sold and paid for in full.
Recipient Name and Recipient Email, if provided, are attached to the card for later lookup.
If Send email to recipients is on and the row has a Recipient Email, a notification goes out.
If the balance is $0.00 and Import zero-balance gift cards is off, the row is skipped entirely.
If the code already exists — in the system, or repeated in your own file — the row is rejected. Nothing is overwritten or duplicated.
Note: One row in, one fully-paid, ready-to-use gift card out — unless it's a duplicate or a skipped zero-balance row.
Understanding Errors
Message | What it means |
"Gift card code is required." | The Code column was blank. |
"Gift card balance is required." | The Balance column was blank. |
"Invalid balance value..." | The Balance isn't a number the system can read. |
"Duplicate gift card code ... found in file" | The same code appears twice in your spreadsheet. |
"Gift card code ... already exists." | That code was already imported previously. |
"...was skipped because the order processing queue did not clear..." | The system was too busy to process that one card. Nothing is wrong with the row — just re-import it. |
A row with an error is not imported, but it doesn't affect any other valid rows in your file. Correct the flagged rows and import just those rows again.
Common Use Cases
Migrating from another system: Export your outstanding gift card codes and balances from your previous platform, paste them into the template, and import with Send email to recipients off so existing cardholders aren't re-notified.
Issuing a batch of cards: Create a set of codes with the same or varying balances — for a corporate order, a fundraiser, or a promotion — and import them all at once. Turn Send email to recipients on if you want each recipient notified automatically.
Conclusion
The Gift Card Import tool turns a spreadsheet into ready-to-use gift cards in a single step, with built-in protection against duplicates and clear error reporting for anything that needs a second look. For details on gift card settings, denominations, and how customers redeem them, see the Gift Cards article.