Order Details not saving on Checkout when using Paypal IPN

[ficiousjigs.com]

Can anyone help me figure out why the product detail is not being saved when the PayPal IPN payment method is used?

It works just fine when selecting the Check/Money Order payment method.

The customers information is there along with only the order total.

Thanks in advance.

[ficiousjigs.com]

Just to add some clarification ... I realize that it won't show up on the paypal site. The order detail is not showing up within the zencart admin when the paypal is used as the method of payment.

[DrByte]

The age-old "orders not in Zen Cart" when using PayPal IPN issue. It's almost always a result of failed communication from PayPal's server to your server, in order to release the order.

Troubleshooting: http://www.zen-cart.com/wiki/index.php/PayPal

Also make sure you're using the most recent released version of Zen Cart so that you have all the bugfixes.

[ficiousjigs.com]

Thanks for the quick reply.

I went through the checklist and believe that everything is set up correctly.

When an order is passed to PayPal ... I see the order summary with the total dollar amount. I get passed back to my site and it tells me that the payment was successfully processed. The problem is that in the zencart database I can see a record for the order in the "orders" table ... but the "orders_products" table has no related records to that order. Same story when I look through the admin console.

Any ideas on why the order detail is not being saved? Again ... the order detail does save if I use the payment option of check/money order which leads me to believe it is some sort of paypal thing. I did read something that indicated the paypal IPN does not take the detail and that my store would save the detail.

I can send you screenshots of things if that would help. Just let me know what to send.

Thanks

[DrByte]

The problem is that in the zencart database I can see a record for the order in the "orders" table ... but the "orders_products" table has no related records to that order.

That's a little different then.

What version of Zen Cart?
What are *all* the addons/contributions you've got installed?

It seems that something's got a dependency somewhere, which works fine when the customer is shopping, but when PayPal comes in its back-door to complete the order it's not finding all the dependencies properly.

[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