International Shipping

[estore]

Hi Linda,

I have installed the 1.5 version. Step 1 of the checkout process does not show the shipping methods. I have enabled the store pick up option from the admin as well as installed the zone rate module(also given a sort order 1 for store pick up and 2 for zone rate). I have configured shipping rates for US and Canada and it is functioning well (zone1 for US and zone 2 for Canada and zone3 for international) but not yet for international shipping. Is this the reason that the shipping method is not showing up in the step 1 of the checkout process? The shipping estimator also does not show the shipping estimate.
Secondly the registration form for new customers shows the drop down for provinces only for US and Canada and not for all the other countries. Is it because the zone definitions for international shipping have not been created?

I am new to zencart, any help would be much appreciated.

[Ajeh]

First, go to the Locations / Taxes ... Countries ...

How many Countries are listed at the bottom of the list, example:

Displaying 1 to 20 (of 243 countries)

[estore]

Hi

Thanks for your reply. Yes there are 243 countries listed there. I need to insert a sql patch for all countries other than US and Canada as I have yet to configure intl shipping for the rest of the world other than US and Canada. Where can I find the coding for this?

[Ajeh]

For Zone 3, if you want everyone else, meaning not the US and CA which you have set for Zone 1 and Zone 2, just enter 00 to indicate everyone else ...

Does this now make the International Shipping work?

When you say creating a new account is not showing other countries, have you added some kind of filters to this?

Have you an URL where we could perhaps peek at your site and try to see what is happening?

[estore]

Hi Linda,

Thanks so much for your prompt response. Where do I enter 00 for all other countries? I have given the ISO codes for all other countries in zone 3.

In the zone definitions I created a zone for US shipping following your instructions on your first post to sheila. Then I created a zone for US continental 48 states and DC and inserted the following patch via tools, insert sql patches.

INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`)
VALUES
(21, '48 Lower States', '48 States + DC', NULL, '2008-02-01 12:12:12');

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

Now do I need to insert another patch for Canada and another one for all countries except US and Canada?

The url where you can have a peek is www.modestycatalog.com/modestycatalog. If only I could make this intl shipping work I can launch this site.

thanks for your help

estore

[Ajeh]

If you are using Zone Rates zones shipping module, you do not need to create Zone Definitions for it as this shipping module is based on the 2 character ISO code that you will see on the Countries that I have you check ...

[Ajeh]

Secondly the registration form for new customers shows the drop down for provinces only for US and Canada and not for all the other countries. Is it because the zone definitions for international shipping have not been created?

I am not sure what you mean by this, I go to create an account and I see all the countries listed ...

[estore]

Hi Linda,

Yes all the countries are listed, but when you choose a country other than US or Canada the drop down does not show the list of the states or provinces.

Yes, I am using zone rates - zone 1 for US and zone 2 for Canada and zone 3 for international. The shipping rates are displayed for US and Canada but for international I do not know if I have configured it right. Since I am not able to create an account as a customer from a country other than US and Canada (as the drop down for provinces/states does not open up) I cannot test if the intl shipping works or not. This is what I have done:

Zone Based Rates

Enable Zones Method
True

Calculation Method
Price

Tax Class
--none--

Tax Basis
Shipping

Sort Order
2

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


Zone 1 Countries
US

Zone 1 Shipping Table
50:6.00, 100:10.00, 150:13.00, 200:15.00, 300:20.00, 500:25, 700:30, 1000:35

Zone 1 Handling Fee
0

Handling Per Order or Per Box Zone 1 (when by weight)
Order

Zone 2 Countries
CA

Zone 2 Shipping Table
50:12.00, 100:16.00, 150:20.00, 200:24.00, 300:28.00, 500:32.00, 700:36.00, 1000:40.00

Zone 2 Handling Fee
0

Handling Per Order or Per Box Zone 2 (when by weight)
Order

Zone 3 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,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 3 Shipping Table
50:15.00, 100:25.00, 150:32.00, 200:40.00, 300:48.00, 500:60.00, 700:75.00, 1000:85.00

Zone 3 Handling Fee
0

Handling Per Order or Per Box Zone 3 (when by weight)
Order

All I want is to offer 3 different shipping quotes: 1 for US, 1 for Canada and one for international. I thought there is a connection between the zone rates and the zone definitions. But I don't mind what module I use as long as whatever I use functions perfectly and offers the shipping rates to my customers without any error. Can you pls suggest how I can configure international shipping and which module I should use?

thanks

estore

[Ajeh]

Is Zone 3 for ALL other countries except US and CA? If so, set that to 00 so no one is left out ... as 00 means everyone else that is not listed in Zone 1 and Zone 2 ...

Only some Countries will have anything for the States, not all have anything for that field ...

You appear to have some extra Zones added for United States and Canada ... go to Locations / Taxes ... Zones ... and look in the United States and Canada ... do you have weird Zones with names like 3 for Zone 2 in Canada and a Zone 1 for the United States? If so, delete those ...

[estore]

Is Zone 3 for ALL other countries except US and CA? If so, set that to 00 so no one is left out ... as 00 means everyone else that is not listed in Zone 1 and Zone 2 ...

Only some Countries will have anything for the States, not all have anything for that field ...

You appear to have some extra Zones added for United States and Canada ... go to Locations / Taxes ... Zones ... and look in the United States and Canada ... do you have weird Zones with names like 3 for Zone 2 in Canada and a Zone 1 for the United States? If so, delete those ...

I did as you told me. I deleted the weird zones-zone 1, 2 and zone 3 from the Locations/taxes then countries, zones.... and also replaced the ISO country codes for zone 3 countries in the zone rate module with 00. Then I shopped as a customer from Germany(the drop down now shows a only a few european countries and Australia). The shipping rate for germany was displayed as "shipping for DE" I don't understand what this DE is. Have I configured the zone rates correctly? And if I don't use the zone rates module for US, Canada & international shipping then what else can I use and how? And how can I configure correctly?

estore