Legacy YAML export_articles_parents_ost_channeladvisor_bak

Legacy-Definition sicher vergleichen

Diese Detailansicht zeigt den unveränderten Legacy-Dateistand. Von hier aus lässt sich die Definition als Draft in die Workbench übernehmen und dort weiter bearbeiten, ohne das Original im Dateisystem anzutasten.

Zum Raw YAML Zu den Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

export_articles_parents_ost_channeladvisor Kurzinfo

Raw YAML

Dateiinhalt

Der Inhalt wird read-only aus dem Legacy-Dateisystem geladen. Bearbeitbar wird er erst nach dem Import in die Workbench.

#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


Read_Conditions:  #sql where - Read-Filter
  - articles.attr1 = 1 AND articles.active_ost = 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
 supplier_number: 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
 iwm_versandkosten: VARCHAR(255) DEFAULT NULL
 montagekosten: VARCHAR(255) DEFAULT NULL
 textverwendungskennzeichen_mitbewerber_name: VARCHAR(255) DEFAULT NULL
 etikettenart: VARCHAR(255) DEFAULT NULL
 weight: VARCHAR(255) 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(40) DEFAULT NULL
 Korpus: VARCHAR(40) DEFAULT NULL
 Anschlag: VARCHAR(40) DEFAULT NULL
 Varianten: VARCHAR(40) DEFAULT NULL
 Holzart: VARCHAR(40) 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
 Design: VARCHAR(40) DEFAULT NULL
 Energieeffizienzklasse: VARCHAR(40) DEFAULT NULL
 Farbe: VARCHAR(40) 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

#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_ost_channeladvisor.relationship_name
 title:
  Source: articles.name_ost
 description:
  Source: articles.description_long_ost
  Field_Adapter:
      - replace: [';', '']
 stock: ()
 category:
   Source: shopware_article_info.category
 ean: ()
 product_condition: (new)
 shipping: shopware_article_info.shipping
 supplier:
  Source: articles.supplier_ost
 tax:
  Source: articles.tax
 price_VK: ()
 pseudoprice_VK: ()
 supplier_number: articles.suppliernumber
 active:
   Source: articles.active_ost
   In_Export: no
 configurator_options:
   Source: articles.configuratorOptions
 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: [';', '']
 montagekosten:
     Source: articles.attr16
     Field_Adapter:
       - replace: [';', '']
 textverwendungskennzeichen_mitbewerber_name:
     Source: articles.swag_attr24
     Field_Adapter:
       - replace: [';', '']
 etikettenart:
     Source: articles.attr18
     Field_Adapter:
       - replace: [';', '']
 document_id:
     Source: articles.attr19
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 iwm_seo_name:
     Source: articles.name_oms
     Field_Adapter:
       - replace: [';', '']
     In_Export: no
 weight:
  Source: articles.weight
  Field_Adapter:
    - replace: ['.00', '']
    - replace: [',', '']
    - simple_division: 1000
 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
 Liegeflaeche:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Liegefläche:.*\|/']
    - explode: [':','1'] #explode by : and get Array[1]
    - trim: ' |' #trim with space
 Haertegrad:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Härtegrad:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Bezug:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Dessin:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Dessin:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Fuss:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Fuß:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Tischplatte:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Tischplatte:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Gestellfarbe:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Gestellfarbe:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Front:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Front:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Korpus_und_Arbeitsplatte:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Korpus und Arbeitsplatte:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Anschlag:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Anschlag:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Varianten:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Varianten:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Holzart:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Holzart:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Kissenbezug:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug Kissen:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Sitzschale:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitzschale:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Oberflaeche:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Oberfläche:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Fussform:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Fußform:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Farbvariante:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Farbe:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Sitz:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitz:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Gestell:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Gestell:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Materialvariante:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Material:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Bezug1:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug 1:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Bezug2:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug 2:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Rueckenlehne:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Rückenlehne:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Polsterung:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Polsterung:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Kontrastnaht:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Kontrastnaht:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Leder:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Leder:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Holzausfuehrung:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Holzausführung:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Sitzhoehe:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitzhöhe:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Nahtart:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Nahtart:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Korpus:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Korpus:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Griff:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Griff:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Funktion:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Funktion:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Armlehne:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Armlehne:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Ruecken:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Rücken:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Korpusbezug:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug Korpus:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Sitz_und_Kissen:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitz und Kissen:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Arbeitsplatte:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Arbeitsplatte:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Innenkorpus:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Innenkorpus:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Applikationsfarbe:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Applikationsfarbe:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Wangenform:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Wangenform:.*\|/']
    - explode: [':','1']
    - trim: ' |'
 Tischsaeule:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Tischsäule:.*\|/']
    - explode: [':','1']
    - trim: ' |'


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_ost < 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_ost_channeladvisor__filterNonParents
    reason: 'no parent article'

#Target
Datapool: export_articles_parents_ost_channeladvisor #sql table
Primary_Key: [sku]

Source

Datei und Status

