Legacy-Definition sicher vergleichen
Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.
draft
Raw YAML
Dateiinhalt
Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.
#Connections
Source_Config: unitizeEngine #config - credetials of source connection service
Target_Config: enhanceEngine #config - credentials of target connection service
Enhance_Mode: flexible
#Engine Mode
Engine_Mode: full
#Source
Source_Datapool: iwm_articles_new #sql from
Order_By: ordernumber ASC
Joins:
- Left_Join:
Datapool: iwm_articles_stock
Join_Condition: iwm_articles_new.attr1 = iwm_articles_stock.firma and iwm_articles_new.ordernumber = iwm_articles_stock.ordernumber
- Left_Join:
Datapool: dg_supplierdata_enhanced.iwm_articles_properties_pil
Join_Condition: iwm_articles_new.ordernumber = iwm_articles_properties_pil.ordernumber and iwm_articles_new.attr1 = iwm_articles_properties_pil.firma
#Target
Datapool: articles_inhouse #sql table
Target_Datapool: articles_inhouse #sql from
Primary_Key: [ordernumber, attr1]
#Mapping -> Mappings source fields are detected by Mapping
Mapping:
ordernumber: iwm_articles_new.ordernumber
mainnumber:
Source: iwm_articles_new.mainnumber
File_Field_Adapter:
File: articles_new.mainnumber
arte:
Source: iwm_articles_new.arte
File_Field_Adapter:
File: articles_new.arte
name_oms:
Source: iwm_articles_new.name_oms
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_names_6
Cross_Field: name_oms
Mapping:
arte: arte
attr1: firma
Options:
- match_only: true
name_tre:
Source: iwm_articles_new.name_tre
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_names_6
Cross_Field: name_tre
Mapping:
arte: arte
attr1: firma
Options:
- match_only: true
name_ost:
Source: iwm_articles_new.name_ost
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_names_6
Cross_Field: name_ost
Mapping:
arte: arte
attr1: firma
Options:
- match_only: true
tax:
Source: iwm_articles_new.tax
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
price_ost: ()
price_tre: ()
price_oms: ()
shipping_ost: ()
shipping_tre: ()
shipping_oms: ()
pseudoprice_ost: ()
pseudoprice_tre: ()
pseudoprice_oms: ()
purchaseprice:
Source: iwm_articles_new.purchaseprice
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
baseprice: iwm_articles_new.baseprice
active_ost: iwm_articles_new.active_ost
active_tre: iwm_articles_new.active_tre
active_oms: iwm_articles_new.active_oms
description:
Source: iwm_articles_new.description
Field_Adapter:
- addslashes:
- replace: ['http://', 'https://']
description_long_ost:
Source: iwm_articles_new.description_long_ost
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_articles_texts_online #name of cross datapool
Cross_Field: description_long_ost #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: attr1
description_long_tre:
Source: iwm_articles_new.description_long_tre
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_articles_texts_online #name of cross datapool
Cross_Field: description_long_tre #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: attr1
description_long_oms:
Source: iwm_articles_new.description_long_oms
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_articles_texts_online #name of cross datapool
Cross_Field: description_long_oms #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: attr1
added: iwm_articles_new.added
changed: iwm_articles_new.changed
unitID: iwm_articles_new.unitID
attr9:
Source: iwm_articles_new.attr9
Field_Adapter:
- addslashes
variant_ean: iwm_articles_new.variant_ean
suppliernumber_original: iwm_articles_new.suppliernumber_original
suppliernumber:
Source: iwm_articles_new.suppliernumber
File_Field_Adapter:
Engine: importEngine
Datapool: static_mapping_suppliernumber
Identifier: id
File: articles_new.suppliernumber
Fields:
- id
- name_ost
- firma
- systemnummer
- lieferantennummer
- attr9
- hwg
- suppliernumber
ean:
Source: iwm_articles_new.ean
Field_Adapter:
- str_pad: ['13', '0', 'left']
- replace: ['0000000000000','']
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: iwm_articles_eans #name of cross datapool
Cross_Field: EAN #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
attr9: ATTR9
suppliernumber_original: SUPPLIERNUMBER_ORIGINAL
Options:
keep_existing: true
File_Field_Adapter:
File: articles_new.ean
attr9_strip:
Source: iwm_articles_new.attr9
Field_Adapter:
- replace: ['.','']
- replace: [',','']
- replace: ['(','']
- replace: [')','']
- replace: ['-','']
- replace: ['_','']
- replace: [' ','']
categories: iwm_articles_new.categories
referenceUnit: iwm_articles_new.referenceUnit
supplier_ost:
Source: iwm_articles_new.supplier_ost
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_3 #name of cross datapool
Cross_Field: supplier_ost #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
supplier_tre:
Source: iwm_articles_new.supplier_tre
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_3 #name of cross datapool
Cross_Field: supplier_tre #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
supplier_oms:
Source: iwm_articles_new.supplier_oms
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_3 #name of cross datapool
Cross_Field: supplier_oms #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
purchaseUnit: iwm_articles_new.purchaseUnit
metaTitle: iwm_articles_new.metaTitle
packUnit: iwm_articles_new.packUnit
configSetId: iwm_articles_new.configSetId
configuratorType: iwm_articles_new.configuratorType
configuratorOptions:
Source: iwm_articles_new.configuratorOptions
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_variants
Cross_Field: configuratorOptions
Local_Key: ordernumber
Cross_Key: ordernumber
kind:
Source: iwm_articles_new.kind
File_Field_Adapter:
File: articles_new.kind
weight:
Source: iwm_articles_new.weight
height:
Source: iwm_articles_new.height
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
width: iwm_articles_new.width
swag_attr27: #Produktart
Source: iwm_articles_new.name_oms
Field_Adapter:
- explode: [' ','0']
categoryPath_ost:
Source: iwm_articles_new.categoryPath_ost
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: shopware_article_info_ost
Cross_Field: category
Mapping:
ordernumber: ordernumber
categoryPath_tre:
Source: iwm_articles_new.categoryPath_tre
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: shopware_article_info_tre
Cross_Field: category
Mapping:
ordernumber: ordernumber
categoryPath_oms:
Source: iwm_articles_new.categoryPath_oms
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: shopware_article_info_oms
Cross_Field: category
Mapping:
ordernumber: ordernumber
cat_google_produktart:
Source: iwm_articles_new.cat_google
Cross_Field_Adapters_Target_Injection:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: dynamic_mapping_categories
Cross_Field: google_category_ID
Mapping:
swag_attr27: Produktart
cat_google_shop_category:
Source: iwm_articles_new.cat_google
Cross_Field_Adapters_Target_Injection:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: dynamic_mapping_categories
Cross_Field: google_category_ID
Mapping:
categoryPath_oms: Shop_category
cat_google:
Source: iwm_articles_new.cat_google
File_Field_Adapter:
File: articles_new.cat_google
# - Cross_Field_Adapter:
# Config: importEngine
# Cross_Datapool: dynamic_mapping_categories
# Cross_Field: google_category_ID
# Mapping:
# categoryPath_oms: Shop_category
# Options:
# - keep_existing: true
cat_ebay:
Source: iwm_articles_new.cat_ebay
Cross_Field_Adapters_Target_Injection:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: static_mapping_categories
Cross_Field: ebay_category
Mapping:
categoryPath_oms: oms_category
cat_amazon:
Source: iwm_articles_new.cat_amazon
Cross_Field_Adapters_Target_Injection:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: static_mapping_categories
Cross_Field: amazon_category
Mapping:
categoryPath_oms: oms_category
propertyGroupName: iwm_articles_new.propertyGroupName
propertyValueName: iwm_articles_new.propertyValueName
farbe:
Source: iwm_articles_new.ordernumber
Cross_Field_Adapters_Target_Injection:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_properties
Cross_Field: farbe
Mapping:
ordernumber: ordernumber
attr1: firma
material:
Source: iwm_articles_new.ordernumber
Cross_Field_Adapters_Target_Injection:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_properties
Cross_Field: material
Mapping:
ordernumber: ordernumber
attr1: firma
accessory: iwm_articles_new.accessory
attr1: iwm_articles_new.attr1
attr2: iwm_articles_new.attr2
attr3: iwm_articles_new.attr3
attr4: iwm_articles_new.attr4
attr5: iwm_articles_new.attr5
attr6:
Source: iwm_articles_new.attr6
File_Field_Adapter:
File: articles_new.attr6
attr7: iwm_articles_new.attr7
attr8: iwm_articles_new.attr8
attr10:
Source: iwm_articles_new.attr10
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: iwm_articles_tkz_2 #name of cross datapool
Cross_Field: TVK_2_PROPERTIES #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: ordernumber
attr11: iwm_articles_new.attr11
anlieferart: iwm_articles_new.anlieferart
stock_ir:
Source: iwm_articles_new.name_oms
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock_inventory #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
instock:
Source: iwm_articles_new.attr18
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
Field_Adapter:
- replace_empty: 0
File_Field_Adapter:
File: articles_new.instock
attr12:
Source: iwm_articles_new.attr12
File_Field_Adapter:
Config: enhanceEngine
Engine: enhanceEngine
Datapool: iwm_articles_lieferzeit_gesamt_mit_ausfallzeit
Identifier: ordernumber
File: articles_new.attr12
Fields:
- ordernumber
- lieferzeit
- firma
Field_Adapter:
- replace_empty: 0
- replace_smaller: [0,0]
attr13:
Source: iwm_articles_new.attr13
File_Field_Adapter:
File: articles_new.attr13
attr14:
Source: iwm_articles_new.attr14
File_Field_Adapter:
File: articles_new.attr14
Field_Adapter:
- replace_empty: 0
- replace_smaller: [0,0]
attr16:
Source: iwm_articles_new.attr16
Field_Adapter:
- replace_empty: 0
- replace_smaller: [0,0]
attr17:
Source: iwm_articles_new.attr17
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: iwm_articles_tkz_3 #name of cross datapool
Cross_Field: TVK_3_PROPERTIES #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: ordernumber
attr18:
Source: iwm_articles_new.attr18
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_prices #name of cross datapool
Cross_Field: attr18 #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
attr19: iwm_articles_new.attr19
swag_attr23:
Source: iwm_articles_stock.stock_inventory
Field_Adapter:
- replace_empty: 0
- replace_not_equals: ['0', '1']
swag_attr21:
Source: iwm_articles_new.swag_attr21
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_kojen_per_article #name of cross datapool
Cross_Field: kojencode #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: mainnumber
attr1: firma
swag_attr24:
Source: iwm_articles_new.swag_attr24
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: synonyme_articles #name of cross datapool
Cross_Field: Synonyme #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: arte
- Cross_Field_Adapter:
Config: importEngine
Cross_Datapool: iwm_articles_tkz_0 #name of cross datapool
Cross_Field: PROPERTIES #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: ordernumber
Options:
concat: ' '
swag_attr25: iwm_articles_new.swag_attr25
swag_attr26: #sortierte Ware
Source: iwm_articles_new.konsigniert
attr15: #Shippingcosts in_addition
Source: iwm_articles_new.attr15
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: versandkosten_addition
Identifier: id
File: articles_new.attr15
Fields:
- id
- name
swag_attr29:
Source: iwm_articles_new.swag_attr29 #carrier
File_Field_Adapter:
File: articles_new.swag_attr29
attr30: #local stock -> sum of local stocks without exhibition stocks
Source: iwm_articles_new.attr18
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock_local #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: firma
Field_Adapter:
- replace_empty: 0
attr31: # ir stock
Source: iwm_articles_new.name_oms
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: stock_inventory #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
attr36: () #finanzierbare produkte -> gefüllt im export
imageUrl:
Source: iwm_articles_new.imageUrl
File_Field_Adapter:
File: articles_new.imageUrl
ItemImageDate:
Source: iwm_articles_new.ItemImageDate
File_Field_Adapter:
File: articles_new.ItemImageDate
stock_witten:
Source: iwm_articles_new.attr18
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_stock #name of cross datapool
Cross_Field: witten #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
Field_Adapter:
- replace_empty: 0
shippingfree: iwm_articles_new.shippingfree
attr37_pre_oms:
Source: iwm_articles_new.name_oms
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_oms #name of cross datapool
Cross_Field: shippingcosts #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
attr37_pre_ost:
Source: iwm_articles_new.name_oms
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_ost #name of cross datapool
Cross_Field: shippingcosts #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
attr37_pre_tre:
Source: iwm_articles_new.name_oms
Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: export_iwm_articles_prices_tre #name of cross datapool
Cross_Field: shippingcosts #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
Field_Adapter:
- replace: [',','.']
- float_pricision: 2
attr37: #shipping costs (calculated in dataEngine)
Source: iwm_articles_new.shippingfree
File_Field_Adapter:
Config: enhanceEngine
Engine: enhanceEngine
Datapool: iwm_articles_prices
Identifier: ordernumber
File: articles_new.attr37
Fields:
- ordernumber
- verkaufshaus
- abholpreis
- lieferpreis
- vollservicepreis
attr38: #shipping time (calculated in dataEngine)
Source: iwm_articles_new.shippingfree
File_Field_Adapter:
File: articles_new.attr38
attr41: #enev new scale (1 = new scale, 0 = old scale)
Source: iwm_articles_new.attr41
File_Field_Adapter:
File: articles_new.attr41
attr48:
Source: iwm_articles_new.attr48
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: diomex_config #name of cross datapool
Cross_Field: mainnumber #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: firma
Field_Adapter:
- replace_not_equals: ['','1']
attr50:
Source: iwm_articles_new.attr50
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: wandmontage_articles #name of cross datapool
Cross_Field: Wandmontage #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: arte
attr1: firma
attr53:
Source: iwm_articles_new.attr53
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_properties #name of cross datapool
Cross_Field: farbe #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: firma
attr54: #Kalkulationsindex calculated in export
Source: iwm_articles_new.attr54
attr55:
Source: iwm_articles_new.attr55
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: prospektartikel_gesamt #name of cross datapool
Cross_Field: text #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: arte
attr1: firma
Field_Adapter:
- replace_not_equals: ['Prospektartikel','Artikel']
attr57: #Eigenmarke (0/1)
Source: iwm_articles_new.attr57
File_Field_Adapter:
File: articles_new.attr57
attr60:
Source: iwm_articles_new.name_ost
Cross_Field_Adapter:
Config: enhanceEngine
Engine: enhanceEngine
Cross_Datapool: iwm_articles_properties #name of cross datapool
Cross_Field: Form #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
attr61: #nicht überschriebene Wiederbeschaffungszeit
Source: iwm_articles_new.attr61
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_lieferzeit_gesamt_mit_ausfallzeit #name of cross datapool
Cross_Field: lieferzeit #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
File_Field_Adapter:
File: articles_new.attr61
tpl_color_badge:
Source: iwm_articles_new.tpl_color_badge
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: varianten #name of cross datapool
Cross_Field: tpl_color_badge #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
Field_Adapter:
- replace_empty: 0
textilkennzeichen_text:
Source: iwm_articles_new.textilkennzeichen_text
Cross_Field_Adapter:
Config: enhanceEngine
Engine: enhanceEngine
Cross_Datapool: iwm_articles_textilkennzeichen_8 #name of cross datapool
Cross_Field: textilkennzeichen #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
AHLZSD:
Source: iwm_articles_new.AHLZSD
Cross_Field_Adapter:
Config: unitizeEngine
Engine: unitizeEngine
Cross_Datapool: iwm_articles_arhp #name of cross datapool
Cross_Field: AHLZSD #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
ARKMFR:
Source: iwm_articles_new.ARKMFR
nutschicht:
Source: iwm_articles_new.nutschicht
textilkennzeichen_needed:
Source: iwm_articles_new.textilkennzeichen_needed
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: static_mapping_textilkennzeichen_flag
Identifier: id
File: articles_new.textilkennzeichen_needed
Fields:
- id
- hwg
- uwg
- keyword
- AHLZSD
- ARKMFR
- nutschicht
- textilkennzeichen_needed
has_textilkennzeichen:
Source: iwm_articles_new.has_textilkennzeichen
File_Field_Adapter:
File: articles_new.has_textilkennzeichen
pil_needed_static:
Source: iwm_articles_new.pil_needed_static
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: static_mapping_pil_flag
Identifier: id
File: articles_new.pil_needed_static
Fields:
- id
- hwg
- uwg
- keyword
- ARKMFR
- pil_needed
pil_needed_dynamic:
Source: iwm_articles_new.pil_needed_dynamic
File_Field_Adapter:
Config: importEngine
Engine: importEngine
Datapool: pflicht_enev
Identifier: id
File: articles_new.pil_needed_dynamic
Fields:
- id
- Teilwort
pil_needed:
Source: iwm_articles_new.pil_needed
File_Field_Adapter:
File: articles_new.pil_needed
pil_text:
Source: iwm_articles_new.pil_text
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_properties_pil #name of cross datapool
Cross_Field: pil_html_gesamt #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: firma
has_pil:
Source: iwm_articles_new.has_pil
File_Field_Adapter:
File: articles_new.has_pil
ahstat:
Source: iwm_articles_new.ahstat
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_arhp #name of cross datapool
Cross_Field: ahstat #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber
attr1: firma
LBNTEK:
Source: iwm_articles_new.LBNTEK
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_ek_prices_new #name of cross datapool
Cross_Field: A9K300 #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
LBKALK: ()
# Source: iwm_articles_new.LBKALK
# File_Field_Adapter:
# File: articles.LBKALK
mehrwertsteuerschluesselek: iwm_articles_new.mehrwertsteuerschluesselek
mehrwertsteuerschluesselvk: iwm_articles_new.mehrwertsteuerschluesselvk
lagernummer: iwm_articles_new.lagernummer
koje: iwm_articles_new.koje
# farbe: iwm_articles_new.farbe
aufbaukennzeichen: iwm_articles_new.aufbaukennzeichen
stil: iwm_articles_new.stil
montageeinheiten: iwm_articles_new.montageeinheiten
dimensionsfolge: iwm_articles_new.dimensionsfolge
abmessung_dimension_1: iwm_articles_new.abmessung_dimension_1
abmessung_dimension_2: iwm_articles_new.abmessung_dimension_2
abmessung_dimension_3: iwm_articles_new.abmessung_dimension_3
tourenart: iwm_articles_new.tourenart
versandart: iwm_articles_new.versandart
groesse: iwm_articles_new.groesse
knuepfart: iwm_articles_new.knuepfart
variant_hbsn: iwm_articles_new.variant_hbsn
variant_kurzbezeichnung: iwm_articles_new.variant_kurzbezeichnung
variant_langbezeichnung: iwm_articles_new.variant_langbezeichnung
bestellsperre:
Source: iwm_articles_new.bestellsperre
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: exportEngine
Cross_Datapool: iwm_articles_new_bssp_and_auslauf_vkhs_0 #name of cross datapool
Cross_Field: bestellsperre #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
ordernumber: ordernumber #hier muss arte: ordernumber hin, damit Bestellsperre auf Varianten vererbt wird
attr1: firma
auslaufkennzeichen:
Source: iwm_articles_new.auslaufkennzeichen
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_new_bssp_and_auslauf #name of cross datapool
Cross_Field: auslaufkennzeichen #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
konsigniert: iwm_articles_new.konsigniert
zeltgut: iwm_articles_new.zeltgut
lieferzeit:
Source: iwm_articles_new.lieferzeit
File_Field_Adapter:
File: articles_new.lieferzeit
gpsr_herstellerinfo:
Source: iwm_articles_new.gpsr_herstellerinfo
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: herstellerinfo #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
gpsr_verantwortlicher:
Source: iwm_articles_new.gpsr_verantwortlicher
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: verantwortlicher #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
ear_marke:
Source: iwm_articles_new.ear_marke
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: ear_marke #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
H_Name:
Source: iwm_articles_new.H_Name
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: H_Name #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
H_Strasse:
Source: iwm_articles_new.H_Name
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: H_Strasse #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
H_PLZOrt:
Source: iwm_articles_new.H_Name
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: H_PLZOrt #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
H_Email:
Source: iwm_articles_new.H_Name
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: H_Email #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
WEEE_RegNr:
Source: iwm_articles_new.H_Name
Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_suppliers_4 #name of cross datapool
Cross_Field: WEEE_RegNr #field to select value from in cross datapool
Local_Key: arte #key for where condition from datapool
Cross_Key: arte #key for where condition from cross datapool
prop1: () #Farbe
prop2: () #Breite
prop3: () #Länge
prop4: () #Höhe
prop5: () #Abmessung
prop10: () #Modell
prop11: () #Material
prop12: () #Raum
prop50: () #Matratze Größe
prop51: () #Matratze Härtegrad
prop52: () #Matratze Bezugsmaterial
prop53: () #Matratze Matratzenart
prop60: () #Teppich Flächengewicht
prop61: () #Teppich Florhöhe
prop62: () #Teppich Fußbodenheizung
prop63: () #Teppich Form
prop64: () #Teppich Muster
attr20:
Source: iwm_articles_new.name_oms
File_Field_Adapter:
File: articles_new.attr20
Engine: unitizeEngine
Datapool: iwm_articles_tvk_8
Identifier: arte
Fields:
- arte
- properties
enev_klasse:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles_new.enev_klasse #mapping der Klasse auf die Farbe de
enev_color:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles_new.enev_color #mapping der Klasse auf die Farbe des Etiketts
enev_download:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles_new.enev_download
enev_image:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles_new.enev_image #mapping der Klasse auf das entsprechende Bild
enev_spectrumfrom:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles_new.enev_spectrumfrom
enev_spectrum:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles_new.enev_spectrum
enev_active:
Source: iwm_articles_properties_pil.Energieeffizienzklasse1
File_Field_Adapter:
File: articles_new.enev_active
certification:
Source: iwm_articles_new.name_oms
Cross_Field_Adapter:
Config: unitizeEngine
Cross_Datapool: iwm_articles_tvk_4_eprel #name of cross datapool
Cross_Field: eprel #field to select value from in cross datapool
Local_Key: ordernumber #key for where condition from datapool
Cross_Key: ordernumber #key for where condition from cross datapool
File_Field_Adapter:
File: articles_new.certification
swag_attr28:
Source: iwm_articles_new.swag_attr28
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: iwm_articles_tvk_4 #name of cross datapool
Cross_Field: eek #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: arte
attr1: firma
File_Field_Adapter:
File: articles_new.swag_attr28
datenblatt:
Source: iwm_articles_new.datenblatt
File_Field_Adapter:
File: articles_new.datenblatt
has_datenblatt:
Source: iwm_articles_new.has_datenblatt
File_Field_Adapter:
File: articles_new.has_datenblatt
datenblatt_needed:
Source: iwm_articles_new.datenblatt_needed
File_Field_Adapter:
File: articles_new.datenblatt_needed
modellfamilie:
Source: iwm_articles_new.name_ost
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: modellfamilie_articles #name of cross datapool
Cross_Field: Label #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: arte
attr1: firma
no_packstation:
Source: iwm_articles_new.name_ost
Cross_Field_Adapters:
- Cross_Field_Adapter:
Config: enhanceEngine
Cross_Datapool: packstation_articles #name of cross datapool
Cross_Field: no_packstation #field to select value from in cross datapool
Mapping: #cross field adapter with more than one key
arte: arte
attr1: firma
Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
- Filter:
name: Corona-Problem IR-Bestand
condition: (stock_witten < 1) AND (stock_ir < 1) AND (attr2 == 91) AND (attr11 == 'B')
reason: 'Corona-Problem IR-Bestand'
- Filter:
name: Corona-Problem IR-Bestand
condition: (stock_witten == '0') AND (stock_ir == '0') AND (attr2 == '91') AND (attr11 == 'B')
reason: 'Corona-Problem INVR-Bestand'
- Filter:
name: 'Artikeldeaktivierung Gesamtmengenfilter'
condition:
In_Pool_Filter_Adapter:
Config: importEngine
Datapool: static_filter_inactive_articles
Reason_Key: reason
Mapping: #left is from current datapool, right from filter datapool
suppliernumber: supplier_number
supplier_ost: supplier_name
supplier_tre: supplier_name
ordernumber: ordernumber
attr1: attr1
attr2: attr2
attr3: attr3
attr4: attr4
attr11: attr11
attr12: attr12
price_ost: price
price_tre: price
instock: stock
stock_witten: stock_witten
name_ost: name
name_tre: name
description_long_ost: description
auslaufkennzeichen: auslauf
bestellsperre: bestellsperre
ahstat: AHSTAT
swag_attr26: konsigniert
swag_attr28: swag_attr28
textilkennzeichen_needed: textilkennzeichen_needed
has_textilkennzeichen: has_textilkennzeichen
pil_needed: pil_needed
has_pil: has_pil
enev_active: enev_active
datenblatt_needed: datenblatt_needed
has_datenblatt: has_datenblatt
height: laenge
width: breite
configuratorOptions: configuratorOptions
Metadata
Erkannte Konfiguration
Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.
| Source_Config | unitizeEngine |
|---|---|
| Target_Config | enhanceEngine |
| Enhance_Mode | flexible |
| Engine_Mode | full |
| Source_Datapool | iwm_articles_new |
| Order_By | ordernumber ASC |
| Joins | [ { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "iwm_articles_new.attr1 = iwm_articles_stock.firma and iwm_articles_new.ordernumber = iwm_articles_stock.ordernumber" }, { "Left_Join": null, "Datapool": "dg_supplierdata_enhanced.iwm_articles_properties_pil", "Join_Condition": "iwm_articles_new.ordernumber = iwm_articles_properties_pil.ordernumber and iwm_articles_new.attr1 = iwm_articles_properties_pil.firma" } ] |
| Datapool | articles_inhouse |
| Target_Datapool | articles_inhouse |
| Primary_Key | [ "ordernumber", "attr1" ] |
| Mapping | { "ordernumber": "iwm_articles_new.ordernumber", "mainnumber": { "Source": "iwm_articles_new.mainnumber", "File_Field_Adapter": { "File": "articles_new.mainnumber" } }, "arte": { "Source": "iwm_articles_new.arte", "File_Field_Adapter": { "File": "articles_new.arte" } }, "name_oms": { "Source": "iwm_articles_new.name_oms", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_names_6", "Cross_Field": "name_oms", "Mapping": { "arte": "arte", "attr1": "firma" }, "Options": [ { "match_only": true } ] } } ] }, "name_tre": { "Source": "iwm_articles_new.name_tre", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_names_6", "Cross_Field": "name_tre", "Mapping": { "arte": "arte", "attr1": "firma" }, "Options": [ { "match_only": true } ] } } ] }, "name_ost": { "Source": "iwm_articles_new.name_ost", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_names_6", "Cross_Field": "name_ost", "Mapping": { "arte": "arte", "attr1": "firma" }, "Options": [ { "match_only": true } ] } } ] }, "tax": { "Source": "iwm_articles_new.tax", "Field_Adapter": [ { "replace": [ ",", "." ] }, { "float_pricision": 2 } ] }, "price_ost": "()", "price_tre": "()", "price_oms": "()", "shipping_ost": "()", "shipping_tre": "()", "shipping_oms": "()", "pseudoprice_ost": "()", "pseudoprice_tre": "()", "pseudoprice_oms": "()", "purchaseprice": { "Source": "iwm_articles_new.purchaseprice", "Field_Adapter": [ { "replace": [ ",", "." ] }, { "float_pricision": 2 } ] }, "baseprice": "iwm_articles_new.baseprice", "active_ost": "iwm_articles_new.active_ost", "active_tre": "iwm_articles_new.active_tre", "active_oms": "iwm_articles_new.active_oms", "description": { "Source": "iwm_articles_new.description", "Field_Adapter": [ { "addslashes": null }, { "replace": [ "http:\/\/", "https:\/\/" ] } ] }, "description_long_ost": { "Source": "iwm_articles_new.description_long_ost", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_texts_online", "Cross_Field": "description_long_ost", "Mapping": { "ordernumber": "ordernumber", "attr1": "attr1" } } } ] }, "description_long_tre": { "Source": "iwm_articles_new.description_long_tre", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_texts_online", "Cross_Field": "description_long_tre", "Mapping": { "ordernumber": "ordernumber", "attr1": "attr1" } } } ] }, "description_long_oms": { "Source": "iwm_articles_new.description_long_oms", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_articles_texts_online", "Cross_Field": "description_long_oms", "Mapping": { "ordernumber": "ordernumber", "attr1": "attr1" } } } ] }, "added": "iwm_articles_new.added", "changed": "iwm_articles_new.changed", "unitID": "iwm_articles_new.unitID", "attr9": { "Source": "iwm_articles_new.attr9", "Field_Adapter": [ "addslashes" ] }, "variant_ean": "iwm_articles_new.variant_ean", "suppliernumber_original": "iwm_articles_new.suppliernumber_original", "suppliernumber": { "Source": "iwm_articles_new.suppliernumber", "File_Field_Adapter": { "Engine": "importEngine", "Datapool": "static_mapping_suppliernumber", "Identifier": "id", "File": "articles_new.suppliernumber", "Fields": [ "id", "name_ost", "firma", "systemnummer", "lieferantennummer", "attr9", "hwg", "suppliernumber" ] } }, "ean": { "Source": "iwm_articles_new.ean", "Field_Adapter": [ { "str_pad": [ "13", "0", "left" ] }, { "replace": [ "0000000000000", "" ] } ], "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "iwm_articles_eans", "Cross_Field": "EAN", "Mapping": { "attr9": "ATTR9", "suppliernumber_original": "SUPPLIERNUMBER_ORIGINAL" }, "Options": { "keep_existing": true } } } ], "File_Field_Adapter": { "File": "articles_new.ean" } }, "attr9_strip": { "Source": "iwm_articles_new.attr9", "Field_Adapter": [ { "replace": [ ".", "" ] }, { "replace": [ ",", "" ] }, { "replace": [ "(", "" ] }, { "replace": [ ")", "" ] }, { "replace": [ "-", "" ] }, { "replace": [ "_", "" ] }, { "replace": [ " ", "" ] } ] }, "categories": "iwm_articles_new.categories", "referenceUnit": "iwm_articles_new.referenceUnit", "supplier_ost": { "Source": "iwm_articles_new.supplier_ost", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_3", "Cross_Field": "supplier_ost", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "supplier_tre": { "Source": "iwm_articles_new.supplier_tre", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_3", "Cross_Field": "supplier_tre", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "supplier_oms": { "Source": "iwm_articles_new.supplier_oms", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_3", "Cross_Field": "supplier_oms", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "purchaseUnit": "iwm_articles_new.purchaseUnit", "metaTitle": "iwm_articles_new.metaTitle", "packUnit": "iwm_articles_new.packUnit", "configSetId": "iwm_articles_new.configSetId", "configuratorType": "iwm_articles_new.configuratorType", "configuratorOptions": { "Source": "iwm_articles_new.configuratorOptions", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_variants", "Cross_Field": "configuratorOptions", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "kind": { "Source": "iwm_articles_new.kind", "File_Field_Adapter": { "File": "articles_new.kind" } }, "weight": { "Source": "iwm_articles_new.weight" }, "height": { "Source": "iwm_articles_new.height", "Field_Adapter": [ { "replace": [ ",", "." ] }, { "float_pricision": 2 } ] }, "width": "iwm_articles_new.width", "swag_attr27": { "Source": "iwm_articles_new.name_oms", "Field_Adapter": [ { "explode": [ " ", "0" ] } ] }, "categoryPath_ost": { "Source": "iwm_articles_new.categoryPath_ost", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "shopware_article_info_ost", "Cross_Field": "category", "Mapping": { "ordernumber": "ordernumber" } } } ] }, "categoryPath_tre": { "Source": "iwm_articles_new.categoryPath_tre", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "shopware_article_info_tre", "Cross_Field": "category", "Mapping": { "ordernumber": "ordernumber" } } } ] }, "categoryPath_oms": { "Source": "iwm_articles_new.categoryPath_oms", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "shopware_article_info_oms", "Cross_Field": "category", "Mapping": { "ordernumber": "ordernumber" } } } ] }, "cat_google_produktart": { "Source": "iwm_articles_new.cat_google", "Cross_Field_Adapters_Target_Injection": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "dynamic_mapping_categories", "Cross_Field": "google_category_ID", "Mapping": { "swag_attr27": "Produktart" } } } ] }, "cat_google_shop_category": { "Source": "iwm_articles_new.cat_google", "Cross_Field_Adapters_Target_Injection": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "dynamic_mapping_categories", "Cross_Field": "google_category_ID", "Mapping": { "categoryPath_oms": "Shop_category" } } } ] }, "cat_google": { "Source": "iwm_articles_new.cat_google", "File_Field_Adapter": { "File": "articles_new.cat_google" } }, "cat_ebay": { "Source": "iwm_articles_new.cat_ebay", "Cross_Field_Adapters_Target_Injection": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "static_mapping_categories", "Cross_Field": "ebay_category", "Mapping": { "categoryPath_oms": "oms_category" } } } ] }, "cat_amazon": { "Source": "iwm_articles_new.cat_amazon", "Cross_Field_Adapters_Target_Injection": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "static_mapping_categories", "Cross_Field": "amazon_category", "Mapping": { "categoryPath_oms": "oms_category" } } } ] }, "propertyGroupName": "iwm_articles_new.propertyGroupName", "propertyValueName": "iwm_articles_new.propertyValueName", "farbe": { "Source": "iwm_articles_new.ordernumber", "Cross_Field_Adapters_Target_Injection": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_properties", "Cross_Field": "farbe", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ] }, "material": { "Source": "iwm_articles_new.ordernumber", "Cross_Field_Adapters_Target_Injection": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_properties", "Cross_Field": "material", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ] }, "accessory": "iwm_articles_new.accessory", "attr1": "iwm_articles_new.attr1", "attr2": "iwm_articles_new.attr2", "attr3": "iwm_articles_new.attr3", "attr4": "iwm_articles_new.attr4", "attr5": "iwm_articles_new.attr5", "attr6": { "Source": "iwm_articles_new.attr6", "File_Field_Adapter": { "File": "articles_new.attr6" } }, "attr7": "iwm_articles_new.attr7", "attr8": "iwm_articles_new.attr8", "attr10": { "Source": "iwm_articles_new.attr10", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "iwm_articles_tkz_2", "Cross_Field": "TVK_2_PROPERTIES", "Mapping": { "arte": "ordernumber" } } } ] }, "attr11": "iwm_articles_new.attr11", "anlieferart": "iwm_articles_new.anlieferart", "stock_ir": { "Source": "iwm_articles_new.name_oms", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_articles_stock", "Cross_Field": "stock_inventory", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "instock": { "Source": "iwm_articles_new.attr18", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_stock", "Cross_Field": "stock", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": 0 } ], "File_Field_Adapter": { "File": "articles_new.instock" } }, "attr12": { "Source": "iwm_articles_new.attr12", "File_Field_Adapter": { "Config": "enhanceEngine", "Engine": "enhanceEngine", "Datapool": "iwm_articles_lieferzeit_gesamt_mit_ausfallzeit", "Identifier": "ordernumber", "File": "articles_new.attr12", "Fields": [ "ordernumber", "lieferzeit", "firma" ] }, "Field_Adapter": [ { "replace_empty": 0 }, { "replace_smaller": [ 0, 0 ] } ] }, "attr13": { "Source": "iwm_articles_new.attr13", "File_Field_Adapter": { "File": "articles_new.attr13" } }, "attr14": { "Source": "iwm_articles_new.attr14", "File_Field_Adapter": { "File": "articles_new.attr14" }, "Field_Adapter": [ { "replace_empty": 0 }, { "replace_smaller": [ 0, 0 ] } ] }, "attr16": { "Source": "iwm_articles_new.attr16", "Field_Adapter": [ { "replace_empty": 0 }, { "replace_smaller": [ 0, 0 ] } ] }, "attr17": { "Source": "iwm_articles_new.attr17", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "iwm_articles_tkz_3", "Cross_Field": "TVK_3_PROPERTIES", "Mapping": { "arte": "ordernumber" } } } ] }, "attr18": { "Source": "iwm_articles_new.attr18", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_prices", "Cross_Field": "attr18", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "attr19": "iwm_articles_new.attr19", "swag_attr23": { "Source": "iwm_articles_stock.stock_inventory", "Field_Adapter": [ { "replace_empty": 0 }, { "replace_not_equals": [ "0", "1" ] } ] }, "swag_attr21": { "Source": "iwm_articles_new.swag_attr21", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_kojen_per_article", "Cross_Field": "kojencode", "Mapping": { "arte": "mainnumber", "attr1": "firma" } } } ] }, "swag_attr24": { "Source": "iwm_articles_new.swag_attr24", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "synonyme_articles", "Cross_Field": "Synonyme", "Mapping": { "arte": "arte" } } }, { "Cross_Field_Adapter": { "Config": "importEngine", "Cross_Datapool": "iwm_articles_tkz_0", "Cross_Field": "PROPERTIES", "Mapping": { "arte": "ordernumber" }, "Options": { "concat": " " } } } ] }, "swag_attr25": "iwm_articles_new.swag_attr25", "swag_attr26": { "Source": "iwm_articles_new.konsigniert" }, "attr15": { "Source": "iwm_articles_new.attr15", "File_Field_Adapter": { "Config": "importEngine", "Engine": "importEngine", "Datapool": "versandkosten_addition", "Identifier": "id", "File": "articles_new.attr15", "Fields": [ "id", "name" ] } }, "swag_attr29": { "Source": "iwm_articles_new.swag_attr29", "File_Field_Adapter": { "File": "articles_new.swag_attr29" } }, "attr30": { "Source": "iwm_articles_new.attr18", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_stock", "Cross_Field": "stock_local", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ], "Field_Adapter": [ { "replace_empty": 0 } ] }, "attr31": { "Source": "iwm_articles_new.name_oms", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_articles_stock", "Cross_Field": "stock_inventory", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "attr36": "()", "imageUrl": { "Source": "iwm_articles_new.imageUrl", "File_Field_Adapter": { "File": "articles_new.imageUrl" } }, "ItemImageDate": { "Source": "iwm_articles_new.ItemImageDate", "File_Field_Adapter": { "File": "articles_new.ItemImageDate" } }, "stock_witten": { "Source": "iwm_articles_new.attr18", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_stock", "Cross_Field": "witten", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace_empty": 0 } ] }, "shippingfree": "iwm_articles_new.shippingfree", "attr37_pre_oms": { "Source": "iwm_articles_new.name_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_oms", "Cross_Field": "shippingcosts", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "attr37_pre_ost": { "Source": "iwm_articles_new.name_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_ost", "Cross_Field": "shippingcosts", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "attr37_pre_tre": { "Source": "iwm_articles_new.name_oms", "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "export_iwm_articles_prices_tre", "Cross_Field": "shippingcosts", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "Field_Adapter": [ { "replace": [ ",", "." ] }, { "float_pricision": 2 } ] }, "attr37": { "Source": "iwm_articles_new.shippingfree", "File_Field_Adapter": { "Config": "enhanceEngine", "Engine": "enhanceEngine", "Datapool": "iwm_articles_prices", "Identifier": "ordernumber", "File": "articles_new.attr37", "Fields": [ "ordernumber", "verkaufshaus", "abholpreis", "lieferpreis", "vollservicepreis" ] } }, "attr38": { "Source": "iwm_articles_new.shippingfree", "File_Field_Adapter": { "File": "articles_new.attr38" } }, "attr41": { "Source": "iwm_articles_new.attr41", "File_Field_Adapter": { "File": "articles_new.attr41" } }, "attr48": { "Source": "iwm_articles_new.attr48", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "diomex_config", "Cross_Field": "mainnumber", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ], "Field_Adapter": [ { "replace_not_equals": [ "", "1" ] } ] }, "attr50": { "Source": "iwm_articles_new.attr50", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "wandmontage_articles", "Cross_Field": "Wandmontage", "Mapping": { "arte": "arte", "attr1": "firma" } } } ] }, "attr53": { "Source": "iwm_articles_new.attr53", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_properties", "Cross_Field": "farbe", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ] }, "attr54": { "Source": "iwm_articles_new.attr54" }, "attr55": { "Source": "iwm_articles_new.attr55", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "prospektartikel_gesamt", "Cross_Field": "text", "Mapping": { "arte": "arte", "attr1": "firma" } } } ], "Field_Adapter": [ { "replace_not_equals": [ "Prospektartikel", "Artikel" ] } ] }, "attr57": { "Source": "iwm_articles_new.attr57", "File_Field_Adapter": { "File": "articles_new.attr57" } }, "attr60": { "Source": "iwm_articles_new.name_ost", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Engine": "enhanceEngine", "Cross_Datapool": "iwm_articles_properties", "Cross_Field": "Form", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "attr61": { "Source": "iwm_articles_new.attr61", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_lieferzeit_gesamt_mit_ausfallzeit", "Cross_Field": "lieferzeit", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "File_Field_Adapter": { "File": "articles_new.attr61" } }, "tpl_color_badge": { "Source": "iwm_articles_new.tpl_color_badge", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "varianten", "Cross_Field": "tpl_color_badge", "Local_Key": "arte", "Cross_Key": "arte" }, "Field_Adapter": [ { "replace_empty": 0 } ] }, "textilkennzeichen_text": { "Source": "iwm_articles_new.textilkennzeichen_text", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Engine": "enhanceEngine", "Cross_Datapool": "iwm_articles_textilkennzeichen_8", "Cross_Field": "textilkennzeichen", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "AHLZSD": { "Source": "iwm_articles_new.AHLZSD", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Engine": "unitizeEngine", "Cross_Datapool": "iwm_articles_arhp", "Cross_Field": "AHLZSD", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "ARKMFR": { "Source": "iwm_articles_new.ARKMFR" }, "nutschicht": { "Source": "iwm_articles_new.nutschicht" }, "textilkennzeichen_needed": { "Source": "iwm_articles_new.textilkennzeichen_needed", "File_Field_Adapter": { "Config": "importEngine", "Engine": "importEngine", "Datapool": "static_mapping_textilkennzeichen_flag", "Identifier": "id", "File": "articles_new.textilkennzeichen_needed", "Fields": [ "id", "hwg", "uwg", "keyword", "AHLZSD", "ARKMFR", "nutschicht", "textilkennzeichen_needed" ] } }, "has_textilkennzeichen": { "Source": "iwm_articles_new.has_textilkennzeichen", "File_Field_Adapter": { "File": "articles_new.has_textilkennzeichen" } }, "pil_needed_static": { "Source": "iwm_articles_new.pil_needed_static", "File_Field_Adapter": { "Config": "importEngine", "Engine": "importEngine", "Datapool": "static_mapping_pil_flag", "Identifier": "id", "File": "articles_new.pil_needed_static", "Fields": [ "id", "hwg", "uwg", "keyword", "ARKMFR", "pil_needed" ] } }, "pil_needed_dynamic": { "Source": "iwm_articles_new.pil_needed_dynamic", "File_Field_Adapter": { "Config": "importEngine", "Engine": "importEngine", "Datapool": "pflicht_enev", "Identifier": "id", "File": "articles_new.pil_needed_dynamic", "Fields": [ "id", "Teilwort" ] } }, "pil_needed": { "Source": "iwm_articles_new.pil_needed", "File_Field_Adapter": { "File": "articles_new.pil_needed" } }, "pil_text": { "Source": "iwm_articles_new.pil_text", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_properties_pil", "Cross_Field": "pil_html_gesamt", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ] }, "has_pil": { "Source": "iwm_articles_new.has_pil", "File_Field_Adapter": { "File": "articles_new.has_pil" } }, "ahstat": { "Source": "iwm_articles_new.ahstat", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_articles_arhp", "Cross_Field": "ahstat", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } }, "LBNTEK": { "Source": "iwm_articles_new.LBNTEK", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_ek_prices_new", "Cross_Field": "A9K300", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" } }, "LBKALK": "()", "mehrwertsteuerschluesselek": "iwm_articles_new.mehrwertsteuerschluesselek", "mehrwertsteuerschluesselvk": "iwm_articles_new.mehrwertsteuerschluesselvk", "lagernummer": "iwm_articles_new.lagernummer", "koje": "iwm_articles_new.koje", "aufbaukennzeichen": "iwm_articles_new.aufbaukennzeichen", "stil": "iwm_articles_new.stil", "montageeinheiten": "iwm_articles_new.montageeinheiten", "dimensionsfolge": "iwm_articles_new.dimensionsfolge", "abmessung_dimension_1": "iwm_articles_new.abmessung_dimension_1", "abmessung_dimension_2": "iwm_articles_new.abmessung_dimension_2", "abmessung_dimension_3": "iwm_articles_new.abmessung_dimension_3", "tourenart": "iwm_articles_new.tourenart", "versandart": "iwm_articles_new.versandart", "groesse": "iwm_articles_new.groesse", "knuepfart": "iwm_articles_new.knuepfart", "variant_hbsn": "iwm_articles_new.variant_hbsn", "variant_kurzbezeichnung": "iwm_articles_new.variant_kurzbezeichnung", "variant_langbezeichnung": "iwm_articles_new.variant_langbezeichnung", "bestellsperre": { "Source": "iwm_articles_new.bestellsperre", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "exportEngine", "Cross_Datapool": "iwm_articles_new_bssp_and_auslauf_vkhs_0", "Cross_Field": "bestellsperre", "Mapping": { "ordernumber": "ordernumber", "attr1": "firma" } } } ] }, "auslaufkennzeichen": { "Source": "iwm_articles_new.auslaufkennzeichen", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_articles_new_bssp_and_auslauf", "Cross_Field": "auslaufkennzeichen", "Local_Key": "arte", "Cross_Key": "ordernumber" } }, "konsigniert": "iwm_articles_new.konsigniert", "zeltgut": "iwm_articles_new.zeltgut", "lieferzeit": { "Source": "iwm_articles_new.lieferzeit", "File_Field_Adapter": { "File": "articles_new.lieferzeit" } }, "gpsr_herstellerinfo": { "Source": "iwm_articles_new.gpsr_herstellerinfo", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "herstellerinfo", "Local_Key": "arte", "Cross_Key": "arte" } }, "gpsr_verantwortlicher": { "Source": "iwm_articles_new.gpsr_verantwortlicher", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "verantwortlicher", "Local_Key": "arte", "Cross_Key": "arte" } }, "ear_marke": { "Source": "iwm_articles_new.ear_marke", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "ear_marke", "Local_Key": "arte", "Cross_Key": "arte" } }, "H_Name": { "Source": "iwm_articles_new.H_Name", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "H_Name", "Local_Key": "arte", "Cross_Key": "arte" } }, "H_Strasse": { "Source": "iwm_articles_new.H_Name", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "H_Strasse", "Local_Key": "arte", "Cross_Key": "arte" } }, "H_PLZOrt": { "Source": "iwm_articles_new.H_Name", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "H_PLZOrt", "Local_Key": "arte", "Cross_Key": "arte" } }, "H_Email": { "Source": "iwm_articles_new.H_Name", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "H_Email", "Local_Key": "arte", "Cross_Key": "arte" } }, "WEEE_RegNr": { "Source": "iwm_articles_new.H_Name", "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_suppliers_4", "Cross_Field": "WEEE_RegNr", "Local_Key": "arte", "Cross_Key": "arte" } }, "prop1": "()", "prop2": "()", "prop3": "()", "prop4": "()", "prop5": "()", "prop10": "()", "prop11": "()", "prop12": "()", "prop50": "()", "prop51": "()", "prop52": "()", "prop53": "()", "prop60": "()", "prop61": "()", "prop62": "()", "prop63": "()", "prop64": "()", "attr20": { "Source": "iwm_articles_new.name_oms", "File_Field_Adapter": { "File": "articles_new.attr20", "Engine": "unitizeEngine", "Datapool": "iwm_articles_tvk_8", "Identifier": "arte", "Fields": [ "arte", "properties" ] } }, "enev_klasse": { "Source": "iwm_articles_properties_pil.Energieeffizienzklasse1", "File_Field_Adapter": { "File": "articles_new.enev_klasse" } }, "enev_color": { "Source": "iwm_articles_properties_pil.Energieeffizienzklasse1", "File_Field_Adapter": { "File": "articles_new.enev_color" } }, "enev_download": { "Source": "iwm_articles_properties_pil.Energieeffizienzklasse1", "File_Field_Adapter": { "File": "articles_new.enev_download" } }, "enev_image": { "Source": "iwm_articles_properties_pil.Energieeffizienzklasse1", "File_Field_Adapter": { "File": "articles_new.enev_image" } }, "enev_spectrumfrom": { "Source": "iwm_articles_properties_pil.Energieeffizienzklasse1", "File_Field_Adapter": { "File": "articles_new.enev_spectrumfrom" } }, "enev_spectrum": { "Source": "iwm_articles_properties_pil.Energieeffizienzklasse1", "File_Field_Adapter": { "File": "articles_new.enev_spectrum" } }, "enev_active": { "Source": "iwm_articles_properties_pil.Energieeffizienzklasse1", "File_Field_Adapter": { "File": "articles_new.enev_active" } }, "certification": { "Source": "iwm_articles_new.name_oms", "Cross_Field_Adapter": { "Config": "unitizeEngine", "Cross_Datapool": "iwm_articles_tvk_4_eprel", "Cross_Field": "eprel", "Local_Key": "ordernumber", "Cross_Key": "ordernumber" }, "File_Field_Adapter": { "File": "articles_new.certification" } }, "swag_attr28": { "Source": "iwm_articles_new.swag_attr28", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "iwm_articles_tvk_4", "Cross_Field": "eek", "Mapping": { "arte": "arte", "attr1": "firma" } } } ], "File_Field_Adapter": { "File": "articles_new.swag_attr28" } }, "datenblatt": { "Source": "iwm_articles_new.datenblatt", "File_Field_Adapter": { "File": "articles_new.datenblatt" } }, "has_datenblatt": { "Source": "iwm_articles_new.has_datenblatt", "File_Field_Adapter": { "File": "articles_new.has_datenblatt" } }, "datenblatt_needed": { "Source": "iwm_articles_new.datenblatt_needed", "File_Field_Adapter": { "File": "articles_new.datenblatt_needed" } }, "modellfamilie": { "Source": "iwm_articles_new.name_ost", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "modellfamilie_articles", "Cross_Field": "Label", "Mapping": { "arte": "arte", "attr1": "firma" } } } ] }, "no_packstation": { "Source": "iwm_articles_new.name_ost", "Cross_Field_Adapters": [ { "Cross_Field_Adapter": { "Config": "enhanceEngine", "Cross_Datapool": "packstation_articles", "Cross_Field": "no_packstation", "Mapping": { "arte": "arte", "attr1": "firma" } } } ] } } |
| Filters | [ { "Filter": { "name": "Corona-Problem IR-Bestand", "condition": "(stock_witten < 1) AND (stock_ir < 1) AND (attr2 == 91) AND (attr11 == 'B')", "reason": "Corona-Problem IR-Bestand" } }, { "Filter": { "name": "Corona-Problem IR-Bestand", "condition": "(stock_witten == '0') AND (stock_ir == '0') AND (attr2 == '91') AND (attr11 == 'B')", "reason": "Corona-Problem INVR-Bestand" } }, { "Filter": { "name": "Artikeldeaktivierung Gesamtmengenfilter", "condition": { "In_Pool_Filter_Adapter": { "Config": "importEngine", "Datapool": "static_filter_inactive_articles", "Reason_Key": "reason", "Mapping": { "suppliernumber": "supplier_number", "supplier_ost": "supplier_name", "supplier_tre": "supplier_name", "ordernumber": "ordernumber", "attr1": "attr1", "attr2": "attr2", "attr3": "attr3", "attr4": "attr4", "attr11": "attr11", "attr12": "attr12", "price_ost": "price", "price_tre": "price", "instock": "stock", "stock_witten": "stock_witten", "name_ost": "name", "name_tre": "name", "description_long_ost": "description", "auslaufkennzeichen": "auslauf", "bestellsperre": "bestellsperre", "ahstat": "AHSTAT", "swag_attr26": "konsigniert", "swag_attr28": "swag_attr28", "textilkennzeichen_needed": "textilkennzeichen_needed", "has_textilkennzeichen": "has_textilkennzeichen", "pil_needed": "pil_needed", "has_pil": "has_pil", "enev_active": "enev_active", "datenblatt_needed": "datenblatt_needed", "has_datenblatt": "has_datenblatt", "height": "laenge", "width": "breite", "configuratorOptions": "configuratorOptions" } } } } } ] |