Zen Cart v1.5.5f PayPal Express Checkout issues

Hi,

been using zen cart for about a month, so far no real issues (until this) and am quite impressed!

So basically, I've setup my site https://phantomvaper.com using X10Hosting's free hosting solution (confirmed PHP version 7.1 installed and in use).

I have Cloudflare running, a shared SSL cert (flexible SSL) provided by them, and have configured the site to run fully on HTTPS.

I've installed Ultimate SOE urls, Quick Updates, SBA (Products with Attributes stock) & Sitemap.xml modules, with all working together well.

I've then setup (as per the instructions) the Paypal Express Checkout module and have validated the setup by making test purchases whilst in Sandbox mode.

However, when changing the module to live, customers go through the paypal checkout, click pay now, and are redirected to a blank page on my site.

No order is raised, and no payment is taken from the customer, it just doesn't work.

So I enabled debug with email, and can see that there is a 10486 error being returned by paypal, and instructing to redirect to paypal.
This doesn't work, the page stays on a blank page.

Then when attempting to test this myself, I've created a test product (for 1p), and a discount code to remove any postage fee (9a213caf25), run through the checkout using my personal details and a card with funds. Same error... so its not an insufficient funds problem.

I've verified the IPN link is set in paypal as "https://phantomvaper.com/store/ipn_main_handler.php".

After reading nearly every post on this site, I've also set and turned on the return URL in paypal with the following,

"https://phantomvaper.com/index.php?main_page=checkout_process"

And I've checked everything else I can find, including the test scripts provided (all report back as ok with no issues found (this was expected though as the sandbox purchases work fine)).

