PayPal IPN - can't tell what customer ordered

I have a similar problem. The customer ordered and paid via paypa and the only notification i rec'd was from paypal, but the receipt didn't say what the customer ordered. There was no record of an order placed in my Admin, so I had to email the cust and asked them what they bought!

I have everything set to email me, so i'm not sure why I didnt get the receipt though my ZC admin. I contaced paypal yesterday about why there's no order detail in their receipt and they said it was because of something ZC, but I'm clueless as to what's not set up right.

All of my orders through Auth.net work just fine, so i'm not sure where to start with this paypal thing. Oh, I was running the PayPal IPN and just a minute ago I activated the PayPal Express and turned off the IPN in hopes that maybe one works better than the other for me....now I just have to wait for an order!

So if anyone could help me on the Admin side, I'd really appreciate it.

jo

FAQ on common causes of PayPal problems:
http://www.zen-cart.com/wiki/index.php/PayPal

I'm not sure whether this may help, but one of the problems we were having after we installed all the patches and made sure all the settings were correct was the following error after payment was completed in Paypal

1406 Data too long for column 'last_page_url' at row 1
in:

[update <<<INPUT DATA REMOVED FOR PRIVACY>>>]

Increasing the size of the "last_page_url" field in the sql database fixed the error of the paypal orders not being completed and everything is working fine (well almost - we're getting duplicate orders now, but that's better then not getting the information).

where can i go to find the last url field

