Shopify Gift Card Importer - Help & Documentation

Prepare your CSV, validate, and import gift cards with confidence. Quick links and a 3-minute video get you moving fast.

Watch 3-min videoOpen the app

Quick links

Start here

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.

01
Download the sample

Use it as a template or to validate your own file.

02
Check required columns

code, initial_balance are required.

See CSV format
03
Import with validation

Auto-map columns and catch duplicates before import.

Open importer
Heads up
Large files are supported. If your CSV exceeds 20 MB, split by 10-25k rows per file for a smoother review cycle.
Before you begin

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...).
Template

CSV format

Required fields are code, initial_balance,. Optional fields help with reporting and expiration.

ColumnRequiredExampleNotes
codeYesGC-9F3K-2L8AUnique per row
initial_balanceYes100Number (no currency symbol)
currencyOptionalUSDISO code
expires_onOptional2026-12-31YYYY-MM-DD
noteOptionalMigrated from POSFree text
customer_emailOptionaljane@doe.comSends to customer if provided
statusOptionalactiveactive or disabled
Sample CSV
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,,active
Workflow

Step-by-step import

Step 1
Upload CSV

Bring data from any POS or platform.

Step 2
Auto‑map fields

Adjust mappings without re-uploading.

Step 3
Validate

Duplicates, formats, and balance checks flagged in real time.

Step 4
Import & track

Progress view and exportable logs for auditing.

Start importingWatch walkthrough
See it in action

3-minute video tutorial

A quick overview of the import flow, validation, and logs.

▶ Play on YouTube
If something breaks

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.

Answers

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.

Need help?

We’re here 24/7

Preferred
Reply to your onboarding email with your CSV attached and we’ll validate it for you. Average response time: under 2 hours.
Self-serve
Contact supportWatch tutorial