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 ... :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
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!!
Re: International Shipping
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');
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 (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
Re: International Shipping
Thanks Ajeh. I'll get working on it and will post back with my results.
Shelia:thumbsup:
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
Re: International Shipping
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:
Re: International Shipping
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
Re: International Shipping
Not a problem ... thanks for letting us know that the zone list worked for you ... :smile: