PayPal RESTful API Payment Module

Using Paypalr 1.0.2 with ZC 1.58a and OPC 2.4.6, I've seen this e-mail alert a few times over the last day or two:

ALERT: PayPal Checkout Error (Order Requires Attention)

An error was returned by PayPal when attempting to initiate an order. As a courtesy, only the error 'code' was shown to your customer.  The details of the error are shown below.

{
    "errNum": 400,
    "errMsg": "An interface error (400) was returned from PayPal.",
    "curlErrno": 0,
    "name": "INVALID_REQUEST",
    "message": "Request is not well-formed, syntactically incorrect, or violates schema.",
    "details": [
        {
            "field": "/purchase_units",
            "value": "",
            "location": "body",
            "issue": "MISSING_REQUIRED_PARAMETER",
            "description": "A required field / parameter is missing."
        },
        {
            "field": "/intent",
            "value": "",
            "location": "body",
            "issue": "MISSING_REQUIRED_PARAMETER",
            "description": "A required field / parameter is missing."
        }
    ],
    "debug_id": "7610a5441e3e4"
}

I think each one has been for a payment in EUR while our store's default currency is GBP. This is a new issue - I've been using Paypalr for months without seeing this before.
I also have the Paypalr and OPC debug logs that I can send if it helps.

I have checked other, successful orders today and they include both card and Paypal payments via Paypalr.

BillJ:

Using Paypalr 1.0.2 with ZC 1.58a and OPC 2.4.6, I've seen this e-mail alert a few times over the last day or two:

ALERT: PayPal Checkout Error (Order Requires Attention)

An error was returned by PayPal when attempting to initiate an order. As a courtesy, only the error 'code' was shown to your customer. The details of the error are shown below.

{
"errNum": 400,
"errMsg": "An interface error (400) was returned from PayPal.",
"curlErrno": 0,
"name": "INVALID_REQUEST",
"message": "Request is not well-formed, syntactically incorrect, or violates schema.",
"details": [
{
"field": "/purchase_units",
"value": "",
"location": "body",
"issue": "MISSING_REQUIRED_PARAMETER",
"description": "A required field / parameter is missing."
},
{
"field": "/intent",
"value": "",
"location": "body",
"issue": "MISSING_REQUIRED_PARAMETER",
"description": "A required field / parameter is missing."
}
],
"debug_id": "7610a5441e3e4"
}