2018-02-21 07:09:52
-------------------
(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers:
Array
(
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 90
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(R) - PayPal/NVP
    [4] => X-VPS-VIT-Integration-Version: 1.5.5
)


Request Parameters: {DoExpressCheckoutPayment}
Array
(
    [PAYMENTREQUEST_0_AMT] => 0.01
    [PAYMENTREQUEST_0_ITEMAMT] => 0.01
    [L_PAYMENTREQUEST_0_NAME0] => All the items in your shopping basket (see details in the store and on your store receipt).
    [L_PAYMENTREQUEST_0_AMT0] => 0.01
    [PAYMENTREQUEST_0_SHIPTONAME] => emma wicks
    [PAYMENTREQUEST_0_SHIPTOSTREET] => 25 Cherry Tree Court
    [PAYMENTREQUEST_0_SHIPTOSTREET2] => Fairlawn
    [PAYMENTREQUEST_0_SHIPTOCITY] => Charlton
    [PAYMENTREQUEST_0_SHIPTOSTATE] => Charlton
    [PAYMENTREQUEST_0_SHIPTOZIP] => SE7 7DX
    [PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE] => GB
    [BUTTONSOURCE] => ZenCart-EC_us
    [RETURNFMFDETAILS] => 0
    [PAYMENTREQUEST_0_CUSTOM] => EC-1-1519214989
    [PAYMENTREQUEST_0_INVNUM] => 1-1519214989-[PhantomVaper]
    [PAYMENTREQUEST_0_CURRENCYCODE] => GBP
    [TOKEN] => EC-1HA12097734434612
    [PAYERID] => KGVKAPSWTH7RY
    [PAYMENTREQUEST_0_PAYMENTACTION] => Sale
    [NOTIFYURL] => https://phantomvaper.com/store/ipn_main_handler.php
    [METHOD] => DoExpressCheckoutPayment
    [USER] => syoung_api1.sega.co.uk
    [PWD] => ****************
    [VERSION] => 124.0
    [SIGNATURE] => ****************************************************2W.t
)


Response:
Array
(
    [TOKEN] => EC-1HA12097734434612
    [SUCCESSPAGEREDIRECTREQUESTED] => false
    [TIMESTAMP] => 2018-02-21T12:09:52Z
    [CORRELATIONID] => 237a6f314746c
    [ACK] => Failure
    [VERSION] => 124.0
    [BUILD] => 43715881
    [L_ERRORCODE0] => 10486
    [L_SHORTMESSAGE0] => This transaction couldn't be completed.
    [L_LONGMESSAGE0] => This transaction couldn't be completed. Please redirect your customer to PayPal.
    [L_SEVERITYCODE0] => Error
    [CURL_ERRORS] =>
)

Can anyone shed any light on why every customer is seeing this same error please? (its driving me insane!!!)

Thanks,
Shaun

Well two things, one may be a transcription error, the return address provided above does not include the store folder:

https://phantomvaper.com/index.php?main_page=checkout_process

Probably should be:

https://phantomvaper.com/[b]shop/[/b]index.php?main_page=checkout_process

The other thing not identified in the detailed message above is if different credentials were obtained to place the store in live mode with respect to PayPal. (yes, the credentials for live should be different than for sandbox.)

Another thing to check is for any myDebug-xxx style logs generated in the effort as a blank page ought to create one: http://www.zen-cart.com/content.php?124-blank-page

And yet another is what payment methods have been activated in configuration->credit cards?

Updating the log to include a full debug log... (this time with privacy edits made).

paypalwpp
In function: before_process() - Express Checkout

Value List:
Array
(
    [PAYMENTREQUEST_0_AMT] => 0.01
    [PAYMENTREQUEST_0_ITEMAMT] => 0.01
    [L_PAYMENTREQUEST_0_NAME0] => All the items in your shopping basket (see details in the store and on your store receipt).
    [L_PAYMENTREQUEST_0_AMT0] => 0.01
    [PAYMENTREQUEST_0_SHIPTONAME] => [Full Name]
    [PAYMENTREQUEST_0_SHIPTOSTREET] => [Address Line 1]
    [PAYMENTREQUEST_0_SHIPTOSTREET2] => Address Line 2
    [PAYMENTREQUEST_0_SHIPTOCITY] => [City]
    [PAYMENTREQUEST_0_SHIPTOSTATE] => [Same as city]
    [PAYMENTREQUEST_0_SHIPTOZIP] => [PostCode]
    [PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE] => GB
    [BUTTONSOURCE] => ZenCart-EC_us
    [RETURNFMFDETAILS] => 0
    [PAYMENTREQUEST_0_CUSTOM] => EC-1-1519227845
    [PAYMENTREQUEST_0_INVNUM] => 1-1519227845-[PhantomVaper]
    [PAYMENTREQUEST_0_CURRENCYCODE] => GBP
    [TOKEN] => EC-63U5445543479261A
    [PAYERID] => KGVKAPSWTH7RY
    [PAYMENTREQUEST_0_PAYMENTACTION] => Sale
    [NOTIFYURL] => https://phantomvaper.com/store/ipn_main_handler.php
    [METHOD] => DoExpressCheckoutPayment
    [USER] => [API User]
    [PWD] => ****************
    [VERSION] => 124.0
    [SIGNATURE] => ****************************************************2W.t
)


Response:
Array
(
    [TOKEN] => EC-63U5445543479261A
    [SUCCESSPAGEREDIRECTREQUESTED] => false
    [TIMESTAMP] => 2018-02-21T15:44:08Z
    [CORRELATIONID] => 1726b3cc23f04
    [ACK] => Failure
    [VERSION] => 124.0
    [BUILD] => 43715881
    [L_ERRORCODE0] => 10486
    [L_SHORTMESSAGE0] => This transaction couldn't be completed.
    [L_LONGMESSAGE0] => This transaction couldn't be completed. Please redirect your customer to PayPal.
    [L_SEVERITYCODE0] => Error
    [CURL_ERRORS] =>
)



Session data: Array
(
    [securityToken] => [Token]
    [customers_host_address] => [IP]
    [SSL_SESSION_ID] =>
    [cartID] => 30129
    [cart] => shoppingCart Object
        (
            [contents] => Array
                (
                    [87] => Array
                        (
                            [qty] => 1
                        )

                )

            [total] => 0.01
            [weight] => 0
            [cartID] => 30129
            [content_type] => physical
            [free_shipping_item] => 0
            [free_shipping_weight] => 0
            [free_shipping_price] => 0
            [download_count] => 0
            [total_before_discounts] => 0.01
            [display_debug_messages] =>
            [flag_duplicate_msgs_set] =>
        )

    [check_valid] => true
    [navigation] => navigationHistory Object
        (
            [path] => Array
                (
                    [0] => Array
                        (
                            [page] => index
                            [mode] => SSL
                            [get] => Array
                                (
                                    [type] => ec
                                    [token] => EC-63U5445543479261A
                                    [PayerID] => KGVKAPSWTH7RY
                                )

                            [post] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                            [page] => checkout_process
                            [mode] => SSL
                            [get] => Array
                                (
                                )

                            [post] => Array
                                (
                                )

                        )

                )

            [snapshot] => Array
                (
                )

        )

    [language] => english
    [languages_id] => 1
    [languages_code] => en
    [currency] => GBP
    [today_is] => 2018-02-21
    [updateExpirations] => 1
    [pwas_class2] => products_with_attributes_class_stock Object
        (
            [_isSBA:products_with_attributes_class_stock:private] => Array
                (
                )

        )

    [session_counter] => 1
    [customers_ip_address] => [IP]
    [customer_id] => 1
    [customer_default_address_id] => 1
    [customers_authorization] => 0
    [customer_first_name] => [Customer First Name]
    [customer_last_name] => [Customer Second Name]
    [customer_country_id] => 222
    [customer_zone_id] => 300
    [messageToStack] =>
    [valid_to_checkout] => 1
    [cart_errors] =>
    [sendto] => 1
    [payment] => paypalwpp
    [shipping_weight] => 0
    [shipping] => Array
        (
            [id] => table_table
            [title] => Table Rate (1 x 0.00kg) (Best Way)
            [cost] => 4.99
        )

    [billto] => 1
    [shipping_tax_amount] => 0.998
    [comments] =>
    [cc_id] => 4
    [paypal_ec_markflow] => 1
    [paypal_ec_token] => EC-63U5445543479261A


    [paypal_ec_payer_id] => KGVKAPSWTH7RY
    [paypal_ec_payer_info] => Array
        (
            [payer_id] => KGVKAPSWTH7RY
            [payer_email] => [paypal email address]
            [payer_salutation] =>
            [payer_gender] =>
            [payer_firstname] => [First Name]
            [payer_lastname] => [Surname]
            [payer_business] =>
            [payer_status] => unverified
            [ship_country_code] => GB
            [ship_address_status] => Confirmed
            [ship_phone] => [Phone Number minus first 0]
            [order_comment] =>
            [ship_name] => [Customer Name Removed]
            [ship_street_1] => [Address Line 1]
            [ship_street_2] => [Addres Line 2]
            [ship_city] => [City]
            [ship_state] => [Same as city]
            [ship_postal_code] => [Post Code]
            [ship_country_name] => United Kingdom
        )

    [paypal_ec_temp] =>
    [payment_attempt] => 1
    [shipping_tax_description] => VAT
)

I've also tried disabling Ultimate SEO URLS to no avail, and whilst they were enabled, I've also tried reinstalling the PayPal express... module.

Thanks!

Good spot for the IPN link... (thanks) where can I edit it in the config? As paypal has that set correctly, but my site is in the "store" folder, so this must be an internal site issue. (UPDATE: Checked the return URL in paypal... it was missing the store subfolder... updated and testing again).
Yes the API credentials set for live are from my merchant account (not my sandbox account).

And no other payment modules are enabled (not even free shipping!).

Will check the debug logs now, I've about 300 of them now due to the debug / repeat testing... so could take me a few mins to find the correct one (any tips for a naming conventions for the specific file that would be generated please?)

Thanks,
Shaun

(UPDATE: Checked the return URL in paypal... it was missing the store subfolder... updated and testing again).

mc12345678:

Well two things, one may be a transcription error, the return address provided above does not include the store folder:

https://phantomvaper.com/index.php?main_page=checkout_process

> Probably should be:
> ```
https://phantomvaper.com/[b]shop/[/b]index.php?main_page=checkout_process

The other thing not identified in the detailed message above is if different credentials were obtained to place the store in live mode with respect to PayPal. (yes, the credentials for live should be different than for sandbox.)

Another thing to check is for any myDebug-xxx style logs generated in the effort as a blank page ought to create one: http://www.zen-cart.com/content.php?124-blank-page

And yet another is what payment methods have been activated in configuration->credit cards?

Ok, so just realised what you meant by Credit cards...

Only had the top two enabled previously, but now have these. Purchases are still failing.

Nothing obvious in the debug logs either...

Thanks again,
Shaun

madshaun1984:

Good spot for the IPN link... (thanks) where can I edit it in the config? As paypal has that set correctly, but my site is in the "store" folder, so this must be an internal site issue. (UPDATE: Checked the return URL in paypal... it was missing the store subfolder... updated and testing again).
Yes the API credentials set for live are from my merchant account (not my sandbox account).

And no other payment modules are enabled (not even free shipping!).

Will check the debug logs now, I've about 300 of them now due to the debug / repeat testing... so could take me a few mins to find the correct one (any tips for a naming conventions for the specific file that would be generated please?)

Thanks,
Shaun

(UPDATE: Checked the return URL in paypal... it was missing the store subfolder... updated and testing again).

Naming convention is myDebug-xxxxx (Where xxxxx is either a series of numbers or admin followed by a series of numbers. Looking for most recent of such log, the previously provided link (http://www.zen-cart.com/content.php?124-blank-page) provides more detail about the logs.

Unsure (because of updates to this and the post that followed it) of current status/configuration.

As far as failing, the question becomes are they failing with the same message(s) or is there something different occurring now that these changes have been made?

madshaun1984:

Good spot for the IPN link... (thanks) where can I edit it in the config? As paypal has that set correctly, but my site is in the "store" folder, so this must be an internal site issue. (UPDATE: Checked the return URL in paypal... it was missing the store subfolder... updated and testing again).
Yes the API credentials set for live are from my merchant account (not my sandbox account).

And no other payment modules are enabled (not even free shipping!).

Will check the debug logs now, I've about 300 of them now due to the debug / repeat testing... so could take me a few mins to find the correct one (any tips for a naming conventions for the specific file that would be generated please?)

Thanks,
Shaun

(UPDATE: Checked the return URL in paypal... it was missing the store subfolder... updated and testing again).

Free shipping is not a payment module, but instead a shipping module.

Do you have any shipping modules enabled?

In checkout process, have you attempted to step all the way through to the checkout_confirmation page or only using/trying express checkout from the shopping_cart page?

mc12345678:

Free shipping is not a payment module, but instead a shipping module.

Do you have any shipping modules enabled?

In checkout process, have you attempted to step all the way through to the checkout_confirmation page or only using/trying express checkout from the shopping_cart page?

Nevermind, review of the log data identifies that table rate shipping is enabled as shown in post #3.

Ok, so decided to delete all current logs (all 1000+ of them) and re-test purchasing.

So...

I got 6 logs as a result of yet another failed purchase (error still shows as 10486)...

The logs all look exactly the same as previously, and are all relating to the Paypal module directly, non are named "myDebug-xxx.

In one of the logs I have noticed the following (near the top of the log).

getLineItemDetails 6
Discounts have caused the subtotal to calculate incorrectly. Line-item-details cannot be submitted.

Could this be the root cause of the error, as all purchases have had the same coupon applied (to provide free shipping).
How should I go about testing this?

Beyond that, everything else is the same as already posted, or a log of a successful part of the payment chain (happy to post anything specifically required though).

To answer the last couple of replies.

Only paypal express (debug) is enabled under payment modules. Shipping modules has only table rates enabled.

Order total modules are as follows,

Also, forgot I had installed the Simple Social Share module.

Really running out of idea's now...

Thanks,
Shaun

Yeah, since the payment amount is 0, it appears the software protects itself from trying to submit a payment amount (includes/modules/payment/paypalwpp.php:

if (strval($optionsST['PAYMENTREQUEST_0_ITEMAMT']) <= 0) {

So, couple of options. Guess could set paypal to authorize instead of capture, then after a test payment is received, could cancel the purchase instead of refund it.

mc12345678:

Yeah, since the payment amount is 0, it appears the software protects itself from trying to submit a payment amount (includes/modules/payment/paypalwpp.php:

if (strval($optionsST['PAYMENTREQUEST_0_ITEMAMT']) <= 0) {

> 
> So, couple of options. Guess could set paypal to authorize instead of capture, then after a test payment is received, could cancel the purchase instead of refund it.

Just attempted that, wont even open the paypal window now...

10423 Transaction refused because of an invalid argument. See additional error messages for details. - This transaction cannot be completed with PaymentAction of Authorization.

Going to increase the price to an item of £1... However, have a feeling this will fail too as the error was originally found when an actual customer tried to purchase an item for £71.10...

Update: Setting Authorize instead of Final Sale fails with same blank page / error code (10486).

This was for an item set at £1.00 inc: VAT £0.8333 pre:VAT.

I have also removed the API signiture from Paypal, and created / updated the modules config with new API Access details.

Ok... gone back to the drawing board and have switched to sandbox again.

Purchases go through fine while in sandbox, so this must be being declined by the bank... for some reason. How would I find out / what would the most likely cause be?

Also, how do I fix the "blank" page issue, as that's really not useful...

I've checked the includes/modules/paypal/paypalwpp.php file has the extra string to catch the 10486 error as recommended elsewhere, but its clearly not working...

Thanks,
Shaun

Can't recall the message seen way back when, but at one point if the "older" VAT module was installed without making some changes to modules such as PayPal, a purchase would not go through properly. All that said to ask, what version or method of including VAT is being used?

Also, there was a change applied to PayPal I think in 1.5.5f associated with decimal differences and I don't know if that is playing a factor in this issue or not.

Another question that was asked was if any other methods of using paypal express other than buy now have been attempted such as logging in after arriving at the shopping_cart, stepping through checkout (checkout_shipping, checkout_payment and selecting paypal, then checkout_confirmation) and what, if any issues were experienced?

Another question related to the testing process (understanding that other customers seemed to end up having issues as well) was if you had logged out/logged back in, cleared sesions/cache/cookies, etc...

Yes some of these are guesses and possibilities, but am trying to rule out other issues.

Speaking of which, since there was a message generated in one of the paypal debug logs where that log had not been fully shared, would suggest cleansing it like done with the others and posting it as it should show more of what is happening "internally" to maybe she'd some light on the issue.

Lastly (for now), do things work differently if instead of entering £1 as the gross price to back calculate what the "original" price was, what happens if instead a realistic net price is entered to then calculate a gross price that shows what the value of the product is after adding the Value Added Tax?

Ok so big update today, I bit the bullet in the end last night and reached out to paypal....

They said that due to the "risk assessment"associated with my registering the site as a "Retail" business and set the subcategory to "Tobacco related", the paypal system automatically flags the site as a high risk. For this eeason all transactions for the site were being automatically declined.

They have escalated it to their internal "branding" team to set about lifting this bar on payments,but in the meantime have given me a workaround of editing the category of my store in my profile setting (so I set it as "other retail - Non durable goods).

After making this change and switching the api access strings back to the live environment. I then edited my test product back to 0.01p in price, added it to cart, used a discount code to remove shipping costs and then successfully ran through checkout / paypal login and purchase.

I was returned to the site correctly etc... and payment shows as successful in both buyer / merchant paypal accounts, plus the order was raised correctly in my zen cart admin pages.

So... what this leaves to resolve now is the mystery (I have no way to test this now as I dont have a 0 balance funding source available, is the failed redirect to paypal due to a 10486 error being seen (as it appears that this just doesn't work? Or coukd it be due to some paypal f$%#ery had effectively blacklisted my site?).

Anyone know if this is actually going to occur to customers that are legitimately declined due to insufficient funds? And if so, how would I fix it if the suggested fixes are already a part of the module included with zen cart v1.5.5f?

Thanks to all who have offered input so far!
Shaun

Remember that log I discussed? It would/should provide the path of how the error was "collected"/identified such that the path of a user's issue could be also considered and reviewed.

It would appear that in this situation that even though error 10486 was thrown with the suggestion to redirect back to PayPal that there would not be anything that PayPal would support because it was not a customer issue but instead a "store" issue. (yes I know a setting to identify the type of product.)

What I'm saying is that the process incorporated to address 10486 is expected to be related to a customer problem. That the error code for a store problem wasn't sufficiently handled doesn't mean that the customer related problem wouldn't be handled. This should be testible (the software right?) through the sandbox mode and offering some customer level of information that would result in throwing 10486...

Afterall your question relates to how the software works on the store side when PayPal returns an error resulting from the customer's information, not as relates to the store's setup/product.

The other part of that would have been what was the uri on the browser when the blank page was seen? I'm guessing it was a paypal address with '?cmd=_express-checkout&token=' in it.

Ah ok, yeah just escalated this again with paypal as the uri was ended "checkout_process" and didnt have the token attached.

They seem to believe that this would of been the result (as you mentioned) an incorrectly handled error code on paypals side and not due to the customer.

They are going to monitor for declined payments / test the site to ensure it isn't an issue once the bars lifted etc... so I'll leave this here for a bit but stop worrying about it for now.

Thanks again for the support with this... seems paypal should be giving a different error for this type of devlined reason if you ask me, as that would of made the issue easily identifiable and rectifiable immediately rather than cost me 2 days of checking / double checking every little detail...

Oh well, live and learn right...

Shaun

madshaun1984:

Thanks again for the support with this... seems paypal should be giving a different error for this type of devlined reason if you ask me, as that would of made the issue easily identifiable and rectifiable immediately rather than cost me 2 days of checking / double checking every little detail...

Oh well, live and learn right...

Shaun
Yup.

Also identifies further that the sandbox isn't quite as completely the same as the live side as they claim. :)