Support

Home Forums Event Espresso Premium Paypal problems – incomplete transactions (continued)

Paypal problems – incomplete transactions (continued)

Posted: January 7, 2013 at 9:28 am


Michel Neray

January 7, 2013 at 9:28 am

Hi Josh – this is picking up the previous thread here: https://eventespresso.com/topic/paypal-problems-after-update/page/2/

Again, test registrations went through fine after removing the old templates, but registrations from other people are still showing as incomplete, even though their payment has gone through in paypal.

Recent IPN log entry for a registration that is paid, but marked incomplete in EE:

12/27/2012 2:23 PM] - Errors from IPN Validation:

Using BUILT-IN PHP curl methods
key = mc_gross
value = 11.30
key = protection_eligibility
value = Ineligible
key = item_number1
value =
key = payer_id
value = RVA2DRC6QMYTN
key = tax
value = 1.30
key = payment_date
value = 11:23:44 Dec 27, 2012 PST
key = payment_status
value = Completed
key = charset
value = windows-1252
key = mc_shipping
value = 0.00
key = mc_handling
value = 0.00
key = first_name
value = NAME
key = mc_fee
value = 0.63
key = notify_version
value = 3.7
key = custom
value =
key = payer_status
value = unverified
key = business
value = EMAIL
key = num_cart_items
value = 1
key = mc_handling1
value = 0.00
key = verify_sign
value = AuaofqQd2e-2NuLkob0HpzqE3dYDAllA6ZrSqgXyRuI0CqABSftals0f
key = payer_email
value = NAMENAME@
key = mc_shipping1
value = 0.00
key = tax1
value = 0.00
key = txn_id
value = 5N9168745A429342C
key = payment_type
value = instant
key = last_name
value = NAME
key = item_name1
value = Cover Charge for Burl-Oak MoMonday Jan 21, 2013. Attendee: NAME NAME
key = receiver_email
value = EMAIL
key = payment_fee
value =
key = quantity1
value = 1
key = receiver_id
value = FY7CVSP4GPKPU
key = txn_type
value = cart
key = mc_gross_1
value = 10.00
key = mc_currency
value = CAD
key = residence_country
value = CA
key = transaction_subject
value = Shopping CartCover Charge for Burl-Oak MoMonday Jan 21, 2013. Attendee: NAME NAME
key = payment_gross
value =
key = ipn_track_id
value = 4b022b5c38c7
Success Setting host: https://www.paypal.com/cgi-bin/webscr
Success Setting request type to post
Success Setting post fields: mc_gross=11.30&protection_eligibility=Ineligible&item_number1=&payer_id=RVA2DRC6QMYTN&tax=1.30&payment_date=11%3A23%3A44+Dec+27%2C+2012+PST&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=NAME&mc_fee=0.63&notify_version=3.7&custom=&payer_status=unverified&business=mn%40EssentialMessage.com&num_cart_items=1&mc_handling1=0.00&verify_sign=AuaofqQd2e-2NuLkob0HpzqE3dYDAllA6ZrSqgXyRuI0CqABSftals0f&payer_email=NAMENAME%40&mc_shipping1=0.00&tax1=0.00&txn_id=5N9168745A429342C&payment_type=instant&last_name=NAME&item_name1=Cover+Charge+for+Burl-Oak+MoMonday+Jan+21%2C+2013.+Attendee%3A+NAME+NAME&receiver_email=mn%40neray.com&payment_fee=&quantity1=1&receiver_id=FY7CVSP4GPKPU&txn_type=cart&mc_gross_1=10.00&mc_currency=CAD&residence_country=CA&transaction_subject=Shopping+CartCover+Charge+for+Burl-Oak+MoMonday+Jan+21%2C+2013.+Attendee%3A+NAME+NAME&payment_gross=&ipn_track_id=4b022b5c38c7&cmd=_notify-validate
Success Setting Fain On Error
Success Setting return transfer
Success Setting Timeout
Success Setting verbose mode
Errors resulting from the execution of curl transfer: [12/27/2012 2:23 PM] - SUCCESS!
IPN POST Vars from gateway:
mc_gross=11.30, protection_eligibility=Ineligible, item_number1=, payer_id=RVA2DRC6QMYTN, tax=1.30, payment_date=11:23:44 Dec 27, 2012 PST, payment_status=Completed, charset=windows-1252, mc_shipping=0.00, mc_handling=0.00, first_name=NAME, mc_fee=0.63, notify_version=3.7, custom=, payer_status=unverified, business=EMAIL, num_cart_items=1, mc_handling1=0.00, verify_sign=AuaofqQd2e-2NuLkob0HpzqE3dYDAllA6ZrSqgXyRuI0CqABSftals0f, payer_email=NAMENAME@, mc_shipping1=0.00, tax1=0.00, txn_id=5N9168745A429342C, payment_type=instant, last_name=NAME, item_name1=Cover Charge for Burl-Oak MoMonday Jan 21, 2013. Attendee: NAME NAME, receiver_email=EMAIL, payment_fee=, quantity1=1, receiver_id=FY7CVSP4GPKPU, txn_type=cart, mc_gross_1=10.00, mc_currency=CAD, residence_country=CA, transaction_subject=Shopping CartCover Charge for Burl-Oak MoMonday Jan 21, 2013. Attendee: NAME NAME, payment_gross=, ipn_track_id=4b022b5c38c7,
IPN Response from gateway Server:
VERIFIED


