paypal IPN woes

Hi,

I've got my cart set up to accept Paypal IPN payments only. All worked well on testing but since going live, every transaction has resulted in PayPal taking the money but no emails being delivered and empty orders against the customers name. When I try it myself, it woks smoothly and as expected.

So to summarise, I can make orders using Paypal, my customers attempts fail. Any ideas?

Make sure that you have installed the current PayPal Patch and uninstalled, reinstalled and reconfigured your payment module:
http://www.zen-cart.com/forum/showthread.php?t=56216

Ajeh:

Make sure that you have installed the current PayPal Patch and uninstalled, reinstalled and reconfigured your payment module:
http://www.zen-cart.com/forum/showthread.php?t=56216

Thanks, ajeh. but doesn't that only apply to paypal Express? I'm not using Express.

It applies to both actually ... :smile:

Ajeh:

Make sure that you have installed the current PayPal Patch and uninstalled, reinstalled and reconfigured your payment module:
http://www.zen-cart.com/forum/showthread.php?t=56216

Ajeh:

It applies to both actually ... :smile:

Thanks. I've just made the update. Hopefully it'll sort me out. Could not having the patch installed effect all but my own sales?

wishy

The patch fixes numerous things since the release of v1.3.7 ...

Let's see if the magic happens for you ... :smile:

Ajeh:

The patch fixes numerous things since the release of v1.3.7 ...

Let's see if the magic happens for you ... :smile:

Darn. Afraid not. Still customers' orders not working. I have to reorder for them whereupon it works perfectly and as it should. Any other clues? This is driving me nuts.

Explain how it is that you are re-ordering for them and it works but does not work for them?

What is different?

Ajeh:

Explain how it is that you are re-ordering for them and it works but does not work for them?

What is different?

Nothing that I can see is different. I now temporarily install and reorder via CC coz, I can use the test number, but if I make an order and go through the full paypal payment process, all goes smoothly.

Have you tried turning on the debug for this?

Ajeh:

Have you tried turning on the debug for this?

Yes, I have debug on. I've looked at the resulting log files but don't really know how to diagnose the problem from that info.

Anyone any hints on how my PayPal log files can help identify problems? There is the following extract that looks mighty suspicious...

May 04 2007 8:51 -- Breakpoint: 1 - Collected data from PayPal notification

May 04 2007 8:51 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

May 04 2007 8:51 -- Breakpoint: 2 - Validated transaction components

May 04 2007 8:51 -- Breakpoint: 3 - Communication method verified

May 04 2007 8:51 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

May 04 2007 8:51 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

tia,
wishy

That debug log correctly states that:> Could not find matched txn_id record in DB. Therefore is new to us.For a new transaction (rather than an update such as an eCheck clearance notice, etc), that is expected.

There should be several more lines in the debug output, similar to this:> May 03 2007 11:02 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

May 03 2007 11:02 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 62V10969UC5928123

May 03 2007 11:02 -- Breakpoint: 5 - Transaction type (txn_type) = something-here

May 03 2007 11:02 -- IPN INFO :: Currency/Amount Details:
PayPal email address = mytest@my_test.com
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 3.62
| converted_amount = 3.62
| order_amount = 6.84

May 03 2007 11:02 -- Breakpoint: 6 - Completed IPN order add. ordersID = 32 IPN_id=13Was there any more info in your log? If not, then at least we know approximately "where" it's failing.

What version of PHP are you using?
What version of MySQL?

DrByte:

That debug log correctly states that:For a new transaction (rather than an update such as an eCheck clearance notice, etc), that is expected.

There should be several more lines in the debug output, similar to this:Was there any more info in your log? If not, then at least we know approximately "where" it's failing.

Yes there are more lines. Here's the full debug file with customer details and store email blanked out.

Don't know if it's relevant but set cookie gives the store server IP address

May 05 2007 14:57 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202 notify.paypal.com

May 05 2007 14:57 -- IPN NOTICE :: ipn_application_top -> language files okay

May 05 2007 14:57 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => XXXXXXXXXXX
[address_country] => XXXXXXXXXXXXX
[address_country_code] => US
[address_name] => XXXXXXX XXXXXXXXX
[address_state] => XX
[address_status] => confirmed
[address_street] => XXXX XXXXX XXXX
[address_zip] => XXXXXX
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=4a5c61366939afd7df2cc208a2f633bb
[first_name] => XXX
[item_name] => Future Historic Purchase
[item_number] => 1
[last_name] => XXXXXX
[mc_currency] => GBP
[mc_fee] => 0.51
[mc_gross] => 7.99
[notify_version] => 2.1
[payer_email] => XXXXXXXXXXXXXXXX
[payer_id] => CWRYWEKB9BY2A
[payer_status] => verified
[payment_date] => 06:58:06 May 05, 2007 PDT
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => R87L7YBPSPRQS
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 8JS141025P5949601
[txn_type] => web_accept
[verify_sign] => AKwUpvimaCAfmfJ-.PhckWeGqTcrArGM-jI.FuK.RrlthLo0frKDkBOg
)

