|
MAC Webmaster
|
April 15, 2016 at 3:38 pm
Events are not having their payment status updated to complete once Payment to Paypal is completed. This is problem is causing an administrative nightmare. Can you help with this please. Thanks.
I have Registration Id: # 133-57114a498ce57 with payment status of Incomplete and transaction id: 0 but in the log it shows:
[ 2016-04-15 16:11:00 ] process_payments.php -> event_espresso_txn
Payment for: Paypal Test 2, Karl|| registration id: 133-57114a498ce57|| transaction details: a:53:{s:4:"r_id";s:17:"133-57114a498ce57";s:4:"type";s:6:"paypal";s:2:"id";s:4:"4525";s:8:"event_id";s:3:"133";s:15:"attendee_action";s:12:"post_payment";s:11:"form_action";s:7:"payment";s:8:"mc_gross";s:4:"0.02";s:22:"protection_eligibility";s:8:"Eligible";s:14:"address_status";s:9:"confirmed";s:12:"item_number1";s:0:"";s:8:"payer_id";s:13:"AM7TNSZK5F7R8";s:3:"tax";s:4:"0.00";s:14:"address_street";s:16:" Canning Court";s:12:"payment_date";s:25:"13:10:49 Apr 15, 2016 PDT";s:14:"payment_status";s:9:"Completed";s:7:"charset";s:5:"UTF-8";s:11:"address_zip";s:7:"L3S 2W7";s:11:"mc_shipping";s:4:"0.00";s:11:"mc_handling";s:4:"0.00";s:10:"first_name";s:7:"Michael";s:6:"mc_fee";s:4:"0.02";s:20:"address_country_code";s:2:"CA";s:12:"address_name";s:16:"M B";s:14:"notify_version";s:3:"3.8";s:6:"custom";s:0:"";s:12:"payer_status";s:10:"unverified";s:8:"business";s:36:"payments@mortgagealliance.com";s:15:"address_country";s:6:"Canada";s:14:"num_cart_items";s:1:"1";s:12:"mc_handling1";s:4:"0.00";s:12:"address_city";s:7:"Markham";s:11:"verify_sign";s:56:"Aw44NCNIe3P9gB2wAzyBZJGhSKZ7ABfidu68fSTP05fMCSUW.OTXJ2gD";s:11:"payer_email";s:28:"email1@mortgagealliance.com";s:12:"mc_shipping1";s:4:"0.00";s:4:"tax1";s:4:"0.00";s:4:"memo";s:11:"Test 2 ....";s:6:"txn_id";s:17:"3T267638MB102234S";s:12:"payment_type";s:7:"instant";s:9:"last_name";s:8:"Beckette";s:13:"address_state";s:7:"Ontario";s:10:"item_name1";s:60:"General Admission for Karl Test Attendee: Karl Paypal Test 2";s:14:"receiver_email";s:36:"payments@mortgagealliance.com";s:11:"payment_fee";s:0:"";s:9:"quantity1";s:1:"1";s:11:"receiver_id";s:13:"B5LR34JSLF9DY";s:8:"txn_type";s:4:"cart";s:10:"mc_gross_1";s:4:"0.02";s:11:"mc_currency";s:3:"CAD";s:17:"residence_country";s:2:"CA";s:10:"receipt_id";s:19:"1540-6578-2139-8825";s:19:"transaction_subject";s:0:"";s:13:"payment_gross";s:0:"";s:12:"ipn_track_id";s:12:"f2de5aa1ca34";}
In the IPN History for the transaction I get:
Instant Payment Notification (IPN) details
Message ID
6WB40381TH6321448
Date/time created
15/04/2016 16:10 GMT-04:00
Original/Resent
Original
Latest delivery attempt date/time
15/04/2016 16:11 GMT-04:00
Notification URL
http://mydomain/event-registration-confirmation/?r_id=133-57114a498ce57&type=paypal&id=4525&event_id=133&attendee_action=post_payment&form_action=payment
HTTP response code
200
Delivery status
Sent
No. of retries
0
Transaction ID
3T267638MB102234S
IPN type
Transaction made
IPN Message:
mc_gross=0.02&protection_eligibility=Eligible&address_status=confirmed&item_number1=&payer_id=AM7TNSZK5F7R8&tax=0.00&address_street=Canning Court&payment_date=13:10:49 Apr 15, 2016 PDT&payment_status=Completed&charset=UTF-8&address_zip=L3S 2W7&mc_shipping=0.00&mc_handling=0.00&first_name=M&mc_fee=0.02&address_country_code=CA&address_name=M B¬ify_version=3.8&custom=&payer_status=unverified&business=payments@mortgagealliance.com&address_country=Canada&num_cart_items=1&mc_handling1=0.00&address_city=Markham&verify_sign=Aw44NCNIe3P9gB2wAzyBZJGhSKZ7ABfidu68fSTP05fMCSUW.OTXJ2gD&payer_email=k@mortgagealliance.com&mc_shipping1=0.00&tax1=0.00&memo=Test 2 ....&txn_id=3T267638MB102234S&payment_type=instant&last_name=B&address_state=Ontario&item_name1=General Admission for Karl Test Attendee: Karl Paypal Test 2&receiver_email=payments@mortgagealliance.com&payment_fee=&quantity1=1&receiver_id=B5LR34JSLF9DY&txn_type=cart&mc_gross_1=0.02&mc_currency=CAD&residence_country=CA&receipt_id=1540-6578-2139-8825&transaction_subject=&payment_gross=&ipn_track_id=f2de5aa1ca34
-
This topic was modified 8 years, 7 months ago by
 MAC Webmaster.
