This tab is used if a country is split into several zones. You will need a zone list to determine the prices in different areas. This is usually provided with the price sheet, but in case it isn't, you can contact the carrier and ask for it.

Zone and Country_ISOA2 columns

The Zone and Country_ISOA2 columns work the same way they do in the Zones-CountryList tab. The "Zone" is the name of the zone which will be referenced later, so it should be something that makes sense, for example Zone_Home for the warehouse address, ZoneDK_01, ZoneDK_02 for Zones 1 and 2 in Denmark and so on.

ISOA2 is the country code of the relevant country. DK for Denmark, DE for Germany and so on. 

A zone can contain several postcode intervals.

ValueFrom and ValueTo

ValueFrom and ValueTo can be used to reference a postcode interval, for example, 1000-2000. If the zone is not an interval, but a specific postcode such as 1234, you simply input 1234 in both ValueFrom and ValueTo. Notice that you cannot have the same postcode, in the same country represented twice. This will cause the price service lookup to fail and output an error.

ValueFormat

ValueFormat refers to the format of the postcode. If the postcode in a zone is 1000, it can be defined as having 4 numerals, which means the ValueFormat is NNNN. If a postcode contains letters, they can be defined as Alphanumerical and must be written as A in the FormatValue. Some postcodes are a combination of letters (Alphanumericals) and numbers (numericals). The ValueFormat can be any combination of letters, numbers, spaces, and certain special characters such as or -. See example 1.

Example 1:

Postcodes in the UK

Postcodes in the United Kingdom are a bit different than most other countries, therefore there is a special ValueFormat called "uk_short" which can be used. UK postcodes usually start with 1 or 2 letters followed by a number. Example 2 shows a postcode interval in UK using the special format.

Example 2:


EliminateSpaces should always be true. It will make sure that a postcode can be inputted both with or without spaces in production.