How to fill data in CSV file when doing bulk issue gift card

Our app offers a powerful and convenient way for store owners to issue gift cards in bulk. By using a CSV (Comma-Separated Values) file, you can upload and manage multiple gift cards at once, making the process fast, organized, and efficient. This guide explains the structure of the CSV file, the purpose of each column, and the formatting rules you must follow to ensure a smooth and successful upload.

CSV file structure

The CSV file used for bulk gift card issuance contains seven required columns. Each row represents one gift card, and all information must be entered in the correct order.

1. Sender Name
This column contains the name of the person sending the gift card. Enter the sender’s name for each gift card exactly as you would like it to appear to the recipient.

2. Recipient Name
In this column, enter the full name of the gift card recipient. Make sure the name is accurate and corresponds to the correct recipient.

3. Recipient Email
This column requires the recipient’s email address. Gift cards are delivered to this email, so it is important to double-check that all email addresses are entered correctly.

4. Gift Card Value (Number Only)
Specify the value of the gift card using numbers only. Do not include currency symbols or text. For example, enter 50 for a $50 gift card.

5. Delivery Date (Leave Empty for Send Now)
If you would like the gift card to be delivered on a specific future date, enter that date in this column. If you want the gift card to be sent immediately, leave this field empty.

6. Expire Date (Leave Empty for Never Expire)
Use this column to set an expiration date for the gift card. If the gift card should never expire, simply leave this field empty.

7. Message for the Recipient
This column allows you to add a personalized message that will be sent along with the gift card. You can include a greeting, a short note, or any customized message for the recipient.

Formatting Guidelines

To ensure your CSV file uploads successfully, it’s important to follow these formatting rules carefully. Failure to do so may result in errors during the import process.

• Create the CSV file using a plain text editor or spreadsheet software such as Excel or Google Sheets.

• Do not include column headers or titles in the first row. Begin entering gift card data directly in the first row of the file.

• Avoid extra spaces, special characters, or additional formatting in any cell.

• Save the file strictly in .csv format before uploading it to the app.

Conclusion

By following this comprehensive guide, you can easily leverage our app's bulk gift card issuance feature using a CSV file. Remember to accurately input the data in each column, following the provided descriptions, and adhere to the formatting guidelines to ensure a successful gift card upload process. This efficient method will save you time and effort while allowing you to provide an enhanced gifting experience to your customers.

Should you have any further concerns, please feel free to contact us via email at support@govalos.com