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

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 ... :cry:

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

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!!

Ok, I got this far! :thumbsup: 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');

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 ...

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 (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),
(38, 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),
(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);

search helper: premade World Zone or Rest of the World except for the US

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

Shelia:thumbsup:

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

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

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? :cry:

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 ... :cool:

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

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

Shelia

Not a problem ... thanks for letting us know that the zone list worked for you ... :smile:

Hi Linda,
Sorry for my ignorance. I don't understand how to create the list. Can you tell me how to do that? What do I have to copy, save as what file, then install SQL?
Thanks.

Klemens.

Just copy that whole peice of the 2 INSERTS that I posted into your Zen Cart Admin ... Tools ... Insert SQL Patch ...

Paste it into the input window ...

Click Send ...

You will see it all on your screen and that it was successful ...

Go to the Localization/Taxes ... Zone Definitions ...

You will see NOT US ... click the details ...

You will see all countries added except the US ...

NOTE: the US includes the 50 states, the territories, islands, armed services, etc.

So be sure you mean what you say when you say All of the US for the other zone ...

From page 1 of this thread, you only had 1 insert:

PHP code...

The message above it by Sheila with #international.

Do you mean I copy both the #international, then the PHP code inserts right after that into the SQL inseart area? Please verify.

If you look carefully ... my post contains 2 INSERT statements ...

1 is 1 line long ...

The 2nd is a mile long ... make sure you get all of the lines ... the last line ends in a semi-colon ...

Linda,
You are supper! Your help from the other post and this one help me to set it up the way I want it, perfectly.
Thank you again.

You are most welcome ... glad that you could get your US and World Shipping straightened out for the different zones ... :smile:

Thanks for that, Linda. Very helpful. I've got the zone implemented in the Admin > locations/taxes > Zone Definitions area. Now how do I implement it in my shipping options?

I'm guessing I have to go into the Shipping module, and use Zone based shipping... for Zone 1 i've just got "US" and what do I enter for Zone 2? Or is there something else I have to do?

Linda,

Thanks for the 'Not US' shipping zone, it worked a treat! That was just what I was looking for......

Now, off to figure out how to create 2 more shipping rates to charge flat rates for 2-day and 3-day shipping....then I'm done!!!!

Thanks so much for all your great posts, I've found a lot of good info in them.

wrong:

Thanks for that, Linda. Very helpful. I've got the zone implemented in the Admin > locations/taxes > Zone Definitions area. Now how do I implement it in my shipping options?

I'm guessing I have to go into the Shipping module, and use Zone based shipping... for Zone 1 i've just got "US" and what do I enter for Zone 2? Or is there something else I have to do?

Actually, you can use a Zone on most all of the Shipping Modules ...

You just need to think through what a zone will do to a shipping module and that you have all the bases covered on the Zones and do not exclude anyone ...

In case anyone wants this, I did all the work of pasting all the "Non US" zones, so you can use zone shipping. Just copy and paste:

AX,AF,AL,DZ,AS,AD,AO,AI,AQ,AG,AR,AM,AW,AU,AT,AZ,BS,BH,BD,BB,BY,BE,BZ,BJ,BM,BT,BO,BA,BW,BV,BR,IO,BN,BG,BF,BI,KH,CM,CA,CV,KY,CF,TD,CL,CN,CX,CC,CO,KM,CG,CK,CR,CI,HR,CU,CY,CZ,DK,DJ,DM,DO,TP,EC,EG,SV,GQ,ER,EE,ET,FK,FO,FJ,FI,FR,FX,GF,PF,TF,GA,GM,GE,DE,GH,GI,GR,GL,GD,GP,GU,GT,GN,GW,GY,HT,HM,HN,HK,HU,IS,IN,ID,IR,IQ,IE,IL,IT,JM,JP,JO,KZ,KE,KI,KP,KR,KW,KG,LA,LV,LB,LS,LR,LY,LI,LT,LU,MO,MK,MG,MW,MY,MV,ML,MT,MH,MQ,MR,MU,YT,MX,FM,MD,MC,MN,MS,MA,MZ,MM,NA,NR,NP,NL,AN,NC,NZ,NI,NE,NG,NU,NF,MP,NO,OM,PK,PW,PA,PG,PY,PE,PH,PN,PL,PT,PR,QA,RE,RO,RU,RW,KN,LC,WS,SM,ST,SA,SN,SC,SL,SG,SK,SI,SB,SO,ZA,GS,ES,LK,SH,PM,SD,SR,SJ,SZ,SE,CH,SY,TW,TJ,TZ,TH,TG,TK,TO,TT,TN,TR,TM,TC,TV,UG,UA,AE,GB,UM,UY,UZ,VU,VA,VE,VN,VG,VI,WF,EH,YE,YU,ZM,ZW