My PayPal IPN echeck orders not completing

dear Dr Bite and all, some help will be highly appreciated.

I'have Zen cart 1.3.7 and I've installed the last paypal IPN patch (17 june), but still ,
orders paid via Paypal Echeck do not show in the admin.

Payment are received and paypal does return the client to my zen cart, but the order doesn't show and in fact is completely gone from the customer shopping cart and database.

I've also noticed that if the order come from a recurring customer, on return from paypal ( paid via echeck) , zen cart creates a duplicate order of the last paid order of this customer in the database, even if the the prior order was of different total amount and was paid with other method like 2CO.

i've included below a paypal IPN log of a failed test ( changed Ids) and I can't see a notice at the Breakpoint: 3 that may be triggering this problem ,


please help, how to fix it ? many thanks





Aug 15 2007 7:37 -- IPN PROCESSING INITIATED.
*** Originating IP: xx.xxx.xxx.xx

notify.paypal.com

Aug 15 2007 7:37 -- IPN NOTICE :: ipn_application_top -> language

files okay

Aug 15 2007 7:37 -- IPN INFO - POST VARS received (sorted):
Array
(


[business] => [email protected]
[charset] => windows-1252
[custom]

=> zenid=d96b214xxxxxxxxxxxxxxxxxxxxxxxxx
[first_name] => John
[item_name]

=> Testshop.com - Purchase
[item_number] => Store

Receipt
[last_name] => smith
[mc_currency] => USD
[mc_gross] => 0.01


[notify_version] => 2.4
[payer_business_name] => Jamesbuy
[payer_email]

=> james########################## [payer_id] => G8Vxxxxxxxxxx
[payer_status] => verified


[payment_date] => 04:36:57 Aug 15, 2007 PDT
[payment_gross] => 0.01


[payment_status] => Pending
[payment_type] => echeck
[pending_reason] =>

echeck
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id]

=> RNGxxxxxxxxxx
[residence_country] => TH
[shipping] => 0.00
[tax] =>

0.00
[txn_id] => 65Y5xxxxxxxxxxxx [txn_type] => web_accept
[verify_sign]

=> AZxbwZ9bPVPFFfxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
)


Aug 15 2007 7:37 --

IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST

/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 786
Connection: close

Array
(
[payment_date] => 04:36:57 Aug 15, 2007 PDT
[txn_type] => web_accept


[last_name] => Smith
[residence_country] => TH
[pending_reason] => echeck


[item_name] => Testshop.com - Purchase
[payment_gross] => 0.01


[mc_currency] => USD
[business] => [email protected]
[payment_type] => echeck


[verify_sign] => AZxbwZ9bPVPFFfxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


[payer_status] => verified
[tax] => 0.00
[payer_email] => james##########################


[txn_id] => 65Y5xxxxxxxxxxxx [quantity] => 1
[receiver_email] =>

[email protected]
[first_name] => James
[payer_id] => G8Vxxxxxxxxxx


[receiver_id] => RNGxxxxxxxxxx
[item_number] => Store Receipt


[payer_business_name] => Jamesbuy
[payment_status] => Pending
[shipping] =>

0.00
[mc_gross] => 0.01
[custom] => zenid=d96b214xxxxxxxxxxxxxxxxxxxxxxxxx


[charset] => windows-1252
[notify_version] => 2.4
[cmd] => _notify-validate
)


Aug 15 2007 7:37 -- IPN INFO - Confirmation/Validation response
SUCCESS

Aug 15 2007

7:37 -- Breakpoint: 1 - Collected data from PayPal notification

Aug 15 2007 7:37 --

IPN INFO :: Transaction email details.
From IPN = [email protected] |

[email protected]
From CONFIG = [email protected]

Aug 15 2007 7:37 -- Breakpoint: 2 -

Validated transaction components

Aug 15 2007 7:37 -- Breakpoint: 3 - Communication

method verified

Aug 15 2007 7:37 -- IPN NOTICE :: Could not find matched txn_id

record in DB. Therefore is new to us.

Aug 15 2007 7:37 -- Breakpoint: 4 - Details:

txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type =

unique
parent_txn_id = None
txn_id = 65Y5xxxxxxxxxxxx

Aug 15 2007 7:37 --

Breakpoint: 5 - Transaction type (txn_type) = pending-echeck

Does the order show up properly after the echeck clears ?

dera Dr Byte, Thanks for your reply.


this is getting worse, I have detected 2 scenarios:


scenario 1-

a completely new customer register, checkout and pay via PAYPAL ECHECK, upon return to my website , the checkout_sucess page displays a " 500 INTERNAL SERVER error page".
No sign of the order in the database but I do get the echeck payment email notice from paypal.

