You can migrate your existing (pre-Wrapped) gift cards to Wrapped free of charge during your trial period, allowing them to sync with your Lightspeed Golf sales channels and be managed seamlessly through Wrapped going forward.
Before Proceeding:
Do not complete an import of your existing gift cards until Lightspeed Retail and Restaurant are connected and turned on. You should run a test to confirm gift cards are syncing correctly.
How to import existing gift cards
Export the gift card data as an Excel sheet from your current provider and clean the data using the following upload template as a guide.
Wrapped can import a maximum of 10,000 entries in a single upload.
Ensure your information matches the columns below. (You do not need to include all columns, only those relevant to your import)
Column | Description |
Code | The unique gift card code. If this is blank, a unique gift card code will be generated by Wrapped on upload. |
Balance* | Current gift card balance. This is required. Only gift cards with a balance greater than zero will be synced to your connected sales channels. |
ExpiresAt | Expiry date of gift card. This is optional. Must be in format yyyy-MM-dd. |
RecipientName | Name of gift card recipient/customer. This is optional. |
RecipientEmail | Email address of gift card recipient/customer. This is optional. |
InitialAmount* | Initial amount of gift card. This is required. This should be equal or greater to the balance amount. |
IssuedDate | Date gift card was issued. This is optional. If it is not set, Wrapped will use the uploaded date. Must be in format yyyy-MM-dd. |
AlternateLookupCode | This is optional. This can be used by Wrapped in our balance checker or POS web extensions to find a gift card. The value should be unique. |
Note | An optional note. Use this to pull through any additional information you might want to store about a gift card. |
Here is an example upload using the template:
2. Login to the Wrapped dashboard and navigate to Gift cards > Batches.
3. Select Bulk create or import gift cards.
4. Give your import a title and select Upload CSV.
5. The Batch Import wizard will guide you through validating your upload before the import is completed. If any issues are detected, the wizard will display clear error messages highlighting the affected rows and the reason for each error.
Note: Be sure to check your spreadsheet for hidden commas, special characters, or unsupported symbols, as these can cause the import to fail and should be removed before uploading.
6. Click Submit.
7. Create Batch and wait for the import to process. Depending on the amount of gift cards in the import, the processing time may take minutes to several hours to complete.
Following your import, we recommend you spot check a few gift cards from the batch by clicking on the unique code to view the individual gift card timeline. You should see a record that the existing card is now created in all your connected Lightspeed channels.
For help with your import, please email support@wrappedgiftcards.com and provide your Wrapped Account Name and Excel file.