-
This topic was modified 6 years, 1 month ago by
 Seth Shoultes.
-
This topic was modified 6 years, 1 month ago by Seth Shoultes.
|
|
Josh
|
April 15, 2016 at 3:51 pm
Hi there,
Do you happen to have the WP SpamShield plugin installed? If so, you can follow step 13 in the WP-Spamshield documentation:
Are you having trouble with an API call, webhook, or payment gateway getting blocked? We have made every effort to whitelist all of these on major plugins, but in some rare occasions a problem will arise. Try using the option “Disable anti-spam for miscellaneous forms” and see if that helps.
|
|
MAC Webmaster
|
April 18, 2016 at 7:22 am
We are not using that plugin. But I was thinking that perhaps wordfence was blocking the responses?
|
|
Lorenzo Orlando Caum
|
April 18, 2016 at 7:38 am
Hello, could you temporarily turn off that plugin and then try resending the IPN from some resent transactions that were not updated?
You can resend through the history screen for the IPN:
https://developer.paypal.com/docs/classic/ipn/integration-guide/IPNOperations/
—
Lorenzo
|
|
MAC Webmaster
|
April 18, 2016 at 8:30 am
Just did the test you suggested and so far it hasn’t made any updates. Just checking the logs and it looks like the IPN Response message is received? But the updates to the event and payment status is still not being made? See details below.
[ 2016-04-18 10:09:39 ] process_payments.php -> event_espresso_txn
Payment for: Paypal Test, Karl|| registration id: 133-571144ddd4945|| transaction details: a:54:{s:4:"r_id";s:17:"133-571144ddd4945";s:4:"type";s:6:"paypal";s:2:"id";s:4:"4524";s:8:"event_id";s:3:"133";s:15:"attendee_action";s:12:"post_payment";s:11:"form_action";s:7:"payment";s:10:"mc_gross_1";s:4:"0.02";s:12:"mc_handling1";s:4:"0.00";s:14:"num_cart_items";s:1:"1";s:8:"payer_id";s:13:"AM7TNSZK5F7R8";s:20:"address_country_code";s:2:"CA";s:12:"ipn_track_id";s:13:"4e680009409ef";s:11:"address_zip";s:7:"L3S 2W7";s:7:"charset";s:5:"UTF-8";s:13:"payment_gross";s:0:"";s:14:"address_status";s:9:"confirmed";s:14:"address_street";s:16:"Canning Court";s:10:"receipt_id";s:19:"0420-5170-2581-7029";s:11:"verify_sign";s:56:"Ai1PaghZh5FmBLCDCTQpwG8jB264ASZu7Uh.vpZdYwvl7YBmqKRpkTLm";s:4:"tax1";s:4:"0.00";s:11:"mc_shipping";s:4:"0.00";s:8:"txn_type";s:4:"cart";s:11:"receiver_id";s:13:"B5LR34JSLF9DY";s:11:"payment_fee";s:0:"";s:12:"item_number1";s:0:"";s:11:"mc_currency";s:3:"CAD";s:19:"transaction_subject";s:0:"";s:6:"custom";s:0:"";s:22:"protection_eligibility";s:8:"Eligible";s:9:"quantity1";s:1:"1";s:15:"address_country";s:6:"Canada";s:12:"payer_status";s:10:"unverified";s:10:"first_name";s:7:"Michael";s:10:"item_name1";s:58:"General Admission for Karl Test Attendee: Karl Paypal Test";s:12:"address_name";s:16:"M B";s:8:"mc_gross";s:4:"0.02";s:12:"mc_shipping1";s:4:"0.00";s:12:"payment_date";s:25:"13:06:31 Apr 15, 2016 PDT";s:14:"payment_status";s:9:"Completed";s:8:"business";s:36:"payments@mortgagealliance.com";s:11:"mc_handling";s:4:"0.00";s:9:"last_name";s:8:"B";s:13:"address_state";s:7:"Ontario";s:6:"txn_id";s:17:"79110652VK418153R";s:6:"mc_fee";s:4:"0.02";s:6:"resend";s:4:"true";s:12:"payment_type";s:7:"instant";s:14:"notify_version";s:3:"3.8";s:4:"memo";s:66:"Testing Pyapal Integration with Event Espresso & IPN Notifications";s:11:"payer_email";s:28:"ks@mortgagealliance.com";s:14:"receiver_email";s:36:"payments@mortgagealliance.com";s:12:"address_city";s:7:"Markham";s:3:"tax";s:4:"0.00";s:17:"residence_country";s:2:"CA";}
From the IPN History Page:
Instant Payment Notification (IPN) details
Message ID
37204179FJ614090D
Date/time created
15/04/2016 16:06 GMT-04:00
Original/Resent
Original
Latest delivery attempt date/time
15/04/2016 16:06 GMT-04:00
Notification URL
http://events.mortgagealliance.com/event-registration-confirmation/?r_id=133-571144ddd4945&type=paypal&id=4524&event_id=133&attendee_action=post_payment&form_action=payment
HTTP response code
200
Delivery status
Sent – resending
No. of retries
0
Transaction ID
79110652VK418153R
IPN type
Transaction made
IPN Message
mc_gross=0.02&protection_eligibility=Eligible&address_status=confirmed&item_number1=&payer_id=AM7TNSZK5F7R8&tax=0.00&address_street=38 Canning Court&payment_date=13:06:31 Apr 15, 2016 PDT&payment_status=Completed&charset=UTF-8&address_zip=L3S 2W7&mc_shipping=0.00&mc_handling=0.00&first_name=Michael&mc_fee=0.02&address_country_code=CA&address_name=Michael Beckette¬ify_version=3.8&custom=&payer_status=unverified&business=online_payments@mortgagealliance.com&address_country=Canada&num_cart_items=1&mc_handling1=0.00&address_city=Markham&verify_sign=AaDGXKRfJtkfKjNa8l02wAqao9BiA8M7z3QzxDWeEMzgIvqyOg5Grv5z&payer_email=ksutton@mortgagealliance.com&mc_shipping1=0.00&tax1=0.00&memo=Testing Pyapal Integration with Event Espresso & IPN Notifications&txn_id=79110652VK418153R&payment_type=instant&last_name=Beckette&address_state=Ontario&item_name1=General Admission for Karl Test Attendee: Karl Paypal Test&receiver_email=online_payments@mortgagealliance.com&payment_fee=&quantity1=1&receiver_id=B5LR34JSLF9DY&txn_type=cart&mc_gross_1=0.02&mc_currency=CAD&residence_country=CA&receipt_id=0420-5170-2581-7029&transaction_subject=&payment_gross=&ipn_track_id=4e680009409ef
|
|
Josh
|
April 18, 2016 at 10:04 am
Hi there,
Can you go to the Event Espresso > Payment Methods > Logs tab, and check to see if the IPN response is logged there?
|
|
MAC Webmaster
|
April 18, 2016 at 10:15 am
I dont see that option? I am using Event Espresso – 3.1.37.7.P? I went to the Payment Settings page but didnt see an option to go to a Logs tab there. I got the information from the logs by checking the espresso_log.txt file
|
|
Josh
|
April 18, 2016 at 2:29 pm
In that case, can you follow the guide that shows how to install a simplified transactions page template?
https://eventespresso.com/wiki/how-to-set-up-paypal-ipn/#incomplete
|
