Countries

For each country you do business with, you must create a corresponding country on your solution.

You can then select the country as the default country on the Ecommerce settings of a website.

Countries in Dynamicweb Ecommerce are used to:

  • Control which countries  and regions can be selected as billing and delivery countries
  • Anchor shipping methods and payment methods to a particular country – and preselecting default shipping and billing methods
  • Setting the system VAT rate

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 (Figure 1.1)
Figure 1.1 Adding a new country to your solution

A new country is created with the basic information already filled out, except the system VAT rate.

Under Default methods (Figure 1.2) you can select a default payment method and shipping method for the country.

They will be preselected in the shopping cart when the user checks out in the relevant country-context.

If none are available for selection, you need to create them and select them for the country (or All Countries). Switch between language contexts to access the methods created under a non-default language.

Figure 1.2 Selecting the default payment & shipping methods for a country - don't forget to switch to the appropriate language context

Under Region/States (Figure 1.3), 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.

Figure 1.3 Creating regions or states for a country

When you’ve created the languages, countries and currencies necessary for your setup, make sure you set a default country, language and currency on each website or language layer. Not doing so is one of the most common sources of WTFs in Dynamicweb.

Dynamicweb supports a number of query string operations for manipulating the internationalization settings:

Parameter Effect
CountryCode=US Switches the country context to US

 

Database

These are the database tables related to internationaliation in Dynamicweb:

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 10
CountryRegionCode nvarchar 3

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