You can bring gift cards you already have, from another gift card provider, an old POS or a spreadsheet, into Wrapped by importing a CSV file. Each row becomes a gift card with its code and balance. Wrapped then creates each card in every connected sales channel, so customers can keep using their cards everywhere. Importing is free during your free trial.
Shopify only shares the last four characters of gift cards created in Shopify, so they can't be exported and imported by CSV. See Bring existing Shopify gift cards into Wrapped.
Before you import
- Connect and turn on every sales channel first. Imported cards are created in the channels connected at the time of the import. A channel you connect later only gets a card when that card next changes or is re-synced.
- Test first. Import two or three cards, check they appear in each sales channel, and then import the rest.
- Check your codes meet every channel's rules, for example 8 to 20 characters for Shopify, or 16 digits for Square. Codes that break a channel's rules show a sync error for that channel. See Gift card code format and each platform's rules.
- Codes should be random, not sequential.
- Keep each file to 10,000 rows or fewer. Split larger lists into several imports.
- Clean the spreadsheet. Hidden commas, special characters and unsupported symbols can make rows fail. Avoid commas in names and notes.
The columns
| Column | Required? | What to put in it |
|---|---|---|
| Balance | Required | The card's current balance, as a number. Must be more than 0. |
| InitialAmount | Required | The card's original value. Must be equal to or more than Balance. |
| Code | Optional | The gift card code. Leave it blank and Wrapped generates one using your code format. |
| ExpiresAt | Optional | Expiry date as yyyy-MM-dd, in your account's time zone. Leave it blank to use your default expiry setting. |
| IssuedDate | Optional | When the card was originally issued, as yyyy-MM-dd. Leave it blank to use the import date. |
| RecipientName | Optional | The card holder's name. |
| RecipientEmail | Optional | The card holder's email address. |
| AlternateLookupCode | Optional | A second value Wrapped accepts for this card, such as what an old card's barcode contains when it isn't the code itself. See Keep using the physical gift cards you already have. |
| Note | Optional | Anything else you want kept on the card, shown in its notes. |
Import the file
- Go to Gift cards › All gift cards › Import / Export › Import from CSV file, or Gift cards › Batches › Create batch and choose Import a CSV file, then click Next.
- Enter a Batch name (required), such as "Cards from old provider". It's how you'll find these cards later.
- Under When a code is already in your account, choose Update the existing card or Skip it (see below).
- Click Upload CSV and choose your file. Match your file's columns to Wrapped's when asked, and fix any rows the importer flags.
- When you see File ready with the number of cards, check the count is right.
- Turn on Promotional if these cards were given away rather than sold.
- Optionally open Advanced settings to change the Reason (default "Imported from batch CSV") or turn on Never send emails for this batch.
- Click Create batch.
You'll see "Batch created. It's being processed — the cards appear as they're made." Only Owners and Admins can import.
While it processes
- The batch appears in Gift cards › Batches with the status Pending, then Processing, then Completed. If the whole file can't be read, it shows Error; click the badge to copy the error.
- Cards appear in All gift cards as they're created. Each card is created in each of your sales channels as it's imported, so a large file can take from a few minutes to several hours.
- When it's finished, use the batch's … menu › Download import report. It lists every row with its outcome (Created, Updated, Reactivated, SkippedDuplicate or Error) and the reason.
- Download original file gives you back the file you uploaded.
Spot-check a few cards afterwards: open each one and look for "Created … gift card in …" in its activity for every sales channel. See Reading a gift card's timeline and adjustments.
Codes that already exist in Wrapped
| Choice | What happens to an existing card with the same code |
|---|---|
| Update the existing card | Its balance is set to the file's Balance (recorded as a CSV import adjustment and synced to your channels). RecipientName, RecipientEmail and Note are updated if filled in. ExpiresAt is applied only if Let your team change a card's expiry is on in Settings › Gift card rules. The card moves into this batch. A deleted card is restored, and an expired card is restored if its expiry date is now in the future. Voided cards aren't restored. |
| Skip it | Nothing changes. The row is reported as skipped. |
What imported cards look like
- Balance is the file's balance, and Total issued starts at that balance. The card's original value is the InitialAmount.
- The issue date is IssuedDate, or the import date if blank.
- The reason is Imported from batch CSV unless you chose another, and you can filter the gift card list by the batch.
- Cards imported with a balance are active straight away and created in your sales channels.
Emails
Wrapped doesn't email customers when their card is imported. A card with a RecipientEmail can get emails later, for example a balance update after they spend on it, or reminder emails if you've turned those on. To stop all emails for the imported cards, turn on Never send emails for this batch before you import.
Common questions
Do imported cards count toward my plan?
Cards imported during your free trial don't count. After the trial, a card imported with a balance is activated in Wrapped when you import it, so it usually counts in that billing period. If you need to migrate a large number of cards after your trial has ended, contact the Wrapped team before you import. See How the monthly gift card allowance works.
Do imported cards sync to my sales channels?
Yes. Each card is created in every connected, enabled sales channel as it's imported. If a channel refuses a card, it shows a sync error. See Fixing gift card sync errors.
How long does an import take?
From a few minutes for a small file to several hours for thousands of cards, because each card is created in each sales channel.
Some rows failed
Download the import report, fix those rows in a new file with only the failed rows, and import it as a new batch. With Update the existing card, re-importing rows that already worked doesn't create duplicates.
Can I import cards with a $0 balance?
Import cards that still have value. A card with no balance isn't created in your sales channels. For unsold printed cards, see Keep using the physical gift cards you already have.
I need help with a migration
Email support@wrappedgiftcards.com with your account name and the spreadsheet. See Getting help from the Wrapped team.