Simple Cart – not recording sandbox orders

[Lee]

I setup Simple Cart and the Collect Customer Input plug in.

I enabled the PayPal Sandbox and processed a couple of orders, using the Sandbox buyer and seller accounts. The PayPal order confirmation in the Sandbox account, shows that the order was completed.

The transaction completes successfully, and I end up at the Order Complete page on my site, however, I don’t receive the email that should be send to the Seller, and Cart Orders continues to show no orders. The Trash section of the page shows a new pending entry for each order, but it contains no details.

[admin]

This will be an issue with the IPN notification. The plugin is not receiving the IPN notification from PayPal sandbox.

Two things can cause this issue:

#1) You don’t have the IPN notification turned in your Sandbox account. The following video will explain how to enable the IPN feature (in your case, you need to enable it in your sandbox account):

https://www.tipsandtricks-hq.com/ecommerce/how-to-setup-paypal-ipn-notification-2796

#2) There is a security or firewall plugin that is blocking the IPN notification.

Enable the debug logging option in the plugin settings. That will show you if the plugin is getting the IPN notification or not.

[Lee]

Ok, I followed the steps to enable IPN for the Sandbox account, and that now shows it’s enabled. I’m still seeing a similar result (empty pending entries in the trash). The debug log shows the following. It looks like an SSL error, but the website is not currently using SSL. I had chatted with PayPal support earlier this evening and they told me that SSL wasn’t required for IPN to work. Did they give me bad info?

===========

[03/10/2020 2:33 AM] – SUCCESS :Collect input addon: wpspsc_cci_save_data_handler hook triggered

[03/10/2020 2:35 AM] – SUCCESS :Paypal Class Initiated by 173.0.82.126

[03/10/2020 2:35 AM] – SUCCESS :Post string : mc_gross=560.00&protection_eligibility=Ineligible&item_number1=&item_number2=&payer_id=P7ZMCTE5JSV98&payment_date=19%3A35%3A12+Mar+09%2C+2020+PDT&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&first_name=John&mc_fee=16.54&notify_version=3.9&custom=wp_cart_id%253D3776%2526ip%253D73.81.14.51&payer_status=verified&business=sb-hmcyf1168364%40business.example.com&num_cart_items=2&verify_sign=AqgbzXxZczxnHeJ6bYgEH0vQ68XtAr2bmNT6AHivEuaw3h7vGtSZ96UK&payer_email=sb-xdr211154353%40personal.example.com&mc_shipping1=0.00&txn_id=4HY95609TR7067801&payment_type=instant&last_name=Doe&item_name1=Standard+Ticket&receiver_email=sb-hmcyf1168364%40business.example.com&item_name2=Under+40+Ticket&payment_fee=16.54&shipping_discount=0.00&quantity1=2&insurance_amount=0.00&quantity2=1&receiver_id=WHNESEURNB52C&txn_type=cart&discount=0.00&mc_gross_1=400.00&mc_currency=USD&mc_gross_2=160.00&residence_country=US&test_ipn=1&shipping_method=Default&transaction_subject=&payment_gross=560.00&ipn_track_id=8ea82e851435d&

[03/10/2020 2:35 AM] – SUCCESS :Checking if PayPal IPN response is valid

[03/10/2020 2:35 AM] – SUCCESS :Connecting to: https://www.sandbox.paypal.com/cgi-bin/webscr

[03/10/2020 2:35 AM] – FAILURE :IPN validation failed.

[03/10/2020 2:35 AM] – FAILURE :Error response: cURL error 35: error:14077410:SSL routines:SSL23_GET_SERVER_HELLO:sslv3 alert handshake failure

[03/10/2020 2:35 AM] – SUCCESS :Paypal class finished.

===========

[admin]

This looks like an issue with the server configuration. Setting up sandbox can be a little tricky sometimes (if you are not a developer). I would recommend you do the test with a $1 transaction in live mode. Then you can refund that transaction. That way you will remove a lot of the other issues from the equation (issues that are related to setting up everything sandbox related). It’s better to do the testing “live” anyway because once the normal transaction is working, you can keep it as is. Otherwise, you will need to do the testing again in live mode since your live paypal account and sandbox account do not share the setup (those account have completely separate configuration that need to be configured correctly).

Some useful information here (it is a good read):

https://support.tipsandtricks-hq.com/forums/topic/plugin-testing-checklist-setup-preparation-for-testing

Can you do live mode testing here?

[Author]

Posts