Paypal echeck 1.3.8a problem

Hi,

I have read many posts and cannot find an answer anywhere. I am running the latest version 1.3.8a and having dramas with the paypal module when people use echeck's. Whenever a customer purchases using an echeck their order never shows up in the admin at all, not even as pending. Everything else to do with the paypal module works fine.

Any ideas on why orders arent showing up after echeck's clear?

Pleas help!
Brad.

Have you double checked your PayPal profile? There is an option to accept or not accept e-checks...

Yes that is all setup correctly as the echeque's process and clear fine into our paypal account but the order never shows up in the zen cart admin.

Surely other people are having this problem?

Brad.

Have you turned on PayPal debug logging?
What do the logs show when the echeck order is placed, and when the echeck clears?

Hi,

I did turn it on a few days ago but the logs folder is empty when i checked it today, i just set permissions on the folder 777 so that might fix the issue, when i get the next echeque go through i'll go and check it.

Brad.

Hi,

OK i did some testing and found that when making a purchase using paypal echeque a log file is created however once the echeque clears there is no log file created for that instance. We receive both the 'pending echeque' email and the 'cleared echeque' emails.

I can post the log files created when an echeque order is placed however i wasnt sure of the privacy issues with that, but if you need the log file to look into this further then i will comment out some sections of it.

Let me know!

Brad.

You can PM me a link to the zip of your log files if you prefer to not have it posted publicly.

I also have that problem with eChecks. Customer completes payment and is returned to Checkout Success, but no order in admin. Please post a solution here if you find one. Thanks.

I've had the same problem since I set up Zen Cart (Version 1.3.7) over a year ago. I get the emails notifying me of the eCheck payment, but nothing shows up in the admin of my store. I usually end up emailing the customer to find out what they ordered. Very embarrassing. Luckily I don't get too many eChecks. I hope this thread ends with a solution.

The easiest solution is to not accept eCheques. We do, so, I now use Paypal Sessions Viewer mod (in downloads). This is intended to show stuck orders when customer fails to complete last step of checkout when making paypal payment. Be careful because it will also show data from non-paid orders.
The log_in_as_customer mod may be used to see contents of their cart when payment has been made, and you don't know what for.
These are just stop-gap measures really. However I hope these suggestions help until someone comes up with a better solution.

I'm having the same problem since upgrading to 1.3.8 with echeques. Would be good if this was fixed in the next version. My other Paypal IPN orders are also pretty tempremental and sometimes don't get recorded in admin and works other times. Didn't have this many issues when I was using Zencart 1.3.6

I'm also having this problem and would LOVE to hear a solution if someone finds one. It looks terrible to have to email someone and ask them what they've ordered.

lhardie:

I'm also having this problem and would LOVE to hear a solution if someone finds one. It looks terrible to have to email someone and ask them what they've ordered.

Admin/Customers/PayPal IPN

You will find your order there.

Unfortunately, due to another bug I have on my site, I cannot see any info in that particular section. Nobody has replied to my requests for help with it.

I am running the latest install of Zen cart and the only module I have added is the Canada Post module. Yet when I go to see the Paypal IPN section, I get the following error (which they say is due to running an older version mixed with newer files)

1054 Unknown column 'p.order_id' in 'on clause'
in:
[select count(*) as total from paypal as p left join orders as o on o.orders_id = p.order_id]

If anyone knows how to fix this or has ideas on where to start, I'd love it! :)

Thanks for your help, hopefully I can fix this bug and then I can see that area to view the orders. Thank you for telling me where to find the information.

Zandig:

Admin/Customers/PayPal IPN

You will find your order there.

Is the order supposed to show up in the PayPal IPN section right away or not until it has cleared? I just received an echeck payment that is waiting to clear, and nothing is in the IPN.. :(

Also we've been having some random issues where the order doesn't show up in the site, but the paypal comes in.

Just checked all of my settings in my paypal account, and everything looks fine. Randomly we'll get a regular paypal order where we get the money, but the order doesn't come in. Also, every e-check order, nothing is in the admin section.

Any help would be greatly appreciated. Thanks!

Please anyone reply if this issue has been resolved or a workaround exists.

I've just hit the same issue on the brand new install (1.3.8.a).

Any help, hints would be greatly appreciated.

THank you in advance!

Hello!

I've just posted my SOS on another thread dedicated to the same issue.

Yes, I'm having exactly the same issue in my brand new (1.3.8.a) installation.

PayPal Website Payments Standard, PDT enabled, e-checks are submitted by the customer but no recorded orders with any status.
CC via PayPal payments or PayPal payments create orders fine, just the echeck leaves no footprints.
I checked all possible DB tables for any signs -- nothing, clean...

My other site's old faithful version 1.2.7 works with echecks without problems.

Any workaround other than disable the echeck?

Look forward to hearing from the community.

...continuing my previous post above.

I took a look at the Apache SSL logs and I can see the checkout completed and the response from the PayPal.
PayPal calls produced "500" HTTP status.
The log excerpt below reflects onlly calls to executables, calls to css and images were removed for readability.
Please take a look:

X.X.X.X - - [15/Dec/2009:20:29:42 -0500] "POST /checkout_confirmation HTTP/1.1" 200 19864 "[deleted].com/checkout_payment" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5"
66.211.170.66 - - [15/Dec/2009:20:31:39 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"
X.X.X.X - - [15/Dec/2009:20:31:43 -0500] "GET /checkout_process/referer/paypal?tx="[deleted]&st=Pending&amt=48.55&cc=USD&cm=zenid%3da1ee8663c3c5fdb7a00d9104372a6258&item_number=Store%20Receipt HTTP/1.1" 302 - "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5"
X.X.X.X - - [15/Dec/2009:20:31:45 -0500] "GET /checkout_success HTTP/1.1" 200 22010 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5"
66.211.170.66 - - [15/Dec/2009:20:31:54 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"
X.X.X.X - - [15/Dec/2009:20:32:00 -0500] "GET /logoff HTTP/1.1" 302 - ""[deleted].com/checkout_success" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5"
X.X.X.X - - [15/Dec/2009:20:32:00 -0500] "GET /logoff HTTP/1.1" 200 18281 ""[deleted].com/checkout_success" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5"
66.211.170.66 - - [15/Dec/2009:20:32:18 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"
66.211.170.66 - - [15/Dec/2009:20:33:02 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"
66.211.170.66 - - [15/Dec/2009:20:34:25 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"
66.211.170.66 - - [15/Dec/2009:20:37:09 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"
66.211.170.66 - - [15/Dec/2009:20:42:34 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"
66.211.170.66 - - [15/Dec/2009:20:53:18 -0500] "POST /ipn_main_handler.php HTTP/1.0" 500 - "-" "-"

"500 - Internal Server Error" is something that your apache server triggers. And, when such an error is triggered, the cause of the error should be in the apache error_log, and/or the mod_security log.
If you can't find those logs, get your hosting company to tell you what's going wrong.