restalfep

Taylorsuk, how did you fix it in the plugin files directly? I wasn’t sure what to change those 2 lines to. Thanks

Obviously, this isn’t ideal and Yotpo should fix it in the core plugin files so updates don’t overwrite it but I’m not sure if they are really monitoring this support forum. I also emailed them but receive no response.

I’m assuming your website is responsive (instead of changing themes depending if desktop or mobile). If your website is fully responsive then this issue most likely won’t happen for you.

We currently use Fashionzozza with Any Theme Mobile Switcher, which changes to a different version of Fashionzozza when on mobile.

We will be converting to fully responsive under 1 theme shortly though so this isn’t a big deal to us, just more of an FYI incase others are using separate themes when mobile/desktop.

I did see that but is there a way to do it with a full backup that exists from before?

For example, if I schedule daily full backups and randomly needed to restore a database only from a few days ago is there any way to use the old backup since I can’t make a “database only” as that would take the current database instead of the one from a few days ago.

Ended up being webhost issue with database and not your plugin. Sorry for the mistake.

Unfortunately, it doesn’t change anything. I updated SG Optimizer to 4.0.5. Turned on Dynamic Cache and once it was on then it messed up the mobile version of the website (it just showed Desktop version to both Mobile & Desktop). As soon as I disabled Dynamic Cache then it worked properly with just WP Rocket enabled. WP Rocket has a setting specifically to cache separately for mobile vs Desktop, incase you don’t have a responsive website & instead have a website that shows a different theme/layout to mobile. It seems with Dynamic Cache enabled in SG Optimizer, that gets overridden or ignored.

We will be updating to a responsive website soon that only uses 1 theme so this might not matter long to us, but just an FYI.

submitted ticket. thanks

Last item, then I think I debugged every scenario for this issue and I will wait for your response:

Even if you only try to order 1 X or 1 Y it still shows the SetExpresscheckoutDetails & GetExpresscheckoutDetails correct in the log (with only 1 item), but then there is the same error in the DoExpresscheckoutDetails.

When trying to order just 1 X or Y item by itself, it still shows lines for both items (with the “nan” in the log under DoExpressCheckoutPayment) when failed:

[L_PAYMENTREQUEST_0_NAME0] => X Formula
[L_PAYMENTREQUEST_0_AMT0] => nan
[L_PAYMENTREQUEST_0_NAME1] => Y Formula
[L_PAYMENTREQUEST_0_AMT1] => nan

before the correct single item:

[L_PAYMENTREQUEST_0_NAME2] => X Formula
[L_PAYMENTREQUEST_0_QTY2] => 1

So it seems it has nothing to do with coupons or ordering 2 different products. Instead, the new coding in the latest plugin update is causing those “nan” lines to show up regardless and cause the transaction to fail.

One more detail (sorry I’ve been debugging this all day), but if you add this info to the past few messages I think it should give you a good idea of what is going on:

If you disable “Send line item details to Paypal” in the Paypal Express settings for your plugin. Then the orders will go through but the Order Confirmation page shows the items incorrectly to the customer, as shown below:

X × 0 $0.00 – This line shouldn’t be here.
Y × 0 $0.00 – This line shouldn’t be here.
X × 1 $75.00
Y × 1 $75.00

Fixed.

For anyone that needs this, PayPal only passes the phone number back to your page if you set it as Required in your Merchant Account (or Sandbox account for testing).

You need to go to your PayPal Account then Profile & Settings, My Selling Tools, Website Preferences, then scroll down to Contact Telephone Number and make sure you select “On (Required Field)”. If you select the Off or On but Optional then you will not get the phone number back from Paypal and your customers will have to re-enter it.

Everything seems the same between Success and Failed in the Paypal Express logs until it gets to that final:

INFO DoExpressCheckoutPayment Request: Array, which is shown above. Before that, there is no “nan” in the logs or duplicate items showing like above.

Just tried again and used a coupon and it did work. Then tried a 2nd time and it didn’t work. Something in the Paypal Express coding is randomly causing the below variations:

