What to Do with Gift Card Data When Migrating from NCR Retail Online

The discontinuation of NCR Retail Online makes gift card records one of the most sensitive parts of an ecommerce migration. Product listings and customer accounts can usually be rebuilt from standard exports, but a gift card represents stored value, a customer promise and a potential liability. Losing its balance or redemption history can create disputes at the register, online checkout and customer service desk.

Australian retailers moving to Magento, WooCommerce or another platform through an NCR Counterpoint partner should treat gift cards as a financial data migration rather than a simple database transfer. The work involves identifying every active card, protecting card credentials, preserving expiry information, mapping redemption rules and proving that the opening liability on the new system matches the old records.

Find Every Gift Card Record

Start by locating all sources of gift card information. NCR Retail Online may contain digital card numbers, while NCR Counterpoint, a point-of-sale database, spreadsheets, payment reports or an external gift card provider may hold balances and transaction histories. Store-issued plastic cards, email vouchers, promotional credits and manually adjusted balances should be included in the inventory.

Create a record for each active instrument with a stable internal identifier. Useful fields include the card number or token, remaining balance, original value, issue date, expiry date, currency, status, customer reference, sales channel and last activity date. Keep cancelled, fully redeemed and expired records in a separate historical dataset so that customer service staff can investigate older transactions without making those cards usable again.

Do not assume that a successful export means the records are complete. Compare the number of gift cards and total outstanding value against sales reports, general-ledger figures and recent redemption activity. A retailer with stores in Sydney and Melbourne may have several years of point-of-sale data, while online records cover only cards created through the website. Differences should be documented and resolved before the import.

Protect Sensitive Card Information

Gift card numbers and PINs require careful handling, even when they are not payment cards in the traditional sense. Export files should be encrypted, access should be restricted to the migration team, and temporary copies should have a defined deletion date. Never send unprotected card data through ordinary email or leave it in a shared download folder after testing.

Ask the implementation partner how the replacement platform stores card numbers, PINs, tokens and balances. A secure design may retain only a token in the ecommerce application while the authoritative balance remains in a controlled gift card or point-of-sale service. If full card numbers must be transferred, confirm encryption at rest, access logging, administrator permissions and backup retention.

Australian businesses should also consider the Privacy Act and the Australian Privacy Principles when customer-linked gift card records are moved between systems or suppliers. Remove information that the new platform does not need, such as an old delivery address attached to a card-only purchase. PCI DSS obligations may apply where gift card workflows touch payment systems, so the payment gateway, POS provider and migration partner should each define their responsibilities in writing.

Map Balances, Rules And Expiry

Before importing data, write down how the old system calculates a balance and how the new system will reproduce it. Include partial redemptions, refunds, cancelled orders, abandoned checkouts, split payments, store-only cards, online-only vouchers and manual adjustments. A card worth $100 with a $35 redemption should arrive with $65 available, not with its original face value.

Australian gift card requirements deserve special attention. Gift cards sold to consumers generally need at least a three-year expiry period under Australian Consumer Law, subject to specific exceptions and the terms that applied when the card was issued. A migration must not silently shorten a valid period. Display the expiry date consistently in the customer account, email, checkout and staff tools, and obtain legal advice for unusual promotional or business-to-business vouchers.

Test edge cases using realistic Australian transactions. A customer may buy online in AUD, collect in Brisbane, return an item in Adelaide and ask for the value to be restored to the original gift card. Test GST-inclusive pricing, refunds, order cancellations, split tenders and store transfers. If the business promotes giftable merchandise, product pages such as gift ideas for him can also be used to test the path from online purchase to gift-card redemption.

Reconcile And Test Before Launch

Run a trial migration with masked or controlled data before moving live balances. Select samples by age, value, status, sales channel and store. Staff should verify that a card can be checked, partially redeemed, fully redeemed, refunded where permitted and blocked when its status is cancelled. Test both the new website and the Counterpoint-connected register if customers can use the same card in-store and online.

Reconciliation should happen at several levels. Compare the count of active cards, total unspent value, number of expired cards and daily redemption totals between the old and new environments. Investigate every variance rather than applying a blanket adjustment. A small difference may indicate a timing issue, but a large difference can signal duplicate imports, missed cards or an incorrect currency or tax setting.

A phased rollout reduces the risk of taking every channel offline at once. The migration team can use a phased rollout plan to move a limited product range, store group or customer segment first, then compare live results before expanding. Freeze or tightly control gift card changes during the final cutover window, record transactions created after the export and apply them through a documented delta process.

Checks To Complete Before Cutover

• Confirm that each active card has one authoritative balance and status.
• Reconcile the total outstanding liability with accounting and point-of-sale reports.
• Verify that expiry dates and Australian consumer terms remain unchanged.
• Test online, in-store, partial, refund and cancelled-order scenarios.
• Record who can approve manual balance changes and review the audit log.

Communicate The Change Clearly

Customers should not have to explain the migration to staff when they try to redeem a valid card. Publish a short notice explaining that existing cards remain usable, where customers can check their balance and what to do if a number or PIN fails. Keep the wording consistent across the website, receipts, automated emails and store signage.

Customer service and store teams need a practical script and a reliable lookup process. Train them to distinguish between an invalid card, a card with a zero balance, an expired card, a card blocked for suspected misuse and a temporary system error. They should never request a PIN in a public support channel or write sensitive details into an unsecured ticket.

Review every customer-facing selling and redemption journey after launch. For example, a sports retailer should verify that a gift card works against ordinary merchandise and specialist ranges such as men's sportswear, including discounts, delivery charges and returns. The same check applies during high-volume events such as Click Frenzy, Christmas trading and end-of-financial-year promotions, when redemption volume and support requests can rise sharply.

Keep the old gift card data in a restricted, read-only archive for an agreed period. It can support dispute resolution, financial audits and proof of historical transactions, but it should not remain an unofficial second source of truth. After the retention period, securely delete unnecessary exports and document the disposal.

A successful migration leaves customers with uninterrupted access to stored value and gives the retailer a defensible record of every balance movement. The practical standard is simple: reconcile the liability, protect the credentials, preserve lawful expiry terms and test the exact journeys customers will use across the website and Australian stores.