Josh

  • Support Staff

January 7, 2013 at 4:59 pm

Hi Michel,

Can you clarify whether the test registrations were done using a live PayPal account or a PayPal Sandbox account?


Michel Neray

January 8, 2013 at 10:00 am

Hi Josh – the test registrations were done with a live Paypal account.


Josh

  • Support Staff

January 8, 2013 at 12:01 pm

Thanks Michel,

Are any of the non-test transactions going through as complete?


Michel Neray

January 8, 2013 at 3:38 pm

yes, some are. we can’t tell what the difference is between those that go through fine and those that don’t. The majority, however, show up as incomplete.


Sam Anderson

January 8, 2013 at 4:18 pm

Hi Michel,

Sorry to jump in on this but i have also had a similar issue where Paypal transactions where being processed by Paypal but on EE showing as incomplete and end users not receiving any payment or registration emails thus requiring me to manually update the tickets and manually sending ticket emails etc..

After helpful advice the the support team (Jonathan big thanks to you) one thing they noticed on my install was that the Groupon add-on was not on the latest version. They mentioned that recently it had a name change however there wasn’t a notification of an available update in the dashboard so i must have missed it out when doing my usual checks and updates.

So after being updated manually the plugin is now listed as “Social Coupons” and from what i can see after testing is that this may have been the culprit for me.

Having runs some live Paypal tests my site is now back and running as it should be and the EE is now updated correctly along with the emails being sent to the end users.

May not be the case with you but your symptoms are very similar so may be worth a try..

Regards,
Sam


Josh

  • Support Staff

January 8, 2013 at 4:40 pm

Michel,

So did all the event registrations that came in today, which are all marked complete, need to get manually updated?


Michel Neray

January 8, 2013 at 4:51 pm

it’s hard to remember, but I believe goldbeck and the two arnall registrations came through fine. It would be tempting to note they all belong to Calgary which was created today, but Winnipeg has been giving a lot of failed confirmations except for Rhonda Tough on Jan 4.


Michel Neray

January 8, 2013 at 4:52 pm

I will start a separate listing of which ones fail and which ones work fine so I don’t have to backtrack….


Josh

  • Support Staff

January 8, 2013 at 4:57 pm

When you can find one that was a confirmed fail, can you check the server logs for when that happened to see if there were any errors?


Michel Neray

January 8, 2013 at 4:59 pm

With your eagle eye, can you check?

An instant payment notification failed
from dinglis7@shaw.ca on 01/08/2013 at 4:22 PM

An instant payment notification failed
from odette@businesswomenontop.com on 01/08/2013 at 1:10 PM

An instant payment notification failed
from bradtw@shaw.ca on 01/07/2013 at 8:20 PM

An instant payment notification failed
from abeetlestone@rogers.com on 01/07/2013 at 7:01 PM

