Engine / Editor
export_articles_plenty-oms
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_Fields: [ordernumber, mainnumber, name_oms, tax, price_oms, pseudoprice_oms, baseprice, active_oms, description, description_long_oms, unitID, ean, categories, referenceUnit, purchaseUnit] #sql select Source_Datapool: articles #sql from 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: Datapool: iwm_properties Join_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma #Mapping -> Mappings source fields are detected by Mapping Mapping: ordernumber: articles.ordernumber mainnumber: Source: articles.mainnumber Field_Adapter: - replace: ['-1', ''] name_ost: Source: articles.name_ost Field_Adapter: - addslashes name_tre: Source: articles.name_tre Field_Adapter: - addslashes name_oms: Source: articles.name_oms Field_Adapter: - addslashes name_bil: Source: articles.name_bil Field_Adapter: - addslashes supplier_ost: Source: articles.supplier_ost Field_Adapter: - addslashes supplier_tre: Source: articles.supplier_tre Field_Adapter: - addslashes supplier_oms: Source: articles.supplier_oms Field_Adapter: - addslashes supplier_bil: Source: articles.supplier_bil Field_Adapter: - addslashes tax: articles.tax kind: articles.kind price_ost: articles.price_ost price_tre: articles.price_tre price_oms: articles.price_oms price_bil: articles.price_bil pseudoprice_ost: articles.pseudoprice_ost pseudoprice_tre: articles.pseudoprice_tre pseudoprice_oms: articles.pseudoprice_oms pseudoprice_bil: articles.pseudoprice_bil active_ost: articles.active_ost active_tre: articles.active_tre active_oms: articles.active_oms active_bil: articles.active_bil categoryPath_ost: Source: articles.categoryPath_ost Field_Adapter: - addslashes categoryPath_tre: Source: articles.categoryPath_tre Field_Adapter: - addslashes categoryPath_oms: Source: articles.categoryPath_oms Field_Adapter: - addslashes categoryPath_bil: Source: articles.categoryPath_bil Field_Adapter: - addslashes configuratorOptions: articles.configuratorOptions description_long_ost: Source: articles.description_long_ost Field_Adapter: - addslashes description_long_tre: Source: articles.description_long_tre Field_Adapter: - addslashes description_long_oms: Source: articles.description_long_oms Field_Adapter: - addslashes description_long_bil: Source: articles.description_long_bil Field_Adapter: - addslashes attr1: articles.attr1 attr2: articles.attr2 attr3: articles.attr3 attr4: articles.attr4 attr5: articles.attr5 attr6: articles.attr6 attr7: articles.attr7 attr8: articles.attr8 attr9: articles.attr9 attr10: articles.attr10 attr11: articles.attr11 attr12: articles.attr12 attr13: articles.attr13 attr14: articles.attr14 attr15: articles.attr15 attr16: articles.attr16 attr17: articles.attr17 attr18: articles.attr18 attr19: articles.attr19 attr20: articles.attr20 swag_attr21: articles.swag_attr21 swag_attr22: Source: articles.swag_attr22 Field_Adapter: - addslashes swag_attr23: articles.swag_attr23 swag_attr24: articles.swag_attr24 swag_attr25: articles.swag_attr25 swag_attr26: articles.swag_attr26 swag_attr27: articles.swag_attr27 swag_attr28: articles.swag_attr28 swag_attr29: articles.swag_attr29 swag_attr30: articles.swag_attr30 ean: articles.ean imageUrl: articles.imageUrl stock_witten: iwm_articles_stock.witten propertyValueName: Source: iwm_properties.propertyValueName Field_Adapter: - replace: ['|',':de;'] weight: Source: articles.weight Field_Adapter: - replace: ['.00', ''] - replace: [',', ''] - simple_division: 1000 listingID: Source: articles.ordernumber Field_Adapter: - replace: ['-', '00'] ebay_active: (1) LBKALK: Source: articles.LBKALK In_Export: no plenty_cat_id: Source: articles.name_oms File_Field_Adapter: Datapool: plenty_cat_ids Identifier: plenty_cat_id Fields: - plenty_cat_id - Level1 - Level2 #Target Datapool: export_articles_plenty_oms #sql table Primary_Key: [ordernumber, attr1] Filters: - Filter: name: Mindestbestand condition: (price_oms < 6) AND (stock_witten < 10) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L') reason: 'Mindestbestand price_ost < 6 AND stock_witten < 10' - Filter: name: 'Mindestbestand' condition: (price_oms < 25) AND (stock_witten < 3) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L') reason: 'Mindestbestand price_ost < 25 AND stock_witten < 3' - Filter: name: 'Mindestbestand' condition: (price_oms < 100) AND (stock_witten < 1) AND (attr2 == 90 or attr2 == 91 or attr2 == 92 or attr2 == 96 or attr2 == 101) AND (attr11 == 'L') reason: 'Mindestbestand price_ost < 100 AND stock_witten < 1' - Filter: name: filter_plenty_oms_suppliers condition: supplier_oms == 'PAIDI' or supplier_oms == 'weber' or supplier_oms == 'vito' or supplier_oms == 'MONDO' or supplier_oms == 'VALMONDO' or supplier_oms == 'LIV´IN' or supplier_oms == 'SELF' or supplier_oms == 'KETTLER' or supplier_oms == 'hülsta' or supplier_oms == 'Kollektion-Wiedemann' or supplier_oms == '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 attr3 == 70 output: positive reason: 'bad calculation: attr2 = 91 AND attr3 = 70' - Filter: name: filter_plenty_oms_kalkulation condition: attr2 == 92 AND attr3 == 54 output: positive reason: 'bad calculation: attr2 = 92 AND attr3 = 54' - Filter: name: filter_plenty_oms_kalkulation condition: (attr11 != 'L') output: positive reason: 'Bestellartikel' - Filter: name: filter_plenty_oms_kalkulation condition: (stock_witten < 1) output: positive reason: 'Bestellartikel' - Filter: name: 'Preis ungueltig' condition: (price_oms == '0') or (price_oms == '') or (price_oms == '0.00') or (price_oms == '0,00') or (price_oms == '0,0') reason: 'alle Preise = 0'
Definition aktualisieren