show last 4 digits of cc on invoice and customer email

[cway]

I wonder if anybody out there knows of a module or a way to display the last 4 digits of the customers credit card number in the Invoice screen and customer or merchant emails?

[wcw]

Re: show last 4 digits of cc on invoice and customer email

You should be able to do it on the invoice screen with the tool kit's newsubstring function by capturing characters 13 to 16 if the number is 16 characters long.

[cway]

Re: show last 4 digits of cc on invoice and customer email

Is accomplishing this easy enough for the non-coder?
What about customer or merchant emails?

[Nerd Boy Inc]

Re: show last 4 digits of cc on invoice and customer email

Dear CWay,

Depending on which Gateway you are using that information may not be available.

[wcw]

Re: show last 4 digits of cc on invoice and customer email

Like Jeff said, you have to know the variable to look for. It may not be there. If it is the tool kit has an example of the newsubstring function that should be easy to follow.

[cway]

Re: show last 4 digits of cc on invoice and customer email

My client is using Payflow Pro. Does anybody know if this information is available from Payflow Pro (now Paypal) and what the variable is?
I assume the information and variable is available because it's working in our Miva4.24 store with Ivo's Merchant Email module.

[wcw]

Re: show last 4 digits of cc on invoice and customer email

You can use latu's free store helper module to identify what variables are available on the invoice screen. You will need to place a test order to see them.

[cway]

Re: show last 4 digits of cc on invoice and customer email

What about email receipts? Sounds like your MailManager won't display the last 4 digits?

[wcw]

Re: show last 4 digits of cc on invoice and customer email

Maybe, maybe not. You need to see if the variable is on the INVC page using the store helper.

[cway]

Re: show last 4 digits of cc on invoice and customer email

As usual, thanks for the quick responses, WCW.

I found the below on the Invoice screen.
Does this mean it's likely your Toolkit module will display some of the numbers on the Invoice screen and in Merchant and Customer emails?

Also, I've received a sample of code from our gracious host - Hostasaurus - from another module that's displaying partial card numbers in emails. Let me know WCW if you'd like it and I will email it to you. It's from an uncompiled module, but it may help.

g.PaymentNet_CardNumber    &mvt:global:paymentnet_cardnumber;    4111111111111111

[wcw]

Re: show last 4 digits of cc on invoice and customer email

Try this on the INVC page template

<mvt:item name="toolkit" param="newsubstring|card4|g.paymentnet_cardnumber, 13,4" />
TEST: &mvte:global:card4;

Don't forget to assign the tool kit to the INVC page template.

If it works, you would be able to use the same code in the mail manager emails IF you use the store morph template layout.

[cway]

Re: show last 4 digits of cc on invoice and customer email

Done. And I got this:
TEST: 4111
Looks like the first 4 digits of the test card I used.

[wcw]

Re: show last 4 digits of cc on invoice and customer email

Interesting. Contact me at the support link below.

[wcw]

Re: show last 4 digits of cc on invoice and customer email

I left off the code tags before. Try this

<mvt:item name="toolkit" param="newsubstring|card4|g.paymentnet_cardnumber,13,4" />
TEST: &mvte:global:card4;

Take out the space that was between the , and 13. Unless you use the code tags this board puts spaces where you least expect them. I wish they would get rid of the smileys so the code tags weren't required.

[zazen06]

Re: show last 4 digits of cc on invoice and customer email

Hi Cway,

It's nearly a year later from your post, and thought you might have the answer?

We're after this same functionality, to display the last four numbers of a credit card on the online invoice as well as the email confirmation.

I'm guessing the tool kit's newsubstring function solved part of the problem? but what about the email? Were you ever able to get both displays working? If so, please send tips to help us avoid re-inventing the wheel.

Thanks!