Item Master Data
Driver Name - Dear Inventory Item Master Update
In Cin7 core, item master data can be synchronised by setting up the Product has been updated and New sky for sale notification type and sending the ProductList export type. This synchronises all data, so a separate call is not needed.
-
This connector ignores any item marked as Service type.
-
This connector used DocData to confirm that item data has been updated. If no change has been detected since the last window, then the item is not synchronised. This is based on the fields used. If an irrelevant field is updated, it will not synchronise.
-
This connector has internal handling of the UOMs. There is no need to switch or to enforce certain UOM types. All metric types calculate to millimetres and kilograms. All imperial types calculate to inches and pounds.
-
Cin7 does not have a concept of trade units. Therefore, these are not used.
|
.wms field |
Cin7 field |
Notes |
|---|---|---|
|
InstanceCode |
connections.DWMSInstance |
Sourced from ERPGate |
|
TenantCode |
connections.DWMSDefaultTenant |
Sourced from ERPGate |
|
APIKey |
connections.DWMSAPIKey |
Sourced from ERPGate |
|
ItemCode |
SKU |
|
|
ItemName |
Name |
|
|
ItemGroup |
Category |
Only synchronises if Dear.ItemMaster.SyncCategoryToGroup is enabled. |
|
IsDangerous |
NO |
Hardcoded to NO |
|
ItemWeight |
Weight |
|
|
ItemCubic |
Calculation of length/width/height |
Done at mm or in level |
|
StockUnit |
UOM |
Only synchronises if Dear.ItemMaster.SyncUOMToStockUnit is enabled. |
|
SkipDeleteExistingTradeUnits |
YES |
Only synchronises if Dear.ItemMaster.SkipDeleteExistingTradeUnits is enabled. |
|
SkipDeleteExistingAttributes |
YES |
Only synchronises if Dear.ItemMaster.SkipDeleteExistingAttributes is enabled. |
|
TradeItem/GTIN |
Barcode/SKU |
SKU is used if the Barcode field is blank. |
|
TradeItem/Quantity |
1 |
Hardcoded to 1 |
|
TradeItem/TradeItemDimensions/TradeItemWidth |
Width |
Post calculation can be turned off by setting Dear.ItemMaster.TradeItemType. |
|
TradeItem/TradeItemDimensions/TradeItemDepth |
Length |
Post calculation can be turned off by setting Dear.ItemMaster.TradeItemType. |
|
TradeItem/TradeItemDimensions/TradeItemHeight |
Height |
Post calculation can be turned off by setting Dear.ItemMaster.TradeItemType. |
|
TradeItem/TradeItemDimensions/TradeItemWeight |
Weight |
Post calculation can be turned off by setting Dear.ItemMaster.TradeItemType. |
|
Attributes |
Mappable |
Any other fields in the payload can be mapped using Dear.ItemMaster.AttributeMap. |
The following settings can be applied to change the logic and behaviour.
|
Setting |
Values |
Notes |
|---|---|---|
|
Dear.ItemMaster.SyncNonInventoryItems |
Yes/No Default - No |
Synchronise non-inventory items if needed. |
|
Dear.ItemMaster.SynCategoryToGroup |
Yes/No Default - No |
Synchronise Category to ItemGroup. |
|
Dear.ItemMaster.SynUOMToStockUnit |
Yes/No Default - No |
Synchronise UOM to StockUnit field. |
|
Dear.ItemMaster.SkipDeleteExistingAttributes |
Yes/No Default - No |
Adds the SkipDeleteExistingAttributes node to the payload to prevent attributes from being deleted. |
|
Dear.ItemMaster.SkipDeleteExistingTradeUnits |
Yes/No Default - No |
Adds the SkipDeleteExistingTradeUnits node to the payload to prevent attributes from being deleted. |
|
Dear.ItemMaster.TradeItemType |
Advanced/Basic Default - Advanced |
Defined if TradeItemDimensions are synchronised. |
|
Dear.ItemMaster.AtrributeMap |
JSON object |
Maps payload values to attributes of your choice in key:value relationship of "Cin7Filed":".wmsAttribute". |