> I *think* each one has been for a payment in EUR while our store's default currency is GBP. This is a new issue - I've been using Paypalr for months without seeing this before.
> I also have the Paypalr and OPC debug logs that I can send  if it helps.
> 
> I have checked other, successful orders today and they include both card and Paypal payments via Paypalr.
Yep, shoot me the paypalr logs (the OPC ones aren't going to "tell the story"), please.

lat9:

Yep, shoot me the paypalr logs (the OPC ones aren't going to "tell the story"), please.

On its way. Thanks!

When I press the Confirm Order button in PayPal, I get sent back to the cart, but I'm logged off.

The only PayPal log I have is the first one created:

2024-06-28 13:40:16: (index) ppr_webhook_main (return, live) starts.
{
"op": "return",
"token": "",
"PayerID": "",
"main_page": "index"
}

I wonder if this is a samesite cookie issue?

Tested - nope, that's not the problem.

For some reason, $_SESSION['PayPalRestful'] is not set on return. And a logout has been done.

Everything looks good right before the handoff:

2024-06-28 23:50:53: (checkout_confirmation) pre_confirmation_check, sending the payer-action off to PayPal.

I'm wondering if there's a session issue on their server. Investigating.

Since I switched from PayPal Express to RESTful I get a couple errors every time someone uses it. I had hoped that getting all my updates done would fix, but it has not. I have not yet tried this in my 2.0.1 dev environment. Currently on:
ZC 1.5.8a
Bootstrap 3.7.2
OPC 2.5.2
PayPal Checkout Restful 1.0.2
PayPal Express Checkout 1.5.8 (disabled)
PHP 8.1.29

First Error:

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 /includes/modules/payment/paypal/paypal_functions.php(48): zen_debug_error_handler()
#1 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#2 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#3 /includes/application_top.php(237): require('/home/pcs/publi...')
#4 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 48.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 /includes/modules/payment/paypal/paypal_functions.php(55): zen_debug_error_handler()
#1 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#2 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#3 /includes/application_top.php(237): require('/home/pcs/publi...')
#4 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 55.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 /includes/modules/payment/paypal/paypal_functions.php(48): zen_debug_error_handler()
#1 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 48.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 /includes/modules/payment/paypal/paypal_functions.php(55): zen_debug_error_handler()
#1 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Warning: Undefined array key 1 in /includes/modules/payment/paypal/paypal_functions.php on line 55.

Second Error:

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(561): preg_match()
#2 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#3 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#4 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#5 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#6 /includes/application_top.php(237): require('/home/pcs/publi...')
#7 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Deprecated: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 561.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id not set
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(177): mysqli_real_escape_string()
#2 /includes/classes/db/mysql/query_factory.php(562): queryFactory->prepare_input()
#3 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#4 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#5 /includes/init_includes/init_paypal_ipn_sessions.php(34): ipn_get_stored_session()
#6 /includes/autoload_func.php(40): require_once('/home/pcs/publi...')
#7 /includes/application_top.php(237): require('/home/pcs/publi...')
#8 /ipn_main_handler.php(122): require('/home/pcs/publi...')
--> PHP Deprecated: mysqli_real_escape_string(): Passing null to parameter #2 ($string) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 177.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(561): preg_match()
#2 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#3 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#4 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Deprecated: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 561.

[30-Jul-2024 19:54:03 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.140, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(177): mysqli_real_escape_string()
#2 /includes/classes/db/mysql/query_factory.php(562): queryFactory->prepare_input()
#3 /includes/classes/db/mysql/query_factory.php(513): queryFactory->getBindVarValue()
#4 /includes/modules/payment/paypal/paypal_functions.php(48): queryFactory->bindVars()
#5 /ipn_main_handler.php(217): ipn_get_stored_session()
--> PHP Deprecated: mysqli_real_escape_string(): Passing null to parameter #2 ($string) of type string is deprecated in /includes/classes/db/mysql/query_factory.php on line 177.

Thoughts or suggestions?

Well it looks like this does NOT happen in my 2.0.1 dev environment, so hopefully its fixed in the new version.

Noting that those errors identified in the 2nd post back are coming from the ipn_main_handler.php, which is not part of the PayPal RESTful implementation.

I am testing this module against a sandbox account and have come across a problem.
If a customer makes a sucessful purchase using paypal restful and then attempts to make a second purchase with out loging out one of 2 things happen.
The first time I tried it the paypal restful module was disable so paypal could not be used for the second transaction.
This produced an admin log. (so it may have been a different issue as i sucessfully issues a refund).

[09-Aug-2024 10:38:01 UTC] Request URI: /sales/ILSadmin/index.php?cmd=orders&origin=index&page=1&oID=2087&action=edit, IP address: 127.0.0.1, Language id 1

#0 [internal function]: zen_debug_error_handler()

#1 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(547): trigger_error()
#2 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(534): paypalr->setConfigurationDisabled()
#3 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(291): paypalr->validateConfiguration()
#4 /home/lotus/public_html/innerlightcrystals/sales/ILSadmin/orders.php(514): paypalr->__construct()
#5 /home/lotus/public_html/innerlightcrystals/sales/ILSadmin/index.php(16): require('...')
--> PHP Warning: Setting configuration disabled: The <b>sandbox</b> credentials for the <var>paypalr</var> payment module are invalid. in /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php on line 547.

The second time I tested it (having logged out and back in) I got the message " We are unable to process your PayPal Checkout payment at this time. Please contact us for assistance."
I think this is the pertenat bit of the log file

    "errMsg": "An interface error (422) was returned from PayPal.",
    "curlErrno": 0,
    "name": "UNPROCESSABLE_ENTITY",
    "message": "The requested action could not be performed, semantically incorrect, or failed business validation.",
    "details": [
        {
            "issue": "ORDER_ALREADY_CAPTURED",
            "description": "Order already captured.If 'intent=CAPTURE' only one capture per order is allowed."
        }

This is against zen cart 2.0.1 using php 8.3.9 mysql 8.3.9
If you need any further info please let me know.

Yea, I need to come up with a better GUID; that's where the 'already captured' message is coming from.

lat9:

Yea, I need to come up with a better GUID; that's where the 'already captured' message is coming from.

could you just use php function uniqid?

Think if would also be nice if an email was sent to the administrator if the status is changed because of an error.

brittainmark:

could you just use php function uniqid?

Think if would also be nice if an email was sent to the administrator if the status is changed because of an error.
It's a matter of choosing variables that are part of the uniquid; I'm already using a sha256 hash to create that GUID.

I'm unclear as to what condition an email should be sent to the admin as the processing already sends an email to the admin if the configuration is auto-disabled.

brittainmark:

I am testing this module against a sandbox account and have come across a problem.
If a customer makes a sucessful purchase using paypal restful and then attempts to make a second purchase with out loging out one of 2 things happen.
The first time I tried it the paypal restful module was disable so paypal could not be used for the second transaction.
This produced an admin log. (so it may have been a different issue as i sucessfully issues a refund).

[09-Aug-2024 10:38:01 UTC] Request URI: /sales/ILSadmin/index.php?cmd=orders&origin=index&page=1&oID=2087&action=edit, IP address: 127.0.0.1, Language id 1

#0 [internal function]: zen_debug_error_handler()

#1 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(547): trigger_error()
#2 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(534): paypalr->setConfigurationDisabled()
#3 /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php(291): paypalr->validateConfiguration()
#4 /home/lotus/public_html/innerlightcrystals/sales/ILSadmin/orders.php(514): paypalr->__construct()
#5 /home/lotus/public_html/innerlightcrystals/sales/ILSadmin/index.php(16): require('...')
--> PHP Warning: Setting configuration disabled: The <b>sandbox</b> credentials for the <var>paypalr</var> payment module are invalid. in /home/lotus/public_html/innerlightcrystals/sales/includes/modules/payment/paypalr.php on line 547.

> The second time I tested it (having logged out and back in) I got the message  " We are unable to process your PayPal Checkout payment at this time. Please contact us for assistance."
> I think this is the pertenat bit of the log file
> ```
    "errMsg": "An interface error (422) was returned from PayPal.",
    "curlErrno": 0,
    "name": "UNPROCESSABLE_ENTITY",
    "message": "The requested action could not be performed, semantically incorrect, or failed business validation.",
    "details": [
        {
            "issue": "ORDER_ALREADY_CAPTURED",
            "description": "Order already captured.If 'intent=CAPTURE' only one capture per order is allowed."
        }

This is against zen cart 2.0.1 using php 8.3.9 mysql 8.3.9
If you need any further info please let me know.
Possible duplicate of this GitHub issue: https://github.com/lat9/paypalr/issues/28

Zen Cart v2.0.1
paypalr-1.0.2
https://alchemycabinet.com

I'm trying to get this plugin to work. I used to use it or one very similar with great results, so I'd really like to get it up and running again.
I may not have my configuration data correct on the PayPal side; I may have to contact them to help me with that.
Before I do that I want to make sure the Zen Cart side is functioning properly, but if I do a test run to check out with PayPal, I get the following errors:

The cart sends me to this url: https://alchemycabinet.com/ipn_main_handler.php?type=ec which simply says the cart can't handle the request.

The admin logs send me these errors (both errors for each instance):

[09-Aug-2024 17:17:42 UTC] Request URI: /ipn_main_handler.php?type=ec, IP address: 207.173.41.241
--> PHP Fatal error: Uncaught TypeError: CouponValidation::is_product_valid(): Argument #2 ($coupon_id) must be of type int, string given, called in /includes/functions/functions_gvcoupons.php on line 90 and defined in /includes/classes/CouponValidation.php:14
Stack trace:
#0 /includes/functions/functions_gvcoupons.php(90): CouponValidation::is_product_valid(2, '')
#1 /includes/modules/order_total/ot_coupon.php(635): is_product_valid(2, '')
#2 /includes/modules/order_total/ot_coupon.php(138): ot_coupon->get_order_total('')
#3 /includes/classes/order_total.php(197): ot_coupon->process()
#4 /includes/modules/payment/paypalwpp.php(1635): order_total->pre_confirmation_check()
#5 /ipn_main_handler.php(81): paypalwpp->ec_step1()
#6 {main}
thrown in /includes/classes/CouponValidation.php on line 14.

[09-Aug-2024 17:17:42 UTC] Request URI: /ipn_main_handler.php?type=ec, IP address: 207.173.41.241
--> PHP Fatal error: Uncaught TypeError: CouponValidation::is_product_valid(): Argument #2 ($coupon_id) must be of type int, string given, called in /includes/functions/functions_gvcoupons.php on line 90 and defined in /includes/classes/CouponValidation.php:14
Stack trace:
#0 /includes/functions/functions_gvcoupons.php(90): CouponValidation::is_product_valid(2, '')
#1 /includes/modules/order_total/ot_coupon.php(635): is_product_valid(2, '')
#2 /includes/modules/order_total/ot_coupon.php(138): ot_coupon->get_order_total('')
#3 /includes/classes/order_total.php(197): ot_coupon->process()
#4 /includes/modules/payment/paypalwpp.php(1635): order_total->pre_confirmation_check()
#5 /ipn_main_handler.php(81): paypalwpp->ec_step1()
#6 {main}
thrown in /includes/classes/CouponValidation.php on line 14.

I have no idea what is going on there as I don't have any coupons enabled or in use.

Thanks in advance for any help you can give. :)

ETA: I don't have either of the other PayPal modules enabled, so I don't think they're interfering with each other.

DragonLady:

Zen Cart v2.0.1
paypalr-1.0.2
https://alchemycabinet.com

I'm trying to get this plugin to work. I used to use it or one very similar with great results, so I'd really like to get it up and running again.
I may not have my configuration data correct on the PayPal side; I may have to contact them to help me with that.
Before I do that I want to make sure the Zen Cart side is functioning properly, but if I do a test run to check out with PayPal, I get the following errors:

The cart sends me to this url: https://alchemycabinet.com/ipn_main_handler.php?type=ec which simply says the cart can't handle the request.

The admin logs send me these errors (both errors for each instance):

[09-Aug-2024 17:17:42 UTC] Request URI: /ipn_main_handler.php?type=ec, IP address: 207.173.41.241
--> PHP Fatal error: Uncaught TypeError: CouponValidation::is_product_valid(): Argument #2 ($coupon_id) must be of type int, string given, called in /includes/functions/functions_gvcoupons.php on line 90 and defined in /includes/classes/CouponValidation.php:14
Stack trace:
#0 /includes/functions/functions_gvcoupons.php(90): CouponValidation::is_product_valid(2, '')
#1 /includes/modules/order_total/ot_coupon.php(635): is_product_valid(2, '')
#2 /includes/modules/order_total/ot_coupon.php(138): ot_coupon->get_order_total('')
#3 /includes/classes/order_total.php(197): ot_coupon->process()
#4 /includes/modules/payment/paypalwpp.php(1635): order_total->pre_confirmation_check()
#5 /ipn_main_handler.php(81): paypalwpp->ec_step1()
#6 {main}
thrown in /includes/classes/CouponValidation.php on line 14.

[09-Aug-2024 17:17:42 UTC] Request URI: /ipn_main_handler.php?type=ec, IP address: 207.173.41.241
--> PHP Fatal error: Uncaught TypeError: CouponValidation::is_product_valid(): Argument #2 ($coupon_id) must be of type int, string given, called in /includes/functions/functions_gvcoupons.php on line 90 and defined in /includes/classes/CouponValidation.php:14
Stack trace:
#0 /includes/functions/functions_gvcoupons.php(90): CouponValidation::is_product_valid(2, '')
#1 /includes/modules/order_total/ot_coupon.php(635): is_product_valid(2, '')
#2 /includes/modules/order_total/ot_coupon.php(138): ot_coupon->get_order_total('')
#3 /includes/classes/order_total.php(197): ot_coupon->process()
#4 /includes/modules/payment/paypalwpp.php(1635): order_total->pre_confirmation_check()
#5 /ipn_main_handler.php(81): paypalwpp->ec_step1()
#6 {main}
thrown in /includes/classes/CouponValidation.php on line 14.

I have no idea what is going on there as I don't have any coupons enabled or in use.

Thanks in advance for any help you can give. :)

ETA: I don't have either of the other PayPal modules enabled, so I don't think they're interfering with each other.
The logs "say" that you've got PayPal Express Checkout enabled and that's what was used to pay for the order.

Okay; so why was I taken to a page that says the cart can't handle the request? Is that on the PayPal end?

ZC 2.0.1 on local host.
Have installed Restful API and got my credentials (Client ID/Client Secret) from Paypal, but the mod wont activate.
I get this message:
The live credentials for the paypalr payment module are invalid. The payment module has been automatically disabled.

Do I have to test from a live site?

DragonLady:

Okay; so why was I taken to a page that says the cart can't handle the request? Is that on the PayPal end?
Because that resulted in a PHP Fatal Error, i.e. a Server 500 error.

mikecnz:

ZC 2.0.1 on local host.
Have installed Restful API and got my credentials (Client ID/Client Secret) from Paypal, but the mod wont activate.
I get this message:
The live credentials for the paypalr payment module are invalid. The payment module has been automatically disabled.

Do I have to test from a live site?
I've successfully used live credentials on a localhost test environment.

Try turning on the module's debug configuration setting. That will create a trace-log in the site's /logs directory that might have additional information.