order received in paypal but not in zc

I received a PayPal payment notification of a new order but did not get the notification from ZC. I logged in to PayPal and the payment was received fine. Then I logged in to ZC but the order isn't there. The customer is there but his order isn't.

How do I figure out what he ordered??

TIA.

I am having the same problem. I got payment from paypal but their is no order in ZC.

This is the second time this has happened to me and it happened once to one of my store clients. Since it happened the first time I have received other orders.

I am running Version 1.3.7

Need help....

Thanks

If you are getting payments in PayPal but not seeing the order in Zen Cart, then you have a communications problem between PayPal's server and yours ... which is preventing PayPal from telling your store that the order has been paid-for.

http://www.zen-cart.com/wiki/index.php/PayPal

I completed all those steps when I setup the store a couple years ago. Nothing changed on the site so I don't know why it would suddenly stop working--on just one order. Since I posted the original message, my site has processed three orders. All of them worked correctly.

So now my question is, what can I do to push through that order that didn't work?? I have the zenid number from the PayPal transaction detail page.

Thanks.

You can pull the raw product-id number and quantity info from the database using the "paypal sessions viewer" addon in the downloads area.

Cool, thanks! I wanted to make sure there wasn't some other preferred method before I started installing a bunch of add ons.

I just started having the same problem :shocking:

So, am I to understand that that actual order information is contained in the PayPal sessions information? I can't find any information on the order in the other tables, such as orders... :frusty:

I'll try the 'PayPal Sessions Viewer' to see if this gets me the order information as indicated. Hopefully that will get me what is needed to not have to contact the customer to find out what they ordered...

Then the next step, what could have changed in the communications channel between PayPal and my server? What do I need to be asking my host about, as I'm sure I've changed nothing on the site itself.

Everything was working fine within the last month and this week, it's happened twice. The other symptom is that just before this started happening, I started receiving 'IPN Debug message' emails. I'm receiving several per order.

student4ever:

The other symptom is that just before this started happening, I started receiving 'IPN Debug message' emails. I'm receiving several per order.

That only happens "suddenly" when you turn on the debug-to-email option.

This is too frustrating I seem to be having this same issue all of a sudden!

Previous orders and paypal payments have come through fine then suddenly this past week I get 2 paypal payments for orders and ZC admin shows the customers created but no orders???

WHATS THE FIX for this?? Why is this happening suddenly? There have been no changes in my paypal account or server/web host...?

BDCreations:

WHATS THE FIX for this?? Why is this happening suddenly? There have been no changes in my paypal account or server/web host...?

The fix: fix the communication between PayPal's server and your server.

How?
a) make sure your hosting company didn't change anything on your server that's blocking communications from PayPal
b) make sure PayPal is still sending the notifications to your server
http://www.zen-cart.com/wiki/index.php/PayPal

If PayPal's system isn't sending properly, log a ticket in their support system for "Website Payments Standard" (aka PayPal IPN).
http://www.paypal.com/mts

DrByte:

That only happens "suddenly" when you turn on the debug-to-email option.

now, if only I remembered 'suddenly' turning it on... :wacko: :blush:
thanks for the info, I'll be turning that back off.

thanks also for the info on checking with hosting and paypal :clap:

"paypal sessions viewer" works great!

would be even cooler if you could view one at a time and then have the option to convert what you are viewing over to the orders table when you are sure you have a real order, so it can be tracked like orders that went through normally.

student4ever:

would be even cooler if you could view one at a time and then have the option to convert what you are viewing over to the orders table when you are sure you have a real order, so it can be tracked like orders that went through normally.

There are no plans to do that, as that's not a reliable way to process orders. In fact it's rather dangerous. That tool should only be used to attempt to recover known details of occasional failed transactions. Using it regularly indicates there is a bigger problem which needs to be resolved.

Thanks a ton for the info - everything appears to be correct and changed as it should be so here's hoping the next order comes through fine now!! :D

Thanks DrByte, your comments helped me too.

:clap:

student4ever:

now, if only I remembered 'suddenly' turning it on... :wacko: :blush:
thanks for the info, I'll be turning that back off.

thanks also for the info on checking with hosting and paypal :clap:

"paypal sessions viewer" works great!

would be even cooler if you could view one at a time and then have the option to convert what you are viewing over to the orders table when you are sure you have a real order, so it can be tracked like orders that went through normally.

This is possible. There are actually two contributions, one lets you 'push' the orders to the orders table and they will appear just like all other orders. The other version won't. I can't really recall the name of each version, but if you do a search for my user name and 'paypal order not received' you can probably find it.
Apply the latest patch if you haven't done so yet.

I reported this or similar issue some time ago, when I first upgraded to 1.3.7, had never had this issue before that version.

DrByte discovered some bugs and released a patch, that fixed this issue it for me. I've never had a paypal stuck order ever since.

OK, I did a search, the name of the contribution that lets you push stuck orders is PayPal Session Viewer v2.0, this does not appear to be in the download section.

Check this old thread for more details http://www.zen-cart.com/forum/showthread.php?t=59411&highlight=paypal+stuck+order&page=2

Hi guys, I've been getting a few PMs regarding the contribution that allows you push stuck paypal orders. Apparently, the link is dead.

I have attached this contribution here for anyone that needs it. PayPal Session Viewer 2.0

Also, please read this old thread: http://www.zen-cart.com/forum/showthread.php?t=59411&highlight=paypal+stuck+order&page=2

I really think the problem is communication between the paypal and your host, but if you can't find a solution, this contribution might come in handy.
I haven't had the need to use it in a long time since DrByte released a patch that fixed the issue I was having.

tj1:

I have attached this contribution here for anyone that needs it. PayPal Session Viewer 2.0

hi,

I just installed PayPal Session Viewer 2.0 from the link above.
And I get this error, when I choose "view stuck paypal orders" option on "customer" drop down menu:

Displaying 128 records...
PAYPAL SESSION INFO for record #246, which expires on 1200204052
Session_ID=beaf65ab9d2003ff1949235c5cc90818

"Move to other orders database" ( button)

Catchable fatal error: Object of class shoppingCart could not be converted to string in /home/rpgshow/public_html/myadminfolder/view_stuck_paypal_orders.php on line 88

I am using zen-cart 1.3.8.
Just have 1 order lost last night. And new orders came out with no problem.

soundworker:

hi,

I just installed PayPal Session Viewer 2.0 from the link above.
And I get this error, when I choose "view stuck paypal orders" option on "customer" drop down menu:

I am using zen-cart 1.3.8.
Just have 1 order lost last night. And new orders came out with no problem.

I also have same problem with 2.0

Originally having the problem of orders not getting back from paypal.

For the session viewer error, try this.

On line 88 of view_stuck_paypal_orders.php you should see something like:

echo "<strong>$key</strong> => <em>$value</em><br />"; 

replace it with the following:

 
    echo "<strong>$key[B]->_toString()[/B]</strong> => <em>$value[B]->_toString()[/B]</em><br />";