Page 1 of 16 12311 ... LastLast
Results 1 to 10 of 157
  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
    67,322
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  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
    67,322
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  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
    Apr 2006
    Posts
    80
    Plugin Contributions
    0

    Default Re: International Shipping

    Thanks again, everything is working fine.

    Maybe you should package the sql file up for download. I'm sure others would find it useful.

    Shelia

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    67,322
    Plugin Contributions
    6

    Default Re: International Shipping

    Debating that actually ... and would it be a good thing or lead to assumed conclusions?

    Yes, that is the World less the US that I posted ... but that is the World less the US based on our existing Zones ...

    If I make others, and something is missing ... am I doomed? Do I get shot when someone does not test properly?

    Posting it on the forum is less likely to get me hung ...

    But I am debating it as it is a royal pain to not have these made on some of these large combos and it takes longer to explain how to make them than it does to make a sql file and post it ...
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

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

    Default Re: International Shipping

    I see your point! I would hate it if I had a hand in getting the messenger shot!

    It worked for me and I appreciate you taking the time to help.

    Shelia

  10. #10
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    67,322
    Plugin Contributions
    6

    Default Re: International Shipping

    Not a problem ... thanks for letting us know that the zone list worked for you ...
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

 

 
Page 1 of 16 12311 ... LastLast

Similar Threads

  1. Configuring Taxes for Canadian Sites/Zones
    By DrByte in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 310
    Last Post: 17 Mar 2014, 05:01 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
  •