Migration guide

Physical POS gift cards → import into Shopify

Sync gift cards sold in-store with values set at your POS and import them into Shopify for unified online + offline redemption.

10,000
Rows per import file
0
Codes changed - originals kept
Every row
Validated before anything is written

Overview

Many brick-and-mortar retailers issue physical gift cards via POS. This guide shows how to bring those cards into Shopify so customers can redeem them online too.


The challenge retailers face

  • POS can instantly assign value to pre-numbered plastic cards.
  • In native Shopify, a Gift Card requires manual value assignment later.
  • This creates room for error during busy hours and complicates reconciliation.

What's happening in Shopify

You sell a physical item labeled “Gift Card.” The printed number the customer receives has no value until someone assigns it in Products → Gift Cards, which is prone to delays and mistakes.

Solution with BluePeacock Gift Card Importer

  • Keep issuing cards at POS as usual and let POS store the value immediately.
  • Export those cards from POS in CSV (code, balance, created/expiry dates, etc.).
  • Import the CSV into Shopify using the Gift Card Importer.
  • Importer prevents duplicates, so you can safely re-use and append the same CSV as you batch updates.

Recommended flow

  1. Throughout the day: load values on physical cards at POS.
  2. End of day or week: export a CSV from POS.
  3. Upload the CSV to the Gift Card Importer.

Benefits

  • Unified redemption across online and stores.
  • Clear audit trail and easier reconciliation.
  • Less manual work; fewer errors.

Tip: there is no automatic sync. Import newly issued POS cards in a fresh file whenever you need to. Codes already in Shopify are skipped and their balances are not changed.


FAQs

Quick answers to common POS sync questions.

Can I import cards sold at POS into Shopify with balances?

Yes. Export the cards from your POS with their code, balance and expiry date, then map the columns during upload - each card keeps its original code and its exact remaining balance.

What happens if a code is already in my Shopify store?

That row is skipped rather than overwritten, and recorded as skipped in the activity log, so re-running a batch does not create duplicate cards.

Does the importer keep POS and Shopify balances in sync?

No. There is no automatic sync. Each import adds new cards to Shopify. Cards whose code is already in Shopify are skipped, and their balances are not updated. Import newly issued POS cards in a fresh file whenever you need to.