Countries
Countries in Dynamicweb Ecommerce are used to:
- Control which countries and regions can be selected as billing and delivery countries during checkout
- Anchor shipping methods and payment methods to a particular country – and preselecting default shipping and billing methods
- Setting the VAT rate for a country
To add a new country to your solution:
- Go to Settings > Ecommerce > Internationalization > Countries
- Click New Country in the toolbar to open the country selector and add a country
- Fill in the parameters
- Save
A new country is created with the basic information under Settings already filled out, except the VAT-related settings.
Frontend Address Formats
For each country, you can define frontend address formats – formats which control how address fields are shown in frontend. You can customize both the address display format and the address edit format. The display format is meant to be used when displaying an address, and the edit format when using a form to edit an address from frontend.
In frontend, can then use our API to fetch and render addresses using the approproate format – typically this will be in a shopping cart template.
Region/States
Under Region/States (Figure 3.1), you can add regions/states to the country.
This allows your users to select states and regions, in addition to the country, when specifying their delivery and billing addresses during checkout – and is also used for e.g. address validation services and the Avalara AvaTax provider when calculating taxes.
Default Methods
EcomCountries
Contains countries defined in Settings -> Ecom -> Internationalization -> Countries.
Field name | Data type | Length | |
---|---|---|---|
CountryCode2 | nchar | 2 | |
CountryCode3 | nvarchar | 3 | |
CountryCurrencyCode | nvarchar | 3 | |
CountryNumber | nvarchar | 4 | |
CountryVAT | float | 8 | |
CountryCultureInfo | nvarchar | 15 | |
CountryRegionCode | nvarchar | 3 | |
CountryAddressDisplayFormatMode | int | 4 | |
CountryAddressDisplayFormat | nvarchar | Max | |
CountryAddressEditFormatMode | int | 4 | |
CountryAddressEditFormat | nvarchar | Max | |
CountryReverseChargeForVAT | bit | 1 | |
CountryVatPostingGroup | nvarchar | 20 |
EcomCountryText
Defines what languages (CountryTextLanguageID) a country is translated for (CountryTextCode2).
Field name | Data type | Length | |
---|---|---|---|
CountryTextCode2 | nchar | 2 | |
CountryTextLanguageId | nvarchar | 50 | |
CountryTextName | nvarchar | 255 | |
CountryTextRegionCode | nvarchar | 3 | |
CountryTextAutoId | int | 4 |
EcomGlobalIso
System lookup table for internationalization ISO data.
Field name | Data type | Length | |
---|---|---|---|
IsoId | int | 4 | |
IsoCode2 | nchar | 2 | |
IsoCode3 | nvarchar | 3 | |
IsoCountryNameDK | nvarchar | 255 | |
IsoCountryNameUK | nvarchar | 255 | |
IsoCurrencyCode | int | 4 | |
IsoCurrencySymbol | nvarchar | 255 | |
IsoVat | float | 8 | |
IsoCultureInfo | nvarchar | 50 | |
IsoDisabled | bit | 1 |
EcomMethodCountryRelation
Keeps track of for which countries (MethodCountryRelCountryID) a given translation (MethodCountryRelLanguageID) of a payment- or shipping method (MethodCountryRelMethodID) is available.
Field name | Data type | Length | |
---|---|---|---|
MethodCountryRelCode2 | nvarchar | 50 | |
MethodCountryRelMethodType | nvarchar | 50 | |
MethodCountryRelCountryId | nvarchar | 50 | |
MethodCountryRelMethodId | nvarchar | 50 | |
MethodCountryRelLanguageId | nvarchar | 50 | |
MethodCountryRelIsDefault | bit | 1 | |
MethodCountryRelRegionCode | nvarchar | 3 | |
MethodCountryRelAutoId | int | 4 |