Developer Workstation Installation

Sana Commerce SQL Provider does not support multi-currency. For the SQL Provider webshop the default currency is determined in the SQL database.
Default currency: Euro

To change the default currency a SQL script should be executed on the Sana Commerce database:

Step 1: Before executing the script the following values should be set in the script:

DELETE FROM [dbo].[Currencies]
DECLARE @currencyId nvarchar(50)
DECLARE @currencyName nvarchar(50)
DECLARE @oldCurrencyId nvarchar(50)
DECLARE @siteId nvarchar(50)
SET @currencyId = '[currency id]' /* new currency ID*/
SET @currencyName = '[currency friendly name]'/* new currency friendly name */
SET @oldCurrencyId = '[current currency id]'/* current currency ID. case-sensitive. */
SET @siteId = '[site id]'/* ID of the site where currency should be changed */
INSERT INTO [dbo].[Currencies]
VALUES
   (@currencyId,
    @currencyName,
    NULL)
/* Next step should be performed for every site that uses Sql-provider*/
DECLARE @fields nvarchar(MAX)
SET @fields = CAST((SELECT Fields FROM [dbo].[Settings] WHERE Id=@siteId) as nvarchar(MAX))
SET @fields = REPLACE(@fields,
       '<field name="DefaultCurrency" type="System.String, mscorlib" storeWithEntity="False"><string>' + @oldCurrencyId + '</string></field>',
       '<field name="DefaultCurrency" type="System.String, mscorlib" storeWithEntity="False"><string>' + @currencyId + '</string></field>'
      )
UPDATE [dbo].[Settings]
SET Fields = CAST(@fields as xml)
WHERE Id=@siteId

You can also download the SQL script.

Step 2: When the values for the new currency are set, execute the SQL script on the Sana Commerce database.

Now the default currency is changed for the SQL Provider webshop.