thread Re: Find the full number code of the eGift Cards folks have bought? in Archived Discussions (Read Only)

Find the full number code of the eGift Cards folks have bought?

TapTastings — Sat, 30 Nov 2019 13:04:01 GMT

Hi! I can't seem to find the full code number of the eGift Cards folks have bought. Can anyone please help? I'd like to add them to our booking engine so folks can actually use them.

Re: Find the full number code of the eGift Cards folks have bought?

JustinC — Mon, 02 Dec 2019 20:43:42 GMT

Hey @TapTastings! You can access the Gift card numbers directly from the Reports section of your Dashboard. Follow this flow: Reports > Gift Cards > Export (top right corner) > Gift Card Numbers CSV.

Since gift cards have 16 digit numbers assigned to them, the CSV spreadsheet sometimes converts the number into scientific notation to fit inside the cell ( ex 1.23E + 15). In that case, you'll need to change the formatting to plain numbers in Excel.

I hope this helps!

Re: Find the full number code of the eGift Cards folks have bought?

TapTastings — Mon, 02 Dec 2019 21:05:30 GMT

Thanks, Justin, but these are the values in the CSV file.

Gift Card Token	PAN Suffix
7944b713357542489cc21631f155e023	6567
b563498c3b0e4fc287986bcf1f81ff1f	4790

Re: Find the full number code of the eGift Cards folks have bought?

JustinC — Tue, 03 Dec 2019 13:46:48 GMT

🤨 Hmm, that doesn't look right. I'd call into Support about this so they can check out your CSV file and help export the correct Gift Card numbers.

Re: Find the full number code of the eGift Cards folks have bought?

TapTastings — Tue, 03 Dec 2019 13:43:41 GMT

I know, right? It's weird.

Ok, I'll contact them.

Thanks for trying to help, Justin!

Re: Find the full number code of the eGift Cards folks have bought?

JustinC — Tue, 03 Dec 2019 13:48:07 GMT

@TapTastings

Of course! Loop back here and let us know how it goes in case other sellers run into the same issue 😊

Square eGift Cards - Printing Card Number

vickyaustin — Thu, 04 Jun 2020 15:11:09 GMT

Hey,

If we sell a Square eGift Card (not physical) at the register how do we see all 16 digits of the gift card? I know it's emailed to the customer, but who do WE see it?

I can see the last four but no more than that and it won't print a paper ticket at any point with the full number. How do I get this? We want to be able to write down the full number.

I've looked before checkout, after checkout, on receipts, etc.

I've attached a picture showing the last 4: And it shows 4 digits here but I can't find all the digits anywhere

Re: Square eGift Cards - Printing Card Number

vickyaustin — Fri, 05 Jun 2020 15:19:43 GMT

Hi, I could really use some insight in this and/or answers! Thanks!

Re: Square eGift Cards - Printing Card Number

Joe — Fri, 05 Jun 2020 17:15:17 GMT

Hi there, @vickyaustin 👋 Thanks for reaching out again here on the Seller Community! Good to hear from you again.

Before I answer your posting, it's helpful to know you can reach out directly to our Support Team for expedited help with your account. The Seller Community usually offers a 48 hour turnaround response due to volume.

I've gone ahead and merged your post into an existing thread of Sellers who also inquired about the full numbers of customer eGift cards. Take a look at this Best Answer from Justin - he will point to the direct process for exporting. I will also note that this process has caused some irregularity for some Sellers, like you will see in Justin's post. If you have extended trouble, our Support Team is standing by!

Re: Square eGift Cards - Printing Card Number

vickyaustin — Fri, 05 Jun 2020 18:50:05 GMT

Thanks @Joe , but there has got to be an easier way to get the 16 digit number without having to be on the desktop dashboard...

Re: Find the full number code of the eGift Cards folks have bought?

vickyaustin — Fri, 05 Jun 2020 18:52:50 GMT

@JustinC @TapTastings

Same thing is happening to me on the export for the Gift Card Token... seems to be an ongoing issue. Has this been resolved or is it being worked on??

