Customers from other countries

[DrByte]

It's unadvisable to delete any countries from your database. Doing so DOES prevent ANY use of those removed countries for anything, including registration and sales and shipping quotes.

It's better to "disable" certain countries via your Admin. Deleting them altogether is generally a bad idea.


And, now that you've deleted them, you'll need to put them back by completely wiping out all the tables related to countries/zones, and put back the originals that came with Zen Cart: countries, zones, geo_zones, zones_to_geo_zones.
And, if you've ever added any countries/zones back via your Admin after having deleted some, you're going to run into some issues with your historical data that utilized those incorrectly-added records.

[wmorris]

It's unadvisable to delete any countries from your database. Doing so DOES prevent ANY use of those removed countries for anything, including registration and sales and shipping quotes.

It's better to "disable" certain countries via your Admin. Deleting them altogether is generally a bad idea.


And, now that you've deleted them, you'll need to put them back by completely wiping out all the tables related to countries/zones, and put back the originals that came with Zen Cart: countries, zones, geo_zones, zones_to_geo_zones.
And, if you've ever added any countries/zones back via your Admin after having deleted some, you're going to run into some issues with your historical data that utilized those incorrectly-added records.

So if I only ship within United States I still need to put all the countries back into the Database after I delete them. So if did put them back into the Database how can I keep other countries from registering?

[DrByte]

how can I keep other countries from registering?

Admin->Locations->Countries ... click the green dot next to any country you wish to "disable" registration/sales for. That will turn it red so that it's disabled.

[wmorris]

Admin->Locations->Countries ... click the green dot next to any country you wish to "disable" registration/sales for. That will turn it red so that it's disabled.

What is the best way to insert those countries back into the database?

[DrByte]

What is the best way to insert those countries back into the database?

All the data for the "countries" and "zones" tables is in the /zc_install/sql/install/mysql_utf8.sql file.

If you've added records to the geo_zones or zones_to_geo_zones tables that refer to countries or zones that are outside the normal list, or have manually added back any countries to the database that has resulted in those records getting a different countries_id or zone_id then you'll need to manually fix all the conflicts and point the IDs back to the proper original values.

[wmorris]

All the data for the "countries" and "zones" tables is in the /zc_install/sql/install/mysql_utf8.sql file.

If you've added records to the geo_zones or zones_to_geo_zones tables that refer to countries or zones that are outside the normal list, or have manually added back any countries to the database that has resulted in those records getting a different countries_id or zone_id then you'll need to manually fix all the conflicts and point the IDs back to the proper original values.

Ok, when I try to re-insert the SQL I got this:

Error
SQL query:


## SQL Sections Specific to UTF8 character set

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Convert currencies for Text emails', 'CURRENCIES_TRANSLATIONS', '&pound;,£:&euro;,€:&reg;,®:&trade;,™', 'What currency conversions do you need for Text emails?<br />Example = &amp;pound;,&pound;:&amp;euro;,&euro;', 12, 120, NULL, '2003-11-21 00:00:00', NULL, 'zen_cfg_textarea_small(');
MySQL said: Documentation

#1062 - Duplicate entry 'CURRENCIES_TRANSLATIONS' for key 'unq_config_key_zen'