Knowledge BaseField Mapping between Sana Commerce and NAV

Field Mapping between Sana Commerce and NAV

Back Next

Product Import

The data which is retrieved from NAV and stored in the Sana Commerce SQL database for each entity of the product import process is listed in the tables below.
For more information about the product import read this chapter.

IProduct

NAV field	Sana Commerce property	Sana Commerce SQL datamodel
'Item'.'Blocked'	Blocked	XML field
'Comment Line'.'Comment'	Comment	-
'Item'.'Description'	Title	'Product'.'Title'
The combination of 'Item'.'Item Category Code' and 'Item'.'Product Group Code' separated by '__'	CategoryId	'Product'.'CategoryId'
'Item'.'No.'	Code	'Product'.'Id'
This field is stored in the 'Extended Text Line' table. For more information about the product description read in this chapter.	Description	'ProductEnrichments'. 'Description'
'Item'.'No.'	Id	'Product'.'Id'
Calculated field	Inventory	'Product'.'Inventory'
Calculated field	IsOrderable	-
Calculated field	ListPrice	XML field
Calculated field	Price	XML field
-	PriceInclVat	Always set to true
The collection of the related products from the 'Item Substitution' table. For more information read this chapter.	RelatedProducts	The 'RelatedProduct' table
The collection of the variants from the 'Variant' table	Variants	The 'ProductVariant' table
'Item'.'VAT Prod. Posting Group'	VatRateId	'Product'.'VatRateId'
'Item'.'Visible in Webshop'	Visible	'Product'.'Visible'

IRelatedProduct

Other 'IRelatedProduct' fields are given in the table above.

NAV field	Sana Commerce property	Sana Commerce SQL datamodel
'Item Substitution'.'PfsSorting' (PFS add-on) 'Item Substitution'.'Sort No.' (NAV Standard)	Sorting	'RelatedProduct'.'Sorting'
'Item Substitution'.'Relation Type'	RelationType	'RelatedProduct'.'RelationType'

IProductVariant

NAV field	Sana Commerce property	Sana Commerce SQL datamodel
'Item Variant'.'Code'	Id	'ProductVariant'.'Id'
'Item Variant'.'Code'	Code	'ProductVariant'.'Id'
Retrieves by the language code	Title	'VariantComponent'.'Name'
'Item Variant'.'PfsItem Status' (PFS add-on)	Status	-
'Item Variant'.'Item No.'	ProductId	'ProductVariant'.'ProductId'
'Item Variant'.'PfsSorting' (PFS add-on)	SortId	XML field
Calculated field	Inventory	'ProductVariant'.'Inventory'
Calculated field	IsOrderable	-
Calculated field	Price	XML field
Calculated field	ListPrice	XML field

IProductMatrixVariant (PFS Only)

Other 'IProductMatrixVariant (PFS Only)' fields are given in the table above.

NAV field	Sana Commerce property	Sana Commerce SQL datamodel
'PfsItem Horz Component'.'Code' (corresponds to the value of 'Item Variant'.'PfsHorizontal Component')	HorizontalId	'ProductVariant'. 'Component1Id'
'PfsItem Vert Component'. 'Code' (corresponds to the value of 'Item Variant'.'PfsVertical Component')	VerticalId	'ProductVariant'. 'Component2Id'
Calculated field	HorizontalText	'VariantComponentTranslation'. 'Name' If does not exist then it will be stored in 'VariantComponent'.'Name'
Calculated field	VerticalText	'VariantComponentTranslation'.'Name' If does not exist then it will be stored in 'VariantComponent'. 'Name'
'PfsItem Horz Component'.'Sorting'	Component1SortId	XML field of the 'VariantComponent' table
'PfsItem Vert Component'.'Sorting'	Component2SortId	XML field of the 'VariantComponent' table

IbomComponent

During the product import the BOM/Kitting products are saved as simple products.

NAV field	Sana Commerce property
Calculated field (PFS add-on)	HorizontalId
'BOM Component'.'PfsVertical Component' (PFS add-on)	VerticalId
'BOM Component'.'PfsHorizontal Component' (PFS add-on)	HorizontalText
Calculated field (PFS add-on)	VerticalText
Calculated field	Title
'BOM Component'.'No.'	ProductId
'BOM Component'. 'Variant Code'	VariantId
'BOM Component'.'Quantity per'	Quantity
Calculated field	VariantDescription
'Item Variant'.'PfsPrepack Code'	PrepackCode

IProductCategory

During the product import the data is retrieved from the 'Item Category' and 'Product Group' tables. The nodes of the first level are taken from the 'Item Category' table. The nodes of the second level are taken from the 'Product Group' table.

NAV field	Sana Commerce property	Sana Commerce SQL datamodel
'Item Category'. 'Code' (for the nodes of the first level) For the nodes of the second level the combination of 'Product Group'. 'Item Category Code' and 'Product Group'.'Code' is separated by '__'	Id	'ProductCategory'.'Id'
'SC - Translation'. Description if exists for current language otherwise 'Item Category'. Description	Description	'ProductCategoryTranslation'. 'Description' If does not exist it will be stored in 'ProductCategory'. 'Description'
'Item Category'.'Visible in webshop' (for the nodes of the first level) 'Product Group'.'Visible in webshop' (for the nodes of the second level)	Visible	'ProductCategory'.'Visible'
'Item Category'.'Sort No.' (for the nodes of the first level) 'Product Group'.'Sort No.' (for the nodes of the second level)	SortNo	'ProductCategory'.'SortNo'
'0' (for the nodes of the first level) '1' (for the nodes of the second level)	Level	-

Back Next

Knowledge BaseField Mapping between Sana Commerce and NAV

Sitemap

Installation

Product Versions

Sana Software Links

Sana Commerce does not accept any liability for the content of this website, or for the consequences of any actions taken on the basis of the information provided. The information below should be interpreted as an example. No rights can be derived from this information.

Sana Software – e-Commerce for Microsoft Dynamics

Updated: September 2011