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 AX

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"
     title="Product stock and price import"
     type="Sana.Commerce.Tasks.Import.ProductStockandPriceImportTask, Sana.Commerce.Tasks.ProductImport"
     time="4:00am"
     enabled="false"
     sourceCustomerProviderId="AXCustomerProvider"
     sourceCatalogProviderId="AXCatalogProvider"
     destinationWebsiteCode="B2xSql"
     sourceWebsiteCode="B2xAX"
     batchSize="10"
     importType="StockandPrice"
     allowManualStart="true"
     sortNumber="3"/>

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

Configuration nodes Description
time/interval The daily time or period (in seconds) when the 'Product Import' task should be performed.
For more information read this chapter.
sourceCustomerProviderId The identifier of the Customer provider, which is used to get a B2C Template Customer from AX. It is selected from the <sanaCommerce> configuration section, <modules> subsection of the 'web.config' file.
sourceCatalogProviderId The identifier of the Catalog provider, which is selected as the source for the product stock and price data. It is selected from the <sanaCommerce> configuration section, <modules> subsection of the 'web.config' file.
destinationWebsiteCode The code of the webshop to which the stock and price import is performed. It is selected from the <sanaCommerce> configuration section, <sites> subsection of the 'web.config' file.
sourceWebsiteCode The webshop from which the product stock and price import will be performed. It is selected from the <sanaCommerce> configuration section, <sites> subsection of the 'web.config' file.
batchSize The amount of products which are handled in one batch.
importType The parameter which 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 The parameter which specifies that the task can be started manually in the backoffice.
Default value: 'true'
sortNumber The sort order in which the scheduled tasks are arranged in the backoffice.

 

All configuration nodes are required parameters and should be filled in.


 

When the product price is imported it always includes TAX.

The 'Prices incl. sales tax' setting on the 'Customers' form in MS Dynamics AX does not have any influence on price which is imported.

Add-ons and ModulesProduct Stock and Price Import