Jump to content

paypal status change


peterp

Recommended Posts

Hi all,

I have a client that is using paypal IPN and ver 6.2 of cubecart znd what is happening is that the status is not being changed from pending to processed. I have checked the request log and there does seem to be any invalid responses and I can see that the order request has been sent and all looks ok( see below) but the status is not being changed therefore no emails are being sent.

   
Today, 14:58
Request Sent - https://ipnpb.paypal.com/cgi-bin/webscr cmd=_notify-validate&mc_gross=0.01&invoice=180522-145657-3361&protection_eligibility=Eligible&address_status=confirmed&payer_id=8DANFV5AP2D76&address_street=1&payment_date=21%3A57%3A58+May+21%2C+2018+PDT&payment_status=Completed&charset=windows-1252&address_zip=2450&first_name=Debra&mc_fee=0.01&address_country_code=AU&address_name=Sally+Best¬ify_version=3.9&custom=&payer_status=unverified&business=orders%40zippytieman.com.au&address_country=Australia&address_city=Upper+Orara&quantity=1&verify_sign=Ak171esEOv-co2E0sYKmQ0WNitcSAU5kLX6pogUPzIDYF7XcrmAm6AfK&payer_email=debbancroft1102%40yahoo.com.au&txn_id=56L21637KM714672X&payment_type=instant&last_name=Bancroft&address_state=New+South+Wales&receiver_email=orders%40zippytieman.com.au&payment_fee=&shipping_discount=0.00&insurance_amount=0.00&receiver_id=75QRY9W3Z2RJ6&txn_type=web_accept&item_name=Order+180522-145657-3361&discount=0.00&mc_currency=AUD&item_number=180522-145657-3361&residence_country=AU&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=dec628c297478
Response received VERIFIED

I was wondering if anybody else has had this issue and if so could you point me in the right direction to fix this

Thankyou

Best Regards,

Peterp

Link to comment
Share on other sites

With VERIFIED, there is supposed to be a note logged. In admin, Transaction Logs, find the order that just happened (probably on the last page) and click on the Order Number link.

The Notes you see are CubeCart's interpretation of the actual status that PayPal sent back along with VERIFIED. The Request copies back to PayPal what was in the IPN.

So, we see specifically that "payment_status=Completed". You should see a log entry that starts with "Payment successful."

What do you see in the Transaction Logs?

Link to comment
Share on other sites

Hi Brian,

Transaction Logs for Order 180522-144115-6381

Transaction ID Status Amount Gateway Date/Time Notes
01N9900025750423D Pending $0.01 PayPal Today, 14:45 The payment is pending; see the pending_reason variable for more information. Please note, you will receive another Instant Payment Notification when the status of the payment changes to 'Completed', 'Failed', or 'Denied'.

Transaction Logs for Order 180522-142000-9118

Transaction ID Status Amount Gateway Date/Time Notes
5ST45875P7181052X Pending $0.01 PayPal Today, 14:25 The payment is pending; see the pending_reason variable for more information. Please note, you will receive another Instant Payment Notification when the status of the payment changes to 'Completed', 'Failed', or 'Denied'.

 

This is what was in the transaction log for the last 2 orders there is no entry that states that the transaction was successful, however there is status of pending which effectively is the  problem as far as PayPal is concerned it has been paid.

thanks for the help I am at my wits end with this one.

Best regards,

Peterp

Link to comment
Share on other sites

The Request Log entry quoted earlier is for order 180522-145657-3361, while the Transactions Log entries above are for orders made earlier in the day.

Let's look at the Request Log entries logged at about 14:45 and 14:25 on the 22nd.

Link to comment
Share on other sites

Hi Brian,

The request log for the times you requested are for a paypal sandbox, I have included them below with the request log for the order 180522-145657-3361