An instant payment notification failed
from kkjones@sympatico.ca on 01/07/2013 at 3:01 PM


Josh

  • Support Staff

January 9, 2013 at 8:22 am

Hi Michel,

I checked the PayPal IPN logs for these and PayPal is sending the VERIFIED message for each of these with no errors. Does the IPN History in the Paypal account show a FAILED status? If so, is there an error code displayed there?


Michel Neray

January 9, 2013 at 1:19 pm

I don’t see any failed status in my IPN history in Paypal – they all show SENT status.


Josh

  • Support Staff

January 9, 2013 at 8:46 pm

This is very unusual, some transactions are getting marked complete, and these others are not. Do you have access to server error logs? (not the ipn logs, they are not showing any errors)

This question is regarding your above post where you listed the transactions that did not complete. Are you getting notifications from PayPal or sent from your site that say “An instant payment notification failed”? If yes, who is sending them, and when do they arrive? Right away or later?

I’m going to create a new IPN listener page on your to rule out any 301 redirect issues with the current page. It may help.


Michel Neray

January 9, 2013 at 10:00 pm

Maybe my web developer Tracy has access to the server error logs. I don’t. Here are two more:

PayPal: You received a payment of $52.50 CAD from Krista Lloyd (xxxxx@gmail.com)
An instant payment notification failed from xxxxx@gmail.com on 01/09/2013 at 11:24 AM

Hello Essential Message/MoMondays/Concentric Strategies Inc.,
PayPal: You received a payment of $11.30 CAD from (xxxxx@cogeco.ca).
An instant payment notification failed
from xxxxx@cogeco.ca on 01/09/2013 at 4:06 PM

The Paypal confirmation comes in within a minute of the failed notification.


Michel Neray

January 10, 2013 at 5:49 am

In case it helps, I noticed that the Failed transaction from Espresso comes before the PayPal notification of success:

An instant payment notification failed
from RRRYYY@live.com on 01/10/2013 at 6:50 AM
PayPal at 6:51: You received a payment of $22.60 CAD from RRRYYY (RRRYYY@live.com)


Josh

  • Support Staff

January 10, 2013 at 11:29 am

What is so tricky about this is there are no errors in the IPN logs. The next step is to check the server’s error logs to see if there are any additional server errors that may provide clues on why the PayPal IPN continues to fail for most transactions.

Have you considered switching to Stripe? They opened up to Canada, and are much more reliable:

http://go.bloomberg.com/tech-deals/2012-09-19-payments-startup-stripe-expands-to-canada-in-challenge-to-paypal/


Michel Neray

January 10, 2013 at 1:55 pm

Don’t see any errors in the error log on the server. The server logs 300 errors – is that what I want to check?


Michel Neray

January 10, 2013 at 2:14 pm

In the meantime, will check out Stripe… thanks!


Michel Neray

January 10, 2013 at 9:19 pm

well we waited several days for this, but we finally got a successful transaction.

Espresso: Winnipeg MoMonday Jan.28, 2013 registration confirmation
PayPal: Jan 10, 2013 17:05:09 PST | Transaction ID: 36772714KH763011K
Hello Essential Message/MoMondays/Concentric Strategies Inc.,
You received a payment of $20.00 CAD from ray jeanson (XXX@mts.net)


Michel Neray

January 13, 2013 at 9:30 pm

OK, things are getting curiouser and curiouser.

One person purchased 2 tickets in separate transactions. In the first transaction (01/13/2013 at 2:12 PM) Espresso returned a failed transaction, but PayPal charged taxes correctly. In the next transaction (Jan 13, 2013 19:07:21) Espresso was fine but PayPal didn’t charge any taxes.

What gives?


Josh

  • Support Staff

January 14, 2013 at 10:55 am

Hi Michel,

How are taxes set up to be charged? Are you using the “Surcharge” feature in Event Espresso, or using the tax feature in the PayPal account, or something else?


Michel Neray

January 14, 2013 at 11:02 am

PayPal calculates the taxes. I know it’s a PayPal issue, but still it’s odd.

The support post ‘Paypal problems – incomplete transactions (continued)’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso