- 05 Apr 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Batch Update or Change Gift Cards
- Updated on 05 Apr 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
In the Gift Cards Actions menu of the Gift Cards page, a new batch feature can be used to alter any currently existing Gift Cards in the system.
Here you can learn how to use this new feature and interact with Gift Card in your Store.
How To Use Batch Gift Card Updater
1. In the Admin Panel, navigate to Store> Gift Cards > Batch Update Gift Cards.
2. Click Batch Update Gift Cards.
3. Select "Download Gift Card Sample File."
4. Open the file in Excel
Working with the Excel File
*Important* when working with import files, DO NOT alter the first row.
The Excel file is six columns of data. Each column can be interacted with and has different requirements:
Column A - Title: This Column is not required; adding data in this column will over write data during the upload.
Column B - Code: This Column is *Required; you will need to put the Gift Card Code that you are altering in these fields
Column C - Amount: This Column is not required; if left blank, no value changes will be made to the listed gift cards.
Column D - Active: This Column is *Required; you must have either a 1 or a 0, 1 = Active where 0 = inactive. In this way, you can make a batch of codes inactive.
Column E - Expire: This Column is not required; if you choose to change or add an expiry date to the Gift Cards, you can do so here.
Column F - Notes: This Column is not required; adding notes is highly recommended; notes added here will be visible within the individual cards and via the Gift Cards Report.
After updating the report, do not change the file type when saving, and do not update it. Save As somewhere that you can easily find it.