Legacy YAML / Detail

export / export_articles_oms_channeladvisor_test

Unveränderter Legacy-Dateistand mit sicherem Importpfad in die Workbench und direkter Sicht auf Roh-YAML, Metadaten und erkannte Features.

RLS aktiv Host ortho-live
Zurück zum Browser
Managed Definition öffnen

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_oms_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
- Left_Join: #each condition is joined with "AND"
  Datapool: iwm_properties
  Join_Condition: articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma

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.ordernumber
 variation_parent_sku:
  Source: articles.mainnumber
 relationship_name:
   Source: articles.configuratorOptions
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.relationship_name
 title:
  Source: articles.name_oms
 description:
  Source: articles.description_long_oms
  Field_Adapter:
      - replace: [';', '']
 stock:
   Source: iwm_articles_stock.stock
   Field_Adapter:
     - replace_empty: '0'
 category:
   Source: shopware_article_info.category
 ean: articles.ean
 product_condition: (new)
 shipping: shopware_article_info.shipping
 supplier:
  Source: articles.supplier_oms
 tax:
  Source: articles.tax
 price_VK:
  Source: articles.price_oms
  Field_Adapter:
    - replace: [',', '']
    - replace: ['.', ',']
 pseudoprice_VK:
   Source: articles.pseudoprice_oms
   Field_Adapter:
     - replace: [',', '']
     - replace: ['.', ',']
 supplier_number:
   Source: articles.suppliernumber
   In_Export: no
 active:
   Source: articles.active_oms
   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: [';', '']
     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
 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:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1'] #explode by : and get Array[1]
    - trim: ' |' #trim with space
   In_Export: no
 Haertegrad:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Härtegrad:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Bezug:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Dessin:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Dessin:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Fuss:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Fuß:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Tischplatte:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Tischplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Gestellfarbe:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Gestellfarbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Front:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Front:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Korpus_und_Arbeitsplatte:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Korpus und Arbeitsplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Anschlag:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Anschlag:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Varianten:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Varianten:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Holzart:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Holzart:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Kissenbezug:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug Kissen:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Sitzschale:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitzschale:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Oberflaeche:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Oberfläche:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Fussform:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Fußform:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Farbvariante:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Sitz:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitz:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Gestell:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Gestell:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Materialvariante:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Bezug1:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug 1:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Bezug2:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug 2:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Rueckenlehne:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Rückenlehne:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Polsterung:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Polsterung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Kontrastnaht:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Kontrastnaht:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Leder:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Leder:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Holzausfuehrung:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Holzausführung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Sitzhoehe:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitzhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Nahtart:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Nahtart:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Korpus:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Korpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Griff:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Griff:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Funktion:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Funktion:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Armlehne:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Armlehne:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Ruecken:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Rücken:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Korpusbezug:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Bezug Korpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Sitz_und_Kissen:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Sitz und Kissen:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Arbeitsplatte:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Arbeitsplatte:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Innenkorpus:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Innenkorpus:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Applikationsfarbe:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Applikationsfarbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Wangenform:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Wangenform:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Tischsaeule:
   Source: articles.configuratorOptions
   Field_Adapter:
    - get_preg_match: ['/Tischsäule:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Abmessung:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Design:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Design:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Energieeffizienzklasse:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Energieeffizienzklasse:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Farbe:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Farbe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Farbtemperatur:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Farbtemperatur:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Fassung:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Fassung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Flaechengewicht:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Flächengewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Fleachengewicht_exakt:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Flächengewicht exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Florhoehe:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Florhöhe:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Florhoehe_exakt:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Florhöhe exakt:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Form:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Form:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 fuer_Fussbodenheizung_geeignet:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/für Fußbodenheizung geeignet:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Gesamtgewicht:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Gesamtgewicht:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Leistung:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Leistung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Lichtstrom:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Lichtstrom:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Material:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Material:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Muster:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Muster:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Raum:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Raum:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Stil:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Stil:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Typ:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Typ:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
    - explode: [':','1']
    - trim: ' |'
   In_Export: no
 Durchmesser:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.Durchmesser
   In_Export: no
 Laenge:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.Laenge
   In_Export: no
 Breite:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.Breite
   In_Export: no
 Hoehe:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.Hoehe
   In_Export: no
 Tiefe:
   Source: iwm_properties.propertyValueName
   Field_Adapter:
    - get_preg_match: ['/Abmessung:[A-Za-z0-9öüäß -\/]*\|{0,1}/']
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.Tiefe
   In_Export: no
 active_amazon:
   Source: articles.configuratorOptions
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.active_amazon
   In_Export: no
 active_ebay:
   Source: articles.configuratorOptions
   File_Field_Adapter:
    File: export_articles_oms_channeladvisor.active_ebay
   In_Export: no

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: filter_plenty_oms_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 unterwarengruppe = 70'
 - Filter:
    name: filter_plenty_oms_kalkulation
    condition: attr2 == 92 AND unterwarengruppe == 54
    output: positive
    reason: 'bad calculation: attr2 = 92 AND unterwarengruppe = 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: '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'
#Target
Datapool: export_articles_oms_channeladvisor #sql table
Primary_Key: [sku]

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" }, { "Left_Join": null, "Datapool": "iwm_properties", "Join_Condition": "articles.ordernumber = iwm_properties.ordernumber AND articles.attr1 = iwm_properties.firma" } ]
Read_Conditions [ "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 { "sku": { "Source": "articles.ordernumber" }, "variation_parent_sku": { "Source": "articles.mainnumber" }, "relationship_name": { "Source": "articles.configuratorOptions", "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.relationship_name" } }, "title": { "Source": "articles.name_oms" }, "description": { "Source": "articles.description_long_oms", "Field_Adapter": [ { "replace": [ ";", "" ] } ] }, "stock": { "Source": "iwm_articles_stock.stock", "Field_Adapter": [ { "replace_empty": "0" } ] }, "category": { "Source": "shopware_article_info.category" }, "ean": "articles.ean", "product_condition": "(new)", "shipping": "shopware_article_info.shipping", "supplier": { "Source": "articles.supplier_oms" }, "tax": { "Source": "articles.tax" }, "price_VK": { "Source": "articles.price_oms", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "pseudoprice_VK": { "Source": "articles.pseudoprice_oms", "Field_Adapter": [ { "replace": [ ",", "" ] }, { "replace": [ ".", "," ] } ] }, "supplier_number": { "Source": "articles.suppliernumber", "In_Export": "no" }, "active": { "Source": "articles.active_oms", "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": [ ";", "" ] } ], "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" }, "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:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Haertegrad": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/H\u00e4rtegrad:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Bezug": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Dessin": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Dessin:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Fuss": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Fu\u00df:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Tischplatte": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Tischplatte:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Gestellfarbe": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Gestellfarbe:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Front": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Front:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Korpus_und_Arbeitsplatte": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Korpus und Arbeitsplatte:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Anschlag": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Anschlag:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Varianten": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Varianten:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Holzart": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Holzart:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Kissenbezug": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug Kissen:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Sitzschale": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitzschale:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Oberflaeche": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Oberfl\u00e4che:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Fussform": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Fu\u00dfform:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Farbvariante": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Farbe:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Sitz": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitz:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Gestell": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Gestell:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Materialvariante": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Material:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Bezug1": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug 1:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Bezug2": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug 2:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Rueckenlehne": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/R\u00fcckenlehne:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Polsterung": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Polsterung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Kontrastnaht": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Kontrastnaht:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Leder": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Leder:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Holzausfuehrung": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Holzausf\u00fchrung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Sitzhoehe": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitzh\u00f6he:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Nahtart": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Nahtart:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Korpus": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Korpus:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Griff": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Griff:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Funktion": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Funktion:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Armlehne": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Armlehne:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Ruecken": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/R\u00fccken:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Korpusbezug": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Bezug Korpus:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Sitz_und_Kissen": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Sitz und Kissen:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Arbeitsplatte": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Arbeitsplatte:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Innenkorpus": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Innenkorpus:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Applikationsfarbe": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Applikationsfarbe:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Wangenform": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Wangenform:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Tischsaeule": { "Source": "articles.configuratorOptions", "Field_Adapter": [ { "get_preg_match": [ "\/Tischs\u00e4ule:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Abmessung": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Abmessung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Design": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Design:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Energieeffizienzklasse": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Energieeffizienzklasse:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Farbe": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Farbe:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Farbtemperatur": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Farbtemperatur:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Fassung": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Fassung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Flaechengewicht": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Fl\u00e4chengewicht:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Fleachengewicht_exakt": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Fl\u00e4chengewicht exakt:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Florhoehe": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Florh\u00f6he:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Florhoehe_exakt": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Florh\u00f6he exakt:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Form": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Form:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "fuer_Fussbodenheizung_geeignet": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/f\u00fcr Fu\u00dfbodenheizung geeignet:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Gesamtgewicht": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Gesamtgewicht:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Leistung": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Leistung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Lichtstrom": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Lichtstrom:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Material": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Material:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Muster": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Muster:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Raum": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Raum:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Stil": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Stil:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Typ": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Typ:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] }, { "explode": [ ":", "1" ] }, { "trim": " |" } ], "In_Export": "no" }, "Durchmesser": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Abmessung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] } ], "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.Durchmesser" }, "In_Export": "no" }, "Laenge": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Abmessung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] } ], "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.Laenge" }, "In_Export": "no" }, "Breite": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Abmessung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] } ], "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.Breite" }, "In_Export": "no" }, "Hoehe": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Abmessung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] } ], "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.Hoehe" }, "In_Export": "no" }, "Tiefe": { "Source": "iwm_properties.propertyValueName", "Field_Adapter": [ { "get_preg_match": [ "\/Abmessung:[A-Za-z0-9\u00f6\u00fc\u00e4\u00df -\\\/]*\\|{0,1}\/" ] } ], "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.Tiefe" }, "In_Export": "no" }, "active_amazon": { "Source": "articles.configuratorOptions", "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.active_amazon" }, "In_Export": "no" }, "active_ebay": { "Source": "articles.configuratorOptions", "File_Field_Adapter": { "File": "export_articles_oms_channeladvisor.active_ebay" }, "In_Export": "no" } }
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": "filter_plenty_oms_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 unterwarengruppe = 70" } }, { "Filter": { "name": "filter_plenty_oms_kalkulation", "condition": "attr2 == 92 AND unterwarengruppe == 54", "output": "positive", "reason": "bad calculation: attr2 = 92 AND unterwarengruppe = 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": "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" } } ]
Datapool export_articles_oms_channeladvisor
Primary_Key [ "sku" ]