Region Tables 1.0.0 Released!

[tempestade]

Do your other multilingual shipping methods load their language definition files okay?

yes they do, I will unistal the module and reinstal it again to see if that helps.

Thank's Conor!

regards,

[transmobius]

Is it possible to use wildcard matching for a region's country code listing? I need everything outside of the US in a region. So can I do:

!US,*

Or do I need to list them all except 'US' (dumped from the countries database):
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,VC,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,T T,TN,TR,TM,TC,TV,UG,UA,AE,GB,UM,UY,UZ,VU,VA,VE,VN,VG,VI,WF,EH,YE,YU,ZR,ZM,ZW

[transmobius]

Here are all of the ISO country codes (including the US) in aphabetic order for anyone who wants to cut-and-paste to save some typing:

AD,AE,AF,AG,AI,AL,AM,AN,AO,AQ,AR,AS,AT,AU,AW,AX,AZ,BA,BB,BD,BE,BF,BG,BH,BI,BJ,BM ,BN,BO,BR,BS,BT,BV,BW,BY,BZ,CA,CC,CF,CG,CH,CI,CK,CL,CM,CN,CO,CR,CU,CV,CX,CY,CZ,D E,DJ,DK,DM,DO,DZ,EC,EE,EG,EH,ER,ES,ET,FI,FJ,FK,FM,FO,FR,FX,GA,GB,GD,GE,GF,GH,GI, GL,GM,GN,GP,GQ,GR,GS,GT,GU,GW,GY,HK,HM,HN,HR,HT,HU,ID,IE,IL,IN,IO,IQ,IR,IS,IT,JM ,JO,JP,KE,KG,KH,KI,KM,KN,KP,KR,KW,KY,KZ,LA,LB,LC,LI,LK,LR,LS,LT,LU,LV,LY,MA,MC,M D,MG,MH,MK,ML,MM,MN,MO,MP,MQ,MR,MS,MT,MU,MV,MW,MX,MY,MZ,NA,NC,NE,NF,NG,NI,NL,NO, NP,NR,NU,NZ,OM,PA,PE,PF,PG,PH,PK,PL,PM,PN,PR,PT,PW,PY,QA,RE,RO,RU,RW,SA,SB,SC,SD ,SE,SG,SH,SI,SJ,SK,SL,SM,SN,SO,SR,ST,SV,SY,SZ,TC,TD,TF,TG,TH,TJ,TK,TM,TN,TO,TP,T R,TT,TV,TW,TZ,UA,UG,UM,US,UY,UZ,VA,VC,VE,VG,VI,VN,VU,WF,WS,YE,YT,YU,ZA,ZM,ZR,ZW

[conor]

Hi,

Or do I need to list them all except 'US' (dumped from the countries database):

The wildcard matches everything and can't be used in combination with other country codes.

However, it doesn't need to be in your case as regions are matched on a first come, first served basis so all you need to do is have US address matched by a region and then the wildcard matching a following region won't ever apply to the US as US address will already have been matched.

Hope it's easy enough to get your head around that logic! ;-)

[transmobius]

Excellent.

So
Region 1 = US
and
Region 2 = *

Correct?

Also looking at including the US territories and possessions for US postal mail
Region 1 = US,AS,GU,MP,PR,PW,VI
(American Somoa, Guam, Mariana Islands, Puerto Rico, Palau, US Virgin Islands)
As these all require the same postage as the actual US.

[conor]

Hi,

Also looking at including the US territories and possessions for US postal mail
Region 1 = US,AS,GU,MP,PR,PW,VI
(American Somoa, Guam, Mariana Islands, Puerto Rico, Palau, US Virgin Islands)
As these all require the same postage as the actual US.

Yes, so as you've hinted, you'd set up two regions as:

Region 1 = US,AS,GU,MP,PR,PW,VI
Region 2 = *

Didn't know there were any US postal services that covered all of those other countries... interesting! :)

Glad you find the module useful!

[donplay]

Hi Ceon,

The module seems great so far. One small gotcha I can't seem to get around and would love to have your expertise on. Thanks in advance for your time.

- Our Zone 1 is US. I want 1) $10 ground shipping under order total of 300, free if 300 or over 2) $20 2 day ship 3) $30 overnight 4) in store pickup for free

If a person has over $300 in their cart, the free ground shipping is already selected. They don't have the option for in store pickup, or the more expensive, quicker options. We would like all those displayed as well. Any tips on how to get around this?

Here is my setup:

I have Region Tables as my Sort Order #1, Store Pickup as my #2. Below are my Region Tables Settings:

Region 1 Definition Method
Country/Postcode Matching
Region 1 Countries/Postcodes
US
Region 1 Distance From Store
10
Region 1 Shipping Method 1 Table of Rates
299.99:10,*:0
Region 1 Shipping Method 2 Table of Rates
*:20
Region 1 Shipping Method 3 Table of Rates
*:30
Region 1 Shipping Method 4 Table of Rates

Region 1 Handling Fee
0

[conor]

Hi,

The module seems great so far. One small gotcha I can't seem to get around and would love to have your expertise on. Thanks in advance for your time.

I'm glad you appreciate our work! :)

We would like all those displayed as well. Any tips on how to get around this?

I'm not sure what is up with your store but that configuration works just fine on our servers (as it should). The only thing you have done wrong is to leave the Region 1 Shipping Method 4 Table of Rates empty whereas it should be:

*:0

Have you only one region defined or do you have several? I can't think of any reason that all four rates wouldn't be displayed if the value of the cart is above $300 (and if you've set up Method 4 correctly as above).

I'm afraid the only thing I can offer is to log into your site and debug your store manually. If it is doable in a short time I won't charge anything, if I can't find a quick solution then I'm afraid we'd have to talk about a consultancy fee for the work involved.

Please contact me using the contact form on our website:

http://dev.ceon.net/contact_us

Sorry I can't be of more help than that straight off but as I said it works here! :)

(You are using the latest version of the module of course?)

[donplay]

Hi Ceon,

I am using version 1.2.0 of Region Tables which I downloaded from your site a few weeks ago.

I remember during the installation I seemed to lose connectivity or get interrupted partially through, so perhaps things didn't get installed properly. I'd like to try to resolve this myself by uninstalling and then re-installing this module. I didn't run any SQL scripts. Would I just do the following steps?

1) Note my settings
2) Delete the following files

includes/languages/english/modules/shipping/regiontables.php
includes/languages/english/modules/shipping/YOUR_TEMPLATE/regiontables.php
includes/modules/shipping/regiontables.php
includes/modules/shipping/regiontables/geolocation_gb.php
includes/templates/YOUR_TEMPLATE/templates/tpl_checkout_shipping_default.php

3) And then go through the install instructions from the beginning?

thanks,
Don

[donplay]

Conor,

It's sorted now. Didn't have to re-install...essentially I had another setting in the admin that was configured when I was originally trying to set up my rules that was interfering with the Region Tables.

In Modules->Order Total Modules-> Shipping ot_shipping I had it set (and still enabled) to give free shipping if the order were over 299.99. So when it was going over 300 it was superceding your module.

Wish I could say I figured it out on my own...it was actually my wife that found it. She won't let me hear the end of it and has gotten into the habit of saying, "who's the computer guru NOW...." :)

Anyhow thanks for the prompt reply, I believe all is well now. Thanks.

-Don