/includes/functions/whos_online.php
change this line (around 34): $wo_user_agent = zen_db_prepare_input($_SERVER['HTTP_USER_AGENT']);to:```
$wo_user_agent = [B]substr([/B]zen_db_prepare_input($_SERVER['HTTP_USER_AGENT'])[B], 0, 254)[/B];

I'm having the same issue with PayPal IPN. The last successful transaction was on 9/12. All paypal ipn transactions currently return the customer to the store and report that the order was successful but the order does not appear. Also, the order number shown on the 'success' page is their previous successful order, not the the number their order should be.

I tried changing /includes/functions/whos_online.php as noted above but this didn't fix the problem. Also, the DB field was already 255 chars so i didn't change it.

Anything I can do to debug the issue?

Veazer:

The last successful transaction was on 9/12.What transpired on the 12th? esp on your webserver ... perhaps by your hosting company?

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

I reported the problem the the host last time this occurred and the problem was resolved the following day. Now the exact same problem has resurfaced and the host says they have not made any changes and are not to blame.

Here's the test results, most significant results first:

PayPal IPN module log:

**Feb 25 2008 4:43 -- IPN PROCESSING INITIATED.
*** Originating IP: 61.90.235.7 ppp-61-90-235-7.revip.asianet.co.th
*** Browser/User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12

Feb 25 2008 4:43 -- IPN FATAL ERROR :: No POST data available -- Most likely initiated by browser and not PayPal.

*** The rest of this log report can most likely be ignored !! ***

Feb 25 2008 4:43 -- IPN FATAL ERROR :: Could not find stored session in DB, cannot re-create session as PayPal IPN transaction.

Feb 25 2008 4:43 -- IPN FATAL ERROR :: No saved session data available to build order from IPN. Cannot process this as an IPN-only transaction.

Feb 25 2008 4:43 -- IPN NOTICE :: ipn_application_top -> language files okay

Feb 25 2008 4:43 -- IPN INFO - POST VARS received (sorted):
Array
(
) **

Paypal settings for return handler and and IPN notification are correct. PDT token is not enabled, but never was.

Sorry for bump, but i don't know what other info to provide. I've shown the PayPal error log, and the curl and ipntest pass normally.

What does the error in the PayPal IPN module mean?

Veazer:

PayPal IPN module log:

**Feb 25 2008 4:43 -- IPN PROCESSING INITIATED.
*** Originating IP: 61.90.235.7 ppp-61-90-235-7.revip.asianet.co.th
*** Browser/User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12

Feb 25 2008 4:43 -- IPN FATAL ERROR :: No POST data available -- Most likely initiated by browser and not PayPal.

*** The rest of this log report can most likely be ignored !! ***

Feb 25 2008 4:43 -- IPN FATAL ERROR :: Could not find stored session in DB, cannot re-create session as PayPal IPN transaction.

Feb 25 2008 4:43 -- IPN FATAL ERROR :: No saved session data available to build order from IPN. Cannot process this as an IPN-only transaction.

Feb 25 2008 4:43 -- IPN NOTICE :: ipn_application_top -> language files okay

Feb 25 2008 4:43 -- IPN INFO - POST VARS received (sorted):
Array
(
) **

That's a result of someone trying to access ipn_main_handler.php via a browser. It's not a log of an actual transaction from PayPal.
So ... there's nothing there to troubleshoot.

OK, so if the only activity in the log is from directly accessing the file from testing, does this mean that the host is likely blocking the port 80 or 443 needed for communication with the module?

Veazer:

OK, so if the only activity in the log is from directly accessing the file from testing, does this mean that the host is likely blocking the port 80 or 443 needed for communication with the module?

If all the logs show only browser-based tests and nothing from PayPal, then ... either PayPal isn't sending the IPNs or your host has blocked incoming traffic from PayPal. It's unlikely to be a port issue, or your browser couldn't access it.

Make sure your PayPal profile still has IPN enabled. They'll sometimes turn it off if they get rejects from your server several times in a row. Usually they send an automated email about it though.

Hi, I'm having trouble with the Paypal IPN, I get notifications of a sale from Paypal, put the order does not show up in Admin so I do not actually know what the customer had ordered!

I have used the IPNCheck tool with the following results:

------------------ IPNCHECK.PHP - Version 1.0

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

Warning: fsockopen() [function.fsockopen]: no SSL support in this build in /home/divasext/public_html/ipncheck.php on line 81

Warning: fsockopen() [function.fsockopen]: unable to connect to www.paypal.com:443 in /home/divasext/public_html/ipncheck.php on line 81
IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = ssl://www.paypal.com:443 (13) Permission denied

Trying again without SSL ...

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

Script finished. -----------------

Debug has been turned on with the results below:

Keys for submission: Array
(
[bn] => zencart
[cmd] => _ext-enter
[rm] => 2
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[page_style] => Diva
[lc] => GB
[custom] => zenid=eec0f2ea4e96487fe895fb9af5bebac8
[charset] => iso-8859-1
[return] =>
http://www.divasextoys.co.uk/index.php?main_page=checkout_process&referer=paypal
[cancel_return] =>
http://www.divasextoys.co.uk/index.php?main_page=checkout_payment
[shopping_url] =>
http://www.divasextoys.co.uk/index.php?main_page=shopping_cart
[notify_url] => http://www.divasextoys.co.uk/ipn_main_handler.php
[redirect_cmd] => _xclick
[business] => [email protected]
[first_name] => Removed
[last_name] => Removed
[address1] => Removed
[city] => Removed
[state] => Removed
[zip] => Removed
[country] => GB
[email] => Removed
[no_shipping] => 1
[currency_code] => GBP
[paypal_order_id] =>
[item_name] => Diva Toys Purchase
[item_number] => Store Receipt
[upload] => 1
[amount] => 0.01
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00
)
IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com
IPN NOTICE :: ipn_application_top -> language files okay
IPN INFO - POST VARS received (sorted):
Array
(
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=eec0f2ea4e96487fe895fb9af5bebac8
[first_name] => Removed
[item_name] => Diva Toys Purchase
[item_number] => Store Receipt
[last_name] => Removed
[mc_currency] => GBP
[mc_fee] => 0.01
[mc_gross] => 0.01
[notify_version] => 2.4
[payer_email] => [email protected]
[payer_id] => 9SMGVE98FDSKN
[payer_status] => verified
[payment_date] => 12:45:35 Mar 10, 2008 PDT
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => ENB2SJ5B579CC
[residence_country] => GB
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 9YT61711N10834621
[txn_type] => web_accept
[verify_sign] =>
A2S1fniRGsoquzRDbs4f5rc383f8AqMa9YyUIYXSPCOAm4HOA9Zqc5fr
)
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: 721
Connection: close

Array
(
[payment_date] => 12:45:35 Mar 10, 2008 PDT
[txn_type] => web_accept
[last_name] => Removed
[residence_country] => GB
[item_name] => Diva Toys Purchase
[payment_gross] =>
[mc_currency] => GBP
[business] => [email protected]
[payment_type] => instant
[verify_sign] =>
A2S1fniRGsoquzRDbs4f5rc383f8AqMa9YyUIYXSPCOAm4HOA9Zqc5fr
[payer_status] => verified
[tax] => 0.00
[payer_email] => [email protected]
[txn_id] => 9YT61711N10834621
[quantity] => 1
[receiver_email] => [email protected]
[first_name] => Removed
[payer_id] => 9SMGVE98FDSKN
[receiver_id] => ENB2SJ5B579CC
[item_number] => Store Receipt
[payment_status] => Completed
[payment_fee] =>
[mc_fee] => 0.01
[shipping] => 0.00
[mc_gross] => 0.01
[custom] => zenid=eec0f2ea4e96487fe895fb9af5bebac8
[charset] => windows-1252
[notify_version] => 2.4
[cmd] => _notify-validate
IPN INFO - Confirmation/Validation response SUCCESS
Breakpoint: 1 - Collected data from PayPal notification
IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected] From CONFIG = [email protected]
Breakpoint: 2 - Validated transaction components
Breakpoint: 3 - Communication method verified

Would really appreciate any help
Patrick