Re: Find the full number code of the eGift Cards folks have bought?

TapTastings — Fri, 05 Jun 2020 23:31:32 GMT

I forgot to post here that I got some help for this!

Go to Reports (instead of straight to gift cards).

THEN choose Gift Cards.

Then hit Export in the top, right.

Then choose Gift Card Numbers CVS

And there they are!

Re: Find the full number code of the eGift Cards folks have bought?

vhovar — Sat, 06 Jun 2020 21:04:10 GMT

@TapTastings That appears to be the format of the "Detail CSV" Export rather than the "Gift Card Numbers CSV". There seems to have been a recent change with the exports and now the "Gift Card Numbers CSV" shows the full card number in the "Gift Card PAN" column:

Gift Card PAN

Gift Card Token

Currency

Balance Cents

Updated At UTC

The 4 digit you see on the register and on the receipts is the last 4 digits of this number (PAN Suffix) in the "Detail CSV" export:

Gift Card Token

PAN Suffix

Issue Date

Last Reload Date

Last Used Date

Current Outstanding Amount

Location

In an earlier version of the "Gift Card Numbers CSV" it did not have the last digit of the full card number and you had to merge the two files using the "Gift Card Token" to get the correct "PAN Suffix". Hopefully this will stay so you don't have to do the merge. Also, if you need the "PAN Suffix" in the spreadsheet it is easy enough to do an =RIGHT(A2,4) formula and then you can easily search that column. Be aware that you could end up with duplicate "PAN Suffix" and then you have to try to determine which is the correct full card number.

I would like a list of my open egift cards with their redemption number. How can I get that?

mindfulmassage7 — Thu, 24 Sep 2020 01:01:32 GMT

I would like a list of my open egift cards with the date, buyer, recipient, amount, and redemption number. How can I get that? I have clients that come in not knowing their redemption number or amount because the egift card was emailed to the buyer, not recipient. Also, Booker, another spa program, lets you search by name, date, amount, or message to pull up the GC so you can get the redemption number and amount and use it for payment.

Re: I would like a list of my open egift cards with their redemption number. How can I get that?

Joe — Fri, 25 Sep 2020 13:11:19 GMT

Hello @mindfulmassage7 👋 Thanks for joining us here on the Seller Community! Good question, here.

I've gone ahead and merged your post into an existing thread of Sellers who were also looking for information regarding exporting eGift Card information, including card numbers and balances. Take a look at this Best Answer from Justin for more insight on how to obtain such a report.

Let us know if you have any further questions! We are here to help.

Re: Find the full number code of the eGift Cards folks have bought?

mindfulmassage7 — Fri, 25 Sep 2020 13:31:24 GMT

I can export details and summary but I don’t see an option for numbers. Can someone help? Details provides that long gift card token and pan suffix. It would also be nice to see the issuer and recipient name to know who it belongs to.

Re: Find the full number code of the eGift Cards folks have bought?

davidtx — Thu, 18 Mar 2021 20:58:09 GMT

This doesn't seem to be working anymore. There is no Gift Card Numbers CSV. The only options are a summary and detailed report. Neither has the full code. You can only see the last 4 digits on the summary report. Is there another way to get this information?

Re: Find the full number code of the eGift Cards folks have bought?

mindfulmassage7 — Fri, 19 Mar 2021 02:27:49 GMT

I’m not sure why they don’t allow this for owners. I asked for the raw data and they won’t give it to me. For this, Square is awful.

Re: Find the full number code of the eGift Cards folks have bought?

TapTastings — Fri, 19 Mar 2021 12:36:53 GMT

The method mentioned above is working.

Go to Reports first (not directly to gift cards) then choose gift cards and then the export button.

Re: Find the full number code of the eGift Cards folks have bought?

mindfulmassage7 — Fri, 19 Mar 2021 14:13:07 GMT

For the detailed report it only shows you the last four digits. For the summary report, it shows you nothing. So the reports don’t work.