PayPal received but no order in system

tj1:

OK, something else I forgot to mention and seems like a serious issue. Anyone that gets an stuck order should get the PayPal_Session_Viewer_v2.0 and push the stuck order to the orders database ASAP.

http://shoetick.com/PayPal_Session_Viewer_v2.0.zip
Are you managing your own copy of the contribution on your own site nowadays?
Or is this the same one as can be found in the Zen Cart downloads section?

If the stuck order is not moved, any future orders by that customer will have the same content as the original stuck order, regardless of what the customer orders. You need to move all stuck orders to avoid getting future corrupted orders with the different contents and total of what the customer ordered.

This is not entirely accurate. It's an illusion. Actual completed orders -- when they do come through -- will have correct information. However, if PayPal hasn't completed the handshake with your server to deliver the IPN notice successfully, then the customer will see their previous order on the checkout-success page and of course in their My Account area and not the most-recently completed transaction ... until the IPN completes.

Also ... NEVER push an order that has not actually been paid for... ;)

DrByte:

please go to that folder and grab the log files, zip them, and post them here for review.

tj1:

OK, I turned on Debug Logging and have made some test orders.

I have the logs available for all this orders, do you want me to post them?

yes please

DrByte:

Are you managing your own copy of the contribution on your own site nowadays?
Or is this the same one as can be found in the Zen Cart downloads section?

This is not entirely accurate. It's an illusion. Actual completed orders -- when they do come through -- will have correct information. However, if PayPal hasn't completed the handshake with your server to deliver the IPN notice successfully, then the customer will see their previous order on the checkout-success page and of course in their My Account area and not the most-recently completed transaction ... until the IPN completes.

Also ... NEVER push an order that has not actually been paid for... ;)

Hi DrByte, that's not my contribution. LOL, I barely know basic html and almost nothing abour php.

This is not from the downloads section. I got that contribution from the old 'archived contributions' section. It is a modified version of your paypal_sessions_viewer_1.0. The difference is that this one lest you 'push' stuck orders.

Here's the first log. Personal details have been omitted or edited. I paid for this one with my paypal account and did not return to the cart on purpose to see if this is what was causing the error, which it does

Mar 09 2007 14:40 -- IPN PROCESSING INITIATED. 
*** Originating IP: OMITTED

Mar 09 2007 14:40 -- IPN NOTICE::ipn_application_top -> language files okay

Mar 09 2007 14:40 -- IPN INFO - POST VARS received (sorted): 
Array
(
    [business] => [email protected]
    [charset] => windows-1252
    [custom] => zenid=dfa654df6as4df6a6df4a65f46a
    [first_name] => Testname
    [item_name] => mystore.com Purchase
    [item_number] => 1
    [last_name] => Testlastname
    [mc_currency] => USD
    [mc_gross] => 2.31
    [notify_version] => 2.1
    [payer_email] => [email protected]
    [payer_id] => ABCDEF1234567
    [payer_status] => verified
    [payment_date] => 11:40:19 Mar 09, 2007 PST
    [payment_gross] => 2.31
    [payment_status] => Pending
    [payment_type] => instant
    [pending_reason] => address
    [quantity] => 1
    [receiver_email] => [email protected]
    [receiver_id] => 1234567ABCDEF
    [residence_country] => US
    [shipping] => 0.00
    [tax] => 0.00
    [txn_id] => 1234567890abc
    [txn_type] => web_accept
    [verify_sign] => asdfa6544a5df465-a9d4a65d4f9a84d65fa2d49a8789d4f56as6s
)


Mar 09 2007 14:40 -- IPN INFO - POST VARS sent back for validation: 
To: ssl://www.paypal.com (443)
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 714
Connection: close

Array
(
    [txn_type] => web_accept
    [payment_date] => 11:40:19 Mar 09, 2007 PST
    [last_name] => Meza
    [residence_country] => US
    [pending_reason] => address
    [item_name] => mystore.com Purchase
    [payment_gross] => 2.31
    [mc_currency] => USD
    [business] => [email protected]
    [payment_type] => instant
    [verify_sign] => asdfa6544a5df465-a9d4a65d4f9a84d65fa2d49a8789d4f56as6s
    [payer_status] => verified
    [tax] => 0.00
    [payer_email] => [email protected]
    [txn_id] => 1234567890abc
    [quantity] => 1
    [receiver_email] => [email protected]
    [first_name] => Testname
    [payer_id] => ABCDEF1234567
    [receiver_id] => 1234567ABCDEF
    [item_number] => 1
    [payment_status] => Pending
    [shipping] => 0.00
    [mc_gross] => 2.31
    [custom] => zenid=dfa654df6as4df6a6df4a65f46a
    [charset] => windows-1252
    [notify_version] => 2.1
    [cmd] => _notify-validate
)