I have created 4 new customers and tested , and each time happen the same, paypal return to a 500 internal server error page.


scenario 2-

a return customer checkout and pay via paypal echeck, upon return to my website , the checkout_sucess page displays a confirmation with the ID number of the prior existing order of this customer in the database.


I will have to wait a couple of days for the test transactions checks to clear before I will know, however, even if the orders latter show up in the admin , why is that the checkout_success page is displaying a 500 INTERNAL SERVER ERROR, rather than the order confirmation ?

I also can't see any data of those orders into my mysql database tables, so I can't understand how possible paypal IPN return could suddenly create those orders data with detail.


Again, I have problems ONLY with paypal echeck, normal paypal payments works fine.


Please help
many thanks

What contributions/addons do you have installed?
What is your server's errorlog saying when you get the 500 errors?
What currencies are enabled in your store?
What currencies is your ZC PayPal module setup to accept?
How much of the log files get written when you get the 500 errors ?

I lost count how many modules we have installed and how many more we did. but we have heavy customized.

However, we have no other errors and any conflicts we may get, we can usually resolve as they come.
But we are completely newbies dealing with paypal api, so, we are really stuck with this one

what modules could be causing this ?

I have enabled currency: USD, CAN, GBP, AUD, JPY, EUR, SEK, CHF, FRF

ZC paypal module set to : " Selected Currency"

about the error logs, it's strange but I could not see a single mention of 500 internal server error pages in the logs.

I could see some error logs with the godaddy seal contribution , so to be sure I have deleted all the files on that contribution, but seems to be no related.

I don't know what else to do.

I've done many many tests and still I get the 500 internal server error page , every time a new customer return to ZC from a paypal echeck payment

NOTE: that I do get the order confirmation mail ( as a store owner) but empty , without data, neither Order ID
The buyer doesn't get the order confirmation, but yes get the paypal receipt

Please note:

I do not have SEO URLs installed.

I have the original html_output file

I have installed the latest paypal patch ( 17 june)

I've removed completely .htaccess file

there are several errors in my server log file, but they seems to be relate to some missing older files of my prior website at this domain.

However, there is 1 line originated at my IP, that may be significant, which I think match the time of a test transaction, please see below:


[Thu Aug 16 14:06:06 2007] [error] [client xxx.xxx.xxx.xxx] malformed header from script. Bad header=No recipient addresses found i: /hsphere/local/home/silversi/xxxxx.com/index.php


is this error mean something to you ?


This 2 errors below , also originate at my IP and keeps repeating a lot


[Thu Aug 16 13:55:41 2007] [error] [client xxx.xxx.xxx.xxx] File does not exist: /hsphere/local/home/silversi/xxxxxx.com/favicon.ico

[Thu Aug 16 14:06:11 2007] [error] [client xxx.xxx.xxx.xxx] File does not exist: /hsphere/local/home/silversi/xxxxxxx.com/index.php_files/jscript_imagehover.js



please help me out, lost 2 days on this, I'm completely frustrated

many thanks

What happens if you go to www.your_site.com/ipn_main_handler.php with your browser?

Do you have PDT configured?

yes I have PDT configured.

I see this message at page ipn_main_handler

" Nothing to process. Please return to home page"


I have tested the connection with IPN tool and I get this:


IPNCHECK.PHP - Version 1.0

IPN TESTING - POSTING to PayPal via: ssl://www.paypal.com:443

IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = ssl://www.paypal.com:443 (136581300) Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?

Trying again without SSL ...

IPN TESTING - Confirmation/Validation response: RESPONSE RECEIVED - Communications OKAY


Script finished.


allow_url_fopen is off by default at my unix server , but I've added an .htaccess file ( php_value allow_url_fopen 1) to open it as per my server admin instructions

the connection seems to work ok because regular paypal orders return fine , the problem is with echecks payments.

The peculiar thing is that the return process for echecks is no different from the process for non-echecks.

thanks god, my top programer just figured out the internal server error and it fixed, I was going nut.

It was something to do with a modification we did to the orders auto mailer system.

Still echeck orders do not show in the admin, so I'm waiting to see what will happen within a day or 2 once pending echeck orders clears.

I have a client who just called me with this problem also. She is using Zen Cart 1.3.7 with all patches installed.

Even after the eCheck clears the order does not show up in her admin panel. This has happened twice in the last month.

Thanks,
Denise

today checks have cleared and no sign of the orders at the admin.

I suspected that will be the case, since there is no trace of the orders at the database.

PDT is configured. paypal patch is installed, all setup as per instructions, only eChecks is problem

What can we do next ?, please dr Bite, help us !

many thanks

dr Byte , please some help on this, you are our only hope to fix this !!

