Selectable Countries [Support Thread]

[Thannaree]

I use the free shipper module. The Selectable Countries plugin operates properly, it limits the number of countries that can be used to create an account to only those I've selected.

I've created a zone with the countries I've selected and associated the zone to the free shipper module and it now works.

[CCMall]

This is an awesome plug in. Question though. How hard would it be to modify this plug in to allow billing addy to be outside a selected country but not the shipping address? I know a lot of Canadians who buy from the US with a Canadian credit card and ship to a US address. I for one am one.

[lat9]

This is an awesome plug in. Question though. How hard would it be to modify this plug in to allow billing addy to be outside a selected country but not the shipping address? I know a lot of Canadians who buy from the US with a Canadian credit card and ship to a US address. I for one am one.

Thanks for the compliment You could use this plugin to limit the countries that can be associated with an account (and, thus, either the shipping or billing address) and then use the built-in Zen Cart zones to restrict shipping to the US. That way, a customer in Canada can create an account (and a billing address) in Canada but would only be able to ship their order to an address in the US.

[uncharted]

Hello,

Is this module compatible with 1.5.1?

Regards

[Design75]

Yes it is

[lat9]

The function provided by this plugin is partially supported in the upcoming Zen Cart v1.5.2, the differences being:

1. This plugin adds the field countries_active char(1) to the countries table in the database; ZC 1.5.2 adds the field status tinyint(1)
2. This plugin disallows the creation of any address (billing or shipping) if the country is not active; ZC 1.5.2 disallows only shipping addresses.

I'm currently in limbo as to whether and/or how to merge this plugin's changes into a ZC 1.5.2 environment, so at this point of time this plugin should be considered not compatible with ZC 1.5.2.

Feedback and suggestions are welcomed.

[torvista]

as far as getting past the installer upgrade and maintaining the selected country settings I made this alteration to the installer code:
zc_install\sql\mysql_upgrade_zencart_151_to_152.sql
from

ALTER TABLE countries ADD status tinyint(1) DEFAULT '1';

to

ALTER TABLE countries CHANGE countries_active status tinyint(1) DEFAULT '1';

[Togfather]

Hello,

My DB has prefix ZEN_ ( define('DB_PREFIX', 'zen_');)

I try to install the SQL file by pasting: # Selectable Countries Plugin - Install SQL to add the countries_active field to the countries table.
ALTER TABLE zen_countries ADD countries_active char(1) default 1;
and I get the following message:
WARNING: An Error occurred, please refresh the page and try again
Refreshing, going back and trying again gets the same message. Can anyone offer help?

Regards

Tog

[lat9]

When you see the message "WARNING: An Error occurred, please refresh the page and try again", there's a debug-log file present in either your /logs directory or the /cache directory if your Zen Cart version is v1.5.0 or earlier.

If you simply open the installation SQL file in a text editor, copy its contents to the clipboard and then paste that information into your admin's Tools->Install SQL Patches, Zen Cart "knows" that you've got a non-blank DB_PREFIX and will properly handle those changes.

[Togfather]

Thank you but I still couldn't get the plug in to work, so now I have removed the unwanted countries from the database, leaving only one (United Kingdom).

Do you know how I can get rid of the country drop down box, and just have United Kingdom show as static text instead?

Regards

Tog