Engine / Editor
iwm_articles_new
Mandant default
Pipelines
Engines
Include Mappings
Filter
Überblick
Editor
Validierung
Metadaten
Revisionen
Zurück
Altbestand
Engine bearbeiten
Bestand öffnen
Altbestand
Zum Editor
Run erst mit Status active
DRAFT
Status
engine
Typ
unitize
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
Engine: Unitize Source_Config: importEngine Target_Config: unitizeEngine Mysql_Engine: InnoDB Default_Charset: latin1 Source_Connection_Type: database Source_Database_Connection_Service: DatabaseConnectionService Source_Datapool: iwm_articles_new Source_Primary_Key: [ordernumber, ItemFirm] Target_Primary_Key: [ordernumber, attr1] #always primary key for target datapool. primary key of source pool can be read from the pool itself. Datapool: iwm_articles_new Add_Indices: - Add_Index: Datapool: iwm_articles_new Index_Name: idx_FARBE Fields: FARBE - Add_Index: Datapool: dynamic_mapping_colors Index_Name: idx_FARB_ID Fields: FARB_ID - Add_Index: Datapool: dynamic_mapping_variant_dimensions_AA01 Index_Name: idx_dimension_id Fields: dimension_id - Add_Index: Datapool: iwm_articles_new Index_Name: idx_AIAA01 Fields: AIAA01 - Add_Index: Datapool: dynamic_mapping_variant_dimensions_AA02 Index_Name: idx_dimension_id Fields: dimension_id - Add_Index: Datapool: iwm_articles_new Index_Name: idx_AIAA02 Fields: AIAA02 - Add_Index: Datapool: dynamic_mapping_variant_dimensions_AA03 Index_Name: idx_dimension_id Fields: dimension_id - Add_Index: Datapool: iwm_articles_new Index_Name: idx_AIAA03 Fields: AIAA03 Joins: - Left_Join: Datapool: dynamic_mapping_colors Join_Condition: iwm_articles_new.FARBE = dynamic_mapping_colors.FARB_ID - Left_Join: Datapool: dynamic_mapping_variant_dimensions_AA01 Join_Condition: iwm_articles_new.AIAA01 = dynamic_mapping_variant_dimensions_AA01.dimension_id - Left_Join: Datapool: dynamic_mapping_variant_dimensions_AA02 Join_Condition: iwm_articles_new.AIAA02 = dynamic_mapping_variant_dimensions_AA02.dimension_id - Left_Join: Datapool: dynamic_mapping_variant_dimensions_AA03 Join_Condition: iwm_articles_new.AIAA03 = dynamic_mapping_variant_dimensions_AA03.dimension_id # - Left_Join: # Datapool: shopware_article_info_oms # Join_Condition: iwm_articles_new.ordernumber = shopware_article_info_oms.ordernumber # - Left_Join: # Datapool: iwm_articles_new_eans_1 # Join_Condition: iwm_articles_new.ORDERNUMBER = iwm_articles_new_eans_1.ORDERNUMBER # - Left_Join: # Datapool: iwm_articles_new_eans_3 # Join_Condition: iwm_articles_new.ORDERNUMBER = iwm_articles_new_eans_3.ORDERNUMBER # - Left_Join: # Datapool: iwm_atab00 # Join_Condition: iwm_articles_new.FIRMA = iwm_atab00.ATFIRM AND iwm_articles_new.LIEFERANTENNUMMER = iwm_atab00.ATLINR AND iwm_articles_new.SYSTEMNUMMER = iwm_atab00.ATSYSN AND iwm_articles_new.AIAA01 = iwm_atab00.ATAA01 AND iwm_articles_new.AIAFN1 = iwm_atab00.ATAFNR Datapool_Definition: ordernumber: VARCHAR(50) NOT NULL mainnumber: VARCHAR(50) DEFAULT NULL arte: VARCHAR(50) DEFAULT NULL name_ost: VARCHAR(255) DEFAULT NULL name_tre: VARCHAR(255) DEFAULT NULL name_oms: VARCHAR(255) DEFAULT NULL supplier_ost: VARCHAR(100) DEFAULT NULL supplier_tre: VARCHAR(100) DEFAULT NULL supplier_oms: VARCHAR(100) DEFAULT NULL tax: VARCHAR(10) DEFAULT NULL price_ost: VARCHAR(20) DEFAULT NULL price_tre: VARCHAR(20) DEFAULT NULL price_oms: VARCHAR(20) DEFAULT NULL shipping_ost: VARCHAR(20) DEFAULT NULL shipping_tre: VARCHAR(20) DEFAULT NULL shipping_oms: VARCHAR(20) DEFAULT NULL pseudoprice_ost: VARCHAR(20) DEFAULT NULL pseudoprice_tre: VARCHAR(20) DEFAULT NULL pseudoprice_oms: VARCHAR(20) DEFAULT NULL baseprice: VARCHAR(20) DEFAULT NULL active_ost: INT(11) DEFAULT NULL active_tre: INT(11) DEFAULT NULL active_oms: INT(11) DEFAULT NULL description: MEDIUMTEXT DEFAULT NULL description_long_ost: TEXT DEFAULT NULL description_long_tre: TEXT DEFAULT NULL description_long_oms: TEXT DEFAULT NULL added: DATETIME DEFAULT NULL changed: DATETIME DEFAULT NULL unitID: VARCHAR(40) DEFAULT NULL variant_ean: VARCHAR(20) DEFAULT NULL variant_hbsn: VARCHAR(20) DEFAULT NULL ean: VARCHAR(50) DEFAULT NULL attr9_strip: VARCHAR(20) DEFAULT NULL categories: VARCHAR(255) DEFAULT NULL purchaseprice: VARCHAR(20) DEFAULT NULL referenceUnit: VARCHAR(20) DEFAULT NULL purchaseUnit: VARCHAR(20) DEFAULT NULL metaTitle: VARCHAR(255) DEFAULT NULL configSetId: INT(11) DEFAULT NULL packUnit: VARCHAR(20) DEFAULT NULL configuratorType: VARCHAR(255) DEFAULT NULL configuratorOptions: VARCHAR(255) DEFAULT NULL kind: VARCHAR(5) DEFAULT NULL suppliernumber_original: VARCHAR(50) DEFAULT NULL suppliernumber: VARCHAR(50) DEFAULT NULL weight: VARCHAR(20) DEFAULT NULL height: VARCHAR(20) DEFAULT NULL width: VARCHAR(20) DEFAULT NULL categoryPath_ost: TEXT DEFAULT NULL categoryPath_tre: TEXT DEFAULT NULL categoryPath_oms: TEXT DEFAULT NULL cat_google_produktart: TEXT DEFAULT NULL cat_google_shop_category: TEXT DEFAULT NULL cat_google: TEXT DEFAULT NULL cat_ebay: TEXT DEFAULT NULL cat_amazon: TEXT DEFAULT NULL propertyGroupName: VARCHAR(255) DEFAULT NULL propertyValueName: VARCHAR(255) DEFAULT NULL accessory: VARCHAR(255) DEFAULT NULL attr1: VARCHAR(10) NOT NULL attr2: VARCHAR(10) DEFAULT NULL attr3: VARCHAR(10) DEFAULT NULL attr4: VARCHAR(10) DEFAULT NULL attr5: VARCHAR(10) DEFAULT NULL attr6: VARCHAR(150) DEFAULT NULL attr7: VARCHAR(10) DEFAULT NULL attr8: VARCHAR(10) DEFAULT NULL attr9: VARCHAR(50) DEFAULT NULL attr10: VARCHAR(100) DEFAULT NULL attr11: VARCHAR(10) DEFAULT NULL attr12: VARCHAR(10) DEFAULT NULL attr13: VARCHAR(10) DEFAULT NULL attr14: VARCHAR(10) DEFAULT NULL attr15: VARCHAR(100) DEFAULT NULL attr16: VARCHAR(10) DEFAULT NULL attr17: VARCHAR(100) DEFAULT NULL attr18: VARCHAR(10) DEFAULT NULL attr19: VARCHAR(10) DEFAULT NULL attr20: VARCHAR(350) DEFAULT NULL swag_attr21: TEXT DEFAULT NULL swag_attr22: VARCHAR(255) DEFAULT NULL swag_attr23: VARCHAR(25) DEFAULT NULL swag_attr24: VARCHAR(255) DEFAULT NULL swag_attr25: VARCHAR(10) DEFAULT NULL swag_attr26: VARCHAR(10) DEFAULT NULL swag_attr27: VARCHAR(50) DEFAULT NULL swag_attr28: TEXT DEFAULT NULL swag_attr29: VARCHAR(25) DEFAULT NULL attr30: VARCHAR(10) DEFAULT NULL attr31: VARCHAR(10) DEFAULT NULL attr36: VARCHAR(10) DEFAULT NULL attr37_pre_ost: VARCHAR(50) DEFAULT NULL attr37_pre_tre: VARCHAR(50) DEFAULT NULL attr37_pre_oms: VARCHAR(50) DEFAULT NULL attr37: VARCHAR(100) DEFAULT NULL attr38: VARCHAR(50) DEFAULT NULL attr41: VARCHAR(10) DEFAULT NULL attr48: VARCHAR(10) DEFAULT NULL attr50: VARCHAR(10) DEFAULT NULL attr53: VARCHAR(25) DEFAULT NULL attr54: VARCHAR(5) DEFAULT NULL attr55: VARCHAR(25) DEFAULT NULL attr57: VARCHAR(50) DEFAULT NULL attr60: VARCHAR(50) DEFAULT NULL attr61: VARCHAR(50) DEFAULT NULL attr67: VARCHAR(50) DEFAULT NULL tpl_color_badge: VARCHAR(2) DEFAULT NULL stockmin_ost: INT(11) DEFAULT NULL stockmin_tre: INT(11) DEFAULT NULL stockmin_oms: INT(11) DEFAULT NULL ItemImageDate: VARCHAR(255) DEFAULT NULL imageUrl: TEXT DEFAULT NULL LBNTEK: VARCHAR(20) DEFAULT NULL LBKALK: VARCHAR(15) DEFAULT NULL LBMARGE: VARCHAR(10) DEFAULT NULL LBWAEISA: VARCHAR(10) DEFAULT NULL AbsatzMenge3M: VARCHAR(10) DEFAULT NULL shippingfree: VARCHAR(20) DEFAULT NULL auslaufkennzeichen: VARCHAR(10) DEFAULT NULL textilkennzeichen_needed: VARCHAR(10) DEFAULT NULL textilkennzeichen_text: TEXT DEFAULT NULL has_textilkennzeichen: VARCHAR(10) DEFAULT NULL pil_needed: VARCHAR(10) DEFAULT NULL pil_needed_static: VARCHAR(10) DEFAULT NULL pil_needed_dynamic: VARCHAR(10) DEFAULT NULL pil_text: TEXT DEFAULT NULL has_pil: VARCHAR(10) DEFAULT NULL AHLZSD: VARCHAR(10) DEFAULT NULL ARKMFR: VARCHAR(10) DEFAULT NULL anlieferart: VARCHAR(20) DEFAULT NULL nutschicht: VARCHAR(10) DEFAULT NULL stock_witten: VARCHAR(10) DEFAULT NULL stock_ir: VARCHAR(10) DEFAULT NULL stock_local: VARCHAR(10) DEFAULT NULL ahstat: VARCHAR(10) DEFAULT NULL bestellsperre: VARCHAR(10) DEFAULT NULL mehrwertsteuerschluesselek: VARCHAR(20) DEFAULT NULL mehrwertsteuerschluesselvk: VARCHAR(20) DEFAULT NULL lagernummer: VARCHAR(255) DEFAULT NULL koje: VARCHAR(255) DEFAULT NULL material: VARCHAR(50) DEFAULT NULL farbe: VARCHAR(45) DEFAULT NULL aufbaukennzeichen: VARCHAR(10) DEFAULT NULL stil: VARCHAR(20) DEFAULT NULL montageeinheiten: VARCHAR(25) DEFAULT NULL dimensionsfolge: VARCHAR(50) DEFAULT NULL abmessung_dimension_1: VARCHAR(20) DEFAULT NULL abmessung_dimension_2: VARCHAR(20) DEFAULT NULL abmessung_dimension_3: VARCHAR(20) DEFAULT NULL tourenart: VARCHAR(25) DEFAULT NULL versandart: VARCHAR(25) DEFAULT NULL groesse: VARCHAR(25) DEFAULT NULL knuepfart: VARCHAR(25) DEFAULT NULL variant_kurzbezeichnung: VARCHAR(50) DEFAULT NULL variant_langbezeichnung: VARCHAR(50) DEFAULT NULL variant_dimension_1: VARCHAR(50) DEFAULT NULL variant_dimension_2: VARCHAR(50) DEFAULT NULL variant_dimension_3: VARCHAR(50) DEFAULT NULL variant_dimension_1_value: VARCHAR(50) DEFAULT NULL variant_dimension_2_value: VARCHAR(50) DEFAULT NULL variant_dimension_3_value: VARCHAR(50) DEFAULT NULL instock: INT(5) DEFAULT NULL lieferzeit: VARCHAR(50) DEFAULT NULL konsigniert: VARCHAR(20) DEFAULT NULL zeltgut: VARCHAR(2) DEFAULT NULL ahstat: VARCHAR(10) DEFAULT NULL datenblatt: VARCHAR(100) DEFAULT NULL datenblatt_needed: VARCHAR(2) DEFAULT NULL has_datenblatt: VARCHAR(2) DEFAULT NULL modellfamilie: VARCHAR(50) DEFAULT NULL no_packstation: VARCHAR(2) DEFAULT NULL gpsr_herstellerinfo: TEXT DEFAULT NULL gpsr_verantwortlicher: TEXT DEFAULT NULL ear_marke: VARCHAR(100) DEFAULT NULL H_Name: VARCHAR(100) DEFAULT NULL H_Strasse: VARCHAR(100) DEFAULT NULL H_PLZOrt: VARCHAR(100) DEFAULT NULL H_Email: VARCHAR(100) DEFAULT NULL WEEE_RegNr: VARCHAR(100) DEFAULT NULL aktion_Sonderpreis: VARCHAR(10) DEFAULT NULL aktion_Gutscheincode: VARCHAR(10) DEFAULT NULL prop1: VARCHAR(50) DEFAULT NULL prop2: VARCHAR(25) DEFAULT NULL prop3: VARCHAR(25) DEFAULT NULL prop4: VARCHAR(25) DEFAULT NULL prop5: VARCHAR(50) DEFAULT NULL prop10: VARCHAR(25) DEFAULT NULL prop11: VARCHAR(25) DEFAULT NULL prop12: VARCHAR(50) DEFAULT NULL prop50: VARCHAR(25) DEFAULT NULL prop51: VARCHAR(25) DEFAULT NULL prop52: VARCHAR(25) DEFAULT NULL prop53: VARCHAR(50) DEFAULT NULL prop60: VARCHAR(25) DEFAULT NULL prop61: VARCHAR(25) DEFAULT NULL prop62: VARCHAR(25) DEFAULT NULL prop63: VARCHAR(25) DEFAULT NULL prop64: VARCHAR(50) DEFAULT NULL enev_color: VARCHAR(10) DEFAULT NULL enev_download: VARCHAR(100) DEFAULT NULL enev_image: VARCHAR(100) DEFAULT NULL enev_klasse: VARCHAR(10) DEFAULT NULL enev_spectrumfrom: VARCHAR(10) DEFAULT NULL enev_spectrum: VARCHAR(10) DEFAULT NULL enev_active: VARCHAR(1) DEFAULT NULL certification: VARCHAR(100) DEFAULT NULL Mapping: ordernumber: iwm_articles_new.ORDERNUMBER mainnumber: iwm_articles_new.MAINNUMBER arte: iwm_articles_new.MAINNUMBER name_ost: IF (iwm_articles_new.LANGBEZEICHNUNG = '', iwm_articles_new.KURZBEZEICHNUNG, iwm_articles_new.LANGBEZEICHNUNG) as name_ost name_tre: IF (iwm_articles_new.LANGBEZEICHNUNG = '', iwm_articles_new.KURZBEZEICHNUNG, iwm_articles_new.LANGBEZEICHNUNG) as name_tre name_oms: IF (iwm_articles_new.LANGBEZEICHNUNG = '', iwm_articles_new.KURZBEZEICHNUNG, iwm_articles_new.LANGBEZEICHNUNG) as name_oms supplier_ost: () supplier_tre: () supplier_oms: () tax: (19.00) price_ost: () price_tre: () price_oms: () shipping_ost: () shipping_tre: () shipping_oms: () pseudoprice_ost: () pseudoprice_tre: () pseudoprice_oms: () purchaseprice: () baseprice: (1) active_ost: (1) active_tre: (1) active_oms: (1) description: () description_long_ost: () description_long_tre: () description_long_oms: () added: Source: IF(iwm_articles_new.ADDED = '', '2020-01-01 00:00:00', iwm_articles_new.ADDED) AS added changed: Source: IF(iwm_articles_new.CHANGED = '', iwm_articles_new.ADDED, iwm_articles_new.CHANGED) AS changed unitID: () # ean: IF (iwm_articles_new_eans_1.EAN = '', iwm_articles_new_eans_3.EAN, iwm_articles_new_eans_1.EAN) as ean variant_ean: iwm_articles_new.variant_ean variant_hbsn: iwm_articles_new.variant_hbsn ean: iwm_articles_new.ean attr9_strip: iwm_articles_new.ean categories: () referenceUnit: (1) purchaseUnit: () metaTitle: () packUnit: () configSetId: (1) configuratorType: () configuratorOptions: () kind: (1) suppliernumber_original: iwm_articles_new.LIEFERANTENNUMMER suppliernumber: iwm_articles_new.LIEFERANTENNUMMER weight: iwm_articles_new.WEIGHT height: () width: iwm_articles_new.WIDTH categoryPath_ost: () categoryPath_tre: () categoryPath_oms: () cat_google_produktart: () cat_google_shop_category: () cat_google: () cat_ebay: () cat_amazon: () propertyGroupName: () propertyValueName: () accessory: () attr1: iwm_articles_new.FIRMA attr2: iwm_articles_new.HWG attr3: iwm_articles_new.UWG attr4: iwm_articles_new.SYSTEMNUMMER attr5: iwm_articles_new.WARENPOOL attr6: () attr7: () attr8: () attr9: iwm_articles_new.HBSN attr10: () attr11: iwm_articles_new.DISPOART attr12: iwm_articles_new.LIEFERZEITINWOCHEN attr13: iwm_articles_new.VERSANDART attr14: () #IWM Versand Addition attr15: () #IWM Versandkosten attr16: () #IWM Montagekosten attr17: () #Textverwendungskennzeichen Mitbewerber Name attr18: iwm_articles_new.ETIKETTENART attr19: () attr20: () #IWM SEO Name - Artikelname angereichert mit weiteren Daten für Produktexporte attr30: () #IWM SEO Name - Artikelname angereichert mit weiteren Daten für Produktexporte attr31: () #IWM SEO Name - Artikelname angereichert mit weiteren Daten für Produktexporte attr36: () attr37: () #shipping costs from dataEngine attr38: () #shipping time from dataEngine attr41: () attr48: () attr50: () attr53: () attr54: () attr55: () attr57: () attr60: () attr61: () attr67: () tpl_color_badge: () swag_attr23: () ItemImageDate: () imageUrl: () LBNTEK: () LBKALK: () LBMARGE: () LBWAEISA: () shippingfree: (0) auslaufkennzeichen: () textilkennzeichen_needed: () textilkennzeichen_text: () has_textilkennzeichen: () pil_needed: () pil_needed_static: () pil_needed_dynamic: () pil_text: () has_pil: () AHLZSD: () ARKMFR: iwm_articles_new.ARKMFR nutschicht: iwm_articles_new.nutschicht stock_witten: () stock_ir: () stock_local: () ahstat: () bestellsperre: () mehrwertsteuerschluesselek: iwm_articles_new.mehrwertsteuerschluesselek mehrwertsteuerschluesselvk: iwm_articles_new.mehrwertsteuerschluesselvk lagernummer: iwm_articles_new.lagernummer koje: iwm_articles_new.koje material: iwm_articles_new.material farbe: dynamic_mapping_colors.COLOR_NAME aufbaukennzeichen: iwm_articles_new.aufbaukennzeichen stil: iwm_articles_new.stil anlieferart: iwm_articles_new.anlieferart 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_kurzbezeichnung: iwm_articles_new.variant_kurzbezeichnung variant_langbezeichnung: iwm_articles_new.variant_langbezeichnung variant_dimension_1: dynamic_mapping_variant_dimensions_AA01.dimension_name_AA01 variant_dimension_2: dynamic_mapping_variant_dimensions_AA02.dimension_name_AA02 variant_dimension_3: dynamic_mapping_variant_dimensions_AA03.dimension_name_AA03 # variant_dimension_1_value: IF (iwm_atab00.ATZUBZ = '', iwm_atab00.ATLABZ, iwm_atab00.ATZUBZ) as variant_dimension_1_value # variant_dimension_2_value: IF (iwm_atab00.ATZUBZ = '', iwm_atab00.ATLABZ, iwm_atab00.ATZUBZ) as variant_dimension_2_value # variant_dimension_3_value: IF (iwm_atab00.ATZUBZ = '', iwm_atab00.ATLABZ, iwm_atab00.ATZUBZ) as variant_dimension_2_value instock: (0) lieferzeit: () konsigniert: iwm_articles_new.konsigniert zeltgut: iwm_articles_new.ZELTGUT datenblatt: () datenblatt_needed: () has_datenblatt: () modellfamilie: () no_packstation: () gpsr_herstellerinfo: () gpsr_verantwortlicher: () ear_marke: () H_Name: () H_Strasse: () H_PLZOrt: () H_Email: () WEEE_RegNr: () aktion_Sonderpreis: () aktion_Gutscheincode: () 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 enev_color: () enev_download: () enev_image: () enev_klasse: () enev_spectrumfrom: () enev_spectrum: () enev_active: () certification: ()
Definition aktualisieren