Assigning Countries to Continents and creating Regions for Shipping Calculations

For continental shipping calculations we can assign countries to specific continents or country groups and create sub regions within a country.

Assign Country to Continent

  1. Get country ID from wp_wpsc_currency_list table for region creation below
  2. In the same table you can assign any country to a continent or country group

Create Regions for a Country

  1. Using table wp_wpsc_region_tax 
  2. Add rows to create new regions for the country whose ID you acquired above
id country_id name code tax
 64  156 North Island  NI  12.5
 65 156  South Island SI  12.5

More details from the original author here:

http://www.leewillis.co.uk/region-based-shipping-wp-e-commerce/