International Shipping

[Shepherd348]

Is there a way to run a special for free shipping on any order over $100.?

[Ajeh]

You have 2 choices ...

You can set it to give ONLY Free Shipping on Orders over $100 by going to the Modules ... Order Totals ... Shipping ot_shipping ... and edit that so that Free Shipping is enabled and set to 100 ...

Or, if you want to have a Free Shipping Option plus regular shipping on Orders over $100 then go to the Modules ... Shipping ... and turn on the Free Shipping Option freeoptions and set the Total to >= 100 and then you will see both the Free shipping when orders are over $100 plus the regular shipping methods for those in a hurry ...

[Shepherd348]

Thanks, that was easy. Guess there's no way to exclude the free shipping offer for those using discount coupons. I've looked at the restriction options and don't see any way to limit that.

Shep

[Ajeh]

What method are you using for the Free shipping?

This would take quite a bit of coding as the Discount Coupon is added on the checkout_payment ... and you would need to check for if there is a Discount Coupon then to go back to shipping for a new selection plus the explination that if you use a Discount Coupon you lose the nice Free Shipping that brought you to the store to begin with ...

[Shepherd348]

That's what I was afraid of. Thanks for your input but I'll have to find another way around that.

Shep

[casmusic]

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 except for the US

This worked PERFECTLY!
Thank you!

[len7560]

I really could use some assistance with this... I have been looking for a solution since last August.

I am trying to figure out something on a clients zen cart v. 1.3.8a
I would to exclude some countries from being able to use (USPS) international 1st class shipping (package & parcel) while still allowing some others to have this option.

Is there a way to do this? I have not had any success finding a solution.

Thanks in advance!

[outsider]

I have set the US and international zone following the instruction from this threat, when i test with the estimate shipping at shopping cart, the US zone works fine, but when i try to choose other country from the drop down, it just keep showing the US rate instead. Hope someone can help me out. Thanks!

My zone rate module setting is as following:

Zone Based Rates

Enable Zones Method
True

Calculation Method
Item

Tax Class
Taxable Goods

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes


Zone 1 Countries
US

Zone 1 Shipping Table
1:15.00,2:25.00,3:40.00,4:50.00,5:55.00,6:60.00,7:65.00,8:70.00,9:75.00,10:80.00 ,11:85.00,12:90.00

Zone 1 Handling Fee
0

Zone 2 Countries
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,H R,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,M H,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,T N,TR,TM,TC,TV,UG,UA,AE,GB,UM,UY,UZ,VU,VA,VE,VN,VG,VI,WF,EH,YE,YU,ZM,ZW

Zone 2 Shipping Table
1:35.00,2:55.00,3:75.00,4:90.00,5:105.00,6:120.00,7:135.00,8:150.00,9:165.00,10: 180.00,11:195.00,12:210.00

Zone 2 Handling Fee
0

[CottonInk]

I tried inserting your contribution for the 49 states but get the following errors:
Failed: 2
ERROR: Cannot execute because table zen_geo_zones does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_zones_to_geo_zones does not exist. CHECK PREFIXES!
Note: 2 statements ignored. See "upgrade_exceptions" table for additional details.
Any idea why it's not working?

i am getting this same error when trying to load these zones... any help would be appreciated.

**edit** just figured this out... i removed the 2 "zen_" prefixes and it loaded up correctly.

[Ajeh]

I have set the US and international zone following the instruction from this threat, when i test with the estimate shipping at shopping cart, the US zone works fine, but when i try to choose other country from the drop down, it just keep showing the US rate instead. Hope someone can help me out. Thanks!

What version Zen Cart are you running?

Is this an Upgrade or a clean install?

If this is v1.3.8, you need to save all your settings for your Zones to NotePad and REMOVE, INSTALL and reconfigure this shipping module ...

NOTE: for All Zones not defined, you should see that you can use 00 instead of each separate country, once this is done ...