Pay Pal IPN is not carring over my orders

OK tried one other change.
Changed:

define('SQL_CACHE_METHOD', 'none');

to:

define('SQL_CACHE_METHOD', 'database');

and ran test with same negative results. That's all I have for now.:(

golowenow:

Each test is costing me on PayPal as I have Premier accounts and thus have to pay fees LOL. Good luck on researching this. Wow! a lot of views on this thread aye??:smartalec:

If you refund the transaction, you don't pay the fees ...

I made another thread about this. I didnt know this one was here.
Have done the latest update then did it again after doing feb 19th. Sounded important.
Same problem still. Product info does not carry over to paypal, I still get no order info in Admin and order email contains no product info. Says Item #1.

Please help, Paypal IPN is my only checkout. Thank You,
John :frusty:

Okay, This is killing me here. After doing the mar 21 patch again it still didnt fix my problem. Now this all worked fine about 5 days ago.
The only thing that I have messed with in my store since that last successful IPN checkout was to add Paypal Express Checkout. Then I removed it because I dont have SSL at the moment. How could that be the cause?

I have tried everything that I can think of and its not working.
I called Godaddy :oops: . As soon as I said Zen Cart the tech became a jerk.
Long story short, They havent changed anything that would make this happen.

Really really really hurtin here folks. Please help

John,
Your issue is slightly different from the most recent posts in this particular thread.
I have replied to your other post with ideas, esp since it deals with GoDaddy specifically.
http://www.zen-cart.com/forum/showthread.php?t=63165

Ok i have read this thread (but as i am obviosly computer stupid and when i hear the term ftp server i firmly believe people are swearing at me :blush: lol) i am unable to add a patch - would someone mind explaining how to do this please.

Read another post from Mar 4 stating a similar issue. When they switched from PHP5 to PHP4 the IPN module worked. This is probably the issue. Wondering though if perhaps the combination of PHP5 and MySQL 5.0 is effecting the module.

Have not seen any posts to this in a bit. I tried doing a complete install of the newest zencart. Then added the PayPal Express patch(March 21). A totally clean installation and the IPN module will still not save the items purchased. Invoices are still blank of items. Whatever the Express module is doing to save this info needs to be applied to the IPN module. The express module works perfectly. Since the express module works I do not think there is a problem using newest PHP and MySQL versions. This is an issue with the patches.:blink:

Try to uninstall and reinstall and configure your PayPal IPN module ...

Like I said I totally reinstalled the zencart and the latest patch. Then fresh installed both the IPN and Express modules. The Express module works fine. The IPN does not. There is something wrong with the patch. It is either incompatible with PHP 5 or the MySQL version 5.0 or a combination of both. It will not retain the items ordered in the database yet it WILL with the Express module. Thus as previously posted the images of the paypal page and the invoice page are the same. NO ITEMS LISTED. It will take the payment at paypal but the items do not revert to SOLD OUT. I guess I will open another bank account at a different bank so that I can get my wifes paypal account verified so she can use the Express module also and totally uninstall the IPN module on her site also since it is now junk to me:censored: I have been dealing with this for weeks and am really tired of thinking about the stupid thing. Maybe it will get fixed on the next update. All I know is I have tried EVERY option imaginable from rebuilding the database installing uninstalling changing settings in configs on and on and on. Others are having the same issue yet there is no fix soooo:lamo: guess it will never happen for MEEEEE! Enough venting...hehe.

Turn on the debug and run it ...

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.:smartalec:

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

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

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

golowenow:

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

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

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

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

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.