export / export_articles_oms_neocom

#Connections
Source_Config: enhanceEngine #config - credetials of source connection service
Target_Config: exportEngine #config - credentials of target connection service

#Source
Source_Datapool: articles_new  #sql from

Mysql_Engine: InnoDB
Default_Charset: latin1

Joins:
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_articles_stock
  Join_Condition: articles_new.ordernumber = iwm_articles_stock.ordernumber AND articles_new.attr1 = iwm_articles_stock.firma # One row per JOIN
- Left_Join: #each condition is joined with "AND"
  Datapool: shopware_article_info
  Join_Condition: articles_new.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_articles_properties
  Join_Condition: articles_new.ordernumber = iwm_articles_properties.ordernumber AND articles_new.attr1 = iwm_articles_properties.firma

#Read_Conditions:  #sql where - Read-Filter
#  - articles_new.attr1 = 1 AND ((articles_new.attr2 = 91) OR (articles_new.attr2 = 96) or (articles_new.attr2 = 79) or (articles_new.attr2 = 30) or (articles_new.attr2 = 70)or (articles_new.attr2 = 40))

Read_Conditions:
  #- articles_new.attr2 = 79  #old condition
  - Read_Condition:
      name: 'neocom_read_conditions'
      condition:  #new condition
        In_Pool_Condition_Adapter:
          Config: importEngine
          Datapool: static_readconditions_neocom
          Reason_Key: reason
          Mapping:   #left is from current datapool, right from filter datapool
            swag_attr27: Produktart  #although the field is also named "Produktart" in this export, "attr27" must be matched cause it is a read condition of source pool fields in sql where clause
         #   attr1: firma



Order_By: ordernumber, mainnumber ASC


Mapping_Vars:
  shop: 'oms'

#Mapping -> Mappings source fields are detected by Mapping
Mapping:
  Include_Mapping_export_neocom: export_neocom




Filters: #In-Memory-Filter (Write-Filter) -> datasets matched by the filter condition are not in the result set (they are filtered out)
 - Include_Filter: prices_equals_0
 - Filter:
    name: 'channelfilter moebel-shop.de -> Artikel, die auf moebel-shop.de nicht sind, bekommen sonst bei den Rückimportfeldern keine Kategorie und keine Versandktreen'
    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
         ordernumber: ordernumber
         firma: attr1
         attr2: attr2
         unterwarengruppe: attr3
         systemnummer: attr4
         dispositionsart: attr11
         lieferzeitinwochen: attr12
         price: price
         stock: stock
         stock_witten: stock_witten
         title: name
         description: description
         auslaufkennzeichen: auslauf
         bestellsperre: bestellsperre



#Target
Datapool: export_articles_oms_neocom #sql table
Primary_Key: [ordernumber, firma]