Hi Linda,
Sorry for my ignorance. I don't understand how to create the list. Can you tell me how to do that? What do I have to copy, save as what file, then install SQL?
Thanks.
Klemens.
Hi Linda,
Sorry for my ignorance. I don't understand how to create the list. Can you tell me how to do that? What do I have to copy, save as what file, then install SQL?
Thanks.
Klemens.
Klemens
Just copy that whole peice of the 2 INSERTS that I posted into your Zen Cart Admin ... Tools ... Insert SQL Patch ...
Paste it into the input window ...
Click Send ...
You will see it all on your screen and that it was successful ...
Go to the Localization/Taxes ... Zone Definitions ...
You will see NOT US ... click the details ...
You will see all countries added except the US ...
NOTE: the US includes the 50 states, the territories, islands, armed services, etc.
So be sure you mean what you say when you say All of the US for the other zone ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
From page 1 of this thread, you only had 1 insert:
PHP code...
The message above it by Sheila with #international.
Do you mean I copy both the #international, then the PHP code inserts right after that into the SQL inseart area? Please verify.
Klemens
If you look carefully ... my post contains 2 INSERT statements ...
1 is 1 line long ...
The 2nd is a mile long ... make sure you get all of the lines ... the last line ends in a semi-colon ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Linda,
You are supper! Your help from the other post and this one help me to set it up the way I want it, perfectly.
Thank you again.
Klemens
You are most welcome ... glad that you could get your US and World Shipping straightened out for the different zones ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Thanks for that, Linda. Very helpful. I've got the zone implemented in the Admin > locations/taxes > Zone Definitions area. Now how do I implement it in my shipping options?
I'm guessing I have to go into the Shipping module, and use Zone based shipping... for Zone 1 i've just got "US" and what do I enter for Zone 2? Or is there something else I have to do?
Linda,
Thanks for the 'Not US' shipping zone, it worked a treat! That was *just* what I was looking for......
Now, off to figure out how to create 2 more shipping rates to charge flat rates for 2-day and 3-day shipping....then I'm *done*!!!!
Thanks so much for all your great posts, I've found a lot of good info in them.
Actually, you can use a Zone on most all of the Shipping Modules ...Originally Posted by wrong
You just need to think through what a zone will do to a shipping module and that you have all the bases covered on the Zones and do not exclude anyone ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
In case anyone wants this, I did all the work of pasting all the "Non US" zones, so you can use zone shipping. Just copy and paste:
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
Bookmarks