How to Export Shopify Gift Card Codes (and Why You Should)

Exporting Shopify gift card codes requires a third-party app because Shopify's admin only shows the last four digits after creation. A tool like BatchCard captures full codes at creation time and lets you export them as CSV with values, balances, statuses, and recipient data for accounting, distribution, or backup.

Without an export option, merchants managing more than a handful of gift cards hit a wall. There's no "Export All" button in Shopify, no bulk download, and no way to pull a spreadsheet of active codes. Here's why exporting matters and how to build it into your workflow.

Why You Should Export Your Gift Card Codes

Accounting and Financial Reporting

Gift cards create a financial liability on your balance sheet. Every unredeemed gift card represents money you owe. Your finance team needs to know:

• How many gift cards are outstanding
• The total value of unredeemed cards
• Which cards have been partially redeemed and their remaining balances

Without an export, gathering this data means clicking through gift cards one by one in the Shopify admin. With an export, your team has a spreadsheet they can sort, filter, and analyze in seconds.

Distribution Workflows

If you create gift cards for a promotion or employee program, you need the full codes to distribute them. An export gives you a file you can use to:

• Feed codes into an email marketing platform (Mailchimp, Klaviyo, etc.)
• Print physical gift cards with unique codes
• Import codes into an HR system for employee rewards
• Share codes with a fulfillment partner for physical card orders

Backup and Disaster Recovery

Shopify hides the full gift card code after creation. If your only copy of the codes is in a third-party app and something goes wrong with that app, you've lost access to potentially thousands of dollars in gift card data.

A regularly exported CSV file stored in secure, backed-up storage protects you against app issues, account problems, or data loss.

Compliance and Audit Trails

Depending on your industry and location, you may need to maintain records of gift card issuance for regulatory compliance. Gift card laws vary by region, but many require businesses to maintain records of outstanding balances for several years. An export provides the documentation you need.

What Data Is Included

A typical gift card export includes:

The exact fields depend on your export tool. Some include additional data like redemption history, delivery status, and custom tags.

How to Use Exported Data

In Excel or Google Sheets

Open your CSV file in your spreadsheet app of choice. From there, you can:

• Filter by status to see only active cards
• Sort by balance to find partially redeemed cards
• Sum values for financial reporting (total liability, total redeemed, total remaining)
• Search by code to look up specific gift cards
• Pivot table by batch or category for campaign analysis

For Bulk Email Distribution

If you need to send gift card codes through your email marketing platform:

1. Export your codes to CSV
2. Match each code to a recipient email address (your export may already include this if you used email delivery)
3. Import the file into your email tool
4. Use merge fields to insert each recipient's unique code into the email template

For Financial Reconciliation

At the end of each month or quarter, export all gift cards and calculate:

• Total issued value: Sum of all initial values
• Total redeemed: Sum of (initial value - current balance) for partially or fully redeemed cards
• Outstanding liability: Sum of all current balances for active cards
• Breakage estimate: Cards with no redemption activity beyond a certain age

This gives your finance team what they need without manually auditing Shopify's admin.

For Record Keeping

Store exports with a consistent naming convention:

gift-cards-export-2025-03-15.csv
gift-cards-export-2025-04-15.csv

Keep at least 12 months of exports. Some businesses retain gift card records for the full statutory period (often 3-7 years depending on jurisdiction). Check with your accountant about your specific requirements.

Export Best Practices

Export Immediately After Creation

Don't wait. As soon as you create a batch of gift cards, export the codes. This ensures you have a record of the full codes before anything can go wrong.

Store Securely

Gift card codes are cash equivalents. An export file containing $50,000 in gift card codes should be stored with the same care as a file containing $50,000 in wire transfer details.

• Use encrypted storage
• Limit file access to authorized personnel
• Don't email exports in plain text
• Don't store them in publicly accessible folders

Export Regularly for Financial Reporting

Even after the initial export, run periodic exports (monthly is common) to capture current balances and redemption status. This keeps your financial data current without requiring manual spot-checks.

Keep Historical Records

Don't overwrite old exports with new ones. Maintain a history so you can track how balances changed over time. This is valuable for financial auditing and for understanding gift card usage patterns.

Getting Started with Exports

Export features vary significantly between apps. See how BatchCard stacks up against Gift Card Hero for CSV export and code access. BatchCard's CSV import/export feature lets you export any batch or your full gift card inventory to CSV with one click. Each export includes the complete codes, values, balances, and metadata. For step-by-step instructions, see the exporting codes guide.

For instructions on preparing files for import, see our guide on importing from spreadsheets. For organizing your codes effectively before and after export, check out our code management best practices. If you're managing exports for employee rewards or corporate gifting, see those use case pages for workflow-specific tips.