Can you download your paypal debug log files, zip them, upload the file to your server, and PM me with a link to the zip? Reviewing them will help determine trends and hopefully cause.

Quote:

---

Originally Posted by sergiogold

However, there is 1 line originated at my IP, that may be significant, which I think match the time of a test transaction, please see below:


[Thu Aug 16 14:06:06 2007] [error] [client xxx.xxx.xxx.xxx] malformed header from script. Bad header=No recipient addresses found i: /hsphere/local/home/silversi/xxxxx.com/index.php


is this error mean something to you ?

---

I wouldn't expect that error to show up with Zen Cart, since Zen Cart usually validates all email traffic before actually sending a message. Everthing I've seen on Google about that error message suggests that somehow you've got a script that's attempting either to send to a blank email address or the mailserver has an odd configuration that wants its email parameters sent in a different order than what is being supplied.
Zen Cart doesn't accept blank email addresses, so I'm not sure if that error is happening as a result of Zen Cart processing or some other script on your site.

Even if it was a result of bad data coming back from PayPal, Zen Cart still shouldn't attempt to send an email to a blank address ... it should just ignore the whole transaction because the data is not valid.


Again, more paypal logs will help to understand the problem more clearly.
A list of installed mods/contributions and the kinds of customizations you've done to your site would also be a help.

Dr Byte,
This is happening to me as well and has been happening for a month or 2 now. I just had one this morning. It was a paypal echeck, there is nothing listed when I look at the paypal IPN linkin admin. I am at a loss cause I see the uncleard payment in the paypal account but no sign of the order on the site. I can also tell you that in my cart it skipped the order number. I have 582, 584 and 585.. Order 583 would have been placed around the time the customer for the echeck ordered it. But it is no where to be found. I even went through the database and there is no records of it at all that I can find. PLEASE HELP

Rich Fallon
Foilman.com

Logs will be a big help ...

Dr Byte,
I thought I had my logs turned on, but apparently I did not. I just turned them on this morning and I will get you a log from testing ASAP.

Thanks,
Rich Fallon
Foilman.com

I have just been informed that we are having the same problem. I have recently update to the latest zen cart.

On our old one echecks worked fine, but since I have installed the new zen cart they dont show up in the admin at all?!?!

Quote:

---

Originally Posted by DanAllkins

I have just been informed that we are having the same problem. I have recently update to the latest zen cart.

On our old one echecks worked fine, but since I have installed the new zen cart they dont show up in the admin at all?!?!

---

"recently update"
"since installed the new"

Um ... what version did you upgrade *from* ?
Do any non-echeck transactions work properly ?
Can you post logs ?

I just set up a fresh brand new v1.3.7.1 install and tested echeck transactions using the IPN module with PDT enabled.

All my transactions (large amounts and small amounts, lots of products and only single products on the order, downloads and non-downloads) tested fine. Orders paid by echeck were inserted into the Admin immediately, in Pending status.
Once marking the payment as 'cleared' (testing in sandbox allows control over this), the order was upgraded to "Processing" automatically. All the details show in the customer order history as expected.

I can't see anything specifically wrong with echeck support using the IPN module.

Quote:

---

Originally Posted by DrByte

"recently update"
"since installed the new"

Um ... what version did you upgrade *from* ?
Do any non-echeck transactions work properly ?
Can you post logs ?

---

Well We were using an old version, so rather than up grading I set up a new cart (1.3.7)

I'm having the same problem. Since upgrading to 1.3.7 my echeck PayPal orders never show up on my orders list, but the payment is posted to my PayPal account. Not that I have that many orders using echeck, but it would be nice if the sale showed up. :)

Quote:

---

Originally Posted by Shara

I'm having the same problem. Since upgrading to 1.3.7 my echeck PayPal orders never show up on my orders list, but the payment is posted to my PayPal account. Not that I have that many orders using echeck, but it would be nice if the sale showed up. :)

---

Do you have the latest patch installed ? (ie: June 17 as of this post)?

Quote:

---

Originally Posted by DrByte

Do you have the latest patch installed ? (ie: June 17 as of this post)?

---

Should I have PayPal Express Checkout module activated in the paymet module??

Quote:

---

Originally Posted by DanAllkins

I have just been informed that we are having the same problem. I have recently update to the latest zen cart.

On our old one echecks worked fine, but since I have installed the new zen cart they dont show up in the admin at all?!?!

---

Quote:

---

Originally Posted by DrByte

"recently update"
"since installed the new"

Um ... what version did you upgrade *from* ?
Do any non-echeck transactions work properly ?
Can you post logs ?

---

Quote:

---

Originally Posted by DanAllkins

Well We were using an old version, so rather than up grading I set up a new cart (1.3.7)

