Attached to this article is the template for uploading gift cards into talech system.
Explanation of columns:
Card Number (cardNo): Accepts a 16-digit Gift Card number
Balance (balance): The existing balance of the Gift Card. Do not leave cells blank. Enter 0 for a gift card with no existing balance.
Status (cardStatus): accepted values are New, Activated, Deactivated
Type (cardType): Fixed, Hybrid, or Reloadable
Issuance Type (cardIssuanceMode): Standard, Promotional
Card Expiration Date (MM/YY)(cardExpDate): must be formatted in MM/YY. 01/35 will work. 1/35 will fail.
Require PIN (requirePIN): Yes or No
- Card Expiration Date value must be bigger than current month + year
- Balance value with dot (0.25 not 0,25)
- Max 1000 entries per upload, others will be ignored
- Do not format the Card Expiration Date column as a Date. Make sure to format as text.
Glossary of terms:
Fixed: use this for fixed amount gift cards. (like if the customer orders cards that have a dollar value printed on them.) Once all value is depleted, gift card cannot be reloaded or re-used.
Hybrid: use this for combo gift cards+loyalty cards
Reloadable: gift card can be reloaded.
Standard: normal gift card that is purchased at the counter.
Promotional: used for promo gift card, like giveaways, manager comps, etc.