Install Sana Commerce Webshop on Web and Database Server

Open 'Install Sana Commerce Webshop on Web and Database Server' wizard, choose your solution and scenario to see more provider-related information.

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.Interfaces.dll' file from the 'bin' folder of the Interfaces add-on package to the 'bin' folder of the Sana Commerce backoffice.

Step 2: Execute the 'CreateStoredProcedures.sql' script, from the 'scripts' folder, 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"
title="Product import"
type="Sana.Commerce.Tasks.Import.ProductImportTask, Sana.Commerce.Tasks.Interfaces"
time="1:00am"
enabled="true"
sourceCustomerProviderId = "AXCustomerProvider"
sourceCatalogProviderId = "AXCatalogProvider"
sourceWebsiteCode = "B2xAX"
destinationWebsiteCode = "B2xSql"
importOnlyModified="true"
batchSize="100"
allowManualStart="true"
sortNumber="1"
/>
<task name="OrderExport"
   type="Sana.Commerce.Tasks.OrderExport.OrderExportTask, Sana.Commerce.Tasks.Interfaces"
   title="Order export"
   time="1:00am"
   enabled="true"
   sourceWebsiteCode = "B2xSql"
   destinationOrderProviderId = "AXOrderProvider"
   destinationCustomerProviderId = "AXCustomerProvider"
   batchSize="100"
   allowManualStart="true"
   sortNumber="2"
/>
<task name="ProductStockandPriceImportTask"
   type="Sana.Commerce.Tasks.Import.ProductStockandPriceImportTask, Sana.Commerce.Tasks.Interfaces"
   title="Product stock and price import"
   time="1:00am"
   enabled="true"
   sourceCustomerProviderId="AXCustomerProvider"
   sourceCatalogProviderId = "AXCatalogProvider"
   sourceWebsiteCode = "B2xAX"
   destinationWebsiteCode = "B2xSql"
   batchSize="100"
   importType="StockandPrice"
   allowManualStart="true"
   sortNumber="3"
/>
<task name="OrderLineImport"
   title="Order lines import"
   type="Sana.Commerce.Tasks.OrderLineImport.OrderLineImportTask, Sana.Commerce.Tasks.Interfaces"
   time="1:00am"
   enabled="false"
   sourceOrderProviderId = "AXOrderProvider"
   destinationWebsiteCode = "B2xSql"
   allowManualStart="true"
   sortNumber="4"
/>
</tasks>
  • Check the configuration nodes and specify the necessary values.

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

Step 4: Add 'Sana.Commerce.Tasks.Interfaces' 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.Interfaces" />
                  ………
      </session-factory>
</hibernate-configuration>

 

Microsoft Dynamics AX Configuration

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

Step 1: Open the Microsoft Dynamics AX client, select 'Webshop' in the left pane and open the 'Webshops' form.

Step 2: Select the webshop and switch to the 'Overview' tab. In the 'Ledger account' section you need to specify 'Shipping cost account' and 'Payment cost account'.

For more information please read this chapter.

Step 3: In the 'Identification' section you need to specify 'Template customer code' that will be used during the 'Product Import' and 'Product Stock and Price Import' processes. 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 and site configured for this customer.

The 'Prices incl. sales tax' option on the customer's form must be enabled, since the Commerce Provider webshop, where the products will be imported in, only supports the B2C scenario.