Geographic area Paypal problem

DrByte:

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

No, that had nothing to do with it.

I have switched back to IPN for now.

That's not what I was asking.

So much for testing.

Thanks anyways.

DrByte:

That's not what I was asking.

So much for testing.

Thanks anyways.
I did apply the changes you suggested last week, but that didn't fix the problem so I switched back to IPN yesterday after having 3 more people called angry because after they were taken to PayPal and try to login it to their PayPal account they were directed back to the our website and asked for CC#.

Did my comment about being logged in or not mean anything to you DrByte?

malc

For MALC,

When you say "Not Logged In" and then are "Logged In", could you provide the context of this, ie., are you using COWA or some other mod that allows you to checkout with being logged in or not?

This may have an important bearing on what, why and how of things. (Especially to (1) Those trying to troubleshoot the problem, and (2) Those who may be experiencing the same problem using the same mods as you.)

To wit, I had a customer make a purchase and it failed via PayPal Express Checkout. Fortunately, the customer is someone I know and we talked about it...

I then created a Test Product of $1 to re-create the scenario (why burn up real money for testing, so minimize the expense!) and it worked fine for me with the Test Product via PayPal whether I logged into PayPal to use my Personal PayPal Account and then again if I just used my CC/Debit Card (no PayPal account).

NOTES: I was logged in a as User/Member of my ZC cart. And I'm using Numinix's FEAC (Fast and Easy AJAX Checkout mod, v2.14.0). Further, I am using Zone Restrictions for the USA, as I don't currently sell outside of the USA at this time...

It worked just fine for me according to the PayPal and ZC emails that resulted from the transaction. The customer that I happen to personally know, will try again and get back to me on their results soon, on the off-hand chance that the cart or PayPal had a glitch.

For Dr. Byte and ZC team,

Every PayPal transaction is writing a file out to the Db cache location whether there is a problem or not. Is this typical? I thought that a file is written out ONLY if there is a problem or error per the Payment options in ZC - IF I set the Debug mode to Off. (My incorrect assumption?)

While this is not problematic, it is overhead I will need to deal with. And as I read on the Forum, I just now set the PayPal logs to "777". So this may have some bearing or not...

Ultimately, I would like to NOT log or write out everything to a file UNLESS there is a failure of some sort. Is this do-able? In other words, if a transaction is successful, ZC doesn't record the transaction in a Log File at all, anywhere - only when there is a problem or a failure is it logged in a file, etc.

My thinking is that PayPal keeps a record of the successful transactions, so it would be redundant for ZC to record it as well. ZC only needs to record failures for troubleshooting, etc.

Thanks in advance for your replies...

Mega Moonshine
aka PrettySickPuppy.com

Hi Mega Moonshine

I am not aware of any checkout mods to my 1.3.9h install, i have made only a few changes to the templates and installed the 'Zenned' British postcode addon, which changed eh zones for uk use and seems to be fine.
I have tested quite a few times with the standard paypal and it works fine.
So....(express) if i am not logged in and make a purchase it takes me to paypal, i log in and complete the transaction, it then redirects me to my shop an di find i have been automatically logged in. If i log in first before checking out it fails every time.
I have no zone restrictions in place and i have mirrored my exact details to paypal in case.

thanks
Malc

malc:

Hi Mega Moonshine

I am not aware of any checkout mods to my 1.3.9h install, i have made only a few changes to the templates and installed the 'Zenned' British postcode addon, which changed eh zones for uk use and seems to be fine.
I have tested quite a few times with the standard paypal and it works fine.
So....(express) if i am not logged in and make a purchase it takes me to paypal, i log in and complete the transaction, it then redirects me to my shop an di find i have been automatically logged in. If i log in first before checking out it fails every time.
I have no zone restrictions in place and i have mirrored my exact details to paypal in case.

thanks
Malc

Do you happen to have Free Shipper module activated?

Mega Moonshine:

For Dr. Byte and ZC team,

Every PayPal transaction is writing a file out to the Db cache location whether there is a problem or not. Is this typical? I thought that a file is written out ONLY if there is a problem or error per the Payment options in ZC - IF I set the Debug mode to Off. (My incorrect assumption?)

