Help! Orders are NOT recording

[DrByte]

Two more side questions if I may: should I leave off the Payment Data Transfer?

I guess if it won't work with your server, maybe leaving it off is best. But if you haven't tested it since overcoming the misuse of the proxy server, you might want to try it again.

And is it supposed to take so long for the redirect to occur from PayPal to the checkout_success?

No, it's not. The delay sounds like it's coming from PayPal's end.

the question is, should I keep cURL off? Or should I follow your fix in this thread?

Best to use the fix, since you may need the CURL proxy for other services.

[ktak1]

I have a similar problem, but I don't believe it to be an issue with the Paypal IPN.

An order came in on my website, was processed, got transferred to Paypal, payment was received, and the IPN was sent back to my website. The IPN was working correctly except that my website had no order to match the IPN to.

Somewhere in this process, the original order on my website was either not recorded or overwritten by another order. I checked the orders table in my ZC database and there is no record of that particular order. All orders at the time this missing order was placed show that there is no break in the sequential numbering within the Orders table.

So this one customers order just disappeared from Zen Cart. This is the first and only time this has happened or that I am aware of. The customer's registration information and last login/access is recorded in the ZC db, but no order. I know that an order WAS placed thru my website because the Paypal IPN shows all the relevant ID numbers and information. And again, payment was received.

What could have caused this? Could this be a recurring problem?

[pricediscrimination]

Sounds like you might have the same problem I had. You need to do a few things to figure out where the problem is coming from.


1. Go to www.yoursite.com/ipn_main_handler.php and see what it says. If there are an errors listed there, let us know. If it says "Nothing to process. Please return to home page" then that part is ok.

2. If you are using v1.3.8, go to www.yoursite.com/extras/ipncheck.php. It should respond with "IPN TESTING - Confirmation/Validation response: RESPONSE RECEIVED - Communications OKAY".

3. Go to Admin>>My Store>>cURL Proxy Status turn to False then try to do a test payment using PayPal IPN. If it works, then this was the problem. If you only use IPN, you can get away with using this fix, but if you ever plan to use the other PayPal modules, you'd better use this fix instead.


If none of those option work, you will have to turn on the debugging mode, complete a test transaction, and post the results here for someone like DrByte to analyze. But please, try those options first.

[DrByte]

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

[Jorditoms]

Thank you, I do change it to FALSE and all things it's right!!

Thank you very much.

Jordi

[bmarquis]

I thank you for this terrific support site. I finally got my orders to show up... now I just have to find the work around for the ship-to problem.

If the product is virtual - and will not be shipped, how can you get around the problem with paypal that says the payment is unverified?

The Paypal module is looking for a ship to address - but the Zen checkout module won't ask for a ship to if I say that the item is virtual.

Any ideas?
Thanks a million!

[Delights]

Greetings, I am having the same problem with my Palpay,

It goes though and does the order, gives me an order number but nothing is coming up under orders in the Admin and also i am not getting the emails that get sent when there is an order.

Also i have noticed that the order number is the same since it hasnt been working. "Order 132".

here is a copy of the log file.

Breakpoint: 3 - Communication method verified

IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Breakpoint: 5 - Transaction type (txn_type) = unique

Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 9DS25944VN0095812

IPN INFO - Confirmation/Validation response
SUCCESS

IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

Breakpoint: 2 - Validated transaction components

IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Breakpoint: 1 - Collected data from PayPal notification

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: 774
Connection: close

Array
(
[payment_date] => 22:19:04 Nov 01, 2008 PDT
[txn_type] => web_accept
[last_name] => Smith
[residence_country] => AU
[item_name] => Delights of the Flesh Purchase
[payment_gross] =>
[mc_currency] => AUD
[business] => [email protected]
[payment_type] => instant
[protection_eligibility] => Ineligible
[verify_sign] =>
AiPC9BjkCyDFQXbSkoZcgqH3hpacA0tLdvw4fKUmFFt1H10wm1p3rQ8R
[payer_status] => verified
[tax] => 0.00
[payer_email] => jensmith##########################
[txn_id] => 9DS25944VN0095812
[quantity] => 1
[receiver_email] => [email protected]
[first_name] => Jen
[payer_id] => RN8ZH2367HJCJ
[receiver_id] => KX9UYJ2BQNF7Y
[item_number] => Store Receipt
[payment_status] => Completed
[payment_fee] =>
[mc_fee] => 0.12
[shipping] => 0.00
[mc_gross] => 0.12
[custom] => zenid=4f90402aa32e4a31987640f9bc8ee2f1
[charset] => windows-1252
[notify_version] => 2.5
[cmd] => _notify-validate
)

IPN INFO - POST VARS received (sorted):
Array
(
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=4f90402aa32e4a31987640f9bc8ee2f1
[first_name] => Jen
[item_name] => Delights of the Flesh Purchase
[item_number] => Store Receipt
[last_name] => Smith
[mc_currency] => AUD
[mc_fee] => 0.12
[mc_gross] => 0.12
[notify_version] => 2.5
[payer_email] => jensmith##########################
[payer_id] => RN8ZH2367HJCJ
[payer_status] => verified
[payment_date] => 22:19:04 Nov 01, 2008 PDT
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[protection_eligibility] => Ineligible
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => KX9UYJ2BQNF7Y
[residence_country] => AU
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 9DS25944VN0095812
[txn_type] => web_accept
[verify_sign] =>
AiPC9BjkCyDFQXbSkoZcgqH3hpacA0tLdvw4fKUmFFt1H10wm1p3rQ8R
)

I have checked the Settings in Paypal and they appear to be correct. Also i am not recieving anthing under the section "PayPal Instant Payment Notifications".

[Delights]

Okey, i figured out what the error was.

I was also running the addon Store Credit and it was error when you went to complete the order, i believe that this error was also impacting on Paypal somehow, even though it didnt show the error at all when the order was completed with Paypal.

[littletoycompany]

Has anyone found the solution to this problem? I have gone through all of the steps suggested and I still have this problem. Any assistance would be greatly appreciated. I turned off Paypal payments on our cart but its bewildering!!! I sure would like to get this resolved

Janice

[meowhead]

https://www.zen-cart.com/tutorials/index.php?article=28

"PayPal Website Payments Standard (formerly referred to as "PayPal IPN" in older versions of Zen Cart) takes the customer to PayPal's site AFTER the ENTIRE checkout in order to make payment. The customer can pay without having a PayPal account (depending on what country YOU are in ... PayPal limits that feature for some countries). After the payment is completed, your store is notified of the completed payment, after which time the order is stored in your database. If the customer pays without making a PayPal account and declines the invitation to make one, your store sits in limbo and never gets the order (due to a bug in PayPal's logic, which they've not fixed yet). If they DO have OR make a PayPal account, you get the notification and the order is stored in your database. **IF there is any problem in PayPal's ability to communicate to your server, you will never see the order, because it relies entirely on PayPal's server being able to talk to your server in order to store the order."

If this is indeed the problem, how do we fix it?