View Categories

2.10.3 How to import PIN gift cards

2 min read

Purpose: Import gift cards that have a PIN (card numbers and PINs) in bulk. Only imported cards can be sold at the POS and used in store and online. For: owners, managers (needs the Gift Card Import permission).

Before you start: Ordinary gift cards (no PIN) don’t need importing; staff just enter the card number when selling (see 1.11.1 How to sell a gift card). PIN cards must be imported first (official release notes, 2026-01-09). PIN gift cards are imported by the merchant; the account doing it needs the Gift Card Import permission.

Steps #

1. In the Backoffice left menu click Gift Card > Gift Card Records, then click ① Import at the top right.

2.10.3 How to import PIN gift cards – 2103-1

2. The Import window opens. First click ③ Download Template to download the import template.

2.10.3 How to import PIN gift cards – 2103-2

3. Fill in one row per card. The import template (GiftCards_Import_Template.xlsx) columns are:

  • msrcard: the card number, digits only.

  • pincode: the PIN, digits only, at least 4 digits.

  • amount: the amount (0 in the example).

  • holder: the cardholder (Template in the example).

  • expiredDate: the expiry date as YYYY-MM-DD, or empty.

  • salesStatus: 0 = available for sale, 1 = sold.

  • status: -1 = inactive, 0 = available, 1 = frozen.

Figure: the PIN gift card import template format (official release notes image)

2.10.3 How to import PIN gift cards – 2103-3

4. Back in the Import window, click upload area ② (Click icon to select a file.) and choose the completed file. Cancel closes the window.

2.10.3 How to import PIN gift cards – 2103-i2

On success, ⑤ Success appears.

2.10.3 How to import PIN gift cards – 2103-i3

⑥ The imported cards show in Gift Card Records (often Unsold with balance $0.00 until sold).

2.10.3 How to import PIN gift cards – 2103-i4

5. After importing, check the cards under Gift Card Records (see 2.10.2 How to view, export and freeze gift card records), then sell them at the POS as in 1.11.4 How to sell a PIN gift card.

Notes / FAQ #

  • Set amount to 0 (value is added when the card is sold), and set salesStatus to 0 (available) for cards to be sold at the POS. Duplicate card numbers are rejected and can’t be imported twice.

  • Keep the file with the PINs safe and don’t forward it after importing.

  • For paying with a PIN card, see 1.3.3 How to pay with a gift card.

Updated on October 7, 2026

What are your Feelings

  • Happy
  • Normal
  • Sad
Scroll to Top