Something I learned which I thought I might as well share with the Universe.
If you want to create different shipping costs for different parts of a country,
the Magento option you need to set up is called "Table Rate Shipping" in
the Configuration area, under Shipping Methods.
There is a article in the Magento Knowledge Base which describes most of it pretty well here:
http://www.magentocommerce.com/knowl...rate-shipping/
In a nutshell, you can export as CSV, enter your new values, then import it and save the configuration.
HOWEVER
The default countries/regions in the database are only the USA and its 50 states plus what looks like a bunch of other random crap.
If you try to upload your CSV file with any other country/region combinations, you'll get Magento spitting a bunch of rude red reject
messages.
So if you want to create Table Rate Shipping for any other country, you are going to have to roll up the sleeves,
crack open the Magento database with myPHPadmin, and manually insert some records.
There are only two tables you need to worry about
directory_country_region
directory_country_region_name
directory_country_region has 4 fields
* region_id (the next incremental record number in the table)
* country_id (it should be a 2 letter code, eg if your locale is ja_JP, the code you want to use is the second part "JP")
* code (this can be anything you like and should be a unique identifier for the state, province, region whatever. It's not viewable by the end user)
* default_name ( The actual name of the state, region etc for example "Okinawa")
directory_country_region_name has 3 fields
* locale (en_US, or ja_JP etc, NOTE: I just used the en_US locale because I didnt need translated location names.
Didn't research how to add different translations of place names but you might be able to do it through the translation CSV files [not to be confused with the Table Shipping CSV files])
* region_id (must match the field in the other table, above)
* name (same as the field in the table above. Not sure which table is actually drawn upon for the user display)
So enter your new country/region combinations in these fields.
DONT forget to flush the system cache through the site Admin panel.
THEN you can upload your Table Rate CSV file and you should get a happy green success message.
That's it!
