Importing gift cards from another provider/spreadsheet
If you're coming from another provider or have a spreadsheet already that you manage existing gift cards from, we have an import process behind the scenes that accepts a Comma Separated Values (CSV) file.
Please provide us with the following required fields in your CSV file:
Balance- The outstanding currency balance on the gift card, e.g. 49.99
You can also specify the following values, if required/known (leave any columns blank if not required or known):
Code- The gift card code issued, if nothing is specified, we'll generate a random code e.g. "ABC123"
Initial Balance- The initial gift card currency balance on the gift card, e.g. 75.49
Price- The price charged to the purchaser for this gift card, e.g. 100.00
Item Name- The gift card name e.g. "$50 Gift Card"
Description- The description on the gift card, appears underneath the item name e.g. "For use at Juicy Joe's"
Terms- The terms applied to the gift card, we'll use your default gift card terms if nothing specified
Message- The message left to the recipient
Tip- The value of the tip received e.g. 0
Issued On- The date the gift card was issued on, we'll use the current date/time if nothing specified e.g. "2018-10-21"
Expires On- The expiry date of the gift card, leave blank for account default expiry policy. e.g. "2020-10-20" for 20th October
Valid From- The valid from date of the gift card, leave blank for account default valid from policy. e.g. "2020-10-20" for 20th October
Take special care around dates & numbers
For dates, we require a format like this: YYYY-MM-DD, i.e. 2018-10-21 is the 21st August 2018 and likewise 2018-10-09 is the 9th August (and not the 10th September!).
Unit vs. currency-backed gift cards
Initial Unit Balanceinstead
Sending your file to us
Once you've filled in the CSV file with your data, please send it to us at firstname.lastname@example.org where we will review your import file and create a single test gift card for you in your account for you to review. We'll also ask you if you want us to send the gift cards to the recipient by email or not.
After you've reviewed the test gift card and accepted it as correct, we will then import all the gift cards in your CSV file into your account.