customize shipping zones

[stitchnkitty]

I need to restrict the shipping zones to the US and Canada. then be able to go to GB; Japan and Au as I develop the cart.

How do I do this - I am a newbie! TIA

[Ajeh]

There are a couple of ways, but it does depend on the shipping method(s) that you are using ...

Which ones do you intend to use?

[stitchnkitty]

I have tried the shipping zones in the admin but I already have the tax zone in there and it only acceptes one zone that I could see-
I will need right now to restrict the shipping popup screen to only US and Canada - they can be together since canada has shipping fairly close to the US.

After that - I will be adding great Brititan which will be separate and then Austrialia.

It will depend on the shipping likenesses of the rates as to how many I will need and what goes into each zone. We generally get most orders in the US and Ca.

Probably at this time 3 or 4 will be sufficient - but with the popup screen to calculate shipping in all countries I dont want orders from everywhere at this time so I will need to have that not register. TIA

[Ajeh]

You can build a Zone Definition for 50 States plus DC with:

INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (40, 'US - 50 states plus DC', 'All 50 states plus DC', NULL, '2008-11-25');

INSERT INTO zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id) VALUES 
(223,1, 40),
(223,2, 40),
(223,4, 40),
(223,5, 40),
(223,12, 40),
(223,13, 40),
(223,14, 40),
(223,15, 40),
(223,16, 40),
(223,18, 40),
(223,19, 40),
(223,21, 40),
(223,22, 40),
(223,23, 40),
(223,24, 40),
(223,25, 40),
(223,26, 40),
(223,27, 40),
(223,28, 40),
(223,29, 40),
(223,31, 40),
(223,32, 40),
(223,33, 40),
(223,34, 40),
(223,35, 40),
(223,36, 40),
(223,37, 40),
(223,38, 40),
(223,39, 40),
(223,40, 40),
(223,41, 40),
(223,42, 40),
(223,43, 40),
(223,44, 40),
(223,45, 40),
(223,47, 40),
(223,48, 40),
(223,49, 40),
(223,51, 40),
(223,53, 40),
(223,54, 40),
(223,55, 40),
(223,56, 40),
(223,57, 40),
(223,58, 40),
(223,59, 40),
(223,61, 40),
(223,62, 40),
(223,63, 40),
(223,64, 40),
(223,65, 40);

which can be run in the Tools ... Install SQL Patches ...

Then, go to the Zone Definitions and click on DETAILS for this new Zone and add Canada for All Zones to this Definition ...

[stitchnkitty]

TY Ajeh

I have done that - so my zones are now Canada; usly and US with DC.

however in the shipping costs estimator window it will estimate the costs for all countries to be the same as the US and Canada.
And also in checkout.

what have i missed?

[Ajeh]

If you apply the Zone to the shipping module, in the Modules ... Shipping ... and EDIT the shipping module(s) to add the new Zone, you should not see them when you select another country and click update ...

Have you an URL where we could perhaps peek at this?

[stitchnkitty]

Good afternoon
yes you may :
www.stitchnframeonline.com/snfcart

the only place I have product is in the crewel kit section

[Ajeh]

If you send me a PM for your Admin URL and login I can peek at this when I get some time to see what is up here ...

[Ajeh]

I re-added the Zone Definition for the 48 States plus DC and when I add it to the Table Rate the Table Rate will only work for these 48 States plus DC ...

Test this out by adding the new Zone to your Table Rate shipping module and see if it is working for you ...

[Ajeh]

Note: then try the US 50 plus DC and see if all 50 states plus DC work with your shipping ...

Both should block anyone else ...