Install Sana Commerce Webshop on Web and Database Server

Interfaces Add-on Installation

Installation of Interfaces Add-on for Sana Commerce is the same for SDK and the 'Ready to deploy' version. In order to install Interfaces Add-on for Sana Commerce follow these steps:

Step 1: Copy the 'Sana.Commerce.Tasks.OrderExport.dll' and 'Sana.Commerce.Tasks.ProductImport.dll' files to the 'bin' folder of the Sana Commerce backoffice. The 'Order Line Import' task is available in 'Sana.Commerce.Tasks.OrderExport.dll'. The 'Product Stock and Price Import' task is available in 'Sana.Commerce.Tasks.ProductImport.dll'.

Step 2: Run the 'CreateStoredProcedures.sql' script on your database. It will create the stored procedures that are needed for the correct work of the 'Product Import', 'Order Export' and 'Product Stock and Price Import' tasks.

Step 3: Configure the 'Product Import', 'Order Export', 'Product Stock and Price Import' and 'Order Line Import' tasks. This configuration is performed in the backoffice 'web.config' file:

• Locate the 'Interfaces configuration section.txt' file, which contains the tasks configuration sections;
• Copy the whole text of this file into the <tasks> section of the 'web.config' file, so it will look as follows:
  
  

  Make sure to paste the contents of the 'Interfaces configuration section.txt' file just at the end of the <tasks> section and do not delete the existing tasks.

<tasks taskContentConnectionStringName="LocalSqlServer">
<task name="ProductImport"
         type="Sana.Commerce.Tasks.Import.ProductImportTask, Sana.Commerce.Tasks.ProductImport"
         time="13:33"
         enabled="true"
         sourceCustomerProviderId = "NavisionFashionCustomerProvider"
         sourceCatalogProviderId = "NavisionFashionCatalogProvider"
         destinationWebsiteCode = "B2xSql"
         sourceWebsiteCode = "B2xNav2009Standard"
         importOnlyModified="true"
         batchSize="10"
         horizontalVariantComponentGroupCode="Size"
         horizontalVariantComponentGroupTitle="size"
         verticalVariantComponentGroupCode="Color"
         verticalVariantComponentGroupTitle="color"
         normalVariantComponentGroupCode="Variant"
         normalVariantComponentGroupTitle="variant"
         allowManualStart="true"
         sortNumber="1"
/>

<task name="OrderExport"
          title="Order export"
          type="Sana.Commerce.Tasks.OrderExport.OrderExport, Sana.Commerce.Tasks.OrderExport"
          time="4:00am"
          enabled="false"
          sourceWebsiteCode = "B2xSql"
          destinationOrderProviderId = "NavisionStandardOrderProvider"
          destinationCustomerProviderId = "NavisionStandardCustomerProvider"
          batchSize="100"
          allowManualStart="true"
          sortNumber="6"
/>

<task name="ProductStockandPriceImportTask"
          type="Sana.Commerce.Tasks.ProductStockandPriceImport.ProductStockandPriceImportTask, Sana.Commerce.Tasks.ProductStockandPriceImport"
          time="4:00am"
          enabled="true"
          sourceCustomerProviderId="Navision2009StandardCustomerProvider"
          sourceCatalogProviderId = "Navision2009StandardCatalogProvider"
          destinationWebsiteCode = "B2xSql"
          sourceWebsiteCode = "B2xNav2009Standard"
          batchSize="10"
          importType="StockandPrice"
          allowManualStart="true"
/>

<task name="OrderLineImport"
          title="Order lines import"
          type="Sana.Commerce.Tasks.OrderLineImport.OrderLineImportTask, Sana.Commerce.Tasks.OrderExport"
          time="9:00am"
          enabled="false"
          sourceOrderProviderId = "Navision2009StandardOrderProvider"
          destinationWebsiteCode = "B2xSql"     
          allowManualStart="true"
          sortNumber="7"
/>
</tasks>

For more information about the tasks configuration please read the 'Add-ons and Modules' section.

Step 4: Add 'Sana.Commerce.Tasks.ProductImport' assembly mapping to the <hibernate-configuration> section in the 'web.config' file:

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
       <session-factory>
                  ………
                  <mapping assembly="Sana.Commerce.Tasks.ProductImport" />
                  ………
      </session-factory>
</hibernate-configuration>

Microsoft Dynamics NAV Configuration

Configure Microsoft Dynamics NAV for the 'Product Import', 'Order Export', 'Product Stock and Price Import' and 'Order Line Import' tasks:

Step 1: Open the Microsoft Dynamics NAV client, select 'Webshop' in the left pane and open 'Webshop Card'.

Step 2: In the 'Online Shipment' section you need to specify the type of the sales line representing the 'Shipping Cost' with its object identifier and the same for the 'Payment Cost' in the 'Online Payment' section. For more information please read this chapter.

Step 3: Specify Template Customer No. that will be used during the 'Product Import' and 'Product Stock and Price Import'. The product prices imported to the Commerce Provider webshop will be based on the specific prices for this customer. The same goes for the stock amount of the products which will be based on the warehouse configured for this customer.

The 'Prices Including VAT' option on the customer card must be enabled, since the Commerce Provider webshop, where the products will be imported in, only supports the B2C scenario.