Forums / Built-in Shipping and Payment Modules / Order processed, but no confirmation email & no details on admin (Paypal IPN)

Order processed, but no confirmation email & no details on admin (Paypal IPN)

Locked

Started by garou on 25 Feb 2010, 3:59 PM · Views: 3,833

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
25 Feb 2010, 3:59 PM
#1
garou avatar

garou

New Zenner

Join Date:
Feb 2010
Posts:
2
Plugin Contributions:
0

Order processed, but no confirmation email & no details on admin (Paypal IPN)

Hi!

First of all I have to thank you guys because without the precious informations that I've found on this site I would be probably stuck at trying to figure out how to make ImageHandler work... :blush:

Now, my problem, as you can tell from the title, is with Paypal IPN...

I already solved the double order issue and the problem with the 'payment_date', but now it seems that I've reached my limit as a troubleshooter...

My orders are processed, but the customer doesn't get a confirmation email, the order under Customers > Orders has no details and I get absolutely nothing under Customers > Paypal IPN.

Zen Cart (1.3.8b - Italian version) runs on a Windows machine with PHP 5.2.10 and mySql 5.0.51. The only addon installed is ImageHandler.

This is what I get from the ipncheck.php:

IPNCHECK.PHP - Version 1.3.9

IPN TESTING - Response Received via CURL -- COMMUNICATIONS OKAY

IPN ERROR :: Could not establish fsockopen:

Host Details = ssl://www.paypal.com:443 (136) Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?

Trying again with HTTPS over 443 ...

IPN ERROR :: Could not establish fsockopen:

Host Details = https://www.paypal.com:443 (25280476) Unable to find the socket transport "https" - did you forget to enable it when you configured PHP?

Trying again directly over 443 ...

IPN TESTING - Confirmation/Validation response with fsockopen(): FAILED

Default method likely to be used for communications is: CURL, with the fallback method being FSOCKOPEN if possible.

Script finished.

An this is one of the last logs after a "successful" transaction (credit card and direct Paypal account have the same results):

Feb 25 2010 14:37 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Feb 25 2010 14:37 -- IPN INFO - POST VARS received (sorted):
Array
(
[business] => info@******.com
[charset] => windows-1252
[custom] => zenid=grn4loj71kvev4gq11iklj3md4
[first_name] => Nome
[handling_amount] => 0.00
[item_name] => Cose di Casa Shop Purchase
[item_number] => Store Receipt
[last_name] => Cognome
[mc_currency] => EUR
[mc_fee] => 0.01
[mc_gross] => 0.01
[notify_version] => 2.9
[payer_email] => *######################
[payer_id] => W5AX7AS7UJVE2
[payer_status] => verified
[payment_date] => 05:36:59 Feb 25, 2010 PST
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[protection_eligibility] => Ineligible
[quantity] => 1
[receiver_email] => info@
.com
[receiver_id] => ACRXQEMZWFMB2
[residence_country] => IT
[shipping] => 0.00
[tax] => 0.00
[transaction_subject] => zenid=grn4loj71kvev4gq11iklj3md4
[txn_id] => 0B027641443982521
[txn_type] => web_accept
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ4qi4-AK9qVpb9NX9qpiWl4Elcemxm8Iq.
)

Feb 25 2010 14:37 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /it/cgi-bin/webscr HTTP/1.1
Host: https://www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 831
Connection: close

Array
(
[transaction_subject] => zenid=grn4loj71kvev4gq11iklj3md4
[payment_date] => 05:36:59 Feb 25, 2010 PST
[txn_type] => web_accept
[last_name] => Cognome
[residence_country] => IT
[item_name] => Cose di Casa Shop Purchase
[payment_gross] =>
[mc_currency] => EUR
[business] => info@******.com
[payment_type] => instant
[protection_eligibility] => Ineligible
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ4qi4-AK9qVpb9NX9qpiWl4Elcemxm8Iq.
[payer_status] => verified
[tax] => 0.00
[payer_email] => *######################
[txn_id] => 0B027641443982521
[quantity] => 1
[receiver_email] => info@
.com
[first_name] => Nome
[payer_id] => W5AX7AS7UJVE2
[receiver_id] => ACRXQEMZWFMB2
[item_number] => Store Receipt
[handling_amount] => 0.00
[payment_status] => Completed
[payment_fee] =>
[mc_fee] => 0.01
[shipping] => 0.00
[mc_gross] => 0.01
[custom] => zenid=grn4loj71kvev4gq11iklj3md4
[charset] => windows-1252
[notify_version] => 2.9
[cmd] => _notify-validate
)

Feb 25 2010 14:37 -- IPN INFO - Confirmation/Validation response
SUCCESS

Feb 25 2010 14:37 -- Breakpoint: 1 - Collected data from PayPal notification

Feb 25 2010 14:37 -- IPN INFO :: Transaction email details.
From IPN = info@.com | info@.com
From CONFIG = info@******.com

Feb 25 2010 14:37 -- Breakpoint: 2 - Validated transaction components

Feb 25 2010 14:37 -- Breakpoint: 3 - Communication method verified

Feb 25 2010 14:37 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Feb 25 2010 14: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 = 0B027641443982521

Feb 25 2010 14:37 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Feb 25 2010 14:37 -- IPN INFO :: Currency/Amount Details:
PayPal email address = info@******.com
| mc_currency = EUR
| submitted_currency = EUR
| order_currency = EUR
| mc_gross = 0.01
| converted_amount = 0.01
| order_amount = 0.01

Any help or advice would be really appreciated :smile:

Thanks!

25 Feb 2010, 5:00 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Order processed, but no confirmation email & no details on admin (Paypal IPN)

Express Checkout doesn't suffer from the many dependancies that the IPN module is limited by.
I recommend clicking "Remove" on the IPN module and install Express Checkout instead.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

26 Feb 2010, 8:36 AM
#3
garou avatar

garou

New Zenner

Join Date:
Feb 2010
Posts:
2
Plugin Contributions:
0

Re: Order processed, but no confirmation email & no details on admin (Paypal IPN)

:smile: yeah, you're right...
It's just that I spent the last days trying to figure out how to make it work properly and it's a bit frustrating being forced to switch to another solution...
But my client wants results, so Express Checkout here I come...
Thanks anyway o-Sensei-sama :smile: