DataEngine Commerce Product v2 Standardisierung

Source_Config: importEngine
Target_Config: enhanceEngine
Source_Datapool: commerce_raw_articles
Target_Datapool: commerce_product_master_v2
Primary_Key:
  - id
Datapool_Definition:
  id: TEXT
  sku: TEXT
  item_group_id: TEXT
  title: TEXT
  description: TEXT
  link: TEXT
  canonical_link: TEXT
  image_link: TEXT
  additional_image_link: TEXT
  availability: TEXT
  condition: TEXT
  price: TEXT
  sale_price: TEXT
  currency: TEXT
  sale_price_effective_date: TEXT
  tax_rate: TEXT
  net_price: TEXT
  gross_price: TEXT
  cost_price: TEXT
  min_margin_percent: TEXT
  brand: TEXT
  manufacturer: TEXT
  supplier: TEXT
  gtin: TEXT
  mpn: TEXT
  pzn: TEXT
  identifier_exists: TEXT
  product_type: TEXT
  google_product_category: TEXT
  color: TEXT
  size: TEXT
  gender: TEXT
  age_group: TEXT
  material: TEXT
  pattern: TEXT
  shipping_weight: TEXT
  shipping_label: TEXT
  delivery_time_days: TEXT
  quantity: TEXT
  stock_available: TEXT
  stock_reserved: TEXT
  stock_minimum: TEXT
  warehouse: TEXT
  adult: TEXT
  erp_sku: TEXT
  erp_product_type: TEXT
  erp_status: TEXT
  shop_active: TEXT
  channel_exclusions: TEXT
  compliance_notes: TEXT
  custom_label_0: TEXT
  custom_label_1: TEXT
  custom_label_2: TEXT
  custom_label_3: TEXT
  custom_label_4: TEXT
  source_system: TEXT
  source_updated_at: TEXT
  data_quality_status: TEXT
