I lost some PayPal orders - how do I find the details?

DrByte:

Yes .. in fact, the details are stored. Encrypted. Safely. Waiting for PayPal to successfully talk back to your store and let you know that the order is SAFE to release to your customer.

Dr. Byte... so, how do you go about getting the information for these orders that have already been placed? I believe I have this all set up correctly now, but I need to get info on an order that was placed prior to my changes (that I received payment for but didn't not show up in my order history).

Steph,
There's a contribution floating around called PayPal Session Viewer which allows you to snoop at the raw details of those stored orders. Remember though that the data you'll see when using it includes all orders, even the ones that were aborted and never paid for !

Thank you so much for the quick response. I installed the Session Viewer found here...

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=84

However I receive the following error when trying to view the report...

Displaying 6 records...
PAYPAL SESSION INFO for record #3, which expires on 1175597192
Session_ID=2e145eb3844d0c196645e878369359c7
customers_host_address => c-71-201-104-215.hsd1.il.comcast.net
cartID => 27775

Catchable fatal error: Object of class shoppingCart could not be converted to string in /hermes/web05/b141/pow.cheezylu/htdocs/pinkpuppy/htdocs/store/admin/view_stuck_paypal_orders.php on line 71

I am running Zen 1.3.7 with the Google Checkout Module installed.

Line 71 of the above mentioned file is...

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

Any ideas?

At the top of /admin/view_stuck_paypal_orders.php, you have a line that says:```
require('includes/application_top.php');

Immediately AFTER that line, add this new line:```
error_reporting(0);
```This will suppress the warnings that PHP 5.2.0 no longer handles well. 
It should still show the data fine.

Or try the suggestion here: <http://www.zen-cart.com/forum/showpost.php?p=384852&postcount=1>

That took care of the error message, but I don't get any more information other than the five lines it displayed prior to the error message.

Also, it seems to log me out every time I visit that page. If I try to navigate to another page in admin or even just refresh I have to log back in. Any thoughts?

Is there a way to find this information in the database? If so, which table should I look in? I poked around and didn't find anything useful, but I'm sure I'm just not looking in the right place.

By the way... thank you so much for taking the time to help. I really appreciate it.

If you want to try your hand at it, the data is encrypted in the "paypal_sessions" table.
The PayPal Sessions Viewer simply extracts the data, decrypts it, and displays it in a readable format.

Hmmm... well, I suppose I don't know how to go about that. Any idea why it only display a few lines even though it says it has six records?

Displaying 6 records...
PAYPAL SESSION INFO for record #3, which expires on 1175597192
Session_ID=2e145eb3844d0c196645e878369359c7
customers_host_address => c-71-201-104-215.hsd1.il.comcast.net
cartID => 27775

I tried reinstalling the session viewer and I get the same result. This is so frustrating. I'm tired of sounding like an idiot to my customers by asking them to tell me what they ordered. Now, I believe I have fixed the PayPal communication error, but it would be nice to have the session viewer as a backup just in case. I had a similar problem with OSCommerce which is why I switched. It has to be something I'm doing wrong, but I went over everything so many times I can't see where the problem might be. If anyone has any advice, it would be most welcomed.

If you need any further information from me, please let me know. Thanks!

I'm having similar problems. The fix listed above got rid of the error message, but when I try to use the session viewer it seems to give up when it gets to cartID of the first record:

Displaying 2 records...
PAYPAL SESSION INFO for record #2, which expires on 1181494596
Session_ID=cf96f0976ab0069d77632419240f86de
customers_host_address => host86-145-157-197.range86-145.btcentralplus.com
cartID =>

And yes, it is very annoying that it logs me out at this point. Please help us someone!!!:onfire:

Did you direct paypal back to the correct page in your store once payment has been made? Check in your PayPal profile.

Yep, I think that's ok - it goes back to the main handler.

The stuck order viewer just won't work on mine - I'm still getting the irritating problem outlined above. Does anyone know how to fix it? Failing that, how do I extract the order data manually?

I never got the viewer to work properly. I did end up fixing the paypal problem, but for those orders placed prior to the fix I had to look like an idiot to my customers and ask what they ordered. VERY frustrating. If anyone knows the solution, I would be very interested.

Disable the IPN and just use express checkout. It will display to you all of the items that the customer ordered.

The same thing happened to me, luckily I had User Tracking mod installed and I could see what the user had added to cart and checked out.

I just use the Session Viewer to find out these missing orders.
But this is a temporary method.

Does someone know:

1. why this problem suddenly happen, before 31th Oct. was working fine.
2. will this problem lasting for a long time or just a few day? Is paypal doing some change these days?

thank you, DrByte, for the Session Viewer .

Regards