PayPal & Order confirmation again... German Bank Transfer

Hello,

I receive all PayPal made order confirmations fine.
Except "initiated payments from German Bank Transfer".
Notifications from PayPal arrive, no order confirmation is sent either me or the customer...so I don't know what they have ordered.

All PayPal settings are fine, email address is set correct (Iknow...case sensitive)
Latest PayPal IPN patches are applied

Just initiated payment order confirmations won't be sent out.

What do you mean by "initiated payments" ?

Ohh..sorry, missed that.
There is the possibility for German customers to pay by initiating a PayPal payment funded from their bank account.
So the payment status is pending as money has to be transfered to my PayPal account from THEIR Bank account.

Are you referring to an eCheck ?

Can you provide screenshots of the interface the customer uses to do this?

Hello Dr. Byte,

sorry, I was away for some days.
I attach two screenshoots, one with the user interface & the second what I receive after the customer has placed his order and cheked out using the "bank transfer" option in PayPal chekout.

The bug happens every time, he & me are not receiving any confirmation email.

I was checking my paypal settings at PayPal as well.
Payment Receiving Preferences > Option:
Block payments from users who:
Pay with eCheck for website and Smart Logo payments, or German bank transfer for all website payments except eBay

This option is uncheked

Picture Checkout Interface
PayPal Confirmation I get

I hope it's not too late to ask this ... do you have debug logging turned on ?
Can you post the PayPal logs ?

If debug logging isn't on, can you turn it on and do another test transaction?

Stupid me...have not thought about to turn it on.
I will do that now and try to have my sandbox do some tests.
Will post the new soon.

Well, first of all: Sandbox sucks...you have to guess the user setup proccesses, even when reading their half complete manual.
However, you believe it or not:
I did a test order and.... all went smooth.

I received the confirmation twice (one for me and one for the sandbox user)
Here is the log file index:

Mar 24 2007 1:04 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202

Mar 24 2007 1:04 -- IPN NOTICE::ipn_application_top -> language files okay

Mar 24 2007 1:04 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => Ordercity
[address_country] => Germany
[address_country_code] => DE
[address_name] => Mitsaras Kyrmitsous
[address_state] =>
[address_status] => unconfirmed
[address_street] => Popineoglou 89
[address_zip] => 89566
[charset] => windows-1252
[custom] => cusid=ca8fe597ca2867fdccd8ea3985b11fc4
[first_name] => Mitsaras
[item_name] => Wareneinkauf
[item_number] => 1
[last_name] => Kyrmitsous
[mc_currency] => EUR
[mc_gross] => 139.00
[notify_version] => 2.1
[payer_email] => [email protected]
[payer_id] => JC5T9VEYF8QHU
[payer_status] => unverified
[payment_date] => 16:04:57 Mar 23, 2007 PDT
[payment_gross] =>
[payment_status] => Pending
[payment_type] => echeck
[pending_reason] => unilateral
[quantity] => 1
[receiver_email] => [email protected]
[residence_country] => DE
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 0
[txn_type] => web_accept
[verify_sign] => ArjxY3SpX16A2xg7.BkLtgg.pbIAAxPoWLaHhdV5qff1Z5G.qAQ1BlVj
)

Mar 24 2007 1:04 -- IPN INFO - POST VARS sent back for validation:
To: https://www.paypal.com (80)
POST /cgi-bin/webscr HTTP/1.1
Host: https://www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 827
Connection: close

Array
(
[mc_gross] => 139.00
[address_status] => unconfirmed
[payer_id] => JC5T9VEYF8QHU
[tax] => 0.00
[address_street] => Popineoglou 89
[payment_date] => 16:04:57 Mar 23, 2007 PDT
[payment_status] => Pending
[charset] => windows-1252
[address_zip] => 89566
[first_name] => Mitsaras
[address_country_code] => DE
[address_name] => Mitsaras Kyrmitsous
[notify_version] => 2.1
[custom] => cusid=ca8fe597ca2867fdccd8ea3985b11fc4
[payer_status] => unverified
[address_country] => Germany
[address_city] => Ordercity
[quantity] => 1
[verify_sign] => ArjxY3SpX16A2xg7.BkLtgg.pbIAAxPoWLaHhdV5qff1Z5G.qAQ1BlVj
[payer_email] => [email protected]
[txn_id] => 0
[payment_type] => echeck
[last_name] => Kyrmitsous
[address_state] =>
[receiver_email] => [email protected]
[pending_reason] => unilateral
[txn_type] => web_accept
[item_name] => Wareneinkauf
[mc_currency] => EUR
[item_number] => 1
[residence_country] => DE
[payment_gross] =>
[shipping] => 0.00
[cmd] => _notify-validate
)

Mar 24 2007 1:04 -- IPN INFO - Confirmation/Validation report
HTTP/1.1 200 OK
,Date: Fri, 23 Mar 2007 23:05:02 GMT
,Server: Apache/1.3.33 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a mod_ssl/2.8.22 OpenSSL/0.9.7e
,Set-Cookie: cookie_check=yes; expires=Mon, 20-Mar-2017 23:05:02 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=85.234.139.139.104621174691102733; path=/; expires=Sun, 15-Mar-37 23:05:02 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,

Mar 24 2007 1:04 -- Breakpoint: 1 - Collected data from PayPal notification

Mar 24 2007 1:04 -- Breakpoint: 2 - Validated transaction components

Mar 24 2007 1:04 -- Breakpoint: 3 - Communication method verified

Mar 24 2007 1:04 -- IPN WARNING::Could not find matched txn_id record in DB. Therefore is new to us.

Mar 24 2007 1:04 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0
Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 0

Mar 24 2007 1:04 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Mar 24 2007 1:05 -- Breakpoint 6: Completed IPN order add. ordersID = 3598 IPN_id=126

This is a funny issue.... you try it yourself...it works...great.
Hope this helps .
Thank you again

In case it helps, here is the order displayed in my admin.... previous "lost" orders from "real" customers are not..

Order detail

You have "pending_reason" = "unilateral" in the log data you posted. This indicates that the PayPal email address specified as "receiver_email" is not currently tied to a valid PayPal account, or is not yet a "Verified" account.
Granted, you did call this your "sandbox", even though you did the transaction on the Live PayPal servers. If it's sandbox, then it may not be important; however, it's tough to do a refund of the test transaction if it's not claimed into a PayPal account.

Would still like to see the data that comes back from live transaction attempts ...

I will keep further live transactions and post the log here again.
Thank you Dr.Byte

Hello Dr. Byte,

the error accoured again, this time with Credit Card payment via PayPal.
Is it possible to PM you the original log file of the transaction as it contains sensitive customer info?

Dimi

Do you have the latest PayPal patch for v.1.37 installed ?
There's a currency-formatting problem evident in the logs ... which I thought had been fixed.

You could try editing /includes/modules/payment/paypal/paypal_functions.php
around line 173 you'll see:

    $transaction_amount = number_format(($amount) * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency));

replace that with:```
$transaction_amount = preg_replace('/[^0-9.]/', '', number_format(($amount) * $currencies->get_value($my_currency), $currencies->get_decimal_places($my_currency)));

Hmm...as far as I know, I have applied all patches a few weeks ago...
I have done the changes you recommend and will wait for the next "german" or Credit Card Transaction
Thanks a lot for your efforts....will report back if it works.

Stupid me, after one year i remembered to inform that it worked. Sorry

Hi!

Where can i find this Modul? Its not in the Download Area.

Pleas help!

simmsen