Quick links
What you can do on this page
Download a sample CSV, confirm the column format, then follow the four‑step import. Troubleshooting and FAQ are at the bottom.
Use it as a template or to validate your own file.
Prerequisites
- Staff account with permission to create gift cards in Shopify.
- Clean CSV encoded as UTF‑8. Dates in YYYY‑MM‑DD.
- Currencies as ISO codes (USD, EUR, GBP...).
CSV format
Required fields are code, initial_balance, and currency. Optional fields help with reporting and expiration.
| Column | Required | Example | Notes |
|---|---|---|---|
| code | Yes | GC-9F3K-2L8A | Unique per row |
| initial_balance | Yes | 100 | Number (no currency symbol) |
| currency | Yes | USD | ISO code |
| expires_on | Optional | 2026-12-31 | YYYY‑MM‑DD |
| note | Optional | Migrated from POS | Free text |
| customer_email | Optional | jane@doe.com | Sends to customer if provided |
| status | Optional | active | active or disabled |
code,initial_balance,currency,expires_on,note,customer_email,status
GC-9F3K-2L8A,100,USD,2026-12-31,Migrated from POS,jane.doe@example.com,active
GC-7J2M-5Q1B,50.5,USD,,,active
GC-ABCD-1234,200,EUR,2025-06-30,VIP compensation,,activeStep‑by‑step import
Bring data from any POS or platform.
Adjust mappings without re‑uploading.
Duplicates, formats, and balance checks flagged in real time.
Progress view and exportable logs for auditing.
3‑minute video tutorial
A quick overview of the import flow, validation, and logs.
Troubleshooting
“CSV failed to upload”
- Ensure the file is CSV (UTF‑8). Avoid XLS/XLSX.
- Remove empty header rows. Keep one header line only.
- Try smaller batches (10–25k rows) if over 20 MB.
“Duplicate codes detected”
The validator found repeated values in the code column. Deduplicate in your sheet or allow the tool to auto-skip duplicates during import.
“Wrong currency/format”
Use ISO codes (USD, EUR, GBP). Balances should be numbers only and dates must be YYYY‑MM‑DD.
Frequently asked questions
Which CSV formats do you support?
Any CSV with the columns shown above. You can change mappings during upload if your header names differ.
Can I prevent duplicates or wrong balances?
Yes. Real‑time validation flags duplicates, formatting issues, and mismatches before import. You can also export an error report.
Will customers get notified automatically?
If you include customer_email, Shopify can email the gift card. Otherwise, cards are created without sending a notification.