Mar 09 2007 14:40 -- IPN INFO - Confirmation/Validation report 
HTTP/1.1 200 OK
,Date: Fri, 09 Mar 2007 19:40:37 GMT
,Server: Apache/1.3.33 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a mod_ssl/2.8.22 OpenSSL/0.9.7e
,Set-Cookie: cookie_check=yes; expires=Mon, 06-Mar-2017 19:40:37 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=26.18.9.17.70311746923627; path=/; expires=Sun, 01-Mar-37 19:40:37 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8  
,VERIFIED
,0
,


Mar 09 2007 14:40 -- Breakpoint: 1 - Collected data from PayPal notification

Mar 09 2007 14:40 -- Breakpoint: 2 - Validated transaction components

Mar 09 2007 14:40 -- Breakpoint: 3 - Communication method verified

Mar 09 2007 14:40 -- IPN WARNING::Could not find matched txn_id record in DB. Therefore is new to us. 

Mar 09 2007 14:40 -- Breakpoint: 4 - Details:  txn_type=unique    ordersID = 0 IPN_id=0
Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 1234567890abc

Mar 09 2007 14:40 -- Breakpoint: 5 - Transaction type (txn_type) = pending-address

Mar 09 2007 14:40 -- IPN NOTICE:: pending-address transaction -- inserting initial record for reference purposes

Well, I installed the patch dated March 3. And it all seemed to be working fine again, but now today, I have had 3 out of 4 orders mess up. Back to where i get confirmation that paypal payment has been made, but the order is no where to be found.

This is a real problem for us, becuase these are DOWNLOAD files that people are purchasing. And therefore they aren't getting the download links to their files, because there is no order there. I can't email them out to everyone, we have over 1,000 downloads available in the store, and some people order like 10-30 items. To get all of those downloads from the server and then email them to customers because their order doesn't show up is a PITA.

I did download the other STUCK order thing, and can see the orders, but there is so much coding, and it only lists product ID's that it would take me hours to sift through all of our products to find Product ID 722 for $1.99.

I hope this is something that can be resolved soon!

Two of the three customers responded back to an email I sent, and they both said they used CREDIT CARD PAYMENT with PAYPAL. I thought this problem was because of E-Check or something, but this is happening with Credit card payments now too.

Once again... its not the patch. Its PP. It is FAR too sporatic and unpredictable to be the fault of Zen. The only possibilities are 1) Its PayPal or 2) its your server.

• Steven

While I appreciate you saying it's not the patch, or the new version of the cart, I don't know how IT CAN'T BE!!

I've been running the cart just fine, without this problem. Until Feb 1, when I upgraded to the new cart version.

I have processed over 1,000 orders WITHOUT this problem occuring, then I upgraded the cart this last time, and it occured from the VERY first Paypal e-check order that was placed. At that time, it was only occuring with e-check transactions.

I installed the patch on or around March 3 (there wouldn't be a patch if this wasn't a known issue!) and it seemed to be working just fine. Until today. 3 out of 4 orders didn't process all the way through.

Only this time it isn't echeck transactions, it's credit card through paypal transactions. I do not have Paypal Express enabled, just Paypal IPN.

Now, I'm just a store owner, muddling my way through the online retail world. I don't begin to claim that I understand all this coding, etc, but I can read directions quite well, and follow manuals step by step. So, my question to you is, you are saying this is just coincidence that this started happening from DAY ONE of the software upgrade, but isn't anything to do with the upgrade or subsequent patch, but is rather an issue with my server or paypal, even though prior to this upgrate it wasn't an issue?

I did put in a support ticket with Paypal, and they say the order was processed on their end, so it's a software issue on Zen cart end. So, then if it's one or the other, how are you suggesting we proceed?

s_mack:

Once again... its not the patch. Its PP. It is FAR too sporatic and unpredictable to be the fault of Zen. The only possibilities are 1) Its PayPal or 2) its your server.

• Steven

You're wrong, I hate to admit it too, but this time is not paypal's fault.

Have you read any of my previous posts? ZC receives all the info correctly from paypal. As soon as the payment is received it shows up under Customers>PayPal IPN. It's ZC that's not completing the order for some reason.

