Geographic area Paypal problem

PayPal Express Checkout (rev1.3.9h), getting this error on 99% of checkouts, with seemingly random successful orders mixed in:

We are sorry for the inconvenience; however, at the present time we are unable to use PayPal to process orders from the geographic region you selected as your PayPal address. Please continue using normal checkout and select from the available payment methods to complete your order.

My full address is correctly showing in the ...action.log

I swear i have looked and looked through all of the forum and on other sites that mention the same problem, mostly from last year.

I am using v1.3.9h, and every time i see a solution i a post, i get excited. When I go to apply it, it's already been applied in this version.

Fixes I found, but were already there:

• Shipping/payment zones in admin are all set to "none"
• line 1685 or something, in paypalwpp.php: (from http://www.zen-cart.com/forum/showthread.php?t=155664 )

    global $order;
    $order->info['total'] = $response['AMT'];

...and one or two others that i can't find now.

Some of the log, but with details changed:
[payer_lastname] => testerson
[payer_business] =>
[payer_status] => verified
[ship_country_code] => US
[ship_address_status] => Confirmed
[ship_phone] =>
[order_comment] =>
[ship_name] => test testerson
[ship_street_1] => 6111 Testy Circle
[ship_street_2] =>
[ship_city] => Lakeland
[ship_state] => FL
[ship_postal_code] => 33803
[ship_country_name] => United States

This is a new install, straight to v1.3.9h.

I guess that's all i can mention... help?

That typically happens when you have zone restrictions applied to your PayPal modules, and the customer is attempting to do checkout using an address that's not within the zone assigned to the module.

Thanks for the reply!

That's what i've read, but i can't figure out why there would be a mismatch. Cart has every country enabled still, including US, and all addresses tested have been US too.

Is there something else it could be? Like the value being dropped somewhere along the line?

...All shipping/payment zones are set to none, except for tax.

I would need to see detailed PP debug logs to see what's exactly the cause. Most likely some unacceptable address translation by mixing countries.

Turn on logging as described here: http://www.zen-cart.com/forum/showthread.php?t=61199
Then recreate the problem.
Then download and zip the log files, and upload the zip to someplace on your server, and then PM me with the URL to the file so I can access them.

Hi DrByte

Can i send you a link for the same problem, i too have read as many threads as i can, checked and double checked the settings but i do not seem to be getting anywhere.

regards
malc

I have the same problem. I just gave up on paypal for now.

CoolCarPartsOnline:

I have the same problem. I just gave up on paypal for now.

Just done the same now since no fix for it.
At least i am taking money again :smile:

I don't get it.

I've set up a clean new store, with demo products and no other alterations at all except turning on PayPal EC and configuring it, and tried a PayPal checkout using the same address as in the logs sent by bluedye and get no error.

What would I need to do to change my fresh install to mimic your store so that I could trigger the problem?
Do I need to delete a bunch of countries? (I'm testing US store with US customer addresses)
Change some currencies? (I'm using USD)
What taxes have you set up? (I'm using just the FL tax from demo data)
What zones have you set up? (I'm using just the FL zone from demo data)
Languages added? (I'm just using built-in english)
Are these products on sale/special? (I've tested using just the sales/specials in demo data, and products not on sale/special as well)
Other addons?

malc:

Hi DrByte

Can i send you a link for the same problem, i too have read as many threads as i can, checked and double checked the settings but i do not seem to be getting anywhere.

regards
malc

Hi,
I've looked at the logs you sent. For some reason, which I can't ascertain from the logs, PayPal isn't sending back any address details with your transaction.
Did you do something to trick PayPal into not requiring you to supply an address for your purchase?
Zen Cart is taking the blank address and determining that "blank" doesn't match any existing country/zone options, and is rejecting it for that reason. If it accepts it without any address information, then it would be allowing the transactions to put incomplete/corrupt data into your database. And of course you don't want that.

DrByte:

Hi,
I've looked at the logs you sent. For some reason, which I can't ascertain from the logs, PayPal isn't sending back any address details with your transaction.
Did you do something to trick PayPal into not requiring you to supply an address for your purchase?
Zen Cart is taking the blank address and determining that "blank" doesn't match any existing country/zone options, and is rejecting it for that reason. If it accepts it without any address information, then it would be allowing the transactions to put incomplete/corrupt data into your database. And of course you don't want that.

I went through every step in ea tutorial line by line,i went through as many pages of settings in paypal i could find, i had quite a few logs to study but they never changed. I am not aware of any setting that may have stopped the transmit of info back to Zen Cart, at the end of the day it was doing its job rejecting it and i have no issue with that its just that i completely ran out of things to try and all the time i was not fixing it the charity was not getting funds.
I have another site that i use for messing and learning with, could i put express on that and try again even though this one has paypal standard working on it?
cheers for looking

I had it working fine for years, the issue only arise with the EC in the last few weeks.

CoolCarPartsOnline:

I had it working fine for years, the issue only arise with the EC in the last few weeks.
Care to share the logs?

malc:

I am not aware of any setting that may have stopped the transmit of info back to Zen Cart, at the end of the day it was doing its job rejecting it and i have no issue with that its just that i completely ran out of things to tryI'm not pointing fingers. I'm legitimately asking for more information about differences so I can investigate whether there's an issue I can escalate to PayPal's tech teams.
If I can replicate the problem consistently then I can trace back the pattern to its root cause and either fix it in ZC or slap PayPal around for something they've broken.> malc:

I have another site that i use for messing and learning with, could i put express on that and try again even though this one has paypal standard working on it?
You can use PayPal on multiple ZC sites easily. And you can even use the same PayPal account on one other non-ZC site without causing any problems to the ZC sites. Just make sure the IPN URL in your PayPal account points to the non-ZC site's IPN URL, whatever that is for that site.
ref: https://www.zen-cart.com/tutorials/index.php?article=229

Guys, on a whim, try adding this new line, as shown below. I've NOT tested this extensively ... just going on a hunch based on something that it looks like PayPal has silently changed and has broken hundreds of stores.

/includes/modules/payment/paypalwpp.php
around line 1461 you'll see this section ... add the highlighted line, as shown:```
$options['NOSHIPPING'] = 1;
} else {
[B] $options['NOSHIPPING'] = 0;[/B]
$this->zcLog('ec-step1-addr_check', "cart content is not all virtual (or customer is not logged in) ... therefore will be submitting address details");

If this fixes your issues, it'll be another case where PayPal changed normal operations without warning. Some senior product managers there are gonna hate me ... :blush:

ok i have a development for me:

I tried your code above and it did not change anything for me with my problem.
What i did also try was a purchase whilst logged in and a purchase whilst not logged in.
When i was not logged it processed the payment at paypal returned to the site then logged me in automatically and i completed the order, but if i logged in and tried it it failed again.

any help?

malc

Is there any chance these problems are being caused by filter settings in merchant profile settings at paypal site?

This is one of the logs that may have the issue

2011-05-31 04:22:24
-------------------
(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers: 
Array
(
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 45
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(tm) - PayPal/NVP
    [4] => X-VPS-VIT-Integration-Version: 1.3.9h
)


Request Parameters: {SetExpressCheckout} 
Array
(
    [AMT] => 57.00
    [ITEMAMT] => 57.00
    [L_NUMBER0] => SES-DH147/127
    [L_NAME0] => Mazda CX-9 2007-2010 SES Trims Chrome Door Handles - 4Dr
    [L_AMT0] => 57.00
    [L_QTY0] => 1
    [LOCALECODE] => US
    [PAYMENTACTION] => Sale
    [ALLOWNOTE] => 1
    [LANDINGPAGE] => Billing
    [NOSHIPPING] => 0
    [RETURNURL] => https://www.coolcarpartsonline.com/ipn_main_handler.php?type=ec
    [CANCELURL] => https://www.coolcarpartsonline.com/index.php?main_page=shopping_cart&ec_cancel=1
    [PAGESTYLE] => Primary
    [METHOD] => SetExpressCheckout
    [CURRENCYCODE] => USD
    [USER] => sales_api1.coolcarpartsonline.com
    [PWD] => ****************
    [VERSION] => 60.0
    [SIGNATURE] => ****************************************************XSQ3
)


Response: 
Array
(
    [TOKEN] => EC-2LW31511BA321443J
    [TIMESTAMP] => 2011-05-31T20:22:24Z
    [CORRELATIONID] => 7e89d8c5dd8cc
    [ACK] => Success
    [VERSION] => 60.0
    [BUILD] => 1913139
    [CURL_ERRORS] => 
)


SetExpressCheckout, Elapsed: 585ms -- Success

May-31-2011 12:54:27 (1306860867)
getLineItemDetails 7 - subtotal comparisons
BEFORE line-item calcs: Array
(
    [AMT] => 65.49
    [ITEMAMT] => 52.5
    [TAXAMT] => 0
    [SHIPPINGAMT] => 12.99
    [SHIPDISCAMT] => 0
    [HANDLINGAMT] => 0
    [INSURANCEAMT] => 0
)
 - AFTER doing line-item calcs: Array
(
    [AMT] => 65.49
    [ITEMAMT] => 52.5
    [TAXAMT] => 0
    [SHIPPINGAMT] => 12.99
    [SHIPDISCAMT] => 0
    [HANDLINGAMT] => 0
    [INSURANCEAMT] => 0
    [L_NUMBER0] => SPD-DRH-E90054C
    [L_NAME0] => BMW 3 Series e90 2005-2007 Spec D Chrome Door Handle Covers
    [L_AMT0] => 52.5
    [L_QTY0] => 1
)

=================================

May-31-2011 12:54:27 (1306860867)
getLineItemDetails 8
checking subtotals... 
Array
(
    [calculated total] => 65.49
    [AMT] => 65.49
    [ITEMAMT] => 52.50
    [SHIPPINGAMT] => 12.99
)

-------------------
difference: 0  (abs+rounded: 0)
=================================

May-31-2011 12:54:27 (1306860867)
getLineItemDetails 10
subtotals balance - okay
=================================

May-31-2011 12:54:27 (1306860867)
ec_step1 - 1
Checking to see if we are in markflow
cart contents: physical

NOTE: $this->showPaymentPage = 0
Customer ID: 5811
Session Data: Array
(
    [securityToken] => d77cc8d548fbecde4f74c4fa3d7f6cc5
    [customers_host_address] => 173-85-160-182.dsl2-pixley.roch.ny.frontiernet.net
    [cartID] => 26508
    [cart] => shoppingCart Object
        (
            [contents] => Array
                (
                    [175714] => Array
                        (
                            [qty] => 1
                        )

                )

            [total] => 52.5
            [weight] => 20
            [cartID] => 26508
            [content_type] => physical
            [free_shipping_item] => 0
            [free_shipping_weight] => 0
            [free_shipping_price] => 0
        )

    [language] => english
    [languages_id] => 1
    [languages_code] => en
    [check_valid] => true
    [currency] => USD
    [today_is] => 2011-05-31
    [updateExpirations] => 1
    [session_counter] => 1
    [customers_ip_address] => 173.85.160.182
    [payment] => paypalwpp
    [pf-navigation] => navigationHistory Object
        (
            [path] => Array
                (
                )

            [snapshot] => Array
                (
                    [page] => product_info
                    [mode] => NONSSL
                    [get] => Array
                        (
                            [cPath] => 2_236_341
                            [products_id] => 175714
                        )

                    [post] => Array
                        (
                        )

                )

        )

    [pf_maker] => 12
    [pf_model] => 131
    [pf_year] => 2007
    [pf_maker_name] => BMW
    [pf_model_name] => 3 Series
    [pf_products_found] => 4044
    [new_products_id_in_cart] => 175714
    [valid_to_checkout] => 1
    [cart_errors] => 
    [cart_country_id] => 223
    [country_info] => Array
        (
            [countries_name] => United States
            [countries_iso_code_2] => US
            [countries_iso_code_3] => USA
        )

    [cot_gv] => 0
    [customer_id] => 5811
    [customer_default_address_id] => 5705
    [customer_first_name] => komla
    [customer_country_id] => 223
    [customer_zone_id] => 43
    [sendto] => 5705
    [billto] => 5705
    [shipping] => Array
        (
            [id] => percategory_percategory
            [title] => Shipping Fees (To  Lower 48 States)
            [cost] => 12.99
        )

    [total_weight] => 20
    [total_count] => 1
    [cart_address_id] => 5705
    [comments] => 
)

=================================

May-31-2011 12:54:27 (1306860867)
ec-step1-addr_check
cart content is not all virtual (or customer is not logged in) ... therefore will be submitting address details
=================================

May-31-2011 12:54:27 (1306860867)
getOverrideAddress - 4
not logged in and not in markflow mode - nothing to override
=================================

May-31-2011 12:54:27 (1306860867)
ec-step1-addr_check3
address details from override check: <NONE FOUND>
=================================

May-31-2011 12:54:27 (1306860867)
ec_step1 - 2 -submit
Array
(
    [AMT] => 65.49
    [ITEMAMT] => 52.50
    [SHIPPINGAMT] => 12.99
    [L_NUMBER0] => SPD-DRH-E90054C
    [L_NAME0] => BMW 3 Series e90 2005-2007 Spec D Chrome Door Handle Covers
    [L_AMT0] => 52.50
    [L_QTY0] => 1
    [LOCALECODE] => US
    [CURRENCY] => USD
    [PAYMENTACTION] => Sale
    [ALLOWNOTE] => 1
    [SOLUTIONTYPE] => Sole
    [LANDINGPAGE] => Billing
    [NOSHIPPING] => 0
    [EMAIL] => estebane60##########################
    [SHIPTOPHONENUM] => 585-354-8473
    [RETURNURL] => https://www.coolcarpartsonline.com/ipn_main_handler.php?type=ec
    [CANCELURL] => https://www.coolcarpartsonline.com/checkout_shipping/ec_cancel/1
)

=================================

2011-05-31 12:56:35
-------------------
(live transaction) --> https://api-3t.paypal.com/nvp
Request Headers: 
Array
(
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 45
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart(tm) - PayPal/NVP
    [4] => X-VPS-VIT-Integration-Version: 1.3.9h
)


Request Parameters: {GetExpressCheckoutDetails} 
Array
(
    [TOKEN] => EC-5FA056815L789071C
    [REQBILLINGADDRESS] => 1
    [METHOD] => GetExpressCheckoutDetails
    [USER] => sales_api1.coolcarpartsonline.com
    [PWD] => ****************
    [VERSION] => 60.0
    [SIGNATURE] => ****************************************************XSQ3
)


Response: 
Array
(
    [TOKEN] => EC-5FA056815L789071C
    [PHONENUM] => 585-354-8473
    [CHECKOUTSTATUS] => PaymentActionNotInitiated
    [TIMESTAMP] => 2011-05-31T16:56:35Z
    [CORRELATIONID] => 46bd4c3959c48
    [ACK] => Success
    [VERSION] => 60.0
    [BUILD] => 1913139
    [EMAIL] => estebane60##########################
    [PAYERID] => C8YD2GJWZC7JQ
    [PAYERSTATUS] => verified
    [FIRSTNAME] => komla
    [LASTNAME] => kpodjia glikpanu
    [COUNTRYCODE] => US
    [SHIPTONAME] => komla kpodjia glikpanu
    [SHIPTOSTREET] => 115 westfield st
    [SHIPTOSTREET2] => 115 westfield st
    [SHIPTOCITY] => rochester
    [SHIPTOSTATE] => NY
    [SHIPTOZIP] => 14619
    [SHIPTOCOUNTRYCODE] => US
    [SHIPTOPHONENUM] => 585-354-8473
    [SHIPTOCOUNTRYNAME] => United States
    [ADDRESSSTATUS] => Confirmed
    [CURRENCYCODE] => USD
    [AMT] => 65.49
    [ITEMAMT] => 52.50
    [SHIPPINGAMT] => 12.99
    [HANDLINGAMT] => 0.00
    [TAXAMT] => 0.00
    [INSURANCEAMT] => 0.00
    [SHIPDISCAMT] => 0.00
    [L_NAME0] => BMW 3 Series e90 2005-2007 Spec D Chrome Door Handle Covers
    [L_NUMBER0] => SPD-DRH-E90054C
    [L_QTY0] => 1
    [L_TAXAMT0] => 0.00
    [L_AMT0] => 52.50
    [L_ITEMWEIGHTVALUE0] =>    0.00000
    [L_ITEMLENGTHVALUE0] =>    0.00000
    [L_ITEMWIDTHVALUE0] =>    0.00000
    [L_ITEMHEIGHTVALUE0] =>    0.00000
    [CURL_ERRORS] => 
)


GetExpressCheckoutDetails, Elapsed: 343ms -- Success

CoolCarPartsOnline:

This is one of the logs that may have the issueCan you explain your reasoning for your suspicion of this particular transaction?
The only things "odd" I see in it are:

• address-line-2 is a repeat of line 1, but ZC specifically avoids that duplication
• the cancelurl in one spot is SEFU-altered, and not a traditional ZC URL

And I wouldn't expect either of those to be specifically tied to a problem with the Geo-area error message.

DrByte:

Guys, on a whim, try adding this new line, as shown below. I've NOT tested this extensively ... just going on a hunch based on something that it looks like PayPal has silently changed and has broken hundreds of stores.

/includes/modules/payment/paypalwpp.php
around line 1461 you'll see this section ... add the highlighted line, as shown:```
$options['NOSHIPPING'] = 1;
} else {
[B] $options['NOSHIPPING'] = 0;[/B]
$this->zcLog('ec-step1-addr_check', "cart content is not all virtual (or customer is not logged in) ... therefore will be submitting address details");

I'd like to know whether making this adjustment has had any positive impact on your transactions.