export / export_articles_parents_oms_channeladvisor_test

#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]