http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=8622 Posted: 2010-03-06 08:16:06
Category: PayPal Integration
Version: 1.4.0.1
Priority: high
Status: closed
Reported By: onesimpleman

I use Payflow Pro and it declines cards. It turns out to be the bank itself that declines them due to bad expiration date.
If you look at the payflow management page all the declines have the correct month but all years are 20.
It appears to truncate the year and keep the first 2 digits ?20? and leaves out the last 2 digits, which are the ones needed.
Another thing noticed is although the store currency is GBP the currency transferred to paypal is USD

This has started after I upgraded to 1.41
Any thoughts or ideas where to look is appreciated.

---

]]> #1 / Comment by Magento Team

Hello onesimpleman,

According to PayFlow Pro docs we have, the expiration date should be sent in the format of MMYY, where YY are two last digits of the expiration date year. We have checked in Magento 1.4.0.1 and verified that it sends last two digits, not the first two. Can you please double check in live mode with PayFlow Pro support staff?

Thank you.]]> #2 / Comment by onesimpleman

Yes I have 2 websites.
One is an upgrade and the other one is a clean install. Both on Live payflow.
First noticed the problem with the upgraded version. So checked it with the clean install , same issue.

Every card is rejected with expiry year 20 when expiry year is something different.
I checked the pro.php file and the expiry date is supposed to be last two digits. subtring (value, -2,2). I cannot understand where paypal gets the 20 from.]]> #3 / Comment by onesimpleman

Reply from paypal
"
There are a few problems with what I see on this transactions, and I can confirm it is NOT being sent correctly from your site. However, they all may be related to the expiration date being passed incorrectly. When one item is not passed correctly, it can throw off other variables that were. There are two more obvious errors that I would like to cover with you, so that you may pass this on to your cart software provider.

First, as you mentioned, the expiration date. You should never be passing '20' in any way. Using your transaction as an example, the expiration date is 05 or 20??. Say it was meant to be 2012.

If your site passes this as per our documentation - MMYY with only two digits for the year, it will show as 05 / 2012 (we add the 20 ourselves). Instead, your site is passing it as a 4 digit year like MM / YYYY. Because of this, we read in the first four digits that should be all we need, and hte first 4 digits are 05 and 20. When we add our own 20 before this, it becomes 05 / 2020 which is incorrect. Please let your cart provider know that a 4 digit year is being passed, and that is not correct for the Payflow Pro API's.

Secondly, your site is not passing a Currency code with the transaction. This is another variable that is required, and because it was not passed (or may have actually been passed as the work 'null', I am unsure), you see the 'null' before the transaction amount where it should say your currency such as GBP or USD. Please pass this on to them as well.

I sincerely apologize for any inconvenience this may have caused. "]]> #4 / Comment by Magento Team

Fixed. Try this patch please.
http://www.magentocommerce.com/wiki/_media/patches/bug21302-rev63652.patch]]> #5 / Comment by sliilvia

Thats great news, how do I apply the patch? For your info I dont have access to shell commands.]]> #6 / Comment by sliilvia

I tried to patch manually adding and removing the pieces of code that had + and - but when I try to carry out a test purchase I when I get to the one page checkout it's blank. Anyone assist me? Or if anyone has successfully patched it could you attach the files to here or pm me please?

Many thanks, I really need to do this urgently.]]> #7 / Comment by sliilvia

This is still broken as as it hasn't fixed the error using paypal Payflow Pro UK:

?Paypal geteway rejected request. Field format error: 10713-There?s an error with this transaction. Please enter a country in the billing address?

You are not passing the country ID to Paypal, so the fix to the the year is not really much help as Paypal Payflow Pro UK is still broken. Please fix this urgently.]]> #8 / Comment by onesimpleman

Patch works as far as the year is concerned . The second issue regarding the passing the correct currency is not sorted and this causes error with paypal result code 23]]> #9 / Comment by Magento Team

Commencing full review of PayPal Direct PayFlow Edition API variables...]]> #10 / Comment by leeaston

Any news on this guy's, eta or anything?]]> #11 / Comment by leeaston

This is marked as resolved but it's not. My client has now spent 2 weeks un able to sell, I realise you guy's have priorities, but please keep us in the loop with an update now and then.]]> #12 / Comment by Magento Team

Hello onesimpleman,

This issue was fixed. The changes will be available in the next bugfix release.

Thank you.]]> #13 / Comment by sliilvia

When is the bugfix release please?]]> #14 / Comment by a1anm

Or is there something we can d to fix it in the mean time? Not being able to take certain payments is a bit of a problem.]]> #15 / Comment by Magento Team

Patch that fixes country code issue:
http://www.magentocommerce.com/wiki/_media/patches/bug21302-rev64434.patch]]> #16 / Comment by Germán W

Can this Bug also be affecting ?Website Payments Pro? (the non Payflow one)?

Thanks!]]> #17 / Comment by boliviab

i tried applying the patchs above and all it ended up doing is breaking it completely and giving me the following code


Fatal error: Cannot redeclare Mage_PaypalUk_Model_Direct::_getFormattedCcExpirationDate() in /home/*********/public_html/*********/webstore/app/code/core/Mage/PaypalUk/Model/Direct.php on line 85

any ideas?]]> #18 / Comment by boliviab

the error message does actually say Direct.php - the missing p was a typo and this happens when i go to start teh checkout process.]]> #19 / Comment by SimonJ

Has this issue been satisfactorily resolved by anyone??? I have applied both patches and it still does not work....]]> #20 / Comment by SimonJ

...I get the following error now...

PayPal geteway rejected request. Declined: 15005-This transaction cannot be processed.]]> #21 / Comment by boliviab

ivebe trying this for weeks now and cannot get it working. Could some please post a link to 2 new Direct.php file (paypal and paypaluk versions) that are supposed to work with this and also the Nvp.php file that was changed. , im sure it would help others aswell as me.

I have tried using patch , manually entering the code etc and whilst i ave fixed the country code issue I cannot get this expiration date thing working- its driving me mad!]]>