[SOLVED] How to add Australian States?

[deepee]

Hi

I only sell within Australia and have configured this as my default country, unticking all others.
I have set Oceania as the only Zone and Australia is the only country in the zone.

I'm trying to add Australian States in Back Office >> Shipping >> States
There are no states in the list.
When I click "Add New" it opens the "States" form.
I can type an entry into the "Name" and "ISO Code" fields.
The only drop down option in the "Zone" field is "Oceania"

However "USA" in the pre-filled entry in the "Country" field and when I click the drop down list button, there are no other options displayed.

I left the "Country" field as "USA", added "QLD" in the "States" field and saved it but it has had no effect.

Any pointers would be greatly appreciated.

Thanks
Deepee

[deepee]

I've searched the forums again for a solution to this but have drawn a blank.

I've also renamed the thread header to be more specific.

Can anyone help?

Thanks
Deepee

[rocky]

You need to go to Shipping > Countries, edit Australia, then change "Contains States" to "Yes", then Australia will become an option in the Country field when adding states.

[deepee]

Thanks, Rocky.
I couldn't see it for looking at it!
:red:

[jeremy]

it would be nice if the states could be in the install database so we didnt have to add these every time we setup a site. and the gst.

[rocky]

You can edit install/sql/db_settings_lite.sql and add this information so that it is automatically installed. For example, add the following to include the Australian States:

INSERT INTO `PREFIX_state` (`id_country`, `id_zone`, `name`, `iso_code`, `active`) VALUES
(24, 5, 'Australian Capital Territory', 'ACT', 1),
(24, 5, 'New South Wales', 'NSW', 1),
(24, 5, 'Northern Territory', 'NT', 1),
(24, 5, 'Queensland', 'QLD', 1),
(24, 5, 'South Australia', 'SA', 1),
(24, 5, 'Tasmania', 'TAS', 1),
(24, 5, 'Victoria', 'VIC', 1),
(24, 5, 'Western Australia', 'WA', 1);

For the tax, you'll need to edit the following section:

INSERT INTO `PREFIX_tax` (`id_tax`, `rate`) VALUES (1, 19.6),(2, 5.5),(3, 17.5);

INSERT INTO `PREFIX_tax_lang` (`id_tax`, `id_lang`, `name`) VALUES
(1, 1, 'VAT 19.6%'),(1, 2, 'TVA 19.6%'),(1, 3, 'IVA 19.6%'),
(2, 1, 'VAT 5.5%'),(2, 2, 'TVA 5.5%'),(2, 3, 'IVA 5.5%'),
(3, 1, 'VAT 17.5%'),(3, 2, 'TVA UK 17.5%'),(3, 3, 'IVA UK 17.5%');

INSERT INTO `PREFIX_tax_zone` (`id_tax`, `id_zone`) VALUES
(1, 1),
(2, 1);

To add GST, you could change it to:

INSERT INTO `PREFIX_tax` (`id_tax`, `rate`) VALUES (1, 19.6),(2, 5.5),(3, 17.5),(4, 10);

INSERT INTO `PREFIX_tax_lang` (`id_tax`, `id_lang`, `name`) VALUES
(1, 1, 'VAT 19.6%'),(1, 2, 'TVA 19.6%'),(1, 3, 'IVA 19.6%'),
(2, 1, 'VAT 5.5%'),(2, 2, 'TVA 5.5%'),(2, 3, 'IVA 5.5%'),
(3, 1, 'VAT 17.5%'),(3, 2, 'TVA UK 17.5%'),(3, 3, 'IVA UK 17.5%'),
(4, 1, 'GST 10%'),(4,2,'GST 10%'),(4,3,'GST 10%');

INSERT INTO `PREFIX_tax_zone` (`id_tax`, `id_zone`) VALUES
(1, 1),
(2, 1),
(4, 5);

This will add a GST 10% tax in the Oceania zone. You could also delete the VAT taxes if you wanted, but the default products rely on them.

[conniedesign]

HI Rocky,

I have set up the names of Countries by 'Add New' from Shipping Tab.

I wanted to remove/delete created countries 'Australia_Zone' that I made, but it didn't displayed on the listed Countries from Shipping Tab?

Therefore when the customer when to update their address in their account, it appeared the words on the countries dropped down lists. Above is the screen shots, can I know how to remove the 'Australia_zone'.

Thank you

Connie

[rocky]

Go to the Shipping > Countries tab, look for "Australia_zone", then click the tick in the "Enabled" column to disable the country.

[conniedesign]

Hi Rocky,

Thank you for your reply.

I have enabled the country 'Australia_Zone', it worked.

Follow the same step. I have tried to find and delete the 'Australia States' on the listed Countries, but there wasn't a name there on the column.

Somehow it displayed on the 'Countries Options', how can I delete the word 'Australia States'.

I have attached a screen shots and hopefully it will explained well.

Thanks
Connie

[TiaNex Shopping]

thank you,it solved my problem