paypal IPN woes

[DrByte]

When you installed the may 10 patch, did you also configure PDT? This should help prevent stuck orders from happening.

[m_and_s]

Yes, I configured PDT after installing the patch.
No feedback from the clients I found in the stack orders, for some unknown reason they left the Paypal payment page without proceeding.
I have logs activated, 2 other payments went well in the meanwhile... what I did was to remove Paypal Express Checkout that I am not using.

[m_and_s]

I got an email about a payment from Paypal without any Order confirm email...so I thought of another Stuck order, and moved it from Stuck orders to Orders list.
Soon after , looking at the Log files I realized another log file arrived, from PDT that failed to insert order data because I moved from Stuck orders, so probably if I had waited I had had a good order.
PDT was 10min late this time.Looking at the previous logged payments, the 2 log files have the same date/time or a difference of 1 min.

So I realized that the FIRST log file, always reported a warning:

 
-- IPN WARNING :: Currency/Amount Mismatch.  Details: 
PayPal email address = xxx@xxxx
 | mc_currency = EUR
 | submitted_currency = EUR
 | order_currency = 69
 | mc_gross = 69.00
 | converted_amount = 8.00
 | order_amount = 8  
VERIFIED
0

And the orders were saved by PDT:

 
IPN INFO :: Currency/Amount Details: 
PayPal email address = xxx@xxxx
 | mc_currency = EUR
 | submitted_currency = EUR
 | order_currency = EUR
 | mc_gross = 69.00
 | converted_amount = 69.00
 | order_amount = 69
Jun 03 2007 17:11 -- PDT NOTICE :: Order added: 26
PayPal status: Completed  @ 08:10:47 Jun 03, 2007 PDT
 Trans ID:14302649LU228052B
 Amount: 69.00 EUR

Do you have any idea of the reason I get a Currency/Amount Mismatch in the IPN request?

thanks

[DrByte]

Soon after , looking at the Log files I realized another log file arrived, from PDT that failed to insert order data because I moved from Stuck orders, so probably if I had waited I had had a good order.
PDT was 10min late this time.Looking at the previous logged payments, the 2 log files have the same date/time or a difference of 1 min.

The only explanation for PDT being 10 min later is if the customer paid by CC and without a PP account, and was left on the "Click here to create account or here to return to merchant" screen ... and finally came back to your store after choosing one of those options.

So I realized that the FIRST log file, always reported a warning:

 
-- IPN WARNING :: Currency/Amount Mismatch.  Details: 
PayPal email address = xxx@xxxx
 | mc_currency = EUR
 | submitted_currency = EUR
 | order_currency = 69
 | mc_gross = 69.00
 | converted_amount = 8.00
 | order_amount = 8  
VERIFIED
0

It seems really odd that the order_currency contains a number ... because it's supposed to contain the currency of the transaction.
I can't see any reason in the code for that mismatch to happen. And, where does the "8" come from?
Most puzzling.

The following PDT log segment looks good. Strangely enough, both logs use the same piece of code.

And the orders were saved by PDT:

 
IPN INFO :: Currency/Amount Details: 
PayPal email address = xxx@xxxx
 | mc_currency = EUR
 | submitted_currency = EUR
 | order_currency = EUR
 | mc_gross = 69.00
 | converted_amount = 69.00
 | order_amount = 69
Jun 03 2007 17:11 -- PDT NOTICE :: Order added: 26
PayPal status: Completed  @ 08:10:47 Jun 03, 2007 PDT
 Trans ID:14302649LU228052B
 Amount: 69.00 EUR

[m_and_s]

I checked the other log files, and I found that in all of them, in the first log file for each paypal transaction:

1. order_currency and mc_gross have the same value of order amount
2. converted_amount = 8.00
   order_amount = 8 , always, for any kind of order amount

[zend]

I checked the other log files, and I found that in all of them, in the first log file for each paypal transaction:

1. order_currency and mc_gross have the same value of order amount
2. converted_amount = 8.00
   order_amount = 8 , always, for any kind of order amount

For those finding this thread with a search on IPN or stuck orders -
I had the above problem exactly. If your IPN log shows order_currency = 69 (or any number) instead of a currency code like order_currency = EUR or other currency code, it will show converted_amount = 8.00 and order_amount = 8 and no order will be recorded.

Don't know what causes it but I fixed it without upsetting any config by installing a new zencart to another directory then copying its /zencart/includes/modules/payment directory over the troublesome one. I'm using version 1.3.7.1.

Hope this helps others so they don't slave for days like I did!

Thanks Dr Byte for your troubleshooting tips in various threads that helped.

[zend]

Forgot to say IPN/orders was setup and working ok in the new install before I copied the directory(s) over.

[AaronN]

Forgot to say IPN/orders was setup and working ok in the new install before I copied the directory(s) over.

I'm having the exact same issue, I've tried copying over the latest payment modules to no avail. Any help is appreciated.

IPN WARNING :: Currency/Amount Mismatch. Details:
PayPal email address = [email protected] | mc_currency = USD | submitted_currency = USD | order_currency = 1 | mc_gross = 1.00 | converted_amount = 8.00 | order_amount = 8 VERIFIED 0

I've tried a few different things from other post's but the problem persists
Thanks
-Aaron

[AaronN]

I'm having the exact same issue, I've tried copying over the latest payment modules to no avail. Any help is appreciated.



I've tried a few different things from other post's but the problem persists
Thanks
-Aaron

Seems as soon as I ask for help, I FIX IT!!
I copied over the ipn_main_handler.php and that did the trick.
-Aaron

[Kim]

Thanks for posting the solution you found!