VirtueMart Forum

VirtueMart 2 + 3 + 4 => Plugins: Payment, Shipment and others => Topic started by: thanili on July 26, 2013, 13:37:01 PM

Title: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: thanili on July 26, 2013, 13:37:01 PM
Hello guys,

have read the relevant sticky post:

https://forum.virtuemart.net/index.php?topic=110463.0 (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?

Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: thanili on July 26, 2013, 14:20:36 PM
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=
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: Maxim Pishnyak on July 26, 2013, 14:24:07 PM
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
Quote from: Tobes on July 23, 2013, 23:50:46 PM
I could see from the IPN history in the sandbox that the IPN was not pointing to my virtuemart directory.
?
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: thanili on July 26, 2013, 14:30:29 PM
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 ...
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: Maxim Pishnyak on July 26, 2013, 14:37:35 PM
Quote from: camble on January 29, 2013, 08:42:38 AM
Fixed.
Just for anybody else's benefit it was a problem with Paypal's IPN system.
Quote from: Hutson on July 23, 2013, 15:10:36 PM
If it was a problem with Paypal IPN, then it is likely that camble did nothing to resolve it
Quote from: jjk on April 23, 2013, 22:40:03 PM
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
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: thanili on July 26, 2013, 14:39:16 PM
I am using the sanbox at the moment ...

Maxim you mean that paypal ipn system is not working at the moment?
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: Maxim Pishnyak on July 26, 2013, 16:14:45 PM
Quote from: thanili on July 26, 2013, 14:39:16 PM
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?
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: thanili on July 31, 2013, 13:13:47 PM
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?
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: alatak on July 31, 2013, 20:10:17 PM
Hello

Quotewhich 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.

Quotewhich 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.

Quotemc_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
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: thanili on August 01, 2013, 12:38:51 PM
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]
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: alatak on August 01, 2013, 16:20:22 PM
Hello
That is normal. THe reason is because you did not receive the IPN notification.
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: thanili on August 01, 2013, 21:30:40 PM
Yes i guess so ... and the issue is why i do not receive IPN notifications (?) :)
Title: Re: vm2 paypal plugin does not get ipn notification details - status remains pending
Post by: alatak on August 02, 2013, 08:58:22 AM
Hello
have a look here: http://forum.virtuemart.net/index.php?topic=115033.msg397738#msg397738