These both had the exact same items in cart but for some reason, the Failed version had the items in there with “nan” Amts & then again with correct amounts. I never received this error before the USPS/UPS Fixes were implemented so perhaps something in the coding is interfering with the items sent to PayPal. Also with the failed attempt, I look at My Account page, I can see the Failed Order and it shows something like X Formula – 0, Y Formula – 0, X Formula – 1, Y Formula – 1.

[RETURNFMFDETAILS] => 1
[PAYMENTREQUEST_0_AMT] => 144.85
[PAYMENTREQUEST_0_CURRENCYCODE] => USD
[PAYMENTREQUEST_0_CUSTOM] => {“order_id”:3578,”order_key”:”wc_order_5ac6cad927310″}
[PAYMENTREQUEST_0_INVNUM] => WC-ECE18045124521
[PAYMENTREQUEST_0_PAYMENTACTION] => Sale
[PAYMENTREQUEST_0_SOFTDESCRIPTOR] => BRAND
[L_PAYMENTREQUEST_0_NAME0] => X Formula
[L_PAYMENTREQUEST_0_QTY0] => 1
[L_PAYMENTREQUEST_0_AMT0] => 75.00
[L_PAYMENTREQUEST_0_NUMBER0] => 57180
[L_PAYMENTREQUEST_0_NAME1] => Y Formula
[L_PAYMENTREQUEST_0_QTY1] => 1
[L_PAYMENTREQUEST_0_AMT1] => 75.00
[L_PAYMENTREQUEST_0_NUMBER1] => 57181
[L_PAYMENTREQUEST_0_NAME2] => Discount
[L_PAYMENTREQUEST_0_DESC2] => Discount Amount
[L_PAYMENTREQUEST_0_QTY2] => 1
[L_PAYMENTREQUEST_0_AMT2] => -15.00
[PAYMENTREQUEST_0_TAXAMT] => 0.00
[PAYMENTREQUEST_0_SHIPPINGAMT] => 9.85
[PAYMENTREQUEST_0_ITEMAMT] => 135.00

[PAYMENTREQUEST_0_AMT] => 147.90
[PAYMENTREQUEST_0_CURRENCYCODE] => USD
[PAYMENTREQUEST_0_CUSTOM] => {“order_id”:3620,”order_key”:”wc_order_5ac7d16ab2d43″}
[PAYMENTREQUEST_0_INVNUM] => WC-ECE18045124715
[PAYMENTREQUEST_0_PAYMENTACTION] => Sale
[PAYMENTREQUEST_0_SOFTDESCRIPTOR] => BRAND
[L_PAYMENTREQUEST_0_NAME0] => X Formula
[L_PAYMENTREQUEST_0_AMT0] => nan
[L_PAYMENTREQUEST_0_NAME1] => Y Formula
[L_PAYMENTREQUEST_0_AMT1] => nan
[L_PAYMENTREQUEST_0_NAME2] => X Formula
[L_PAYMENTREQUEST_0_QTY2] => 1
[L_PAYMENTREQUEST_0_AMT2] => 75.00
[L_PAYMENTREQUEST_0_NUMBER2] => 57180
[L_PAYMENTREQUEST_0_NAME3] => Y Formula
[L_PAYMENTREQUEST_0_QTY3] => 1
[L_PAYMENTREQUEST_0_AMT3] => 75.00
[L_PAYMENTREQUEST_0_NUMBER3] => 57181
[L_PAYMENTREQUEST_0_NAME4] => Discount
[L_PAYMENTREQUEST_0_DESC4] => Discount Amount
[L_PAYMENTREQUEST_0_QTY4] => 1
[L_PAYMENTREQUEST_0_AMT4] => -15.00
[PAYMENTREQUEST_0_TAXAMT] => 0.00
[PAYMENTREQUEST_0_SHIPPINGAMT] => 12.90
[PAYMENTREQUEST_0_ITEMAMT] => 135.00

The issue seems to be these random lines in the failed attempt:

[L_PAYMENTREQUEST_0_NAME0] => X Formula
[L_PAYMENTREQUEST_0_AMT0] => nan
[L_PAYMENTREQUEST_0_NAME1] => Y Formula
[L_PAYMENTREQUEST_0_AMT1] => nan

