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

[cheezylu]

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).

[DrByte]

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 !

[cheezylu]

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

http://www.zen-cart.com/index.php?ma...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?

[DrByte]

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/showpo...52&postcount=1

[cheezylu]

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.

[DrByte]

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.

[cheezylu]

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

[cheezylu]

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!

[beast666]

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!!!

[numinix]

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