paperthreads, there are two paypayl stuck session viewer mods, version 1 and version 2. The one in the downloads section is version 1 look at one of my previous posts in this thread for the link for version 2, this one allows you push orders to the orders area, it's much easier than figuring it out with version 1.
Make sure payment has been received before pushing stuck orders. It's helpful to have two windows open, Customer>PayPal IPN and Customers>View Stuck PayPal orders. This way you can see which stuck orders you need to move based on payments received.

tj1,

i just did the version 2, but I don't know where in the english.php file to put the following:

define("PAYPAL_SECRET_WORD", "mysecretword");

I placed this in the english.php file, like this:

// push order
define("PAYPAL_SECRET_WORD", "xxxxxxx");

But, when I go in to the stuck order screen, I get the button MOVE ORDERS to DATABASE

I click on it, and it gives me an error that:
Not Found

The requested URL /pushorder.php was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
*

I put the pushorders.php in the /store folder on my server, is it supposed to go somewhere else?
*

ok, well, i got it to work, sort of....

I have to manually fix the URL with the /pushorder.php, then I get another page error, and I backup and do the same thing, fixing the url and it will go through! Dont' know why it will work the second time each time, but not the first time.

At least I was able to recover 3 of my orders, and can now ship them out! :)

Hope that this gets resolved soon, no matter if it's a paypal or zen cart issue....so that I don't have to do that often!

paperthreads:

tj1,

i just did the version 2, but I don't know where in the english.php file to put the following:

define("PAYPAL_SECRET_WORD", "mysecretword");

I placed this in the english.php file, like this:

// push order
define("PAYPAL_SECRET_WORD", "xxxxxxx");

But, when I go in to the stuck order screen, I get the button MOVE ORDERS to DATABASE

I click on it, and it gives me an error that:
Not Found

The requested URL /pushorder.php was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
*

I put the pushorders.php in the /store folder on my server, is it supposed to go somewhere else?
*

Don't worry about that error, it's not critical, if you then go to the Customers>Orders, you will see the order now appears there, even if you got that error. You receive this error because it's looking for /admin/orders.php and most likely you have renamed the admin folder.

pushorder.php does go in the root store folder. You have to edit it if you have renamed your admin folder as recommended by the ZC team for security.

pushorder.php has the following at around line 72

Header("Location: /admin/orders.php");

just replace 'admin' to whatever you have renamed your admin folder.

As for the secret word, yes, you do add the define somewhere to the english.php file, but remember, if you are using override folders, as everyone should, add it to your override english.php file instead.

The installation instructions are not completely clear, this mod hasn't been updated in a long while.

NOTE: there is a new PayPal Patch release for March 15th ...
http://www.zen-cart.com/forum/showthread.php?t=56216

Thanks for letting me know! I didn't see this posting. going to the link and adding it now! Hoping it works!

Well, I installed the patch dated March 15, overwrote all of the previous files from the March 3 patch, and still having the same problem.

I lost 2 orders last night, one at 230 am EST, the person paid with Paypal using a credit card, the second at 715 am EST, the person used cash balance from their paypal account.

At least I'm able to now push the order through, but that wasn't before waking up to find I had received upset emails from customers who think they got ripped off (becuase our files are downloads, and the site says they will be immediately available when payment is made with credit card or cash balance through paypal!)

So, this is really really frustrating. This did not happen once prior to the upgade......

Can you please post your PayPal IPN transaction logs ?

Hi Dr. Byte!

I would love to, but I don't know how!

I get a notice from Paypal showing a payment has been made. I can go into Customer>View Stuck orders, and see the order there and push it through, but when I go to VIEW > PAYPAL IPN, there is nothing there.

How do I get the logs?

http://www.zen-cart.com/forum/showthread.php?t=61199

Ok, I have the debug email activated, but I'm not even getting emails showing there is a problem, that is until this very last transaction.

This is the message I got:
IPN FATAL ERROR (1174497026_Jadn) #1
IPN FATAL ERROR :: Could not establish fsockopen. Host Details = www.paypal.com:80 (110) Connection timed out

Hope that helps in resolving this! It seems in the past 2 days, I have about 50% of my orders not showing up in the orders. And it doesn't matter how they use Paypal (I only have IPN set up, don't have Express), but it happens whether its payment by credit card, paypal balance or echeck.

Could not establish fsockopen. Host Details = www.paypal.com:80 (110) Connection timed outThat means that when PayPal sends you a noticed that there's an order waiting, your server is unable to talk back to PayPal to confirm that you've received their notification.

That's typically because your webserver has ports blocked or requires a proxy server. That issue is discussed here:
http://www.zen-cart.com/wiki/index.php/PayPal

You'll need to talk to your hosting company about why port 80 is blocked for outbound communication via PHP fsockopen() function calls.