Zone Rate For all international

[jennifer]

I am using the table rate for the US and the zone rate for all international countries. Is there a way to just say "international" or do I have to put all of the countries by ISO code into the zone box one by one?

[Christian Lescuyer]

As it is, I believe you have to put all countries in. But will you really ship everywhere?

 

Also, there is a 255 characters limit on the field, so you're effectively limited to about 80 countries.

 

It should not be too difficult to change the shipping module to have a default rate.

[jennifer]

I'll ship to a good majority of them......that stinks. There should be a better way to do that. :roll:

 

Thanks for your help. :D

[Christian Lescuyer]

Are you there yet?

 

One question: why do you use table for the US and zone for the rest of the world? Can't you use zone for both?

 

As for the zone module, it will load the country list, looking for the proper country:

        $countries_table = constant('MODULE_SHIPPING_ZONES_COUNTRIES_' . $i);

       $country_zones = split("[,]", $countries_table);

       if (in_array($dest_country, $country_zones)) {

         $dest_zone = $i;

         break;

       }

Try to remove the if clause and set the dest_zone to 1:

        $countries_table = constant('MODULE_SHIPPING_ZONES_COUNTRIES_' . $i);

       $country_zones = split("[,]", $countries_table);

       $dest_zone = 1;

[Paul_w]

Also, there is a 255 characters limit on the field, so you're effectively limited to about 80 countries.

 

Is there any reson other than possibly slowing things down slightly, why the database field cannot be changed to 'TEXT' from 'VARCHAR' so as to avoid the 255 character limit?

 

I have just done this and am now able to enter what I want within reason, ie. I have entered around 400 characters in some of my fields and all seems to work fine.....

[Christian Lescuyer]

...possibly slowing things down slightly...

 

Nearly all configuration variables are stored in the database, and all are read each time you get a page. Reading a TEXT field is considerably slower than a VARCHAR.

 

I would be interested in real impact measurement if you can (this involves logging).

 

Also, in this particular case, listing all 200+ countries in the world just to say "not here" is definitely not a good solution.