Region Tables 1.0.0 Released!

conor:

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,

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,HR,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,MH,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,TT,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

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,DE,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,MD,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,TR,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

Hi,

transmobius:

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! ;-)

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.

Hi,

transmobius:

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!

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

Hi,

donplay:

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

donplay:

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?)

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

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

Hi Don,

donplay:

She won't let me hear the end of it and has gotten into the habit of saying, "who's the computer guru NOW...." :)

lol Well she sounds like a proper guru... give her my appreciation and thanks! :)

I'm glad that everything's working as expected... enjoy the module! :)

Just wanted to let you know that I solved the problem with the language files and the module is now working just fine.

Thanks again for this great module :clap::clap:

Can anyone help with this problem? I installed Regiontables with great success and it works perfectly with PayPal and 2CO. I recently installed Googlecheckout and for some reason the shipping costs are not being handed over to Google. I've run the shipping handler thing and followed all instructions (I think).

I was wondering if it is to do with this array comment in includes/module/payment/googlecheckout.php

$this->shipping_support = array("flat", "item", "table",  'freeoptions', 'freeshipper', 'perweightunit', 'storepickup', 'itemnational', 'iteminternational');

I've tried adding 'regiontables' in here and in related areas but still no luck. My brain is starting to fail on me. :shocking: Any pointers would be greatly appreciated.

Marcus

Hi,

tempestade:

Just wanted to let you know that I solved the problem with the language files and the module is now working just fine.

What was the problem? How did you fix it?

tempestade:

Thanks again for this great module :clap:

Glad you like it! :)

Hello,

I have installed the latest release of Region Tables. I have 8 regions setup with all my US zip codes identified as follows:

Region 1 - US:900-908,US:910-918,US:919-921,US:922-928,US:930-935
Region 2 - US:863-864,US:889-891,US:936-939

and so on. My shipping I was hoping I could setup like this:

0:$10, 100:10%

Calculation Method = Price.
For $0.00 $99.99 the rate would be $10
For anything over $100 the rate would be 10% of sub-total. This method seems to work in the MZMT shipping module and I was hoping it worked here. Does anyone know how to add percentage of total to shipping for the Region Tables mod? Or is there another mod that would work better for this and 8 regions (or zones) too?

Any help is appreciated.

Thanks,
Steve

Hi,

swiker:

I Does anyone know how to add percentage of total to shipping for the Region Tables mod?

This is a feature a few people have asked for, along with many others.

Subsequently we are developing a replacement for Region Tables called "Advanced Shipper" which we hope to release soon. (It's much more flexible than the Region Tables module and there'll be no need to mess with language defines any longer as the titles can be specified alongside the options for a region/method through the completely new admin system! :clap:)

Development is taking a lot longer than expected but we're aiming to release within the next week or so.

More info will be posted here as it becomes available! ;)

All the best...

Conor
Ceon

This is a really neat module!
For anyone that's using Australia Post I have attached a simple text document that breaks down all of the post codes available today into Australia Post Regions, v1, v2 etc. Hopefully this will save people some time

Just a slight fix for the function _regionMatchesRangeAU in the regiontables.php module

almost all postcodes in Australia are 4 digits in length, however there's two 3 digit ranges
800-909 and 200-221.

replace line 636 with

if (!ereg('(^[0-9][0-9][0-9][0-9])|(^[8-9][0-9][0-9])|(^[0-2][0-2][0-9])', $dest_postcode)) {

My regex foo is weak so I didnt get too fancy with it
it just checks if the number is between 800 and 999 as well as 200 and 229

Hi
I have installed this module and it works great, but, I am using it in weight mode but I also want to add a price threshold for free p&p, eg if they spend £50 or more they get free shipping.

I have the freeshipper module installed as well but it doen't seem to be picking it up.

Could anyone help?

Hello

My client wants to calc the shipping price based on the post code but also the number of products they order (they are large and require one pallet each). I've noted that this contrinbution allows for calculation on price and weight - but not quantity... is that right?

Andy