Yesterday, 14:58
Request Sent - https://ipnpb.paypal.com/cgi-bin/webscr cmd=_notify-validate&mc_gross=0.01&invoice=180522-145657-3361&protection_eligibility=Eligible&address_status=confirmed&payer_id=8DANFV5AP2D76&address_street=1&payment_date=21%3A57%3A58+May+21%2C+2018+PDT&payment_status=Completed&charset=windows-1252&address_zip=2450&first_name=Debra&mc_fee=0.01&address_country_code=AU&address_name=Sally+Best¬ify_version=3.9&custom=&payer_status=unverified&business=orders%40zippytieman.com.au&address_country=Australia&address_city=Upper+Orara&quantity=1&verify_sign=Ak171esEOv-co2E0sYKmQ0WNitcSAU5kLX6pogUPzIDYF7XcrmAm6AfK&payer_email=debbancroft1102%40yahoo.com.au&txn_id=56L21637KM714672X&payment_type=instant&last_name=Bancroft&address_state=New+South+Wales&receiver_email=orders%40zippytieman.com.au&payment_fee=&shipping_discount=0.00&insurance_amount=0.00&receiver_id=75QRY9W3Z2RJ6&txn_type=web_accept&item_name=Order+180522-145657-3361&discount=0.00&mc_currency=AUD&item_number=180522-145657-3361&residence_country=AU&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=dec628c297478
Response received VERIFIED
Yesterday, 14:45
Request Sent - https://ipnpb.sandbox.paypal.com/cgi-bin/webscr cmd=_notify-validate&mc_gross=0.01&invoice=180522-144115-6381&protection_eligibility=Ineligible&address_status=confirmed&payer_id=HC498LDWJ7RPS&address_street=1%0D%0Asnith&payment_date=21%3A45%3A21+May+21%2C+2018+PDT&payment_status=Pending&charset=windows-1252&address_zip=2450&first_name=Peter&address_country_code=AU&address_name=sally+glenton¬ify_version=3.9&custom=&payer_status=unverified&address_country=Australia&address_city=coffs+harbour&quantity=1&verify_sign=A8PiOurJ1pfGWJsUernojno.idsRAC3R1iHGIVCxunP3rcRGFEonaXG5&payer_email=peter%40blackdogenterprises.com.au&txn_id=01N9********0423D&payment_type=instant&last_name=Prentice&address_state=New+South+Wales&receiver_email=orders%40zippytieman.com.au&pending_reason=unilateral&txn_type=web_accept&item_name=Order+180522-144115-6381&mc_currency=AUD&item_number=180522-144115-6381&residence_country=AU&test_ipn=1&transaction_subject=&payment_gross=&ipn_track_id=23efde64973bc
Response received VERIFIED
Yesterday, 14:25
Request Sent - https://ipnpb.sandbox.paypal.com/cgi-bin/webscr cmd=_notify-validate&mc_gross=0.01&invoice=180522-142000-9118&protection_eligibility=Ineligible&address_status=confirmed&payer_id=HC498LDWJ7RPS&address_street=1%0D%0ASmith+Street&payment_date=21%3A25%3A31+May+21%2C+2018+PDT&payment_status=Pending&charset=windows-1252&address_zip=2450&first_name=Peter&address_country_code=AU&address_name=sally+glenton¬ify_version=3.9&custom=&payer_status=unverified&address_country=Australia&address_city=Coffs+Harbour&quantity=1&verify_sign=AQoT17pkcamS6fK8eElyumvkzolZAAqQFpXaVvSydlDxfQUnN8NB7YjS&payer_email=peter%40blackdogenterprises.com.au&txn_id=5ST45875P7181052X&payment_type=instant&last_name=Prentice&address_state=New+South+Wales&receiver_email=orders%40zippytieman.com.au&pending_reason=unilateral&txn_type=web_accept&item_name=Order+180522-142000-9118&mc_currency=AUD&item_number=180522-142000-9118&residence_country=AU&test_ipn=1&transaction_subject=&payment_gross=&ipn_track_id=c0dcc1e49ff4c
Response received VERIFIED
 
