Pay Pal IPN is not carring over my orders

[Ajeh]

Turn on the debug and run it ...

[golowenow]

Ajeh, I have run the debug several times and posted it in the above posts. Dr. Byte cannot seem to figure it out either. For some reason the information is not being saved in the database. It seems to be changed when redirected to the paypal website. All steps are working properly and the items are listed up to the point when you finalize the order. At that point they are lost. Even tried different variants of cache file saving ie; db and blank for sessions. I prefer the file cache system using the cache folder in zencart as when I run session saves on the MySQL server the sessions table has a tendency to crash. Please look at the previous posts for debug info as it will be the same.

[golowenow]

One more bit of information. Customer is receiving paypal confirmation but no ORDER CONFIRMATION from the store.

[katrobb]

Hello,
I am having problems with the order not showing in Admin after a PayPal eCheck was received.
I have v 1.3.7 and I have just updated to PPEC-137-patches-March21-2007.
I have removed and re-installed the Modules>Payment>PayPal IPN.
I am not currectly using the PayPal Express Checkout.
I have tested a PayPal credit card sale and it works fine, as does the refund. I do not know how to test a eCheck sale quickly.
I cannot find the Stuck Order module in Downloads.

MySQL is v 4.1.18.
I looked in the database, but I could not find the information.
In customer_basket, there is no listing for this customer.
In orders, orders_products, and paypal, there is no listing for this customer.

In orders_status_history, there IS a listing, but the order_id = 0. The status is 2 for Processing.
In paypal_payment_status_history, there IS a listing, but the paypal_ipn_id = 0.
In paypal_sessions, there IS a listing.

Am I missing anything? Is there a way to retrieve the information? The patches seem to fix new orders, not current.

Thank you in advance for any help.
Katrina

[katrobb]

Hello,
I found the Stuck Order module, which is named Paypal Sessions Viewer. It is in Downloads>Admin Tools>Paypal Sessions Viewer.
I also found my lost order.

To help others, this is what I did.
I installed the Paypay Sessions Viewer module.
I found my customer and Zen session id in PayPal’s transaction details (PayPal's website).

In Customers>View Stuck PayPal, I found the session_id.
Under cart – contents - the first number is the product_id. I have a list of product ids, but if you do not, you can go in to MySQL and browse the products_description (for the name of the product) or browse products (for the model number). Click on search. Type the product_id in that field and click Go. Now you have your product.

If you have an attribute:
Under cart-content-attributes, you see a number (example 1 => 351). This is the option_value_id (example 351). Go to MySQL and browse the products_attributes. Click on Search and type the option_value_id in that field. Click on Go. You will find the product_attributes_id.
Go back to Zen Cart/Admin. Under Catalog>Attribute Controller, find your product and display it. In the attribute area, you will find the product_attributes_id in the first column. Now you know your attribute.

From there, I placed an order under my customer account to correct the inventory and to keep track of the order. I sent my customer an e-mail for the order confirmation.

Hopefully the newest PPEC patches will work for future orders.

Katrina

[wishy]

One more bit of information. Customer is receiving paypal confirmation but no ORDER CONFIRMATION from the store.

Can I jump in here to mention this is the same issue I'm experiencing and discussing in the thread, PayPal Woes. It appears I'm not the only one experiencing difficulties here so it's kind of a relief (of sorts) to know that it may be software related rather than user (me) error. Anyone got any clues about a fix?

tia
wishy

[Ajeh]

Did you load the latest PayPal Patch for v1.3.7?
http://www.zen-cart.com/forum/showthread.php?t=56216

Did you try hitting Remove ... Install and reconfigure it?

NOTE: Make sure all files upload and overwrite the old files when installing the Patch ...

[wishy]

Did you load the latest PayPal Patch for v1.3.7?
http://www.zen-cart.com/forum/showthread.php?t=56216

Did you try hitting Remove ... Install and reconfigure it?

NOTE: Make sure all files upload and overwrite the old files when installing the Patch ...

That's yes to all of those, I regret to say. I've posted up a suspicious section of the debug log file in the thread titled paypal woes - looks suspect but obviously I'm floundering.

wishy

[wishy]

That's yes to all of those, I regret to say. I've posted up a suspicious section of the debug log file in the thread titled paypal woes - looks suspect but obviously I'm floundering.

wishy

Anyone got any further ideas regarding this paypal problem? I've installed the latest patch, uninstalled and reinstalled the module but still my paypal payments are resulting in no orders, no acknowledgements. Anyone in the same boat managed to tackle this? I'm stumped.

wishy

[tiztc]

I contacted an IT specialist last week the advice given to me was Backup products and all other info - then delete and reinstall the latest zencart. Thats the only help i can offer - i am actually handing the shopping cart side of things over to a specialist.