Mapping:
  id:
    Source: commerce_raw_articles.id
    Field_Adapter:
      - trim: " "
  sku:
    Source: commerce_raw_articles.sku
    Field_Adapter:
      - trim: " "
  item_group_id:
    Source: commerce_raw_articles.item_group_id
    Field_Adapter:
      - trim: " "
  title:
    Source: commerce_raw_articles.title
    Field_Adapter:
      - trim: " "
  description:
    Source: commerce_raw_articles.description
    Field_Adapter:
      - trim: " "
  link:
    Source: commerce_raw_articles.link
    Field_Adapter:
      - trim: " "
  canonical_link:
    Source: commerce_raw_articles.canonical_link
    Field_Adapter:
      - trim: " "
  image_link:
    Source: commerce_raw_articles.image_link
    Field_Adapter:
      - trim: " "
  additional_image_link:
    Source: commerce_raw_articles.additional_image_link
    Field_Adapter:
      - trim: " "
  availability:
    Source: commerce_raw_articles.availability
    Field_Adapter:
      - trim: " "
      - tolower: true
      - replace_empty: in stock
  condition:
    Source: commerce_raw_articles.condition
    Field_Adapter:
      - trim: " "
      - tolower: true
      - replace_empty: new
  price:
    Source: commerce_raw_articles.price
    Field_Adapter:
      - trim: " "
  sale_price:
    Source: commerce_raw_articles.sale_price
    Field_Adapter:
      - trim: " "
  currency:
    Source: commerce_raw_articles.currency
    Field_Adapter:
      - trim: " "
      - replace_empty: EUR
  sale_price_effective_date:
    Source: commerce_raw_articles.sale_price_effective_date
    Field_Adapter:
      - trim: " "
  tax_rate:
    Source: commerce_raw_articles.tax_rate
    Field_Adapter:
      - trim: " "
      - replace_empty: "19"
  net_price:
    Source: commerce_raw_articles.net_price
    Field_Adapter:
      - trim: " "
  gross_price:
    Source: commerce_raw_articles.gross_price
    Field_Adapter:
      - trim: " "
  cost_price:
    Source: commerce_raw_articles.cost_price
    Field_Adapter:
      - trim: " "
  min_margin_percent:
    Source: commerce_raw_articles.min_margin_percent
    Field_Adapter:
      - trim: " "
      - replace_empty: "15"
  brand:
    Source: commerce_raw_articles.brand
    Field_Adapter:
      - trim: " "
  manufacturer:
    Source: commerce_raw_articles.manufacturer
    Field_Adapter:
      - trim: " "
  supplier:
    Source: commerce_raw_articles.supplier
    Field_Adapter:
      - trim: " "
  gtin:
    Source: commerce_raw_articles.gtin
    Field_Adapter:
      - trim: " "
  mpn:
    Source: commerce_raw_articles.mpn
    Field_Adapter:
      - trim: " "
  pzn:
    Source: commerce_raw_articles.pzn
    Field_Adapter:
      - trim: " "
  identifier_exists:
    Source: commerce_raw_articles.identifier_exists
    Field_Adapter:
      - trim: " "
      - tolower: true
      - replace: ["true", "yes"]
      - replace: ["false", "no"]
      - replace_empty: "yes"
  product_type:
    Source: commerce_raw_articles.product_type
    Field_Adapter:
      - trim: " "
  google_product_category:
    Source: commerce_raw_articles.google_product_category
    Field_Adapter:
      - trim: " "
  color:
    Source: commerce_raw_articles.color
    Field_Adapter:
      - trim: " "
  size:
    Source: commerce_raw_articles.size
    Field_Adapter:
      - trim: " "
  gender:
    Source: commerce_raw_articles.gender
    Field_Adapter:
      - trim: " "
      - tolower: true
  age_group:
    Source: commerce_raw_articles.age_group
    Field_Adapter:
      - trim: " "
      - tolower: true
  material:
    Source: commerce_raw_articles.material
    Field_Adapter:
      - trim: " "
  pattern:
    Source: commerce_raw_articles.pattern
    Field_Adapter:
      - trim: " "
  shipping_weight:
    Source: commerce_raw_articles.shipping_weight
    Field_Adapter:
      - trim: " "
  shipping_label:
    Source: commerce_raw_articles.shipping_label
    Field_Adapter:
      - trim: " "
  delivery_time_days:
    Source: commerce_raw_articles.delivery_time_days
    Field_Adapter:
      - trim: " "
  quantity:
    Source: commerce_raw_articles.quantity
    Field_Adapter:
      - trim: " "
  stock_available:
    Source: commerce_raw_articles.stock_available
    Field_Adapter:
      - trim: " "
  stock_reserved:
    Source: commerce_raw_articles.stock_reserved
    Field_Adapter:
      - trim: " "
  stock_minimum:
    Source: commerce_raw_articles.stock_minimum
    Field_Adapter:
      - trim: " "
  warehouse:
    Source: commerce_raw_articles.warehouse
    Field_Adapter:
      - trim: " "
  adult:
    Source: commerce_raw_articles.adult
    Field_Adapter:
      - trim: " "
      - tolower: true
  erp_sku:
    Source: commerce_raw_articles.erp_sku
    Field_Adapter:
      - trim: " "
  erp_product_type:
    Source: commerce_raw_articles.erp_product_type
    Field_Adapter:
      - trim: " "
  erp_status:
    Source: commerce_raw_articles.erp_status
    Field_Adapter:
      - trim: " "
      - tolower: true
  shop_active:
    Source: commerce_raw_articles.shop_active
    Field_Adapter:
      - trim: " "
      - tolower: true
      - replace_empty: "yes"
  channel_exclusions:
    Source: commerce_raw_articles.channel_exclusions
    Field_Adapter:
      - trim: " "
  compliance_notes:
    Source: commerce_raw_articles.compliance_notes
    Field_Adapter:
      - trim: " "
  custom_label_0:
    Source: commerce_raw_articles.custom_label_0
    Field_Adapter:
      - trim: " "
  custom_label_1:
    Source: commerce_raw_articles.custom_label_1
    Field_Adapter:
      - trim: " "
  custom_label_2:
    Source: commerce_raw_articles.custom_label_2
    Field_Adapter:
      - trim: " "
  custom_label_3:
    Source: commerce_raw_articles.custom_label_3
    Field_Adapter:
      - trim: " "
  custom_label_4:
    Source: commerce_raw_articles.custom_label_4
    Field_Adapter:
      - trim: " "
  source_system:
    Source: commerce_raw_articles.source_system
    Field_Adapter:
      - trim: " "
      - replace_empty: csv
  source_updated_at:
    Source: commerce_raw_articles.source_updated_at
    Field_Adapter:
      - trim: " "
  data_quality_status:
    Source: commerce_raw_articles.data_quality_status
    Field_Adapter:
      - trim: " "
      - replace_empty: unchecked
Filters: []
Engine_Mode: full