---

Quote:

---

Originally Posted by DanAllkins

Should I have PayPal Express Checkout module activated in the paymet module??

---

You said you're using the IPN module, right?
You don't "need" Express Checkout to use IPN, and you don't need IPN to use Express Checkout. They are independent of each other.

Thanks for the quick response. :)

Yes, I did the June 17 update and I am using the PayPal IPN, with V1.3.7.

I did some more tests yesterday. It took me to paypal and then brought me back to the store checkout success page, but the order number was one that I had made over a year ago! It did not duplicate, just went back to the last sale number. How weird. There is nothing in the orders for the echeck sale, but the money was taken out of my PayPal account.

Please collect the logs from your tests and post them for review.

Quote:

---

Originally Posted by DrByte

You said you're using the IPN module, right?
You don't "need" Express Checkout to use IPN, and you don't need IPN to use Express Checkout. They are independent of each other.

---

Yes I'm using the IPN module.

We have just had another echeck payment. Paypal send the email saying we have a pending payment (echeck) but it never shows up in the admin home page.

This is driving me mad now as we are having to email the customers to ask what they ordered... also it means that the products they have ordered have not been ear marked and could possibly be sold out by the time their echeck clears.

Without debug logs (as I've requested numerous times in this thread alone), there's nothing I can do to help any of you.

All the tests I'm doing on live and development servers have no problems handling echecks.

If there's a pattern unique to your setup, I'll need logs in order to diagnose further. Zip them up and post a link where I can download them from.

Quote:

---

Originally Posted by DrByte

Without debug logs (as I've requested numerous times in this thread alone), there's nothing I can do to help any of you.

All the tests I'm doing on live and development servers have no problems handling echecks.

If there's a pattern unique to your setup, I'll need logs in order to diagnose further. Zip them up and post a link where I can download them from.

---

Sorry to sound dim, but how do I get the logs. and/ or create them :blush:

http://www.zen-cart.com/forum/showthread.php?t=61199

Quote:

---

Originally Posted by DrByte

http://www.zen-cart.com/forum/showthread.php?t=61199

---

Thanks for this, but When I go to Admin>Modules>payment>paypal there isn't an option to log to file, only Debug Email Notifications ????

Quote:

---

Originally Posted by DanAllkins

Thanks for this, but When I go to Admin>Modules>payment>paypal there isn't an option to log to file, only Debug Email Notifications ????

---

You said you're using v1.3.7 right?
And you applied the June 17 patch, right?
You should have the option if you've got the latest code.

Or are you still referring to your older site?

Quote:

---

Originally Posted by DrByte

You said you're using v1.3.7 right?
And you applied the June 17 patch, right?
You should have the option if you've got the latest code.

Or are you still referring to your older site?

---

right first things first I best check to see if the patch has been installed - sirry for being dim... I'll report back.

Right... it appears I didn't have that patch installed?!?!?!, but I do now and it seams to work fine! - thank you-

When I received my email from paypal saying I had paid I got this:

Order Description: MODULE_PAYMENT_PAYPAL_PURCHASE_DECRIPTION_TITLE

Thats not right is it???

You missed the language file when you installed the patch.
Maybe it didn't upload completely?

I have the same problem with e-checks. I have not received them frequently, so I have not noticed up till now. Normal PayPal IPN payments work just fine.

I have to check if I applied the latest fixes. And no, I have no log files as I was not aware of the problem. I will turn it on and report once I get another e-check (might take another few Month? Don't get them often.) Or can I just test myself and reimburse? No fees for this?

Q: Is this a known issue (e-check) if no patches are applied? I use zen 1.3.7.

Quote:

---

Originally Posted by Kim

You missed the language file when you installed the patch.
Maybe it didn't upload completely?

---

I have checked this and still no luck?!?! this only started to happen since the patch was installed.

Quote:

---

Originally Posted by DanAllkins

Right... it appears I didn't have that patch installed?!?!?!, but I do now and it seams to work fine! - thank you-

When I received my email from paypal saying I had paid I got this:

Order Description: MODULE_PAYMENT_PAYPAL_PURCHASE_DECRIPTION_TITLE

Thats not right is it???

---

Quote:

---

Originally Posted by Kim

You missed the language file when you installed the patch.
Maybe it didn't upload completely?

---

Quote:

---

Originally Posted by DanAllkins

I have checked this and still no luck?!?! this only started to happen since the patch was installed.

---

In your /includes/languages/english/modules/payment/paypal.php file, do you have this near the bottom of the file?

Code:

---

  define('MODULE_PAYMENT_PAYPAL_PURCHASE_DECRIPTION_TITLE', STORE_NAME . ' Purchase');

---

If you don't, then add it. It's in the language file that comes with the patch, but if you've uploaded it and it's not there ... then ... well ... add it manually.
Have you made any other customizations to your paypal.php language file ?


(and, yes, for those reading this who notice the misspelling of "description" in the name ... it's fine ... it's consistent, and will be renamed in a future update. Don't "fix" it or you'll bust things elsewhere)

Quote:

---

Originally Posted by DrByte

In your /includes/languages/english/modules/payment/paypal.php file, do you have this near the bottom of the file?

Code:

---

  define('MODULE_PAYMENT_PAYPAL_PURCHASE_DECRIPTION_TITLE', STORE_NAME . ' Purchase');

---

If you don't, then add it. It's in the language file that comes with the patch, but if you've uploaded it and it's not there ... then ... well ... add it manually.
Have you made any other customizations to your paypal.php language file ?


(and, yes, for those reading this who notice the misspelling of "description" in the name ... it's fine ... it's consistent, and will be renamed in a future update. Don't "fix" it or you'll bust things elsewhere)

---

Many thanks, that worked a treat... it now shows the 'Store Name Purchase'
Thank you

I thought I would give you an update on my fix.

After running the patch from July on my V1.3.7 Paypal stopped working altogether. However, I then downloaded and installed V1.3.7.1 and everything including echecks is now working properly.

I found one thing after the version upgrade. I'm not sure if the patch download that I got was incomplete but when I went to configure my Paypal email address I noticed an item called "PDT Token (Payment Data Transfer)" which did not show up after just installing the patch.

So my advice to anyone else having this problem is to just install V.1.3.7.1

Shara

Godaddy has a “CURL proxy”, stuffed up my sites…
If you have a Godaddy server and "if your page times out it may be because CURL timeouts that suggest DNS or firewall problems"

Paypal express checkout will not work on godaddy servers unless you change your site in accordance with DrByte post that talks about GoDaddy and CURL proxy setup:
http://www.zen-cart.com/forum/showthread.php?t=61528 :smile:

I'm using zencart 1.3.7 with the latest paypal patch.

I received an echeck payment today that didn't give me any store notification, all I got was a confirmation from Paypal, this is the first echeck I've recieved so far.
I didn't have the bug files turned on but I have since turned them on & attempted to test another order but Paypal seems to be failing, I wasn't even redirected.

Here's a copy of the error log:

[bn] => zencart
[cmd] => _ext-enter
[rm] => 2
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[page_style] => Primary
[lc] => AU
[custom] => zenid=8c6f2da11b0a5f544edcbdc3b8bef130
[charset] => iso-8859-1
[return] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/index.php?main_page=checkout_process&referer=paypal&zenid=8c6f2da11b0a5f544edcbd c3b8bef130
[cancel_return] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/index.php?main_page=checkout_payment&zenid=8c6f2da11b0a5f544edcbdc3b8bef130
[shopping_url] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/index.php?main_page=shopping_cart&zenid=8c6f2da11b0a5f544edcbdc3b8bef130
[notify_url] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/ipn_main_handler.php
[redirect_cmd] => _xclick
[business] => live2knit AT live2knit DOT com DOT au
[first_name] => xxx
[last_name] => xxxx
[address1] => xxxx
[city] => xxxx
[state] => xxxx
[zip] => xxxx
[country] => AU
[email] => xxxx
[H_PhoneNumber] => xxxx
[night_phone_b] => xxxx
[day_phone_b] => xxx
[no_shipping] => 1
[currency_code] => AUD
[paypal_order_id] =>
[item_name] => Live 2 Knit Purchase
[item_number] => Store Receipt
[upload] => 2
[amount] => 60.90
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00

Please help as Paypal, has been working fine up till now.

Katie
www.live2knit.com.au

OK, I just got another echeck paypal payment. No order in my cart. I see the payment in my paypal account. I have the debug files.

Dr Byte, you can download the log files as you requested. I will PM you with the location.

BTW I noticed that I had the Instant Payment Notification Preferences ON. I use this PayPal account with two different websites and I realized that the return path was set to the other site! I guess this does not help ether.... I turned it off for now.

Now I'm confused, will the PayPal IPN still work if I set this in the pref in paypal profile.

Instant Payment Notification (IPN) Off
Instant Payment Notification (IPN) URL: (blank)

Will I still receive payments in paypal but no notice gets sent to my cart about the status? I guess this would be ok if I at least would see the order in my zen cart!

Quote:

---

Originally Posted by mydanilo

Now I'm confused, will the PayPal IPN still work if I set this in the pref in paypal profile.

Instant Payment Notification (IPN) Off
Instant Payment Notification (IPN) URL: (blank)

Will I still receive payments in paypal but no notice gets sent to my cart about the status? I guess this would be ok if I at least would see the order in my zen cart!

---

No .. if you are using the IPN module in Zen Cart, then you need the IPN service turned on in your PayPal profile.
Otherwise you'll never get anything back in Zen Cart.

OK, I will set it to ON.

But leave Instant Payment Notification (IPN) URL: (blank)
Correct?

Otherwise I can't have tow carts using this account.

Btw, the log I made accessible to Dr Byte are from before I changed the settings.

So I will set IPN back on and do not specify a return path...

OK, forget my last two postings. It does not work to activate without return path.

I am confused, in zen admin payment paypal ipn it states:

Configuration Instructions:
1. Sign up for your PayPal account - click here.
2. In your PayPal account, under "Profile",

* set your Instant Payment Notification Preferences URL to:
https://www.xxxxxxcandlestore/ipn_main_handler.php
(If another URL is already used, you may leave it alone.)
Be sure that the Checkbox to enable IPN is checked!


(If another URL is already used, you may leave it alone.) What does this mean then! I did have the return path set to my store 1. How will this ever work for my second store?

Quote:

---

Originally Posted by mydanilo

BTW I noticed that I had the Instant Payment Notification Preferences ON. I use this PayPal account with two different websites and I realized that the return path was set to the other site! I guess this does not help ether.... I turned it off for now.

---

Zen Cart overrides whatever URL you enter there, and thus can share with multiple sites.

Quote:

---

Originally Posted by mydanilo

Otherwise I can't have tow carts using this account.

---

See above.

Quote:

---

Originally Posted by mydanilo

So I will set IPN back on and do not specify a return path...

---

I doubt PayPal will let you leave the URL blank.

Quote:

---

Originally Posted by mydanilo

OK, I just got another echeck paypal payment. No order in my cart. I see the payment in my paypal account. I have the debug files.

---

Your debug logs suggest that your webserver has a configuration problem:

Code:

---

Nov 20 2007 14:10 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = www.paypal.com:80 (105) No buffer space available

---

Quote:

---

Originally Posted by DrByte

Your debug logs suggest that your webserver has a configuration problem:

Code:

---

Nov 20 2007 14:10 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = www.paypal.com:80 (105) No buffer space available

---

---

Can you give me a bit more of an idea what I should tell my hosting provider? What needs to be configured right?

I use a Zen recommended host.

I invited my hosting provider to this thread. Hope I can get this resolved soon.

Your missing the PDT Token

PDT Token (Payment Data Transfer)
Enter your PDT Token value here in order to activate transactions immediately after processing (if they pass validation).

Go to paypal and get your token and add it this will work.

Ok I found out how to get a token:

Activating PDT

To use PDT, you must activate PDT and Auto Return in your PayPal account profile. You must also acquire a PDT identity token, which is used in all PDT communication you send to PayPal.

Follow these steps to configure your account for PDT:

1. Log in to your PayPal account.
2. Click the Profile subtab.
3. Click Website Payment Preferences in the Seller Preferences column.
4. Under Auto Return for Website Payments, click the On radio button.
5. For the Return URL, enter the URL on your site that will receive the transaction ID posted by PayPal after a customer payment.
6. Under Payment Data Transfer, click the On radio button.
7. Click Save.
8. Click Website Payment Preferences in the Seller Preferences column.
9. Scroll down to the Payment Data Transfer section of the page to view your PDT identity token.


Remaining Questions:
Will this token work for both sites that I use this paypal account for?
How can I recover the order that was placed and payed with paypal echeck? I see the payment in paypal but no order in Zen. Any chance of recovering the order? Don't know what to ship!

Thank you for all the help so far...

Glad to hear you got it working

Well yes, the token part is all set. Still don't know below:

Quote:

---

Originally Posted by mydanilo

Remaining Questions:
Will this token work for both sites that I use this paypal account for?
How can I recover the order that was placed and payed with paypal echeck? I see the payment in paypal but no order in Zen. Any chance of recovering the order? Don't know what to ship!

Thank you for all the help so far...

---

The token will work for both sites.

But for your order there is no way to recover it

Quote:

---

Originally Posted by knuckle-101

But for your order there is no way to recover it

---

Not entirely correct.
http://www.zen-cart.com/index.php?ma...products_id=84

But that mod is made for 1.2.5 he is running 1.3.7 any conflict you think might happen?

Never used this mod but saw it but did not recommend due to the version info.

Ok, I will try and install this mod. One question, it states:

NOTE: If you've renamed your "admin" folder, be sure to adjust the path of the admin folder in the bottom of the pushorder.php file before uploading.

But... there is no pushorder.php file in the mod included!?

I am going crazy. No pushorder.php to be found. I installed anyway and get a report in code. Not much use, can't see in clear text what my customer ordered. How about pushing the order back into admin? Is this feature gone?

I see an product ID# xx but how do I find out what this is? Looks like some detective work....
I will leave it alone until maybe Dr Byte can shed some light. Is there an easier way to get my order back? Do I miss something?

Quote:

---

Originally Posted by mydanilo

I am going crazy. No pushorder.php to be found. I installed anyway and get a report in code. Not much use, can't see in clear text what my customer ordered.

I see an product ID# xx but how do I find out what this is? Looks like some detective work....

---

You'll see the product number, the quantity, etc.
Sorry, you'll have to look up the product number yourself. You can find the product number next to the product itself in your admin area. Or, you can use the Products Purchased report and type the product number in the first search field (top right corner) ... it'll list all the purchases of the product ... you'll see the product name in a mid-right column.

Quote:

---

Originally Posted by mydanilo

How about pushing the order back into admin? Is this feature gone?

---

I'm not sure where v2 went that contained the push_order script. It was posted on the forum by somebody but never uploaded to the contributions area.

Thank you Dr Byte. Funny that the description for the version in the download section talks about the pushorder.php even if it does not exist. Confusing....was this part of an earlier version?

This is part of it....
NOTE: If you've renamed your "admin" folder, be sure to adjust the path of the admin folder in the bottom of the pushorder.php file before uploading.

Quote:

---

Zen Cart overrides whatever URL you enter there, and thus can share with multiple sites.

---

Is this also true of the Auto Return URL required for PDT?

I've been having the same e-check problem and I'm getting ready to install the most current patch.

TIA!

Sarah

Quote:

---

Originally Posted by sarahjessica7224

Is this also true of the Auto Return URL required for PDT?

---

Must be.. otherwise it would never work for two sites. I wondered too but it just has to be.

Thanks Danilo!

I answered my own question after poking around in paypal.php:

Code:

---

zen_draw_hidden_field('return', zen_href_link(FILENAME_CHECKOUT_PROCESS, 'referer=paypal', 'SSL'))

---

Lol, just didn't want to send my pet site customers to my collectibles site after payment :D


~Sarah

Hello,
I just installed the patch (june 2007) to make the echecks work. The echecks seem to work now.
BUT, now I have a problem, when I'm trying to edit an order (admin / customers / orders / edit button) , there is a new error (doesn't appears before the patch)

Code:

---

Warning:  admin_notification(/home.15/r/e/g/reggaemu/www/shop/includes/modules/payment/paypal/paypal_admin_notification.php) [function.admin-notification on line ]: failed to open stream: No such file or directory in /home.31/r/e/g/reggaemu/www/shop/includes/modules/payment/paypal.php328

Fatal error:  admin_notification() [function.require on line ]: Failed opening required '/home.15/r/e/g/reggaemu/www/shop/includes/modules/payment/paypal/paypal_admin_notification.php' (include_path='.:/usr/local/lib/php') in /home.31/r/e/g/reggaemu/www/shop/includes/modules/payment/paypal.php328

---

:(

I can see the Shipping address, the Billing address, the telephone number etc... but I can't see the items ordered! :cry:

I have orders to process and I am a little bit in panic....

Please help me.

Thanks in advance.

Please forget my previous message, I found the problem!! (I removed paypal_admin_notifications.php during the patch update!)

Sorry for any inconveniances

Quote:

---

Originally Posted by knuckle-101

Your missing the PDT Token

PDT Token (Payment Data Transfer)
Enter your PDT Token value here in order to activate transactions immediately after processing (if they pass validation).

Go to paypal and get your token and add it this will work.

---

this may be a silly question but where do you put the PDT Token after you get one?

Modules- payment- paypal-IPN

edit the module and fill out: PDT Token (Payment Data Transfer)

the same problem occured with PayPal eCheck today.

I made Paypal debug on.

I have my PDT from my paypal account. but I dont have place where to put this PDT in module/paymenr/paypal/???

i have 1.3.7 instaled on Nov 2007.

any advise? or after i put the debug ON will eCheck work properly? what I missed else?

thanks

Quote:

---

Originally Posted by mydanilo

Modules- payment- paypal-IPN

edit the module and fill out: PDT Token (Payment Data Transfer)

---

I assume you have the Paypal-IPN module installed and active? green?


Yes it should be there if you go to the menu: Modules- Payment- Paypal-IPN

and then you see on the right side....


Enable PayPal Module
True

Business ID
[email protected]

PDT Token (Payment Data Transfer)
****************

Transaction Currency
Only USD

Payment Zone

etc etc...

If you press edit, it is the second option from the top. Can't miss it. Otherwise your installation is not correct.
--none--

this what i can see in my admin:

PayPal IPN (debug mode active)

Enable PayPal Module
Do you want to accept PayPal payments?

*True
False

Business ID
Primary email address for your PayPal account.
NOTE: This must match EXACTLY the primary email address on your PayPal account settings. It IS case-sensitive, so please check your PayPal profile preferences at paypal.com and be sure to enter the EXACT same primary email address here.
[email protected]

Transaction Currency
Choose the currency/currencies you want to accept

*Selected Currency
Only USD
Only CAD
Only EUR
Only GBP
Only JPY
Only AUD

Payment Zone
If a zone is selected, only enable this payment method for that zone.


Set Pending Notification Status
Set the status of orders made with this payment module that are not yet completed to this value
('Pending' recommended)


Set Order Status
Set the status of orders made with this payment module that have completed payment to this value
('Processing' recommended)


Set Refund Order Status
Set the status of orders that have been refunded made with this payment module to this value
('Pending' recommended)


Sort order of display.
Sort order of display. Lowest is displayed first.


Continue Button Text
Sets the text for the Continue button on the PayPal Payment Complete page.
Requires Return URL to be set.
Leave blank if no customization required.


Page Style
Sets the Custom Payment Page Style for payment pages. The value of page_style is the same as the Page Style Name you chose when adding or editing the page style. You can add and edit Custom Payment Page Styles from the Profile subtab of the My Account tab on the PayPal site. If you would like to always reference your Primary style, set this to "primary." If you would like to reference the default PayPal page style, set this to "paypal".


Mode for PayPal web services

Default:
www.paypal.com/cgi-bin/webscr
or
www.paypal.com/us/cgi-bin/webscr
or for the UK,
www.paypal.com/uk/cgi-bin/webscr
Choose the URL for PayPal live processing


Debug Mode
Enable debug logging?
NOTE: This can REALLY clutter your email inbox!
Logging goes to the /includes/modules/payment/paypal/logs folder
Email goes to the store-owner address.
Leave OFF for normal operation.

Off
* Log File
Log and Email


ANY IDEAS?

PDT Token (Payment Data Transfer)
Enter your PDT Token value here in order to activate transactions immediately after processing (if they pass validation).

This is missing? Sorry I don't know why this is not there! Did you try and install an older Paypal mod over your 1.3.7? This is definetly not the way it should be. You should have the PDT section. Are files missing? Can you upload your local copy again? Maybe just the directories with Pay pal stuff.

And you can try this as well...
Check if this tool shows more info. http://www.zen-cart.com/forum/showthread.php?t=65680

Maybe open another thread with PayPal PDT Token setting missing... or something like it.

Sorry can't help you more... good luck.

I have read through this thread (and others) and after problems with eCheques have now updated the patch Jun 2007 I have also since loaded Paypal Session viewer to try and find the missing orders as I have 3 payments and I need to confirm what they have order however when I do Admin>Customers>View Stuck Orders I get the following error

Displaying 105 records...
PAYPAL SESSION INFO for record #1, which expires on 1176952062
Session_ID=090db8a9f98467e8bc2b306e04c6bc5c
customers_host_address => mail1.wyndham.vic.gov.au
cartID => 55024

Catchable fatal error: Object of class shoppingCart could not be converted to string in /home/tradingc/public_html/etch/admin/view_stuck_paypal_orders.php on line 71

any ideas why this is happening I am using 1.3.7 with the updated Jun 2007 patch for paypal

Quote:

---

Originally Posted by JohnCrennan

I have read through this thread (and others) and after problems with eCheques have now updated the patch Jun 2007 I have also since loaded Paypal Session viewer to try and find the missing orders as I have 3 payments and I need to confirm what they have order however when I do Admin>Customers>View Stuck Orders I get the following error

Displaying 105 records...
PAYPAL SESSION INFO for record #1, which expires on 1176952062
Session_ID=090db8a9f98467e8bc2b306e04c6bc5c
customers_host_address => mail1.wyndham.vic.gov.au
cartID => 55024

Catchable fatal error: Object of class shoppingCart could not be converted to string in /home/tradingc/public_html/etch/admin/view_stuck_paypal_orders.php on line 71

any ideas why this is happening I am using 1.3.7 with the updated Jun 2007 patch for paypal

---

i also installed the session viewer and got that error. after getting it working i found it to be a little lacking so i spent a few hours recoding it to make it nicer to look at. if you want that version download it here:

http://gattomatto.net/work/zen-cart/...pal_orders.txt

save it into your admin folder, but change the .txt extension to .php. first make a backup of the old view_stuck_paypal_orders.php of course. i think you will find this to be easier to use (as well as functioning properly).

- m@