Engine / Editor
export_articles_oms_channeladvisor_export_fuer_oliver
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
export
Runner
1
Revisionen
Editor
Engine bearbeiten
Definitionstyp
Runner-Typ
Name
Titel
Status
draft
active
archived
YAML-Inhalt
#Connections Source_Config: enhanceEngine #config - credetials of source connection service Target_Config: exportEngine #config - credentials of target connection service #Source Source_Datapool: articles #sql from Mysql_Engine: InnoDB Default_Charset: latin1 Joins: - Left_Join: #each condition is joined with "AND" Datapool: iwm_articles_stock Join_Condition: articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma # One row per JOIN - Left_Join: #each condition is joined with "AND" Datapool: shopware_article_info Join_Condition: articles.ordernumber = shopware_article_info.ordernumber and shopware_article_info.shop = 'oms' # One row per JOIN - Left_Join: #each condition is joined with "AND" Datapool: iwm_properties_3 Join_Condition: articles.ordernumber = iwm_properties_3.ordernumber AND articles.attr1 = iwm_properties_3.firma Read_Conditions: #sql where - Read-Filter - articles.active_oms = 1 Order_By: ordernumber, mainnumber ASC Datapool_Definition: sku: VARCHAR(255) NOT NULL variation_parent_sku: VARCHAR(255) DEFAULT NULL relationship_name: VARCHAR(255) DEFAULT NULL title: VARCHAR(255) DEFAULT NULL firma: VARCHAR(2) NOT NULL description: TEXT DEFAULT NULL stock: VARCHAR(255) DEFAULT NULL category: VARCHAR(500) DEFAULT NULL ean: VARCHAR(255) DEFAULT NULL product_condition: VARCHAR(255) DEFAULT NULL shipping: VARCHAR(255) DEFAULT NULL supplier: VARCHAR(255) DEFAULT NULL tax: VARCHAR(255) DEFAULT NULL price_VK: VARCHAR(255) DEFAULT NULL pseudoprice_VK: VARCHAR(255) DEFAULT NULL versandkosten_berechnet: VARCHAR(255) DEFAULT NULL herstellerartikelnummer: VARCHAR(255) DEFAULT NULL dispositionsart: VARCHAR(255) DEFAULT NULL lieferzeitinwochen: VARCHAR(255) DEFAULT NULL versandart: VARCHAR(255) DEFAULT NULL versandkosten_addition: VARCHAR(255) DEFAULT NULL textverwendungskennzeichen_mitbewerber_name: VARCHAR(255) DEFAULT NULL configurator_options: VARCHAR(255) DEFAULT NULL weight: VARCHAR(255) DEFAULT NULL imageUrl: VARCHAR(500) DEFAULT NULL Liegeflaeche: VARCHAR(40) DEFAULT NULL Haertegrad: VARCHAR(40) DEFAULT NULL Bezug: VARCHAR(50) DEFAULT NULL Dessin: VARCHAR(40) DEFAULT NULL Fuss: VARCHAR(40) DEFAULT NULL Tischplatte: VARCHAR(40) DEFAULT NULL Gestellfarbe: VARCHAR(40) DEFAULT NULL Front: VARCHAR(100) DEFAULT NULL Korpus: VARCHAR(40) DEFAULT NULL Anschlag: VARCHAR(40) DEFAULT NULL Varianten: VARCHAR(200) DEFAULT NULL Holzart: VARCHAR(100) DEFAULT NULL Kissenbezug: VARCHAR(50) DEFAULT NULL Sitzschale: VARCHAR(40) DEFAULT NULL Oberflaeche: VARCHAR(40) DEFAULT NULL Fussform: VARCHAR(40) DEFAULT NULL Groesse: VARCHAR(40) DEFAULT NULL Mass: VARCHAR(40) DEFAULT NULL Fussfarbe: VARCHAR(40) DEFAULT NULL Farbvariante: VARCHAR(40) DEFAULT NULL Sitz: VARCHAR(40) DEFAULT NULL Gestell: VARCHAR(40) DEFAULT NULL Materialvariante: VARCHAR(40) DEFAULT NULL Bezug1: VARCHAR(40) DEFAULT NULL Bezug2: VARCHAR(40) DEFAULT NULL Rueckenlehne: VARCHAR(40) DEFAULT NULL Polsterung: VARCHAR(40) DEFAULT NULL Kontrastnaht: VARCHAR(40) DEFAULT NULL Leder: VARCHAR(40) DEFAULT NULL Holzausfuehrung: VARCHAR(40) DEFAULT NULL Sitzhoehe: VARCHAR(40) DEFAULT NULL Nahtart: VARCHAR(40) DEFAULT NULL Korpus_und_Arbeitsplatte: VARCHAR(40) DEFAULT NULL Griff: VARCHAR(40) DEFAULT NULL Funktion: VARCHAR(40) DEFAULT NULL Armlehne: VARCHAR(40) DEFAULT NULL Ruecken: VARCHAR(40) DEFAULT NULL Korpusbezug: VARCHAR(40) DEFAULT NULL Sitz_und_Kissen: VARCHAR(40) DEFAULT NULL Arbeitsplatte: VARCHAR(40) DEFAULT NULL Innenkorpus: VARCHAR(40) DEFAULT NULL Applikationsfarbe: VARCHAR(40) DEFAULT NULL Wangenform: VARCHAR(40) DEFAULT NULL Tischsaeule: VARCHAR(40) DEFAULT NULL Abmessung: VARCHAR(40) DEFAULT NULL Durchmesser: VARCHAR(40) DEFAULT NULL Laenge: VARCHAR(40) DEFAULT NULL Breite: VARCHAR(40) DEFAULT NULL Tiefe: VARCHAR(40) DEFAULT NULL Hoehe: VARCHAR(40) DEFAULT NULL Design: VARCHAR(40) DEFAULT NULL Energieeffizienzklasse: VARCHAR(40) DEFAULT NULL Farbe: VARCHAR(200) DEFAULT NULL Farbtemperatur: VARCHAR(40) DEFAULT NULL Fassung: VARCHAR(40) DEFAULT NULL Flaechengewicht: VARCHAR(40) DEFAULT NULL Fleachengewicht_exakt: VARCHAR(40) DEFAULT NULL Florhoehe: VARCHAR(40) DEFAULT NULL Florhoehe_exakt: VARCHAR(40) DEFAULT NULL Form: VARCHAR(40) DEFAULT NULL fuer_Fussbodenheizung_geeignet: VARCHAR(40) DEFAULT NULL Gesamtgewicht: VARCHAR(40) DEFAULT NULL Leistung: VARCHAR(40) DEFAULT NULL Lichtstrom: VARCHAR(40) DEFAULT NULL Material: VARCHAR(40) DEFAULT NULL Muster: VARCHAR(40) DEFAULT NULL Raum: VARCHAR(40) DEFAULT NULL Stil: VARCHAR(40) DEFAULT NULL Typ: VARCHAR(40) DEFAULT NULL Produktart: VARCHAR(255) DEFAULT NULL Synonyme: VARCHAR(255) DEFAULT NULL sortiert: VARCHAR(255) DEFAULT NULL Bulletpoints: VARCHAR(255) DEFAULT NULL active_ebay: INT(1) DEFAULT NULL active_amazon: INT(1) DEFAULT NULL Labels: VARCHAR(255) DEFAULT NULL #Mapping -> Mappings source fields are detected by Mapping Mapping: sku: Source: articles.ordernumber variation_parent_sku: Source: articles.mainnumber File_Field_Adapter: File: export_articles_oms_channeladvisor.variation_parent_sku relationship_name: Source: articles.configuratorOptions File_Field_Adapter: File: export_articles_oms_channeladvisor.relationship_name description: Source: articles.description_long_oms Field_Adapter: - replace: [';', ''] File_Field_Adapter: File: export_articles_oms_channeladvisor.description category: Source: shopware_article_info.category ean: articles.ean product_condition: (new) shipping: shopware_article_info.shipping supplier: Source: articles.supplier_oms tax: Source: articles.tax price_VK: Source: articles.price_oms Field_Adapter: - replace: [',', ''] - replace: ['.', ','] pseudoprice_VK: Source: articles.pseudoprice_oms Field_Adapter: - replace: [',', ''] - replace: ['.', ','] supplier_number: Source: articles.suppliernumber In_Export: no active: Source: articles.active_oms In_Export: no configurator_options: Source: articles.configuratorOptions weight: Source: articles.weight Field_Adapter: - replace: ['.00', ''] - replace: [',', ''] - simple_division: 1000 imageUrl: Source: articles.imageUrl firma: Source: articles.attr1 Field_Adapter: - replace: [';', ''] attr2: Source: articles.attr2 Field_Adapter: - replace: [';', ''] In_Export: no unterwarengruppe: Source: articles.attr3 Field_Adapter: - replace: [';', ''] In_Export: no systemnummer: Source: articles.attr4 Field_Adapter: - replace: [';', ''] In_Export: no warenpool: Source: articles.attr5 Field_Adapter: - replace: [';', ''] In_Export: no metatext: Source: articles.swag_attr22 Field_Adapter: - replace: [';', ''] In_Export: no typenplan_id: Source: articles.attr7 Field_Adapter: - replace: [';', ''] In_Export: no versandkosten_berechnet: Source: articles.attr8 Field_Adapter: - replace: [';', ''] herstellerartikelnummer: Source: articles.attr9 Field_Adapter: - replace: [';', ''] textverwendungskennzeichen_hersteller_name: Source: articles.swag_attr25 Field_Adapter: - replace: [';', ''] In_Export: no dispositionsart: Source: articles.attr11 Field_Adapter: - replace: [';', ''] lieferzeitinwochen: Source: articles.attr12 Field_Adapter: - replace: [';', ''] versandart: Source: articles.attr13 Field_Adapter: - replace: [';', ''] versandkosten_addition: Source: articles.attr14 Field_Adapter: - replace: [';', ''] iwm_versandkosten: Source: articles.attr15 Field_Adapter: - replace: [';', ''] In_Export: no montagekosten: Source: articles.attr16 Field_Adapter: - replace: [';', ''] In_Export: no textverwendungskennzeichen_mitbewerber_name: Source: articles.swag_attr24 Field_Adapter: - replace: [';', ''] etikettenart: Source: articles.attr18 Field_Adapter: - replace: [';', ''] In_Export: no document_id: Source: articles.attr19 Field_Adapter: - replace: [';', ''] In_Export: no iwm_seo_name: Source: articles.name_oms Field_Adapter: - replace: [';', ''] In_Export: no kind: Source: articles.kind In_Export: no shippingfree: Source: articles.shippingfree In_Export: no LBKALK: Source: articles.LBKALK In_Export: no stock_witten: Source: iwm_articles_stock.witten In_Export: no stock_ir: Source: articles.stock_ir In_Export: no stock: Source: iwm_articles_stock.witten Field_Adapter: - replace_empty: '0' File_Field_Adapter: File: export_articles_oms_channeladvisor.stock Liegeflaeche: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Liegefläche:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] #explode by : and get Array[1] - trim: ' |' #trim with space Haertegrad: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Härtegrad:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Bezug: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Dessin: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Dessin:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fuss: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Fuß:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Tischplatte: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Tischplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Gestellfarbe: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Gestellfarbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Front: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Front:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Korpus_und_Arbeitsplatte: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Korpus und Arbeitsplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Anschlag: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Anschlag:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Varianten: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Varianten:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Holzart: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Holzart:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Kissenbezug: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug Kissen:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitzschale: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitzschale:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Oberflaeche: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Oberfläche:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fussform: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Fußform:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Farbvariante: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitz: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitz:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Gestell: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Gestell:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Materialvariante: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Bezug1: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug 1:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Bezug2: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug 2:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Rueckenlehne: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Rückenlehne:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Polsterung: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Polsterung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Kontrastnaht: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Kontrastnaht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Leder: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Leder:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Holzausfuehrung: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Holzausführung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitzhoehe: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitzhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Nahtart: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Nahtart:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Korpus: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Korpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Griff: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Griff:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Funktion: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Funktion:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Armlehne: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Armlehne:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Ruecken: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Rücken:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Korpusbezug: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Bezug Korpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Sitz_und_Kissen: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Sitz und Kissen:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Arbeitsplatte: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Arbeitsplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Innenkorpus: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Innenkorpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Applikationsfarbe: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Applikationsfarbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Wangenform: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Wangenform:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Tischsaeule: Source: articles.configuratorOptions Field_Adapter: - get_preg_match: ['/Tischsäule:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Abmessung: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Design: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Design:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Energieeffizienzklasse: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Energieeffizienzklasse:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Farbe: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Farbtemperatur: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Farbtemperatur:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fassung: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Fassung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Flaechengewicht: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Flächengewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Fleachengewicht_exakt: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Flächengewicht exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Florhoehe: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Florhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Florhoehe_exakt: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Florhöhe exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Form: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Form:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' fuer_Fussbodenheizung_geeignet: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/für Fußbodenheizung geeignet:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Gesamtgewicht: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Gesamtgewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Leistung: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Leistung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Lichtstrom: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Lichtstrom:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Material: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Muster: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Muster:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Raum: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Raum:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Stil: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Stil:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Typ: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Typ:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] - explode: [':','1'] - trim: ' |' Durchmesser: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channeladvisor.Durchmesser Laenge: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channeladvisor.Laenge Breite: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channeladvisor.Breite Hoehe: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channeladvisor.Hoehe Tiefe: Source: iwm_properties_3.propertyValueName Field_Adapter: - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/'] File_Field_Adapter: File: export_articles_oms_channeladvisor.Tiefe Produktart: Source: articles.name_oms Field_Adapter: - explode: [' ','0'] Synonyme: Source: articles.swag_attr24 sortiert: Source: articles.swag_attr26 title: Source: articles.name_oms File_Field_Adapter: File: export_articles_oms_channeladvisor.title Bulletpoints: Source: articles.name_oms File_Field_Adapter: File: export_articles_oms_channeladvisor.Bulletpoints active_amazon: Source: articles.configuratorOptions File_Field_Adapter: File: export_articles_oms_channeladvisor.active_amazon active_ebay: Source: articles.configuratorOptions File_Field_Adapter: File: export_articles_oms_channeladvisor.active_ebay Labels: Source: articles.configuratorOptions File_Field_Adapter: File: export_articles_oms_channeladvisor.Labels Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out) - Filter: name: 'Preis ungueltig' condition: (price_VK == '0') or (price_VK == '') or (price_VK == '0.00') or (price_VK == '0,00') or (price_VK == '0,0') reason: 'alle Preise = 0' - Filter: name: 'inactive for all platforms' condition: (active_ebay == 0) and (active_amazon == 0) reason: 'inactive for all platforms' - Filter: name: 'LBKALK < 50' condition: (LBKALK < 50) reason: 'LBKALK < 50' - Filter: name: '(LBKALK < 70) and (attr2 == 10)' condition: (LBKALK < 70) and (attr2 == '10') reason: '(LBKALK < 70) and (attr2 == 10)' - Filter: name: '(LBKALK < 70) and (attr2 == 20)' condition: (LBKALK < 70) and (attr2 == '20') reason: '(LBKALK < 70) and (attr2 == 20)' - Filter: name: '(LBKALK < 70) and (attr2 == 29)' condition: (LBKALK < 70) and (attr2 == '29') reason: '(LBKALK < 70) and (attr2 == 29)' - Filter: name: '(LBKALK < 70) and (attr2 == 30)' condition: (LBKALK < 70) and (attr2 == '30') reason: '(LBKALK < 70) and (attr2 == 30)' - Filter: name: '(LBKALK < 70) and (attr2 == 40)' condition: (LBKALK < 70) and (attr2 == '40') reason: '(LBKALK < 70) and (attr2 == 40)' - Filter: name: '(attr2 == 63)' condition: (attr2 == '63') reason: '(attr2 == 63)' - Filter: name: '(attr2 == 97)' condition: (attr2 == '97') reason: '(attr2 == 97)' - Filter: name: '(attr2 == 91) and (unterwarengruppe == 70)' condition: (attr2 == '91') and (unterwarengruppe == '70') reason: '(attr2 == 91) and (unterwarengruppe == 70)' - Filter: name: '(stock_witten < 1)' condition: (stock_witten < 1) reason: '(stock_witten < 1)' - Filter: name: '(dispositionsart != L)' condition: (dispositionsart != 'L') reason: '(dispositionsart != L)' - Filter: name: '(attr2 == 91) and (price_VK <= 25)' condition: (attr2 == '91') and (price_VK <= 25) reason: '(attr2 == 91) and (price_VK <= 25)' - Filter: name: Wiederbeschaffungszeit condition: (lieferzeitinwochen > 6) AND (dispositionsart == L) AND (stock == 0) AND (attr2 > 89) reason: '(lieferzeitinwochen > 6) AND (dispositionsart == L) AND (stock == 0) AND (attr2 > 89)' - Filter: name: 'Wiederbeschaffungszeit' condition: (lieferzeitinwochen > 4) AND (dispositionsart == 'L') AND ('stock' == 0) AND (supplier == 'Casa Nova') reason: 'Wiederbeschaffungszeit' - Filter: name: filter_suppliers condition: supplier == 'PAIDI' or supplier == 'weber' or supplier == 'vito' or supplier == 'MONDO' or supplier == 'VALMONDO' or supplier == 'LIV´IN' or supplier == 'SELF' or supplier == 'KETTLER' or supplier == 'hülsta' or supplier == 'Kollektion-Wiedemann' or supplier == 'ROLF BENZ' output: positive reason: 'excluded supplier' # - Filter: # name: 'inactive for all platforms' # condition: (active_ebay == 0) and (active_amazon == 0) # reason: 'inactive for all platforms' # - Filter: # name: 'keine Leuchte' # condition: (attr2 != 91) and (attr2 != 92) and (attr2 != 93) and (attr2 != 96) and (attr2 != 103) and (attr2 != 81) # reason: 'keine Leuchte' - Filter: name: 'channelfilter moebel-shop.de -> Artikel, die auf moebel-shop.de nicht sind, bekommen sonst bei den Rückimportfeldern keine Kategorie und keine Versandkosten' condition: In_Pool_Filter_Adapter: Config: importEngine Datapool: static_filter_inactive_articles_oms Reason_Key: reason Mapping: #left is from current datapool, right from filter datapool supplier_number: supplier_number supplier: supplier_name sku: ordernumber firma: attr1 attr2: attr2 unterwarengruppe: attr3 systemnummer: attr4 dispositionsart: attr11 lieferzeitinwochen: attr12 price_VK: price stock: stock stock_witten: stock_witten title: name description: description - Filter: name: 'Artikeldeaktivierung Gesamtmengenfilter' condition: In_Pool_Filter_Adapter: Config: importEngine Datapool: static_filter_inactive_articles_oms_channeladvisor Reason_Key: reason Mapping: #left is from current datapool, right from filter datapool supplier_number: supplier_number supplier: supplier_name sku: ordernumber firma: attr1 attr2: attr2 unterwarengruppe: attr3 systemnummer: attr4 dispositionsart: attr11 lieferzeitinwochen: attr12 price_VK: price stock: stock stock_witten: stock_witten title: name description: description sortiert: sortiert #Target Datapool: export_articles_oms_channeladvisor #sql table Primary_Key: [sku, firma]
Definition aktualisieren