Ultimately, I would like to NOT log or write out everything to a file UNLESS there is a failure of some sort. Is this do-able? In other words, if a transaction is successful, ZC doesn't record the transaction in a Log File at all, anywhere - only when there is a problem or a failure is it logged in a file, etc.
We are aware of this logging issue, and have fixed it for the next version.
It is caused by a (relatively rare) server configuration where the lack of certain dependencies causes logging to engage despite it being turned off. We're removing those dependencies in the next version to allow for much broader compatibility.
You can purge those logs yourself using your FTP program.
Or, IIRC there's an option in the Admin->Tools->Store Manager to purge those logs too.

CoolCarPartsOnline:

Do you happen to have Free Shipper module activated?

Yes free shipping is enabled

malc

I started having issues with IPN and EC after enabling the Free shipper module.

I do have another store that I launched last week that is almost identical to the store having the issues with Free Shipper disabled.

Only got 5 orders on PayPal but no issues.

This may narrow the issue down to Dr Byte. It seems that we both have the Free Shipper module enabled with multiple store zones.

CoolCarPartsOnline:

I started having issues with IPN and EC after enabling the Free shipper module.

...

This may narrow the issue down to Dr Byte. It seems that we both have the Free Shipper module enabled with multiple store zones.
Both of you,

Can you explain how you've got your Free Shipper module configured? Is it just set to the defaults of $0.00, $0.00, tax-class "none", and sort order "0", but with a zone assigned?
I'd like to try setting up my site to match what you're doing.
The details for the zone you've assigned will be important as well too.

And what other shipping modules do you have set up? And how are they configured? Do they have zones assigned? Do they have price restrictions of some sort on them which would limit whether they're available on certain purchases, like zones do?

My 'Free Shipper' is default:
£0.00, £0.00, tax-class "none", and sort order "0", and with no zone assigned?

I have in use UK Postcode by 'Zenned'
Do you want to include Zenned! UK postcode based shipping?

True

Calculation Method
Calculate cost based on Weight, Price or Item?

Weight

Tax Class
Use the following tax class on the shipping fee.
--none--

Tax Basis
On what basis is Shipping Tax calculated. Options are
Shipping - Based on customers Shipping Address
Billing Based on customers Billing address
Store - Based on Store address if Billing/Shipping Zone equals Store zone

Shipping

Sort Order
Sort order of display.

10

Zone 1 Post Codes
UK Post Default Mainland Postcode Zone - Zone 1
LEAVE EMPTY

Zone 1 Shipping Table
Shipping rates to Zone 1 destinations based on a group of maximum order weights/prices. Example: 3:8.50,7:10.50,... Weight/Price less than or equal to 3 would cost 8.50 for Zone 1 destinations.
0.1:1.33,0.25:1.72,0.50:2.16,0.75:2.61,1.00:3.15,1.25:4.90,1.50:5.66,1.75:6.42,2.0:7.18,4.0:8.95,6.0:12.0,8.0:15.05

Zone 1 Handling Fee
Handling Fee for this shipping zone

Zone 2 Post Codes
UK Post Scottish Highlands & Islands - Zone 2

Zone 2 Shipping Table
Shipping rates to Zone 2 destinations based on a group of maximum order weights/prices. Example: 3:8.50,7:10.50,... Weight/Price less than or equal to 3 would cost 8.50 for Zone 2 destinations.
0.1:1.33,0.25:1.72,0.50:2.16,0.75:2.61,1.00:3.15,1.25:4.90,1.50:5.66,1.75:6.42,2.0:7.18,4.0:8.95,6.0:12.0,8.0:15.05

Zone 2 Handling Fee
Handling Fee for this shipping zone

