The Gift cards report lists every gift card activated in the date range you choose, one row per card, with its values, current balance, status, where it came from and who it was for. Use it to review sales by channel, location or staff member, check promotional cards, and export your card list. Open it from Reports › Gift cards (open).
Which cards are included
- Cards activated in the date range. The range filters on each card's activation date, not the date the record was created or the date it was last used. Choose All time to see every card.
- Every source: cards bought in a sales channel or your web store, issued in the dashboard, generated in batches, imported, issued by automations, campaigns or giveaways, and refunds to gift card.
- Not cards hidden from reporting. See Hide a gift card from reporting.
- Not deleted gift cards: deleting a card removes it from reporting. See Void or delete a gift card.
- Not cards that haven't been activated yet, because they have no activation date.
Rows are sorted with the most recently created cards first. The data updates about every 2 hours; see How often reports update.
Filter by customer
Type part of an email address into Filter by customer email. The report shows cards where the recipient's email or the buyer's email contains what you typed.
Columns
Dates and times are in your account's time zone. Money columns are in the card's currency (see the Currency column).
| Column | What it shows |
|---|---|
| Giftcardid | Wrapped's internal ID for the card. |
| Giftcard dashboard link | A link that opens the card in the dashboard, with its timeline. |
| Code ending | The last characters of the code, so full codes aren't in the report. |
| Reason type | Why the card was created, such as Purchased, Refund, Compensation, Reward, Employee, Donation, Campaign, API, Import, GeneratedFromBatch, ImportedFromBatchCsv, Automation, KlaviyoFlow or Other. |
| Initial value | The value the card started with. |
| Total issued value | Everything loaded onto the card: the initial value plus top-ups and bonus credit. |
| Current balance | What's left on the card now. |
| Currency | The card's currency, such as USD or AUD. |
| Status | The card's current status. |
| Recipient name | Who the card is for. |
| Recipient email | The recipient's email address. |
| Created at | When the card was created in Wrapped. |
| Activated at | When the card was activated. This is the date the report's range filters on. |
| Expires at | When the card expires. Empty if it doesn't. |
| Batch name | The batch the card belongs to, if any. |
| Sales channel | Where the card was issued, such as Shopify, a Lightspeed POS, your web store or the dashboard. |
| Sales channel id | Which connection it came from: the sales channel's name and ID. Useful when you have more than one store of the same kind. |
| Webstore product | The web store product it was bought as, if any. |
| Site name | The location it was issued at, where the sales channel reports one. |
| Staff name | The staff member who sold or issued it, where the sales channel reports one. |
| Gifted at | When it was sent as a gift, if it was. |
| Gifted from email | The buyer's email address, for cards sent as a gift. |
| Gift message | The message sent with the gift. |
| Is promotional | Yes for promotional cards, such as bonus gift cards from automations. |
| Has sync errors | Yes if the card has a sync error with a sales channel. See Fixing gift card sync errors. |
| Notes | Notes on the card. |
Common questions
Why isn't a card I sold today in the report?
Reports update about every 2 hours. Also check the date range covers the card's activation date, that the customer email filter is empty, and that the card isn't hidden from reporting. See A gift card or change is missing from a report.
How do I see a card's full code?
Open it with the Giftcard dashboard link. The report only shows the ending of the code.
Does the report show what the customer paid?
No. It shows the card's value. What was paid, including any discount, is on the order in your sales channel. See Revenue, voids and discounts in reports.
How do I list only paid cards, not promotional ones?
Export the report and filter on Is promotional and Reason type. See Promotional gift cards and bonus credit in reports.
Why does a voided card still appear?
Voiding brings the card's balance to $0 and disables it, but keeps the card and its history, so it stays in reporting with a current balance of $0. Deleting a card removes it from reporting.
Can I see every redemption for a card?
Use The Adjustments report, which lists each balance change, or open the card's timeline.