Australian zone and tax settings

You can plug all the default zone and tax settings through the Admin but there’s an easier way. The sql snippets below can be run through phpMyAdmin which you can usually access through cPanel. Once in phpmyadmin, select the database you want to update and click on the Sql tab at the top of the page. Copy n paste the code below then Go. Once done, your Australian store will have all the tax and zone information needed for using various shipping and payment modules.

Note – the sqls below are for a store that is missing the data. Check your admin for these settings already (eg under Localizations >> Currencies for AUD; under Locations/Taxes >> Zones for Australian states. There’s no point readding them if they already exist.)

Australian Zones (States)

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'NSW','New South Wales');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'VIC','Victoria');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'QLD','Queensland');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'NT','Northern Territory');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'WA','Western Australia');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'SA','South Australia');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'TAS','Tasmania');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',13,'ACT','Australian Capital Territory');

Australia GST Setup

update tax_class set tax_class_title="GST" where tax_class_title = "Taxable Goods";
update tax_class set tax_class_description="The following types of products attract GST in Australia" where tax_class_title = "GST";
update tax_rates set tax_description = "GST" where tax_description = "FL TAX 7.0%";
update tax_rates set tax_rate = "10" where tax_description = "GST";

Australia Currency Setup

update currencies set code = "AUD" where code = "USD";
update currencies set title = "Australian Dollar" where code = "AUD";
update configuration set configuration_value = "AUD" where configuration_key = "DEFAULT_CURRENCY";
update configuration set configuration_value = "true" where configuration_key = "DISPLAY_PRICE_WITH_TAX";

Australia Tax Geo Zone Setup

insert into `geo_zones` (`geo_zone_id`,`geo_zone_name`,`geo_zone_description`) values (1,'Australia','');
insert into zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id)
select countries_id as zone_country_id, 0 as zone_id, geo_zone_id
   from countries, geo_zones
   where countries_name = "Australia"
   and geo_zone_name = "Australia";