180521-130755-3493 $96.95 NAB 21 May 2018, 13:08
180522-142241-1500 $100.75 NAB Yesterday, 14:23
180522-142000-9118 $0.01 PayPal Yesterday, 14:25
180522-144115-6381 $0.01 PayPal Yesterday, 14:45
180522-205552-7267 $12.95 Bank Transfer Yesterday, 20:55
180522-211414-9901 $12.95 Bank Transfer Yesterday, 21:14

 

There is not a transaction log for the order invoice=180522-145657-3361

This order was still being verified at a later time even into today which I'm putting down to the cubecart is still trying to accept it please see the request log for later in the day (see below)

There is probably no request log as the transaction has not been accepted yet

 

Thanks Brian I hope this is helpful

Best Regards,

Peterp

 
Link to comment
Share on other sites

Making a very close examination of what was sent back in the Request from what PayPal POSTed to CubeCart, I see this part:

Request copied from what was in POST:

&first_name=Debra
&mc_fee=0.01
&address_country_code=AU
&address_name=Sally+Best¬ify_version=3.9
&custom=
&payer_status=unverified

00000160h: 79 2B 42 65 73 74 C2 AC 69 66 79 5F 76 65 72 73 ; y+Best¬ify_vers

Expected POST (sample):

[first_name] => Test
[mc_fee] => 0.39
[address_country_code] => US
[address_name] => Test User
[notify_version] => 3.0
[custom] => 
[payer_status] => verified

So, we see that at some point, the stream of data got corrupted between 'address_name' and 'notify_version'.

But, there is a VERIFIED response, which suggests that what CubeCart put in the Request does match what PayPal was expecting to see.

We will need to add code that will send diagnostic data to the error_log where CubeCart tells the Order class to move the order to PROCESSing.

In the short-term, make sure this customer and data in the addressbook (wherever address_name comes from) are valid with no odd characters.

Link to comment
Share on other sites

Hi Brian,

I have had the client to enter a order and to use the correct data in each of the fields for the name and address fields that need to be filled out when using the secure checkout, that is there was no silly data it was all real, unfortunately the corrupt looks as though it still has happened which means we got the same result of a pending order. As far as PayPal is concerned it is a paid transaction but this is not been transmitted to cubecart. The request log is below for the order

Today, 09:45
Request Sent - https://ipnpb.paypal.com/cgi-bin/webscr cmd=_notify-validate&mc_gross=0.01&invoice=180524-105622-8343&protection_eligibility=Ineligible&address_status=confirmed&payer_id=7NZNWYWRUPJG8&address_street=212%0D%0AMount+Browne+Road&payment_date=17%3A58%3A32+May+23%2C+2018+PDT&payment_status=Completed&charset=windows-1252&address_zip=2450&first_name=Sally&mc_fee=0.01&address_country_code=AU&address_name=Sally+Glenton¬ify_version=3.9&custom=&payer_status=unverified&business=orders%40zippytieman.com.au&address_country=Australia&address_city=Upper+Orara&quantity=1&verify_sign=AyT6.xRA589q33YWBduptUmRz9IyAPuINt-tq22p1RgaTbIHMpHrbmwu&payer_email=accounts%40zippytieman.com.au&txn_id=5HS2********5944L&payment_type=instant&last_name=Glenton&address_state=New+South+Wales&receiver_email=orders%40zippytieman.com.au&payment_fee=&shipping_discount=0.00&insurance_amount=0.00&receiver_id=75QRY9W3Z2RJ6&txn_type=web_accept&item_name=Order+180524-105622-8343&discount=0.00&mc_currency=AUD&item_number=180524-105622-8343&residence_country=AU&receipt_id=0083-6045-3411-6404&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=efd01b5c9d2ff
Response received VERIFIED

 

Order Summary

 