May 05 2007 14:57 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /uk/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 893
Connection: close

Array
(
[mc_gross] => 7.99
[address_status] => confirmed
[payer_id] => CWRYWEKB9BY2A
[tax] => 0.00
[address_street] => XXX XXXXX XXXX
[payment_date] => 06:58:06 May 05, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => XXXXX
[first_name] => XXX
[mc_fee] => 0.51
[address_country_code] => US
[address_name] => XXX XXXXXX
[notify_version] => 2.1
[custom] => zenid=4a5c61366939afd7df2cc208a2f633bb
[payer_status] => verified
[business] => [email protected]
[address_country] => XXXXXX XXXXXXX
[address_city] => XXXXXXXXXXXX
[quantity] => 1
[verify_sign] => AKwUpvimaCAfmfJ-.PhckWeGqTcrArGM-jI.FuK.RrlthLo0frKDkBOg
[payer_email] => XXXXXXXXXXXXXXX
[txn_id] => 8JS141025P5949601
[payment_type] => instant
[last_name] => XXXXXXX
[address_state] => XX
[receiver_email] => [email protected]
[payment_fee] =>
[receiver_id] => R87L7YBPSPRQS
[txn_type] => web_accept
[item_name] => Future Historic Purchase
[mc_currency] => GBP
[item_number] => 1
[residence_country] => US
[payment_gross] =>
[shipping] => 0.00
[cmd] => _notify-validate
)

May 05 2007 14:57 -- IPN INFO - Confirmation/Validation response
HTTP/1.1 200 OK
,Date: Sat, 05 May 2007 13:58:10 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=Tue, 02-May-2017 13:58:10 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=81.21.73.35.143141178373490727; path=/; expires=Mon, 27-Apr-37 13:58:10 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,

May 05 2007 14:57 -- Breakpoint: 1 - Collected data from PayPal notification

May 05 2007 14:57 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

May 05 2007 14:57 -- Breakpoint: 2 - Validated transaction components

May 05 2007 14:57 -- Breakpoint: 3 - Communication method verified

May 05 2007 14:57 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

May 05 2007 14:57 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 8JS141025P5949601

May 05 2007 14:57 -- Breakpoint: 5 - Transaction type (txn_type) = unique

May 05 2007 14:57 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 7.99
| converted_amount = 7.99
| order_amount = 7.99

DrByte:

What version of PHP are you using?

PHP Ver 5.0.3

DrByte:

What version of MySQL?

MySQL Ver 4.1.10a

cheers,
wishy

Do you have any mods/contributions/addons installed? Which ones?

Have you made any customization changes to the order.php class or the checkout_process.php module?

DrByte:

Do you have any mods/contributions/addons installed? Which ones?

I've added, Add Customers from Admin and Capitalize Sign_Up Fields. Both to try and assist with the problem which had occurred prior.

DrByte:

Have you made any customization changes to the order.php class or the checkout_process.php module?

No. I'm not a coder. The Paypal process initially worked during testing but never has with real remote customers.

wishy

Just for gigles,
in your paypal mod in your ZC admin,

what do you have set for the currency?

Merlinpa1969:

Just for gigles,
in your paypal mod in your ZC admin,

what do you have set for the currency?

The first one, which is called Selected Currency.

wishy

Hello, Wishy:

I have exactly the same problem you did right now. When customer place an order onto my side and pay with Pay IPN, I can receive the money into my paypal account, but I don't receive any email from the Admin, and there is no new order showing in the "Order" in Admin.

Right now I am following Ajeh's suggestions and reintall a brand new Zencart 3.17 onto my server and use the original Zencart database, without adding any modules. If this problem still exists, then it must be something wrong with Paypal IPN. I will let you the result after I finish the intall and test.

Lina

Hello, Wishy:

I installed the original zencart 3.7 onto the server and tested the Paypal IPN, without adding any modules. The same problem still orrured. I think it is the problem of Paypal. But you can still use Pay Express Checkout, which is still working.

Lina