Import from file

📂 Use csv source file to import gift cards.

The Import from File feature allows you to create gift cards in bulk by uploading a CSV file. You can define values, codes, expiration dates, and recipient details directly in the file. Optionally, gift cards can be sent to recipients automatically after import. Perfect for migrating existing gift cards or handling large batch creations efficiently.

💡 Common Use Cases

• Migrating Gift Cards from Another Platform: Easily import existing gift cards when moving from another e-commerce or POS system into Shopify.

• Corporate or Bulk Orders: Create and assign large numbers of gift cards for corporate clients, employee rewards, or event giveaways using a CSV file.

• Physical Gift Card Fulfillment: Upload pre-generated codes to be printed on physical gift cards (e.g., for in-store use or retail distribution).

• Manual Issuance from External Systems: If gift card orders are collected through spreadsheets, forms, or external systems (e.g., Typeform, Airtable), you can import them in bulk without manual entry.

Step by step instructions

1. Download ready to populate template CSV files. Start by downloading a CSV template to structure your gift card data correctly. Below are simple and extended versions of CSV source files.

You can remove any column you don't need. The only required column is: initial_value

142B

gift_card_template.csv

57B

gift_card_template__simple.csv

Optionally you can open and copy our Google Sheet templates:

• Simple

• Extended

1. Fill out the csv file

   Populate the file with your gift card data. The following columns are supported:

   • initial_value (Required) – The value of the gift card in your store’s main currency. Use dots to separate decimal places. Do not use commas anywhere in this value.

   • email (Optional) – The recipient’s email address. If left blank, the gift card will not be sent.

   • code (Optional) – The gift card code. Must be unique and not already used in your store. If left blank, a code will be autogenerated.

   • expires_on (Optional) – The expiration date of the gift card. If left blank, the card will not expire. Supported formats are: YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY, DD-MM-YYYY, or MM-DD-YYYY

   • note (Optional) – An internal note, not visible to the customer. Maximum of 255 characters are allowed.

   • message (Optional) – A message that will be included in the gift card email. Maximum of 255 characters are allowed.

2. Upload the file in app dashboard. Only one file can be uploaded at a time. After uploading, optional configuration settings may appear. A summary will show the number of detected rows and column names—please review and confirm that everything looks correct.

3. (Optional) Configure Additional Options

   

• Choose what happens if a customer is not found in your store (e.g., create or skip).

• Decide which field to assign as the recipient (only available if the email column is present).

• Select whether or not to send the gift card after creation.

• Pick one of four available sending options Read more about sending here.