Order Details not saving on Checkout when using Paypal IPN

[ficiousjigs.com]

I turned paypal logging on and ran a transaction through.

2 Files were created ... here is the content of the 1st file, I changed some personal info:

Nov 17 2007 21:19 -- Keys for submission: Array
(
[bn] => zencart
[cmd] => _ext-enter
[rm] => 2
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[page_style] => Primary
[lc] => US
[custom] => zenid=4533f954451013735501f4a3aadace4d
[charset] => iso-8859-1
[return] => http://www.ficiousjigs.com/zencart/i...referer=paypal
[cancel_return] => http://www.ficiousjigs.com/zencart/i...eckout_payment
[shopping_url] => http://www.ficiousjigs.com/zencart/i...=shopping_cart
[notify_url] => http://www.ficiousjigs.com/zencart/ipn_main_handler.php
[redirect_cmd] => _xclick
[business] => [email protected]
[first_name] => Joe
[last_name] => Kool
[address1] => 1313 Mockingbird Lane
[city] => Los Angeles
[state] => CA
[zip] => 90021
[country] => US
[email] => matt_eckert######################
[H_PhoneNumber] => 1111111111
[night_phone_a] => 222
[night_phone_b] => 333
[night_phone_c] => 3556
[day_phone_a] => 222
[day_phone_b] => 333
[day_phone_c] => 3556
[no_shipping] => 1
[currency_code] => USD
[paypal_order_id] =>
[item_name] => ficious jigs Purchase
[item_number] => Store Receipt
[upload] => 1
[amount] => 1.50
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00
)

Here is the contents of the second file:

Nov 17 2007 21:21 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Nov 17 2007 21:21 -- IPN NOTICE :: ipn_application_top -> language files okay

Nov 17 2007 21:21 -- IPN INFO - POST VARS received (sorted):
Array
(
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=4533f954451013735501f4a3aadace4d
[first_name] => Joe
[item_name] => ficious jigs Purchase
[item_number] => Store Receipt
[last_name] => Kool
[mc_currency] => USD
[mc_gross] => 1.50
[notify_version] => 2.4
[payer_email] => joe_kool######################
[payer_id] => 8SG5VHQVTV5LW
[payer_status] => verified
[payment_date] => 18:17:50 Nov 17, 2007 PST
[payment_gross] => 1.50
[payment_status] => Pending
[payment_type] => echeck
[pending_reason] => echeck
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => ZTV4Z48VNX8M8
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 3TW533093E671443T
[txn_type] => web_accept
[verify_sign] => A-l7Ht3gCcGUz87UP0AOBYyGo3TWATPnco-ZINZ1HPbgGVhGCR-ZOW1D
)


Nov 17 2007 21:21 -- 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: 709
Connection: close

Array
(
[txn_type] => web_accept
[payment_date] => 18:17:50 Nov 17, 2007 PST
[last_name] => Kool
[residence_country] => US
[pending_reason] => echeck
[item_name] => ficious jigs Purchase
[payment_gross] => 1.50
[mc_currency] => USD
[business] => [email protected]
[payment_type] => echeck
[verify_sign] => A-l7Ht3gCcGUz87UP0AOBYyGo3TWATPnco-ZINZ1HPbgGVhGCR-ZOW1D
[payer_status] => verified
[tax] => 0.00
[payer_email] => joe_kool######################
[txn_id] => 3TW533093E671443T
[quantity] => 1
[receiver_email] => [email protected]
[first_name] => Joe
[payer_id] => 8SG5VHQVTV5LW
[receiver_id] => ZTV4Z48VNX8M8
[item_number] => Store Receipt
[payment_status] => Pending
[shipping] => 0.00
[mc_gross] => 1.50
[custom] => zenid=4533f954451013735501f4a3aadace4d
[charset] => windows-1252
[notify_version] => 2.4
[cmd] => _notify-validate
)


Nov 17 2007 21:21 -- IPN INFO - Confirmation/Validation response
SUCCESS

Nov 17 2007 21:21 -- Breakpoint: 1 - Collected data from PayPal notification

Nov 17 2007 21:21 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Nov 17 2007 21:21 -- Breakpoint: 2 - Validated transaction components

Nov 17 2007 21:21 -- Breakpoint: 3 - Communication method verified

Nov 17 2007 21:21 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Nov 17 2007 21:21 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 3TW533093E671443T

Nov 17 2007 21:21 -- Breakpoint: 5 - Transaction type (txn_type) = pending-echeck

Nov 17 2007 21:21 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = USD
| submitted_currency = USD
| order_currency = USD
| mc_gross = 1.50
| converted_amount = 1.50
| order_amount = 1.5

[ficiousjigs.com]

I just read your last post.

Here's the info I pulled from the admin console.

Zen Cart 1.3.7.1
Database Patch Level: 1.3.7.1

I installed this version, it was not an update.

I am not sure what you mean by the addons/contributions you've got installed?

This site is basically the vanilla zencart. The 2 payment option modules I have installed are check/money order and the PayPal IPN.

[DrByte]

Does it work differently if you use real PayPal funds instead of echeck?
or a Credit Card?

[ficiousjigs.com]

Good Question - I am going to test it out

[ficiousjigs.com]

hmmmph ... it's going to take 3 days for the money to become available

[ficiousjigs.com]

PLEASE ... I STILL NEED SOME HELP

Here is a bit more information.

When I go into paypal and refund an order there is an entry that shows up in the paypal_payment_status_history table. The Paypal table has no rows. So it seems that paypal can communicate back to me.

[ficiousjigs.com]

I tried the credit card method and it behaved exactly the same way.

I put all the details into a MS Word doc if you'd like me to send it to you.

[ficiousjigs.com]

While the issues with the PayPal IPN module have not been resolved, we can still consider this thread closed.

ADVICE: Dump the IPN and use the PayPal Express Checkout. Paypal has a great way to test all this through their Sandbox and when I went live it all worked the 1st attempt. You DO NOT need Web Payments Pro ... the Web Payments Standard works just fine and there is no additional fees.