vm2 paypal plugin does not get ipn notification details - status remains pending

[thanili]

Hello guys,

have read the relevant sticky post:

https://forum.virtuemart.net/index.php?topic=110463.0

and checked the paypal.log:

2013-07-25 14:17:07
message: plgVmConfirmedOrder order number: f489010

2013-07-25 14:18:49
message: plgVmConfirmedOrder order number: 6900011

2013-07-25 14:46:04
message: plgVmConfirmedOrder order number: 9b5704

2013-07-25 14:54:19
message: plgVmConfirmedOrder order number: 898705

2013-07-25 15:02:40
message: plgVmConfirmedOrder order number: 254806

2013-07-26 10:30:42
message: plgVmConfirmedOrder order number: c56007

as also table: "XXX_virtuemart_payment_plg_paypal"

which has "0" values in "paypalresponse_raw" field for all orders (as also in all other "paypalresponse_YYY" fields) ...

Obviously i have set the IPN URL:    http://www.artinfur.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginnotification&tmpl=component

which returns 200 status (in the browser) ... but all transactions in IPN history have FAILED ...

How can i proceed and debug the whole process?

[thanili]

This is what i get in my URL when i return form a paypal succesful payment:

http://www.artinfur.com/index.php/shop/store-frontpage/pluginresponse/pluginresponsereceived?on=5afc08&pm=3&tx=8DE67432ND892413P&st=Completed&amt=142%2e78&cc=EUR&cm=0f9d93897dbbca8e38063da2c5fd8fd5&item_number=

[Maxim Pishnyak]

Did you try the latest version of paypal plugin?

Probably you could even try the latest version from VM SVN.

You haven't anything interesting in

I could see from the IPN history in the sandbox that the IPN was not pointing to my virtuemart directory.

?

[thanili]

Maxim thanks!

i am using VM 2.0.22a (latest)

and here is a record from IPN history (failed):

mc_gross=142.78&invoice=5afc08&protection_eligibility=Ineligible&payer_id=QEDF4TN8YFJYW&tax=0.00&payment_date=05:17:59 Jul 26, 2013 PDT&payment_status=Completed&charset=UTF-8&first_name=Kostas&mc_fee=4.49&notify_version=3.7&custom=0f9d93897dbbca8e38063da2c5fd8fd5&payer_status=verified&business=eshop-facilitator@artinfur.com&quantity=1&verify_sign=A1weZhGYRLPiW1Hqd51Y7H04B9BnARtcr.-2H97IoqQIbGe4FgRfh6IL&payer_email=buyer4@artinfur.com&txn_id=8DE67432ND892413P&payment_type=instant&last_name=Maras&receiver_email=eshop-facilitator@artinfur.com&payment_fee=&receiver_id=CQPZRN3YS6TRQ&txn_type=web_accept&item_name=Order Number: 5afc08&mc_currency=EUR&item_number=&residence_country=US&test_ipn=1&handling_amount=0.00&transaction_subject=0f9d93897dbbca8e38063da2c5fd8fd5&payment_gross=&shipping=0.00&ipn_track_id=48741d59396fe

do not see any relevant to virtuemart directory info ...

[Maxim Pishnyak]

Fixed.
Just for anybody else's benefit it was a problem with Paypal's IPN system.

If it was a problem with Paypal IPN, then it is likely that camble did nothing to resolve it

Just for info - PayPal currently is changing a lot of their documentation and services and there still is plenty of old PayPal related stuff online.
The latest ones I know of are these:
https://www.x.com/sites/default/files/ipnguide.pdf
https://developer.paypal.com/webapps/developer/index

[thanili]

I am using the sanbox at the moment ...

Maxim you mean that paypal ipn system is not working at the moment?

[Maxim Pishnyak]

Maxim you mean that paypal ipn system is not working at the moment?

I'm not sure in this on 100%. But it could be as I see. Maybe hitting support of paypal with the big baseball bat attached to some emails could help?

[thanili]

Could we please verify that the URL after paypal redirection is complete and right?

http://www.artinfur.com/index.php?option=com_virtuemart&view=pluginresponse&task=pluginresponsereceived&on=e491010&pm=3&Itemid=0&tx=68G5700017369073G&st=Completed&amt=166%2e98&cc=EUR&cm=53efe0b1483043e1130f526e4365a7e1&;item_number=

should item_number to be populated?

[alatak]

Hello

which has "0" values in "paypalresponse_raw" field for all orders (as also in all other "paypalresponse_YYY" fields) ...

It is normal for the first entry. Because you did not received the notification yet.

which returns 200 status (in the browser) ... but all transactions in IPN history have FAILED ...

Ok. I guess that you see that in the Paypal Back office.

we need to find out why the IPN fails.

mc_gross=142.78&invoice=5afc08&protection_eligibility=Ineligible&payer_id=QEDF4TN8YFJYW&tax=0.00&payment_date=05:17:59 Jul 26, 2013 PDT&payment_status=Completed&charset=UTF-8&first_name=Kostas&mc_fee=4.49&notify_version=3.7&custom=0f9d93897dbbca8e38063da2c5fd8fd5&payer_status=verified&business=eshop-facilitator@artinfur.com&quantity=1&verify_sign=A1weZhGYRLPiW1Hqd51Y7H04B9BnARtcr.-2H97IoqQIbGe4FgRfh6IL&payer_email=buyer4@artinfur.com&txn_id=8DE67432ND892413P&payment_type=instant&last_name=Maras&receiver_email=eshop-facilitator@artinfur.com&payment_fee=&receiver_id=CQPZRN3YS6TRQ&txn_type=web_accept&item_name=Order Number: 5afc08&mc_currency=EUR&item_number=&residence_country=US&test_ipn=1&handling_amount=0.00&transaction_subject=0f9d93897dbbca8e38063da2c5fd8fd5&payment_gross=&shipping=0.00&ipn_track_id=48741d59396fe

The IPN is ok
but check in the   table: "XXX_virtuemart_payment_plg_paypal" if you have an entry with those 2 values:
invoice=5afc08
mc_gross=142.78

You can try also via the Paypal Back office to resend the IPN

[thanili]

Alatak!

mc_gross as also all other paypal_response_YYYY fields are zeros (0) ... for all transactions ... as you can see from the screenshot!



[attachment cleanup by admin]

[alatak]

Hello
That is normal. THe reason is because you did not receive the IPN notification.

[thanili]

Yes i guess so ... and the issue is why i do not receive IPN notifications (?)

[alatak]

Hello
have a look here: http://forum.virtuemart.net/index.php?topic=115033.msg397738#msg397738