Engine / Editor
export_articles_parents_oms_channeladvisor_test
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 # One row per JOIN - Left_Join: Datapool: export_for_dataengine Join_Condition: articles_new.ordernumber = export_for_dataengine.ordernumber AND export_for_dataengine.shop = 'oms' Read_Conditions: #sql where - Read-Filter - articles.active_oms = 1 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 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 configurator_options: 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 weight: VARCHAR(255) DEFAULT NULL #Mapping -> Mappings source fields are detected by Mapping Mapping: sku: Source: articles.mainnumber variation_parent_sku: (Parent) relationship_name: Source: articles.configuratorOptions File_Field_Adapter: File: export_articles_parents_oms_channeladvisor.relationship_name title: Source: articles.name_oms description: Source: articles.description_long_oms Field_Adapter: - replace: [';', ''] stock: () category: Source: export_for_dataengine.category ean: () product_condition: (new) shipping: export_for_dataengine.shipping supplier: Source: articles.supplier_oms tax: Source: articles.tax price_VK: () pseudoprice_VK: () 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 firma: Source: articles.attr1 Field_Adapter: - replace: [';', ''] In_Export: no 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: [';', ''] In_Export: no 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 Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out) - Filter: name: Mindestbestand condition: (price_VK < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (dispositionsart == 'L') reason: 'Mindestbestand price_oms < 6 AND stock_witten < 10' - Filter: name: 'Mindestbestand' condition: (price_VK < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (dispositionsart == 'L') reason: 'Mindestbestand price_ost < 25 AND stock_witten < 3' - Filter: name: 'Mindestbestand' condition: (price_VK < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (dispositionsart == 'L') reason: 'Mindestbestand price_ost < 100 AND stock_witten < 1' - 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: 'Zu lange Lieferzeit' condition: (dispositionsart == 'L') and (lieferzeitinwochen > 6) and (stock == 0) and (attr2 > 89) reason: 'Zu lange Lieferzeit' - Filter: name: 'Zu lange Lieferzeit Suppliernumber 782577' condition: (dispositionsart == 'L') and (lieferzeitinwochen > 4) and (stock == 0) and (supplier == 'Casa Nova') reason: 'Zu lange Lieferzeit Suppliernumber 782577' - 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: filter_plenty_oms_kalkulation condition: attr2 == 63 OR attr2 == 97 output: positive reason: 'bad calculation: attr2 = 63 OR attr2 = 97 ok' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 50 output: positive reason: 'bad calculation: LBKALK < 60' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 70 AND attr2 == 10 output: positive reason: 'bad calculation: LBKALK < 80 AND attr2 = 10' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 70 AND attr2 == 20 output: positive reason: 'bad calculation: LBKALK < 80 AND attr2 = 20' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 70 AND attr2 == 29 output: positive reason: 'bad calculation: LBKALK < 80 AND attr2 = 29' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 70 AND attr2 == 30 output: positive reason: 'bad calculation: LBKALK < 80 AND attr2 = 30' - Filter: name: filter_plenty_oms_kalkulation condition: LBKALK < 70 AND attr2 == 40 output: positive reason: 'bad calculation: LBKALK < 80 AND attr2 = 40' - Filter: name: filter_plenty_oms_kalkulation condition: attr2 == 91 AND unterwarengruppe == 70 output: positive reason: 'bad calculation: attr2 = 91 AND attr3 = 70' - Filter: name: filter_plenty_oms_kalkulation condition: attr2 == 92 AND unterwarengruppe == 54 output: positive reason: 'bad calculation: attr2 = 92 AND attr3 = 54' - Filter: name: filter_plenty_oms_kalkulation condition: (dispositionsart != 'L') output: positive reason: 'Bestellartikel' - Filter: name: filter_plenty_oms_kalkulation condition: (stock_witten < 1) output: positive reason: 'Bestellartikel' - Filter: name: no parent article #there must always be a space between the key and the comparision operator and between the parentheses condition: Cross_Dataset_Filter_Adapter: export_articles_parents_oms_channeladvisor__filterNonParents reason: 'no parent article' #Target Datapool: export_articles_parents_oms_channeladvisor #sql table Primary_Key: [sku]
Definition aktualisieren