Knowledge BaseField Mapping between Sana Commerce and NAV

Field Mapping between Sana Commerce and NAV

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  -
Knowledge BaseField Mapping between Sana Commerce and NAV