Change Status
Order Status
Delivery Address Sally Glenton
212
Mount Browne Road
UPPER ORARA
NEW SOUTH WALES, 2450
Australia Billing Address Sally Glenton
212
Mount Browne Road
UPPER ORARA
NEW SOUTH WALES, 2450
Australia

Order Date: 24 May 2018, 10:56

Items
1 x Test Product (Not For Sale) - test-Product ($0.00)$0.00
Subtotal:$0.00
Total Discount :$0.00
Shipping:$0.01
Total Tax:$0.00
Total:$0.01
Contact Details
Phone / Mobile0415725110
IP Address49.176.167.211
Shipping Information
Shipping MethodAll In One Shipping
Shipping ProductTest Only
GatewayPayPal
 
 
It seems to have corupted the same data as before so is the fault of what cubecart is sending or is it something the PayPal IPN api is causing, we are using the standard PayPal gateway.
 
 
I honestly do not know where to go from here.
 
I don't know enough about PayPal standard to ascertain whether it is a PayPal issue or a cubecart issue
Any help will be appreciated
Best Regards,
Peterp
Link to comment
Share on other sites

Hi Brian,

I have done some more investigating and when I go to the PayPal history I have found that a http error 500 has occurred (see attachment)

When I try to run the notification url that is displayed I just get a blank screen.

I have attached the request sent that marries up with the paypal history see below

Today, 02:43
Request Sent - https://ipnpb.paypal.com/cgi-bin/webscr cmd=_notify-validate&mc_gross=0.01&invoice=180525-151541-6008&protection_eligibility=Eligible&address_status=confirmed&payer_id=8DANFV5AP2D76&address_street=p.o.+box+5264&payment_date=22%3A20%3A10+May+24%2C+2018+PDT&payment_status=Completed&charset=windows-1252&address_zip=2000&first_name=Debra&mc_fee=0.01&address_country_code=AU&address_name=peter+prentice¬ify_version=3.9&custom=&payer_status=unverified&business=info%40zippytieman.com.au&address_country=Australia&address_city=mordialloc&quantity=1&verify_sign=ApPV1ESX-mXIUoWN-XfvRdL8u0FJAbR8x2C4AByBQpIDINbdDKJ-y8kk&payer_email=debbancroft1102%40yahoo.com.au&txn_id=52J90157C9072973H&payment_type=instant&last_name=Bancroft&address_state=New+South+Wales&receiver_email=orders%40zippytieman.com.au&payment_fee=&shipping_discount=0.00&insurance_amount=0.00&receiver_id=75QRY9W3Z2RJ6&txn_type=web_accept&item_name=Order+180525-151541-6008&discount=0.00&mc_currency=AUD&item_number=180525-151541-6008&residence_country=AU&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=83125b88c2fa0
Response received VERIFIED

2018-05-26_11-12-21.png.21b1cb8799b3a09da5372645b57fcc35.png

Based on my limited knowledge of the workings of PayPAl it seems that we are getting 500 error code which is causing our issues, however I'm not sure which server is causing what, should I be talking to our hosting people and if so what should they be looking for.

Sorry it seems a bit vague but this problem is really causing me some pain.

I hope these screen dumps are of some help

best regards,

Peterp

Link to comment
Share on other sites

According to the PayPal IPN Message, the data POSTed is not malformed: address_name=peter prentice&notify version=3.9

The question still remains: where is the corruption occuring? Please snd me a PM with your email address. I will reply with a file that I use to examine what CubeCart receives from the web server.

 

Link to comment
Share on other sites

  • 4 weeks later...

Hi Brian,

              Well after an extreme amount of blood sweat and tears the solution to this problem was that there seemed to be an inconsistency between the language selected and the language of the templates that had been defined. Apparently the reason PayPal was failing was because it was waiting for the other email templates to be completed which was not going to happen as they had not been defined. I must admit that I'm not really sure how this caused all of my issues, however when I changed the main language on the store setup to be the same as the templates that had been setup it all worked as expected. This solved the problem.

Thanks for your help with this issue

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...