International Shipping

Ajeh:

NOTE: the simple way to do this on Zone Rate zones ...

Set the SKIP to US ..

Set the Zone 1 to 00 for Everyone else ...

All done ... :smile:

Where do you find zone rate?

I have zone and zone definition under locations/taxes.

Locations/Taxes
countries
zones
zone definitions
tax classes

tax rate

Ajeh:

NOTE: the simple way to do this on Zone Rate zones ...

Set the SKIP to US ..

Set the Zone 1 to 00 for Everyone else ...

All done ... :smile:

Well...I had done this several months ago. And had forgot I used the sql database add for all countries. I loaded the zone rates mod. I also set zone rates as:
Zone Based Rates

Enable Zones Method
True

Calculation Method
Weight

Tax Class
Taxable Goods

Tax Basis
Store

Sort Order
0

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

Zone 1 Countries
00

Zone 1 Shipping Table
4:11.95,20:38.95,40:49.95,10000:10%

Zone 1 Handling Fee
0.00

And set the Table rate for US as:
Table Rate

Enable Table Method
True

Shipping Table
25:4.50,35:5.55,50:6.25,65:7.75,100:9.75,150:11.75,10000.00:7%

Table Method
price

Handling Fee
0

Tax Class
Taxable Goods

Tax Basis
Store

Shipping Zone
US

Sort Order
0

I need to set the US as a table rate and international with weight.
As I do test orders system keeps giving me weight.

Sorry for all the confusion...Kim

If I go to your site and enter my address for the US I see the Table Rate ...

If I enter my address as Switzerland I see Zone Rate ...

What is is that isn't working on this?

Ajeh:

If I go to your site and enter my address for the US I see the Table Rate ...

If I enter my address as Switzerland I see Zone Rate ...

What is is that isn't working on this?

When I go to checkout as a login user. The top part of page is Shopping Cart contents and has wrong shipping as zone rates. And when you go further down page you see shipping method. You have to click table rate (best way). Then the shopping cart contents change to table rate.

Here is basic screen print.
Your Order Total:
Shopping Cart Contents
Qty. Item Name Total
1 x KJV Cornerstone Master Study - Black Genuine Leather $40.47

$40.47Sub-Total:

$4.77MI TAX 6.0% + US Tax 0.00:

$38.95Zone Rates (Shipping to (1 x 6.20lb(s))):
$84.19Total:
Discount Coupon
Please type your coupon code into the box next to Redemption Code. Your coupon will be applied to the total and reflected in your cart after you click continue.

Please note: you may only use one coupon per order.

Redemption Code

Step 1 - Delivery Information
Shipping MethodShipping AddressBB
Kimberly Burner
9486 Baldwin Road
Gaines, MI 48436
United StatesYour order will be shipped to the address at the left or you may change the shipping address by clicking the Change Address button.

Please select the preferred shipping method to use on this order.
Table Rate $6.25 Best Way

Do you understand? I am not sure if I am explaining correctly. Customers think they are being charged the higher zone rate and leave. What can I do?

Thanks, Kim

It's hard to say as you are not using the Zen Cart checkout but an add-on ...

Thanks for all the great info, but I have a different problem. I sell items for different manufacturers and some offer free ship in the US and others don't. I am very stuck on this one and any assistance would be greatly appreciated. Is this even possible?

I downloaded this add on and see it is for 1.3.5 version. I am using 1.3.7 I am having a devil of a time figuring out how to set free shipping rules so that US (48) get free shipping if order is XXX dollars and All others get free shipping if XXX dollars. Two different price triggers for free shipping. The 48 US states, where shipping is cheap, and the International or everyone else. The free Shipping Options module only list a tax rate zone to apply rules to. If I understand this thread (and I am in the confused and bewildered club) Then I need to create a zone for all 48 US states and that will then apply the rules to orders from the 48 states, however the international orders will not have any free shipping options. I have another store that uses 1.3.8 and the options are the same there, so upgrading doesn't seam to be an answer. I have fixed it so US gets free shipping and international do not. How do I set rules for international so they too can get free shipping, just at a higher dollar amount?

Thanks so much Linda for your posts! Since so many posted so many different variables, I just need the simplest form of this and would like to know:

I only want to offer Free Shipping to only the lower 48 US States but charge for shipping by USPS outside those areas worldwide.

What all do I need to do?

Many thanks,
Frank

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 trying to figure out something on a clients zen cart v. 1.3.8a

The client wants to exclude some countries from being able to use international 1st class shipping (package & parcel) while still allowing some others to have this option.

Their experience has shown that to some countries they want to make shipping with a tracking number mandatory - which the 1st class option doesn't provide.

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

Thanks in advance!

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

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

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

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

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

Shep

Ajeh:

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

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!

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

yes9310:

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.

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!

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