Defining shipping zones in the negative

[Hak Foo]

This isn't strictly an osCommerce problem, since I'm using 'Ecommerce Shopping Cart Software', which is an osCommerce derivative which seemed to work better with PHP5, but whose developers disappeared shortly after I set it up.

 

Basically, I've got a shipping condition as follows:

 

Continental US: 19.95 flat rate

 

Everywhere Else: 99.95.

 

I was able to make a continental US zone by adding the 48 states and DC to a zone, and then setting up flat rate shipping for that zone.

 

The problem is how to make a "rest of world" zone without monster hassle.

 

Right now I have it set up as "weight based shipping", with weight up to 500lbs for 99.95 (since the items all have no weight data, this means effectively infinite items).

 

The problem is that it shows both the 19.95 and 99.95 for continental US customers. I could add a rest-of-world zone and make the "weight based" shipping apply to just that zone, but it seems like that means adding hundreds of regions one by one.

 

Is there a simpler way to say "shipping to elsewhere is 99.95?"

[Hak Foo]

I was able to get it working using the ready-made "Rest of world" query from the contributions table, then adding the minor US territories and Alaska and Hawaii... major time saver.

 

One thing I did notice:

 

I made a test customer with an obviously fake address that ends in Northwest Territories, United States.

 

He's offered NEITHER shipping option. What concerns me is if people will not be told the shipping cost to "Navada" or "Arizone" and believe they'll get free shipping... I'd guess the addresses will be flagged as bogus and the orders rejected, but are there safer "catch-all" methods?