Dateipfad: /srv/app/backend/export/exportEngines/export_articles_parents_ost_channeladvisor_bak.yaml
Runner: export
Feature Flags: Datapool_Definition, Field_Adapter, File_Field_Adapter, Filters, Mapping, Read_Conditions
Connections: enhanceEngine, exportEngine

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Source_Config	enhanceEngine
Target_Config	exportEngine
Source_Datapool	articles
Mysql_Engine	InnoDB
Default_Charset	latin1
Joins	[ { "Left_Join": null, "Datapool": "iwm_articles_stock", "Join_Condition": "articles.ordernumber = iwm_articles_stock.ordernumber AND articles.attr1 = iwm_articles_stock.firma" }, { "Left_Join": null, "Datapool": "shopware_article_info", "Join_Condition": "articles.ordernumber = shopware_article_info.ordernumber" } ]
Read_Conditions	[ "articles.attr1 = 1 AND articles.active_ost = 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", "supplier_number": "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", "iwm_versandkosten": "VARCHAR(255) DEFAULT NULL", "montagekosten": "VARCHAR(255) DEFAULT NULL", "textverwendungskennzeichen_mitbewerber_name": "VARCHAR(255) DEFAULT NULL", "etikettenart": "VARCHAR(255) DEFAULT NULL", "weight": "VARCHAR(255) 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(40) DEFAULT NULL", "Korpus": "VARCHAR(40) DEFAULT NULL", "Anschlag": "VARCHAR(40) DEFAULT NULL", "Varianten": "VARCHAR(40) DEFAULT NULL", "Holzart": "VARCHAR(40) 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", "Design": "VARCHAR(40) DEFAULT NULL", "Energieeffizienzklasse": "VARCHAR(40) DEFAULT NULL", "Farbe": "VARCHAR(40) 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" }
Mapping	{ "sku": { "Source": "articles.mainnumber" }, "variation_parent_sku": "(Parent)", "relationship_name": { "Source": "articles.configuratorOptions", "File_Field_Adapter": { "File": "export_articles_parents_ost_channeladvisor.relationship_name" } }, "title": { "Source": "articles.name_ost" }, "description": { "Source": "articles.description_long_ost", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "stock": "()", "category": { "Source": "shopware_article_info.category" }, "ean": "()", "product_condition": "(new)", "shipping": "shopware_article_info.shipping", "supplier": { "Source": "articles.supplier_ost" }, "tax": { "Source": "articles.tax" }, "price_VK": "()", "pseudoprice_VK": "()", "supplier_number": "articles.suppliernumber", "active": { "Source": "articles.active_ost", "In_Export": "no" }, "configurator_options": { "Source": "articles.configuratorOptions" }, "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": [ ";", "" ] } ] }, "montagekosten": { "Source": "articles.attr16", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "textverwendungskennzeichen_mitbewerber_name": { "Source": "articles.swag_attr24", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "etikettenart": { "Source": "articles.attr18", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "document_id": { "Source": "articles.attr19", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "iwm_seo_name": { "Source": "articles.name_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ], "In_Export": "no" }, "weight": { "Source": "articles.weight", "Field_Adapter": [ { "replace": [ ".00", "" ] }, { "replace": [ ",", "" ] }, { "simple_division": 1000 } ] }, "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" }, "Liegeflaeche": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Liegefl\u00e4che:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Haertegrad": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/H\u00e4rtegrad:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Bezug": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Dessin": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Dessin:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Fuss": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Fu\u00df:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Tischplatte": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Tischplatte:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Gestellfarbe": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Gestellfarbe:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Front": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Front:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Korpus_und_Arbeitsplatte": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Korpus und Arbeitsplatte:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Anschlag": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Anschlag:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Varianten": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Varianten:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Holzart": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Holzart:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Kissenbezug": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug Kissen:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Sitzschale": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitzschale:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Oberflaeche": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Oberfl\u00e4che:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Fussform": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Fu\u00dfform:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Farbvariante": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Farbe:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Sitz": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitz:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Gestell": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Gestell:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Materialvariante": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Material:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Bezug1": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug 1:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Bezug2": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug 2:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Rueckenlehne": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/R\u00fcckenlehne:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Polsterung": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Polsterung:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Kontrastnaht": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Kontrastnaht:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Leder": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Leder:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Holzausfuehrung": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Holzausf\u00fchrung:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Sitzhoehe": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitzh\u00f6he:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Nahtart": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Nahtart:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Korpus": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Korpus:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Griff": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Griff:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Funktion": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Funktion:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Armlehne": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Armlehne:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Ruecken": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/R\u00fccken:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Korpusbezug": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug Korpus:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Sitz_und_Kissen": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitz und Kissen:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Arbeitsplatte": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Arbeitsplatte:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Innenkorpus": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Innenkorpus:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Applikationsfarbe": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Applikationsfarbe:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Wangenform": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Wangenform:.\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] }, "Tischsaeule": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Tischs\u00e4ule:.*\\\|\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " \|" } ] } }
Filters	[ { "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_ost < 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\u00b4IN' or supplier == 'SELF' or supplier == 'KETTLER' or supplier == 'h\u00fclsta' 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", "condition": { "Cross_Dataset_Filter_Adapter": "export_articles_parents_ost_channeladvisor__filterNonParents" }, "reason": "no parent article" } } ]
Datapool	export_articles_parents_ost_channeladvisor
Primary_Key	[ "sku" ]