Add-ons and ModulesProduct Stock and Price Import

Product Stock and Price Import

Sana Commerce 8.1
Your provider

Configure Product Stock and Price Import for NAV

The 'Product Stock and Price Import' functionality uses the Sana Commerce task scheduler. You can read more about it in this chapter.
 
The configuration of the Product Stock and Price Import task is performed in the 'sanaCommerce' configuration section of the backoffice web.config file.
 
To configure the Product Stock and Price Import task:

Step 1: Open the backoffice web.config file.

Step 2: Locate the 'sanaCommerce' configuration section.

Step 3: Locate the 'tasks' subsection:

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

Step 4: Check the following configuration nodes and change them if needed:

time/interval: the daily time or period (in seconds) when the 'Product Stock and Price Import' task should be performed;
For more information read this chapter.
sourceCustomerProviderId: Identifier of the Customer provider, which is used to get a B2C Template Customer from NAV. It is selected from the 'Sana Commerce - Modules' configuration section of the web.config;
sourceCatalogProviderId: Identifier of the Catalog provider, which is used as the source for the product price and stock data. It is selected from the 'Sana Commerce - Modules' configuration section of the web.config;
destinationWebsiteCode: the code of the webshop to which the stock and price import is performed. It is selected from the 'Sana Commerce - Sites' configuration section of the web.config;
sourceWebsiteCode: the webshop from which the product stock and price import will be performed. It is selected from the 'Sana Commerce - Sites' configuration section of the 'web.config' file;
batchSize: the amount of products which are handled in one batch;
importType: this parameter specifies what type of data is imported: 'Stock', 'Price', or 'StockandPrice'. It determines which data (stock and price) will be updated by the import;
allowManualStart: this parameter is 'true' by default and it specifies that the task can be started manually in the backoffice.

All configuration nodes are required parameters and should be filled in to prevent any problems.

When product price is imported it always includes VAT.
 
The 'Price Including VAT' setting on 'Customer' card in MS Dynamics NAV doesn't have any influence on price which is imported.
Add-ons and ModulesProduct Stock and Price Import