Zone 3 Post Codes
UK Post Northern Ireland, Isle of Man, Isles of Scilly - Zone 3
BT1,BT2,BT3,BT4,BT5,BT6,BT7,BT8,BT9,BT10,BT11,BT12,BT13,BT14,BT15,BT16, &,BT17,BT18,BT19,BT20,BT21,BT22,BT23,BT24,BT25,BT26,BT27,BT28,BT29,BT30,BT31, &,BT32,BT33,BT34,BT35,BT36,BT37,BT38,BT39,BT40,BT41,BT42,BT43,BT44,BT45, &,BT46,BT47,BT48,BT49,BT50,BT51,BT52,BT53,BT54,BT55,BT56,BT57,BT58,BT59, &,BT60,BT61,BT62,BT63,BT64,BT65,BT66,BT67,BT68,BT69,BT70,BT71,BT72,BT73,BT74,BT75, &,BT76,BT77,BT78,BT79,BT80,BT81,BT82,BT83,BT92,BT93,BT94, &,IM1,IM2,IM3,IM4,IM5,IM6,IM7,IM8,IM9,TR21,TR22,TR23, TR24,TR25

Zone 3 Shipping Table
Shipping rates to Zone 3 destinations based on a group of maximum order weights/prices. Example: 3:8.50,7:10.50,... Weight/Price less than or equal to 3 would cost 8.50 for Zone 3 destinations.
0.1:1.33,0.25:1.72,0.50:2.16,0.75:2.61,1.00:3.15,1.25:4.90,1.50:5.66,1.75:6.42,2.0:7.18,4.0:8.95,6.0:12.0,8.0:15.05

Zone 3 Handling Fee
Handling Fee for this shipping zone

Zone 4 Post Codes
UK Post Channel Islands - Zone 4
JE1,JE2,JE3,JE4,GY1,GY2,GY3, &,GY4,GY5,GY6,GY7,GY8,GY9,GY10

Zone 4 Shipping Table
Shipping rates to Zone 4 destinations based on a group of maximum order weights/prices. Example: 3:8.50,7:10.50,... Weight/Price less than or equal to 3 would cost 8.50 for Zone 4 destinations.
0.1:1.33,0.25:1.72,0.50:2.16,0.75:2.61,1.00:3.15,1.25:4.90,1.50:5.66,1.75:6.42,2.0:7.18,4.0:8.95,6.0:12.0,8.0:15.05

Zone 4 Handling Fee
Handling Fee for this shipping zone

Malc

FREE SHIPPING

Enable Free Shipping
True

Free Shipping Cost
0.00

Handling Fee
0

Tax Class
--none--

Shipping Zone
--none--

Sort Order
0

I notice we both have sort order to '0' and in other areas this means the item in question will not show, could it have an affect here?

If all your modules are set to 0 sort order, then it's fine. If you've set non-zero value on anything, then everything should get a nonzero value.

sort order is set to zero on all.

That shouldn't matter anyway as customer are able to get to paypal website.

Interesting. Have any of you solved this issue?

wizer:

Interesting. Have any of you solved this issue?
Without seeing your logs, and without putting your database content back so that it has the original content that Zen Cart ships with, it's extremely difficult to lump your problem into the random symptoms discussed in this thread. You could try the code change I posted in #20, but that's unlikely to be a solution for you.
The only value for you in looking at this thread is for you to identify specific configurations that you have in common with those who have already posted. Anything else is merely speculation and unhelpful.
You're already discussing this in several other threads.

Who is the n00b who is not able to code properly??....

In the file /includes/modules/payment/paypalwpp.php
Replace this line:

$sql = $db->bindVars($sql, ':countryId', $address_question_arr['country']['title'], 'string');
by:
$sql = $db->bindVars($sql, ':countryId', $address_question_arr['country']['iso_code_2'], 'string')In our case we were using "England", "Wales", etc as countries into Zen Cart~ not "United Kingdom" as a whole. This prevent flexibility in the countries' management.

The error: "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."

comes from /include/payment/paypalwbb.php

line:

$sql = $db->bindVars($sql, ':countryId', $address_question_arr['country']['title'], 'string');
triggering this mySQL query:
SELECT countries_id, address_format_id
FROM zen_countries
WHERE countries_iso_code_2 = 'United Kingdom'
OR countries_name = 'United Kingdom'
LIMIT 1

should be:

$sql = $db->bindVars($sql, ':countryId', $address_question_arr['country']['iso_code_2'], 'string');
It should use the ISO code, a lot safer than a country title!
In our case we were using "England", "Wales", etc as countries into Zen Cart~ not "United Kingdom" as a whole. This prevent flexibility in the countries' management.

A lot of people had this issue over the past few months, as per my post here.

Hoping you will include it in the next release....