Countries

Countries and regions specified in Aurora will be available to customers for selection when choosing where to ship their order. Each country can be customised, including individual tax rates, languages and their own postcode validation.

This article covers the basics.

Introduction

This series of articles cover the configuration of Countries and Regions in Aurora for use with order Shipping. It makes use of a Postcode Matching system which permits a country to be 'sliced up' into regions for allocating differing shipping costs within a single country. This can also be used, in a limited fashion, to prevent offshore shipping addresses being mistaken as UK addresses.

You may run into problems when creating countries in Aurora if you require two different regions to be created with the same ISO2 code. For example, the ISO2 code for both Northern Ireland and the UK Mainland is considered as GB, but they may require you to have different shipping costs. It is here that the Postcode Matching system can be used to denote which postcodes should be considered within Northern Ireland and UK Mainland.

Managing Countries

The countries page can be found by navigating to Orders > Shipping > Countries.

You'll be presented with a list of countries that are already set up on your store:

Countries can be managed just like other items in Aurora.

ItemDescription
EnabledEnable or disable the respective country. If enabled, the country will appear on your store for customers to select.

The icon displayed at any time represents the current status of the country.
Country NameThe name of the country. This will be displayed to customers.
ISO2 ISO3 ISO3166These fields specify the various ISO codes for each respective country.

Please see the wikipedia article on ISO Country Codes for more information.
Calling CodeThe calling code for the country.

The use of this field will be determined by your front end templates. For example, this could be used for customising telephone numbers.
ZoneThe zone in which the country resides.

Please see the Zones support article for more information.
OrderUse this field to specify the order that countries will appear when in lists on your stores front end. Values left as "0" will be sorted alphabetically. You can also drag and drop rows to re order them.

For example, this could allow you to set commonly used countries with a value of "1", "2" and "3", with the remaining countries left as "0".

This will ensure that these countries are always displayed at the top of lists, with the remaining countries listed below in alphabetical order.
Product TaxEnable or disable product tax for the respective country.

If enabled, more information regarding the countries tax bands can be specified when editing that specific country.

The icon displayed at any time represents the current tax status of the country.
Shipping TaxSpecifies the % shipping tax assigned to the respective country.
EditEdit the respective country.
DeleteDelete the respective country.

Testing Postcode Matching

You can test your Country to Postcode configurations by using the Postcode Search box at the top of the page. Enter the postcode you would like to search with and wait a few moments. Aurora will then search using the Postcode Matching settings you have already configured, and return the countries it believes match the postcode provided.

To find out more about postcode matching, see the Postcode Matching article.

Uploading and Downloading Countries in Bulk

If you would like to make changes to, or add a large number of countries, you may wish to upload these in a CSV file. You also have the option to download a CSV file of the existing countries already set up, to use as a basis for your amendments and additions.

Downloading Countries

From the Upload/Download Countries tab, use the Download CSV link to download a CSV file of all countries already set up. This file will be in the format required for uploads by Aurora.

Uploading Countries

Using the CSV file that has been downloaded, you're free to make any alterations and additions, uploading the file once finished. When making alterations to existing countries, take care not to edit the ID column.

FieldColumnDescriptionExample Value
IDAUnique ID assigned to the country.1
EnabledBSpecifies if the country is enabled or not.

1 = Enabled
0 = Disabled
1
Default CountryCSpecifies if the country is the system default.

1 = Default
0 = Not Default
0
Country NameDName of the country.Austria
ISO2EThe ISO2 country identifier.at
ISO3FThe ISO3 country identifier.aut
ISO3166GThe ISO3166 country identifier.ISO 3166-2:AT
Calling CodeHThe calling code for the country.43
Allow DeliveryISpecifies if customers are allowed to select the country for delivery.

1 = Allowed
0 = Not Allowed
1
ZoneJThe zone in which the country resides, for shipping purposes.Europe
Product TaxKEnable or disable product tax for a specific country.

1 = Enabled
0 = Disabled
1
Shipping TaxLSpecify the shipping tax rate for the country.20
Country OrderMSpecify the position the country will display in lists of countries in your stores front end.

0 = Alphabetical
>0 = Manual
0
Default CurrencyNSpecify the default currency for the country.EUR
Default LanguageOSpecify the default language for the country.de
Postcode CompulsoryPSpecify if a postcode entry is compulsory on checkout.

1 = Required
0 = Not Required
0
Customer Customs InformationQInformation relating to customs that will display when this country is selected.Orders shipped to this country may be subject to further tax.

Tax Band Rates and Codes

In addition to this, all defined Tax Bands within Aurora will be represented within the Download/Upload CSV file in the following format:

FieldColumnDescriptionExample Value
Tax Band A Tax RateRThe tax rate to be used when an order qualifies for the respective tax band.20.00
Tax Band A Tax CodeSThe tax code to be used when an order qualifies for the respective tax band.UKA20
Tax Band B Tax RateTThe tax rate to be used when an order qualifies for the respective tax band.15.00
Tax Band B Tax CodeUThe tax code to be used when an order qualifies for the respective tax band.UKB20

Example CSV File

aurora_countries.csv