Single Server Deployment

Configure the Countries

This chapter is for the SQL Provider only.

During the registration process in the webshop a customer has to specify the country of residence. The 'Country' dropdown is also available on the 'Your details', 'Prospect details' pages and on the second step of the checkout process, when a customer needs to specify the address the order should be delivered to.

To add a new country to make it available in the 'Country' dropdown on the Starter Site a SQL script should be executed on the Sana Commerce database:

• Before executing the script the following values should be set in the script:
  
  

  Value	Description
  countryId	The ID of the country which should be available in the 'Country' dropdown on the Starter Site.
  countryName	The name of the country which should be available in the 'Country' dropdown on the Starter Site.

DECLARE @countryId nvarchar(50)
DECLARE @countryName nvarchar(MAX)
SET @countryId = '[coutry id]'
SET @countryName = '[country name]'
INSERT INTO [dbo].[Countries]
VALUES 
   (@countryId, 
    1, /* 1 - visible, 0 - invisible */
    CAST('<FieldsDictionary><field name="Name" type="System.String, mscorlib"><string>' + @countryName + '</string></field></FieldsDictionary>' as xml)
   ) 

• When the values for the new country are set, execute the SQL script on the Sana Commerce database.

Now the country is added to the database and available in the 'Country' dropdown on the Starter Site.

The countries can be configured in the 'Countries' table in the Sana Commerce SQL database. The 'True' value in the 'Visible' column must be set for the countries which should be available on the Starter Site in the 'Country' dropdown.

By default all added countries are visible.

The 'Countries' Table