Multiple Domains and Websites

Configure Multiple Websites

Step 1: Add a new webshop in the Sana Commerce SQL database:

• Add a new webshop to the 'Websites' table: create a new record, enter the name and the default language for it.
• Create a new record in the 'Settings' table. After this you have two choices of filling the 'Fields' column: by creating a SQL scipt which will automatically fill it or by configuring the webshop settings using backoffice. If you choose the second option please read Step 5.
• Specify on which domain the webshop will run: you can do it either in the 'WebsiteDomains' table of the Sana SQL database or directly in the Sana Commerce backoffice > Settings > General > Website domains. For more information about webshop domains management in the Sana Commerce backoffice, see 'General Settings'.
• Specify the languages that should be available in the new webshop: open the 'WebsiteLanguages' table and create records for each language by entering the 'WebsiteId' of your webshop and the 'LanguageId' in the appropriate fields.

Step 2: Configure your webshop in the 'web.config' files of the backoffice and Starter Site:

• Add the new 'site' node to the 'sites' section in the 'sanaCommerce' configuration section (for a description of the 'site' node properties, please read this chapter).
• Set the 'defaultsite' attribute of the <sites> node to the default site. The 'defaultsite' attribute points to the webshop that is used by default when the backoffice is opened for the first time.
• Select providers from the <modules> section to work with your webshop. All providers are divided into five main subsystems; the description of each provider is stored in the 'description' attribute.

Step 3: Add the domain name of your webshop in IIS (please check the previous chapter for more details).

Step 4: Request a new license file for the new domain. Please read about requesting a license file here.

Step 5: Open the Sana Commerce backoffice and check if the new webshop appears in the list. For more information about configuring a webshop in the backoffice, please read this chapter.

The availability of each setting on the 'Settings -> General' page is configured in the 'WebsiteSettings' table in the Sana Commerce SQL database. If you want to show or hide a specific setting, open the table and set the 'configurable' attribute to 'false' or 'true', depending on whether or not the specified setting should be shown for the webshop in the backoffice.

Step 6: In the Sana Commerce backoffice create content and navigation for the new webshop. You can also reuse the content of the existing webshop using the 'Copy' functionality. More detailed information about webshop content and navigation can be found in the 'Content' section.

Step 7: To be able to process the orders in the newly added webshop the system payment methods and related countries must be configured in the database (On Account and Zero):

• Open the Sana Commerce SQL database.
• Locate the 'PaymentMethods' table and open it. Use the 'PaymentMethods' table to configure 'On Account' and 'Zero' system payment methods:
  
  
  System Payment Methods

This table provides the description of the required fields:

Step 8: Open the 'PaymentMethodCountries' table and specify which payment methods should be available for which countries.

If the 'CountryId' field for a payment method is 'NULL' then this payment method will be available for all countries.
If there is no record for a payment method in the 'PaymentMethodCountries' table then this payment method will not be available.

For more information about payments see additional resources:

• How to configure payment methods in the database see 'Configure Payment Methods'.
• About available external payment service providers see 'Add-ons and Modules'.
• How to configure external payment methods in the Sana Commerce backoffice see 'Payment Methods'.

Step 9: To be able to create shipping methods in the Sana Commerce backoffice for the newly added webshop, shipping providers should be added in the database:

• Open the Sana Commerce SQL database.
• Locate the 'ShippingProviderSettings' table and open it. Use the 'ShippingProviderSettings' table to add shipping providers:
  
  
  Shipping Providers

This table provides the description of the required fields:

This table provides the values of the available shipping provider types ('ProviderType' field) and related names ('Name' field):

'FedEx' shipping provider can be added only if FedEx add-on is already installed.

When the shipping providers are added to the 'ShippingProviderSettings' table of the Sana Commerce SQL database you can create shipping methods in the Sana Commerce backoffice.

For the detailed information about configuration of shipping providers and methods in the Sana Commerce backoffice, see 'Shipping Providers'.

Step 10: Configure the 'Customer indexing' task for the newly added webshop. This is needed to be able to create shop accounts for the new webshop. Open the 'web.config' file of the Sana Commerce backoffice and go to the <tasks> configuration section. Either remove the 'websiteId' attribute (by default websiteId="SanaStore") from the 'Customer indexing' task to make it available for all webshops or duplicate the 'Customer indexing' task that is already present in the 'web.config' file and change the value of the 'websiteId' attribute to the webshop ID for which you are configuring the 'Customer indexing' task. If you duplicate the task and specify the 'websiteId' of the newly added webshop, each webshop will have a separate 'Customer indexing' task.

If you are using Sana Commerce with scheduled interfaces, the scheduled tasks of the 'Scheduled interfaces' add-on should be configured per webshop. In this case you need to configure the 'Product import', 'Product stock and price import', 'Order export' and 'Order line import' tasks for the newly added webshop. Duplicate the mentioned tasks in the 'web.config' file of the Sana Commerce backoffice and configure them.