It seems to be completely random when it works or doesn’t work but it fails more often than not, and it’s always those lines in the failed attempts.

Upon looking at the logs closer. There should have been a 10% coupon applied on those orders however (coupon did show during checkout) so maybe PayPal express is getting messed up when using a coupon? So the totals should have been reduced by $15.

The coupons were working fine before though so I’m not sure if unrelated and just not showing correctly because of the PayPal Express error with the “nan” issue.

If this issue can be resolved and the phone number from PayPal can be passed to Review Order page like the rest of the information (so user doesn’t have to enter it 2x) then we should be all set. Hopefully.

Just did another test, this time using mobile and it produced same error even when not selecting “create an account”. So it seems hit or miss randomly.

Below is information from the Log file that seems to show what is going on here. The incorrect version shows the Products 2X (one time with nan under amounts):

INCORRECT VERSION (happens when hit “Create an Account)”:

[PAYMENTREQUEST_0_AMT] => 157.25
[PAYMENTREQUEST_0_CURRENCYCODE] => USD

[L_PAYMENTREQUEST_0_NAME0] => X Formula
[L_PAYMENTREQUEST_0_AMT0] => nan
[L_PAYMENTREQUEST_0_NAME1] => Y Formula
[L_PAYMENTREQUEST_0_AMT1] => nan
[L_PAYMENTREQUEST_0_NAME2] => Y Formula
[L_PAYMENTREQUEST_0_QTY2] => 1
[L_PAYMENTREQUEST_0_AMT2] => 75.00
[L_PAYMENTREQUEST_0_NUMBER2] => 57181
[L_PAYMENTREQUEST_0_NAME3] => X Formula
[L_PAYMENTREQUEST_0_QTY3] => 1
[L_PAYMENTREQUEST_0_AMT3] => 75.00
[L_PAYMENTREQUEST_0_NUMBER3] => 57999
[PAYMENTREQUEST_0_TAXAMT] => 0.00
[PAYMENTREQUEST_0_SHIPPINGAMT] => 7.25
[PAYMENTREQUEST_0_ITEMAMT] => 150.00

CORRECTION VERSION (sale completed, because didn’t select “create an account”:

[PAYMENTREQUEST_0_AMT] => 157.25
[PAYMENTREQUEST_0_CURRENCYCODE] => USD

[L_PAYMENTREQUEST_0_NAME0] => Y Formula
[L_PAYMENTREQUEST_0_QTY0] => 1
[L_PAYMENTREQUEST_0_AMT0] => 75.00
[L_PAYMENTREQUEST_0_NUMBER0] => 57181
[L_PAYMENTREQUEST_0_NAME1] => X Formula
[L_PAYMENTREQUEST_0_QTY1] => 1
[L_PAYMENTREQUEST_0_AMT1] => 75.00
[L_PAYMENTREQUEST_0_NUMBER1] => 57999
[PAYMENTREQUEST_0_TAXAMT] => 0.00
[PAYMENTREQUEST_0_SHIPPINGAMT] => 7.25
[PAYMENTREQUEST_0_ITEMAMT] => 150.00

I ran some additional tests and this issue only happens if you select “Create an Account” and enter your password on the Review Order page. It then goes back to the Cart page, then if you redo the exact same process, it will go back to the Review Order page but since you are logged in now to the site (since you created an account), the checkout will work at that point.

The Paypal Express checkout works fine as well if you don’t Create an Account on the Review Order page.

We don’t use any 3rd party plugins for discounts, coupons, etc. We do have a simple function that we use to automatically add a coupon when purchasing two separate products but it seems unlikely that would cause any issues since this only happens when using Paypal Express and hitting Create an Account on Review Order page.

It seems somehow the Create an Account is messing up the amount being passed to Paypal Express:

PayPal DoExpressCheckoutPayment API call failed
Detailed Error Message: Item amount is invalid.
Short Error Message: Transaction refused because of an invalid argument. See additional error messages for details.
Error Code: 10431
Error Severity Code: Error