Page 1 of 2 12 LastLast
Results 1 to 10 of 157

Hybrid View

  1. #1
    Join Date
    Apr 2006
    Posts
    80
    Plugin Contributions
    0

    International Shipping

    I am trying to setup Free Shipping for U.S. customers and a per item shipping for everyone else. I have the Free shipping working but I have no idea how to make an International zone to complete the per item setup. I tried making an International zone that includes all countries but that didn'nt work. What am I doing wrong or not doing?

    Shelia

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: International Shipping

    You have the right idea ...

    You should be using the Free Shipping Options freeoptions Shipping Module and have the Zone set to the US ...

    Note: you will need to make that Zone to use it

    For the per item, use the Per Item shipping and again you do need to make a Zone for all the countries except the US ...

    Check that when you make the Zone, you are also adding the details to the Zone Definition ...

    Example:
    In Zone Definitions you would insert a Zone called something like: US Shipping

    Providing you truely mean the entire US which includes the territories, islands, US forces, etc. you can add in the Details the Country United States and the Zone All Zones ...

    For the rest of the world ... you need to add everything except the US ... which is rather a pain ...

    Depending on how good you are with phpMyAdmin ... you could export the zones and build an import for everything and just delete the United States zone_country_id 223
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Apr 2006
    Posts
    80
    Plugin Contributions
    0

    Default Re: International Shipping

    Can I import a new zone (International) into my database using
    zone_id=188 zone_country_id=190 zone_code=International zone_name=International

    I export zen_zones, remove US and the build the International zone using the structure of zen_zones?

    Hope I'm making sense, I guess I think I know how to do just not how to explain!!

  4. #4
    Join Date
    Apr 2006
    Posts
    80
    Plugin Contributions
    0

    Default Re: International Shipping

    Ok, I got this far! how do I make a .sql file so that it can be imported into my database?



    # INTERNATIONAL
    INSERT INTO `zen_zones` VALUES (66, 38, 'AB', 'Alberta');
    INSERT INTO `zen_zones` VALUES (67, 38, 'BC', 'British Columbia');
    INSERT INTO `zen_zones` VALUES (68, 38, 'MB', 'Manitoba');
    INSERT INTO `zen_zones` VALUES (69, 38, 'NF', 'Newfoundland');
    INSERT INTO `zen_zones` VALUES (70, 38, 'NB', 'New Brunswick');
    INSERT INTO `zen_zones` VALUES (71, 38, 'NS', 'Nova Scotia');
    INSERT INTO `zen_zones` VALUES (72, 38, 'NT', 'Northwest Territories');
    INSERT INTO `zen_zones` VALUES (73, 38, 'NU', 'Nunavut');
    INSERT INTO `zen_zones` VALUES (74, 38, 'ON', 'Ontario');
    INSERT INTO `zen_zones` VALUES (75, 38, 'PE', 'Prince Edward Island');
    INSERT INTO `zen_zones` VALUES (76, 38, 'QC', 'Quebec');
    INSERT INTO `zen_zones` VALUES (77, 38, 'SK', 'Saskatchewan');
    INSERT INTO `zen_zones` VALUES (78, 38, 'YT', 'Yukon Territory');
    INSERT INTO `zen_zones` VALUES (79, 81, 'NDS', 'Niedersachsen');
    INSERT INTO `zen_zones` VALUES (80, 81, 'BAW', 'Baden-Wrttemberg');
    INSERT INTO `zen_zones` VALUES (81, 81, 'BAY', 'Bayern');
    INSERT INTO `zen_zones` VALUES (82, 81, 'BER', 'Berlin');
    INSERT INTO `zen_zones` VALUES (83, 81, 'BRG', 'Brandenburg');
    INSERT INTO `zen_zones` VALUES (84, 81, 'BRE', 'Bremen');
    INSERT INTO `zen_zones` VALUES (85, 81, 'HAM', 'Hamburg');
    INSERT INTO `zen_zones` VALUES (86, 81, 'HES', 'Hessen');
    INSERT INTO `zen_zones` VALUES (87, 81, 'MEC', 'Mecklenburg-Vorpommern');
    INSERT INTO `zen_zones` VALUES (88, 81, 'NRW', 'Nordrhein-Westfalen');
    INSERT INTO `zen_zones` VALUES (89, 81, 'RHE', 'Rheinland-Pfalz');
    INSERT INTO `zen_zones` VALUES (90, 81, 'SAR', 'Saarland');
    INSERT INTO `zen_zones` VALUES (91, 81, 'SAS', 'Sachsen');
    INSERT INTO `zen_zones` VALUES (92, 81, 'SAC', 'Sachsen-Anhalt');
    INSERT INTO `zen_zones` VALUES (93, 81, 'SCN', 'Schleswig-Holstein');
    INSERT INTO `zen_zones` VALUES (94, 81, 'THE', 'Thringen');
    INSERT INTO `zen_zones` VALUES (95, 14, 'WI', 'Wien');
    INSERT INTO `zen_zones` VALUES (96, 14, 'NO', 'Niedersterreich');
    INSERT INTO `zen_zones` VALUES (97, 14, 'OO', 'Obersterreich');
    INSERT INTO `zen_zones` VALUES (98, 14, 'SB', 'Salzburg');
    INSERT INTO `zen_zones` VALUES (99, 14, 'KN', 'K???nten');
    INSERT INTO `zen_zones` VALUES (100, 14, 'ST', 'Steiermark');
    INSERT INTO `zen_zones` VALUES (101, 14, 'TI', 'Tirol');
    INSERT INTO `zen_zones` VALUES (102, 14, 'BL', 'Burgenland');
    INSERT INTO `zen_zones` VALUES (103, 14, 'VB', 'Voralberg');
    INSERT INTO `zen_zones` VALUES (104, 204, 'AG', 'Aargau');
    INSERT INTO `zen_zones` VALUES (105, 204, 'AI', 'Appenzell Innerrhoden');
    INSERT INTO `zen_zones` VALUES (106, 204, 'AR', 'Appenzell Ausserrhoden');
    INSERT INTO `zen_zones` VALUES (107, 204, 'BE', 'Bern');
    INSERT INTO `zen_zones` VALUES (108, 204, 'BL', 'Basel-Landschaft');
    INSERT INTO `zen_zones` VALUES (109, 204, 'BS', 'Basel-Stadt');
    INSERT INTO `zen_zones` VALUES (110, 204, 'FR', 'Freiburg');
    INSERT INTO `zen_zones` VALUES (111, 204, 'GE', 'Genf');
    INSERT INTO `zen_zones` VALUES (112, 204, 'GL', 'Glarus');
    INSERT INTO `zen_zones` VALUES (113, 204, 'JU', 'Graubnden');
    INSERT INTO `zen_zones` VALUES (114, 204, 'JU', 'Jura');
    INSERT INTO `zen_zones` VALUES (115, 204, 'LU', 'Luzern');
    INSERT INTO `zen_zones` VALUES (116, 204, 'NE', 'Neuenburg');
    INSERT INTO `zen_zones` VALUES (117, 204, 'NW', 'Nidwalden');
    INSERT INTO `zen_zones` VALUES (118, 204, 'OW', 'Obwalden');
    INSERT INTO `zen_zones` VALUES (119, 204, 'SG', 'St. Gallen');
    INSERT INTO `zen_zones` VALUES (120, 204, 'SH', 'Schaffhausen');
    INSERT INTO `zen_zones` VALUES (121, 204, 'SO', 'Solothurn');
    INSERT INTO `zen_zones` VALUES (122, 204, 'SZ', 'Schwyz');
    INSERT INTO `zen_zones` VALUES (123, 204, 'TG', 'Thurgau');
    INSERT INTO `zen_zones` VALUES (124, 204, 'TI', 'Tessin');
    INSERT INTO `zen_zones` VALUES (125, 204, 'UR', 'Uri');
    INSERT INTO `zen_zones` VALUES (126, 204, 'VD', 'Waadt');
    INSERT INTO `zen_zones` VALUES (127, 204, 'VS', 'Wallis');
    INSERT INTO `zen_zones` VALUES (128, 204, 'ZG', 'Zug');
    INSERT INTO `zen_zones` VALUES (129, 204, 'ZH', 'Zrich');
    INSERT INTO `zen_zones` VALUES (130, 195, 'A Corua', 'A Corua');
    INSERT INTO `zen_zones` VALUES (131, 195, 'Alava', 'Alava');
    INSERT INTO `zen_zones` VALUES (132, 195, 'Albacete', 'Albacete');
    INSERT INTO `zen_zones` VALUES (133, 195, 'Alicante', 'Alicante');
    INSERT INTO `zen_zones` VALUES (134, 195, 'Almeria', 'Almeria');
    INSERT INTO `zen_zones` VALUES (135, 195, 'Asturias', 'Asturias');
    INSERT INTO `zen_zones` VALUES (136, 195, 'Avila', 'Avila');
    INSERT INTO `zen_zones` VALUES (137, 195, 'Badajoz', 'Badajoz');
    INSERT INTO `zen_zones` VALUES (138, 195, 'Baleares', 'Baleares');
    INSERT INTO `zen_zones` VALUES (139, 195, 'Barcelona', 'Barcelona');
    INSERT INTO `zen_zones` VALUES (140, 195, 'Burgos', 'Burgos');
    INSERT INTO `zen_zones` VALUES (141, 195, 'Caceres', 'Caceres');
    INSERT INTO `zen_zones` VALUES (142, 195, 'Cadiz', 'Cadiz');
    INSERT INTO `zen_zones` VALUES (143, 195, 'Cantabria', 'Cantabria');
    INSERT INTO `zen_zones` VALUES (144, 195, 'Castellon', 'Castellon');
    INSERT INTO `zen_zones` VALUES (145, 195, 'Ceuta', 'Ceuta');
    INSERT INTO `zen_zones` VALUES (146, 195, 'Ciudad Real', 'Ciudad Real');
    INSERT INTO `zen_zones` VALUES (147, 195, 'Cordoba', 'Cordoba');
    INSERT INTO `zen_zones` VALUES (148, 195, 'Cuenca', 'Cuenca');
    INSERT INTO `zen_zones` VALUES (149, 195, 'Girona', 'Girona');
    INSERT INTO `zen_zones` VALUES (150, 195, 'Granada', 'Granada');
    INSERT INTO `zen_zones` VALUES (151, 195, 'Guadalajara', 'Guadalajara');
    INSERT INTO `zen_zones` VALUES (152, 195, 'Guipuzcoa', 'Guipuzcoa');
    INSERT INTO `zen_zones` VALUES (153, 195, 'Huelva', 'Huelva');
    INSERT INTO `zen_zones` VALUES (154, 195, 'Huesca', 'Huesca');
    INSERT INTO `zen_zones` VALUES (155, 195, 'Jaen', 'Jaen');
    INSERT INTO `zen_zones` VALUES (156, 195, 'La Rioja', 'La Rioja');
    INSERT INTO `zen_zones` VALUES (157, 195, 'Las Palmas', 'Las Palmas');
    INSERT INTO `zen_zones` VALUES (158, 195, 'Leon', 'Leon');
    INSERT INTO `zen_zones` VALUES (159, 195, 'Lleida', 'Lleida');
    INSERT INTO `zen_zones` VALUES (160, 195, 'Lugo', 'Lugo');
    INSERT INTO `zen_zones` VALUES (161, 195, 'Madrid', 'Madrid');
    INSERT INTO `zen_zones` VALUES (162, 195, 'Malaga', 'Malaga');
    INSERT INTO `zen_zones` VALUES (163, 195, 'Melilla', 'Melilla');
    INSERT INTO `zen_zones` VALUES (164, 195, 'Murcia', 'Murcia');
    INSERT INTO `zen_zones` VALUES (165, 195, 'Navarra', 'Navarra');
    INSERT INTO `zen_zones` VALUES (166, 195, 'Ourense', 'Ourense');
    INSERT INTO `zen_zones` VALUES (167, 195, 'Palencia', 'Palencia');
    INSERT INTO `zen_zones` VALUES (168, 195, 'Pontevedra', 'Pontevedra');
    INSERT INTO `zen_zones` VALUES (169, 195, 'Salamanca', 'Salamanca');
    INSERT INTO `zen_zones` VALUES (170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife');
    INSERT INTO `zen_zones` VALUES (171, 195, 'Segovia', 'Segovia');
    INSERT INTO `zen_zones` VALUES (172, 195, 'Sevilla', 'Sevilla');
    INSERT INTO `zen_zones` VALUES (173, 195, 'Soria', 'Soria');
    INSERT INTO `zen_zones` VALUES (174, 195, 'Tarragona', 'Tarragona');
    INSERT INTO `zen_zones` VALUES (175, 195, 'Teruel', 'Teruel');
    INSERT INTO `zen_zones` VALUES (176, 195, 'Toledo', 'Toledo');
    INSERT INTO `zen_zones` VALUES (177, 195, 'Valencia', 'Valencia');
    INSERT INTO `zen_zones` VALUES (178, 195, 'Valladolid', 'Valladolid');
    INSERT INTO `zen_zones` VALUES (179, 195, 'Vizcaya', 'Vizcaya');
    INSERT INTO `zen_zones` VALUES (180, 195, 'Zamora', 'Zamora');
    INSERT INTO `zen_zones` VALUES (181, 195, 'Zaragoza', 'Zaragoza');

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: International Shipping

    You are making a zone that needs to have the same data as the tables
    zones_to_geo_zones
    geo_zones

    Tables would have ...

    For All Countries except the US you could use this to run through the Admin ... Tools ... Install SQL Patch ...

    PHP Code:
    INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (20'Not US''All Countries Except the US'NULL'2006-07-03 12:32:13');

    INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES (1020),
    (
    2020),
    (
    3020),
    (
    4020),
    (
    5020),
    (
    6020),
    (
    7020),
    (
    8020),
    (
    9020),
    (
    10020),
    (
    11020),
    (
    12020),
    (
    13020),
    (
    14020),
    (
    15020),
    (
    16020),
    (
    17020),
    (
    18020),
    (
    19020),
    (
    20020),
    (
    21020),
    (
    22020),
    (
    23020),
    (
    24020),
    (
    25020),
    (
    26020),
    (
    27020),
    (
    28020),
    (
    29020),
    (
    30020),
    (
    31020),
    (
    32020),
    (
    33020),
    (
    34020),
    (
    35020),
    (
    36020),
    (
    37020),
    (
    38020),
    (
    39020),
    (
    40020),
    (
    41020),
    (
    42020),
    (
    43020),
    (
    44020),
    (
    45020),
    (
    46020),
    (
    47020),
    (
    48020),
    (
    49020),
    (
    50020),
    (
    51020),
    (
    52020),
    (
    53020),
    (
    54020),
    (
    55020),
    (
    56020),
    (
    57020),
    (
    58020),
    (
    59020),
    (
    60020),
    (
    61020),
    (
    62020),
    (
    63020),
    (
    64020),
    (
    65020),
    (
    66020),
    (
    67020),
    (
    68020),
    (
    69020),
    (
    70020),
    (
    71020),
    (
    72020),
    (
    73020),
    (
    74020),
    (
    75020),
    (
    76020),
    (
    77020),
    (
    78020),
    (
    79020),
    (
    80020),
    (
    81020),
    (
    82020),
    (
    83020),
    (
    84020),
    (
    85020),
    (
    86020),
    (
    87020),
    (
    88020),
    (
    89020),
    (
    90020),
    (
    91020),
    (
    92020),
    (
    93020),
    (
    94020),
    (
    95020),
    (
    96020),
    (
    97020),
    (
    98020),
    (
    99020),
    (
    100020),
    (
    101020),
    (
    102020),
    (
    103020),
    (
    104020),
    (
    105020),
    (
    106020),
    (
    107020),
    (
    108020),
    (
    109020),
    (
    110020),
    (
    111020),
    (
    112020),
    (
    113020),
    (
    114020),
    (
    115020),
    (
    116020),
    (
    117020),
    (
    118020),
    (
    119020),
    (
    120020),
    (
    121020),
    (
    122020),
    (
    123020),
    (
    124020),
    (
    125020),
    (
    126020),
    (
    127020),
    (
    128020),
    (
    129020),
    (
    130020),
    (
    131020),
    (
    132020),
    (
    133020),
    (
    134020),
    (
    135020),
    (
    136020),
    (
    137020),
    (
    138020),
    (
    139020),
    (
    140020),
    (
    141020),
    (
    142020),
    (
    143020),
    (
    144020),
    (
    145020),
    (
    146020),
    (
    147020),
    (
    148020),
    (
    149020),
    (
    150020),
    (
    151020),
    (
    152020),
    (
    153020),
    (
    154020),
    (
    155020),
    (
    156020),
    (
    157020),
    (
    158020),
    (
    159020),
    (
    160020),
    (
    161020),
    (
    162020),
    (
    163020),
    (
    164020),
    (
    165020),
    (
    166020),
    (
    167020),
    (
    168020),
    (
    169020),
    (
    170020),
    (
    171020),
    (
    172020),
    (
    173020),
    (
    174020),
    (
    175020),
    (
    176020),
    (
    177020),
    (
    178020),
    (
    179020),
    (
    180020),
    (
    181020),
    (
    182020),
    (
    183020),
    (
    184020),
    (
    185020),
    (
    186020),
    (
    187020),
    (
    188020),
    (
    189020),
    (
    190020),
    (
    191020),
    (
    192020),
    (
    193020),
    (
    194020),
    (
    195020),
    (
    196020),
    (
    197020),
    (
    198020),
    (
    199020),
    (
    200020),
    (
    201020),
    (
    202020),
    (
    203020),
    (
    204020),
    (
    205020),
    (
    206020),
    (
    207020),
    (
    208020),
    (
    209020),
    (
    210020),
    (
    211020),
    (
    212020),
    (
    213020),
    (
    214020),
    (
    215020),
    (
    216020),
    (
    217020),
    (
    218020),
    (
    219020),
    (
    220020),
    (
    221020),
    (
    222020),
    (
    224020),
    (
    225020),
    (
    226020),
    (
    227020),
    (
    228020),
    (
    229020),
    (
    230020),
    (
    231020),
    (
    232020),
    (
    233020),
    (
    234020),
    (
    235020),
    (
    236020),
    (
    237020),
    (
    238020),
    (
    239020),
    (
    240020); 

    search helper: premade World Zone or Rest of the World except for the US
    Last edited by Ajeh; 15 Sep 2009 at 08:51 PM.
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Apr 2006
    Posts
    80
    Plugin Contributions
    0

    Default Re: International Shipping

    Thanks Ajeh. I'll get working on it and will post back with my results.

    Shelia

  7. #7
    Join Date
    Jan 2008
    Location
    Revelstoke, BC, Canada
    Posts
    6
    Plugin Contributions
    0

    Default Re: International Shipping

    Hi Linda,
    I figured out the country code for Canada (38) and slightly modified your script for international shipping using the zonetable rate. Following your instructions I installed the sql patch but get an error message:

    1062 Duplicate entry '20' for key 1 in:
    [INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (20, 'Not CA', 'All Countries Except CA', NULL, '2008-01-01 12:32:13');]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

    Any ideas of where I went wrong?

    Here is the code I was using:
    INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (20, 'Not CA', 'All Countries Except CA', NULL, '2008-01-01 12:32:13');

    INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES (1, 0, 20),
    (2, 0, 20),
    (3, 0, 20),
    (4, 0, 20),
    (5, 0, 20),
    (6, 0, 20),
    (7, 0, 20),
    (8, 0, 20),
    (9, 0, 20),
    (10, 0, 20),
    (11, 0, 20),
    (12, 0, 20),
    (13, 0, 20),
    (14, 0, 20),
    (15, 0, 20),
    (16, 0, 20),
    (17, 0, 20),
    (18, 0, 20),
    (19, 0, 20),
    (20, 0, 20),
    (21, 0, 20),
    (22, 0, 20),
    (23, 0, 20),
    (24, 0, 20),
    (25, 0, 20),
    (26, 0, 20),
    (27, 0, 20),
    (28, 0, 20),
    (29, 0, 20),
    (30, 0, 20),
    (31, 0, 20),
    (32, 0, 20),
    (33, 0, 20),
    (34, 0, 20),
    (35, 0, 20),
    (36, 0, 20),
    (37, 0, 20),
    (39, 0, 20),
    (40, 0, 20),
    (41, 0, 20),
    (42, 0, 20),
    (43, 0, 20),
    (44, 0, 20),
    (45, 0, 20),
    (46, 0, 20),
    (47, 0, 20),
    (48, 0, 20),
    (49, 0, 20),
    (50, 0, 20),
    (51, 0, 20),
    (52, 0, 20),
    (53, 0, 20),
    (54, 0, 20),
    (55, 0, 20),
    (56, 0, 20),
    (57, 0, 20),
    (58, 0, 20),
    (59, 0, 20),
    (60, 0, 20),
    (61, 0, 20),
    (62, 0, 20),
    (63, 0, 20),
    (64, 0, 20),
    (65, 0, 20),
    (66, 0, 20),
    (67, 0, 20),
    (68, 0, 20),
    (69, 0, 20),
    (70, 0, 20),
    (71, 0, 20),
    (72, 0, 20),
    (73, 0, 20),
    (74, 0, 20),
    (75, 0, 20),
    (76, 0, 20),
    (77, 0, 20),
    (78, 0, 20),
    (79, 0, 20),
    (80, 0, 20),
    (81, 0, 20),
    (82, 0, 20),
    (83, 0, 20),
    (84, 0, 20),
    (85, 0, 20),
    (86, 0, 20),
    (87, 0, 20),
    (88, 0, 20),
    (89, 0, 20),
    (90, 0, 20),
    (91, 0, 20),
    (92, 0, 20),
    (93, 0, 20),
    (94, 0, 20),
    (95, 0, 20),
    (96, 0, 20),
    (97, 0, 20),
    (98, 0, 20),
    (99, 0, 20),
    (100, 0, 20),
    (101, 0, 20),
    (102, 0, 20),
    (103, 0, 20),
    (104, 0, 20),
    (105, 0, 20),
    (106, 0, 20),
    (107, 0, 20),
    (108, 0, 20),
    (109, 0, 20),
    (110, 0, 20),
    (111, 0, 20),
    (112, 0, 20),
    (113, 0, 20),
    (114, 0, 20),
    (115, 0, 20),
    (116, 0, 20),
    (117, 0, 20),
    (118, 0, 20),
    (119, 0, 20),
    (120, 0, 20),
    (121, 0, 20),
    (122, 0, 20),
    (123, 0, 20),
    (124, 0, 20),
    (125, 0, 20),
    (126, 0, 20),
    (127, 0, 20),
    (128, 0, 20),
    (129, 0, 20),
    (130, 0, 20),
    (131, 0, 20),
    (132, 0, 20),
    (133, 0, 20),
    (134, 0, 20),
    (135, 0, 20),
    (136, 0, 20),
    (137, 0, 20),
    (138, 0, 20),
    (139, 0, 20),
    (140, 0, 20),
    (141, 0, 20),
    (142, 0, 20),
    (143, 0, 20),
    (144, 0, 20),
    (145, 0, 20),
    (146, 0, 20),
    (147, 0, 20),
    (148, 0, 20),
    (149, 0, 20),
    (150, 0, 20),
    (151, 0, 20),
    (152, 0, 20),
    (153, 0, 20),
    (154, 0, 20),
    (155, 0, 20),
    (156, 0, 20),
    (157, 0, 20),
    (158, 0, 20),
    (159, 0, 20),
    (160, 0, 20),
    (161, 0, 20),
    (162, 0, 20),
    (163, 0, 20),
    (164, 0, 20),
    (165, 0, 20),
    (166, 0, 20),
    (167, 0, 20),
    (168, 0, 20),
    (169, 0, 20),
    (170, 0, 20),
    (171, 0, 20),
    (172, 0, 20),
    (173, 0, 20),
    (174, 0, 20),
    (175, 0, 20),
    (176, 0, 20),
    (177, 0, 20),
    (178, 0, 20),
    (179, 0, 20),
    (180, 0, 20),
    (181, 0, 20),
    (182, 0, 20),
    (183, 0, 20),
    (184, 0, 20),
    (185, 0, 20),
    (186, 0, 20),
    (187, 0, 20),
    (188, 0, 20),
    (189, 0, 20),
    (190, 0, 20),
    (191, 0, 20),
    (192, 0, 20),
    (193, 0, 20),
    (194, 0, 20),
    (195, 0, 20),
    (196, 0, 20),
    (197, 0, 20),
    (198, 0, 20),
    (199, 0, 20),
    (200, 0, 20),
    (201, 0, 20),
    (202, 0, 20),
    (203, 0, 20),
    (204, 0, 20),
    (205, 0, 20),
    (206, 0, 20),
    (207, 0, 20),
    (208, 0, 20),
    (209, 0, 20),
    (210, 0, 20),
    (211, 0, 20),
    (212, 0, 20),
    (213, 0, 20),
    (214, 0, 20),
    (215, 0, 20),
    (216, 0, 20),
    (217, 0, 20),
    (218, 0, 20),
    (219, 0, 20),
    (220, 0, 20),
    (221, 0, 20),
    (222, 0, 20),
    (223, 0, 20),
    (224, 0, 20),
    (225, 0, 20),
    (226, 0, 20),
    (227, 0, 20),
    (228, 0, 20),
    (229, 0, 20),
    (230, 0, 20),
    (231, 0, 20),
    (232, 0, 20),
    (233, 0, 20),
    (234, 0, 20),
    (235, 0, 20),
    (236, 0, 20),
    (237, 0, 20),
    (238, 0, 20),
    (239, 0, 20),
    (240, 0, 20);

  8. #8
    Join Date
    Jun 2008
    Posts
    3
    Plugin Contributions
    0

    Default Re: International Shipping

    Quote Originally Posted by Ajeh View Post
    You are making a zone that needs to have the same data as the tables
    zones_to_geo_zones
    geo_zones

    Tables would have ...

    For All Countries except the US you could use this to run through the Admin ... Tools ... Install SQL Patch ...

    PHP Code:
    INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (20'Not US''All Countries Except the US'NULL'2006-07-03 12:32:13');

    INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES (1020),
    (
    2020),
    (
    3020),
    (
    4020),
    (
    5020),
    (
    6020),
    (
    7020),
    (
    8020),
    (
    9020),
    (
    10020),
    (
    11020),
    (
    12020),
    (
    13020),
    (
    14020),
    (
    15020),
    (
    16020),
    (
    17020),
    (
    18020),
    (
    19020),
    (
    20020),
    (
    21020),
    (
    22020),
    (
    23020),
    (
    24020),
    (
    25020),
    (
    26020),
    (
    27020),
    (
    28020),
    (
    29020),
    (
    30020),
    (
    31020),
    (
    32020),
    (
    33020),
    (
    34020),
    (
    35020),
    (
    36020),
    (
    37020),
    (
    38020),
    (
    39020),
    (
    40020),
    (
    41020),
    (
    42020),
    (
    43020),
    (
    44020),
    (
    45020),
    (
    46020),
    (
    47020),
    (
    48020),
    (
    49020),
    (
    50020),
    (
    51020),
    (
    52020),
    (
    53020),
    (
    54020),
    (
    55020),
    (
    56020),
    (
    57020),
    (
    58020),
    (
    59020),
    (
    60020),
    (
    61020),
    (
    62020),
    (
    63020),
    (
    64020),
    (
    65020),
    (
    66020),
    (
    67020),
    (
    68020),
    (
    69020),
    (
    70020),
    (
    71020),
    (
    72020),
    (
    73020),
    (
    74020),
    (
    75020),
    (
    76020),
    (
    77020),
    (
    78020),
    (
    79020),
    (
    80020),
    (
    81020),
    (
    82020),
    (
    83020),
    (
    84020),
    (
    85020),
    (
    86020),
    (
    87020),
    (
    88020),
    (
    89020),
    (
    90020),
    (
    91020),
    (
    92020),
    (
    93020),
    (
    94020),
    (
    95020),
    (
    96020),
    (
    97020),
    (
    98020),
    (
    99020),
    (
    100020),
    (
    101020),
    (
    102020),
    (
    103020),
    (
    104020),
    (
    105020),
    (
    106020),
    (
    107020),
    (
    108020),
    (
    109020),
    (
    110020),
    (
    111020),
    (
    112020),
    (
    113020),
    (
    114020),
    (
    115020),
    (
    116020),
    (
    117020),
    (
    118020),
    (
    119020),
    (
    120020),
    (
    121020),
    (
    122020),
    (
    123020),
    (
    124020),
    (
    125020),
    (
    126020),
    (
    127020),
    (
    128020),
    (
    129020),
    (
    130020),
    (
    131020),
    (
    132020),
    (
    133020),
    (
    134020),
    (
    135020),
    (
    136020),
    (
    137020),
    (
    138020),
    (
    139020),
    (
    140020),
    (
    141020),
    (
    142020),
    (
    143020),
    (
    144020),
    (
    145020),
    (
    146020),
    (
    147020),
    (
    148020),
    (
    149020),
    (
    150020),
    (
    151020),
    (
    152020),
    (
    153020),
    (
    154020),
    (
    155020),
    (
    156020),
    (
    157020),
    (
    158020),
    (
    159020),
    (
    160020),
    (
    161020),
    (
    162020),
    (
    163020),
    (
    164020),
    (
    165020),
    (
    166020),
    (
    167020),
    (
    168020),
    (
    169020),
    (
    170020),
    (
    171020),
    (
    172020),
    (
    173020),
    (
    174020),
    (
    175020),
    (
    176020),
    (
    177020),
    (
    178020),
    (
    179020),
    (
    180020),
    (
    181020),
    (
    182020),
    (
    183020),
    (
    184020),
    (
    185020),
    (
    186020),
    (
    187020),
    (
    188020),
    (
    189020),
    (
    190020),
    (
    191020),
    (
    192020),
    (
    193020),
    (
    194020),
    (
    195020),
    (
    196020),
    (
    197020),
    (
    198020),
    (
    199020),
    (
    200020),
    (
    201020),
    (
    202020),
    (
    203020),
    (
    204020),
    (
    205020),
    (
    206020),
    (
    207020),
    (
    208020),
    (
    209020),
    (
    210020),
    (
    211020),
    (
    212020),
    (
    213020),
    (
    214020),
    (
    215020),
    (
    216020),
    (
    217020),
    (
    218020),
    (
    219020),
    (
    220020),
    (
    221020),
    (
    222020),
    (
    224020),
    (
    225020),
    (
    226020),
    (
    227020),
    (
    228020),
    (
    229020),
    (
    230020),
    (
    231020),
    (
    232020),
    (
    233020),
    (
    234020),
    (
    235020),
    (
    236020),
    (
    237020),
    (
    238020),
    (
    239020),
    (
    240020); 

    search helper: premade World Zone except for the US
    This worked PERFECTLY!
    Thank you!

  9. #9
    Join Date
    Jun 2008
    Location
    USA
    Posts
    204
    Plugin Contributions
    1

    Default Re: International Shipping

    Quote Originally Posted by Ajeh View Post
    You are making a zone that needs to have the same data as the tables
    zones_to_geo_zones
    geo_zones

    Tables would have ...

    For All Countries except the US you could use this to run through the Admin ... Tools ... Install SQL Patch ...

    PHP Code:
    INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (20'Not US''All Countries Except the US'NULL'2006-07-03 12:32:13');

    INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES (1020),
    (
    2020),
    (
    3020),
    (
    4020),
    (
    5020),
    (
    6020),
    (
    7020),
    (
    8020),
    (
    9020),
    (
    10020),
    (
    11020),
    (
    12020),
    (
    13020),
    (
    14020),
    (
    15020),
    (
    16020),
    (
    17020),
    (
    18020),
    (
    19020),
    (
    20020),
    (
    21020),
    (
    22020),
    (
    23020),
    (
    24020),
    (
    25020),
    (
    26020),
    (
    27020),
    (
    28020),
    (
    29020),
    (
    30020),
    (
    31020),
    (
    32020),
    (
    33020),
    (
    34020),
    (
    35020),
    (
    36020),
    (
    37020),
    (
    38020),
    (
    39020),
    (
    40020),
    (
    41020),
    (
    42020),
    (
    43020),
    (
    44020),
    (
    45020),
    (
    46020),
    (
    47020),
    (
    48020),
    (
    49020),
    (
    50020),
    (
    51020),
    (
    52020),
    (
    53020),
    (
    54020),
    (
    55020),
    (
    56020),
    (
    57020),
    (
    58020),
    (
    59020),
    (
    60020),
    (
    61020),
    (
    62020),
    (
    63020),
    (
    64020),
    (
    65020),
    (
    66020),
    (
    67020),
    (
    68020),
    (
    69020),
    (
    70020),
    (
    71020),
    (
    72020),
    (
    73020),
    (
    74020),
    (
    75020),
    (
    76020),
    (
    77020),
    (
    78020),
    (
    79020),
    (
    80020),
    (
    81020),
    (
    82020),
    (
    83020),
    (
    84020),
    (
    85020),
    (
    86020),
    (
    87020),
    (
    88020),
    (
    89020),
    (
    90020),
    (
    91020),
    (
    92020),
    (
    93020),
    (
    94020),
    (
    95020),
    (
    96020),
    (
    97020),
    (
    98020),
    (
    99020),
    (
    100020),
    (
    101020),
    (
    102020),
    (
    103020),
    (
    104020),
    (
    105020),
    (
    106020),
    (
    107020),
    (
    108020),
    (
    109020),
    (
    110020),
    (
    111020),
    (
    112020),
    (
    113020),
    (
    114020),
    (
    115020),
    (
    116020),
    (
    117020),
    (
    118020),
    (
    119020),
    (
    120020),
    (
    121020),
    (
    122020),
    (
    123020),
    (
    124020),
    (
    125020),
    (
    126020),
    (
    127020),
    (
    128020),
    (
    129020),
    (
    130020),
    (
    131020),
    (
    132020),
    (
    133020),
    (
    134020),
    (
    135020),
    (
    136020),
    (
    137020),
    (
    138020),
    (
    139020),
    (
    140020),
    (
    141020),
    (
    142020),
    (
    143020),
    (
    144020),
    (
    145020),
    (
    146020),
    (
    147020),
    (
    148020),
    (
    149020),
    (
    150020),
    (
    151020),
    (
    152020),
    (
    153020),
    (
    154020),
    (
    155020),
    (
    156020),
    (
    157020),
    (
    158020),
    (
    159020),
    (
    160020),
    (
    161020),
    (
    162020),
    (
    163020),
    (
    164020),
    (
    165020),
    (
    166020),
    (
    167020),
    (
    168020),
    (
    169020),
    (
    170020),
    (
    171020),
    (
    172020),
    (
    173020),
    (
    174020),
    (
    175020),
    (
    176020),
    (
    177020),
    (
    178020),
    (
    179020),
    (
    180020),
    (
    181020),
    (
    182020),
    (
    183020),
    (
    184020),
    (
    185020),
    (
    186020),
    (
    187020),
    (
    188020),
    (
    189020),
    (
    190020),
    (
    191020),
    (
    192020),
    (
    193020),
    (
    194020),
    (
    195020),
    (
    196020),
    (
    197020),
    (
    198020),
    (
    199020),
    (
    200020),
    (
    201020),
    (
    202020),
    (
    203020),
    (
    204020),
    (
    205020),
    (
    206020),
    (
    207020),
    (
    208020),
    (
    209020),
    (
    210020),
    (
    211020),
    (
    212020),
    (
    213020),
    (
    214020),
    (
    215020),
    (
    216020),
    (
    217020),
    (
    218020),
    (
    219020),
    (
    220020),
    (
    221020),
    (
    222020),
    (
    224020),
    (
    225020),
    (
    226020),
    (
    227020),
    (
    228020),
    (
    229020),
    (
    230020),
    (
    231020),
    (
    232020),
    (
    233020),
    (
    234020),
    (
    235020),
    (
    236020),
    (
    237020),
    (
    238020),
    (
    239020),
    (
    240020); 
    search helper: premade World Zone or Rest of the World except for the US
    Hello Linda,

    Would you be able to post a modified version of this SQL code for rest of the world except US and Canada?

    Thanks,
    Meshach


  10. #10
    Join Date
    Apr 2010
    Posts
    2
    Plugin Contributions
    0

    Default Re: International Shipping

    I used the SQL statement to make a Non US zone. I also cloned two flat rates for international shipping using the post by fairestcape of December 16, 2008. When I try to checkout using an international address, I am on Step 1 of 3 where I select a shipping method, then when I click continue, the next page is blank. I am using the latest version of Zencart 1.3.9h Patch 1. It was an upgrade from 1.3.9g. I've spent hours searching through the online documentation and can't find a solution. I have no add-ons, but I am using a template. The server is Apache 2.2.17 and the installation is remote. PHP version 5.2.16 and MySQL version 5.0.91.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v154 Free US shipping, Flat Rate International over $50, $5.00 Shipping under $50
    By Rick5150 in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 27 Feb 2015, 04:24 PM
  2. Replies: 16
    Last Post: 31 May 2012, 07:08 PM
  3. Replies: 15
    Last Post: 26 Nov 2010, 06:17 PM
  4. Help on site with Free shipping and Paid International shipping
    By ruriimasu in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 2 Sep 2009, 08:21 AM
  5. Different National and International Shipping & FREE SHIPPING
    By polarduality in forum Built-in Shipping and Payment Modules
    Replies: 10
    Last Post: 23 Jan 2007, 11:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR