Description

This outbound is the main outbound, which sends new products and updates of the products to shopware. Further more, in this outbound, there are some special attributes, which are used in ChannelPilot to send them to Emmarsys. If there are new images for the products, this outbound needs to include the same products (or more) as in oiep_pim_de_shopware_images.

Mappings

Currently, this outbound has 113 mappings/columns in the export. Here is a mapping between the column name and the attribute.

ordernumber

1. atr_de_gtin_wo_zeros
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

mainnumber

1. atr_de_gtin_wo_zeros
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

sapnumber

1. atr_de_sap_number
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

name

1. atr_de_digital_text
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • removing of "
     • removing of '
2. atr_de_content_string

• output of value: Value and unit
  • output of value: Value and unit
  • calculated: yes
  • preprocessing: no

description_long

1. atr_de_description
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • removing of .
     • removing of "
     • removing of '
2. atr_de_wine_tasty_description
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br><br>Geschmacksbeschreibung:
     • removing of "
     • removing of '
3. atr_de_wine_aroma_description
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br><br>Geruchsbeschreibung:
     • removing of "
     • removing of '
4. atr_de_technical_data
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br><br>Technische Daten:<li>
     • Replacement of ; with </li><li>
     • Append of </li>
     • removing of "
     • removing of '
5. atr_de_animal_feed_type
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br>Futtermittelart:
     • removing of "
     • removing of '
6. atr_de_species_animal_feed
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br>Tierart:
     • removing of "
     • removing of '
7. atr_de_animal_feed_additives
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br>Zusatzstoffe:
     • removing of "
     • removing of '
8. atr_de_animal_feed_composition
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br>Zusammensetzung:
     • removing of "
     • removing of '
9. atr_de_animal_feed_constituents
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <br>Analytische Bestandteile:
     • removing of "
     • removing of '
10. atr_de_pet_permit_ident
    • output of value: Value and unit
    • calculated: no
    • preprocessing:
      • insert before value: <br>Analytische Bestandteile:
      • removing of "
      • removing of '
    • multi value separator: |

supplier

1. atr_de_online_brand
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • replace "" with keine Marke

tax

1. atr_de_vat
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • replace % with ""

ballaststoffe

1. atr_de_fibtg
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

fettefettungsaeurenp100gml

1. atr_de_famscis
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

eiweissp100gml

1. atr_de_pro-
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

energiekcalp100gml

1. atr_de_energy
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • appending of kcal

energiekjp100gml

1. atr_de_energy_kj
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • appending of KJ

fettp100gml

1. atr_de_fat
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

fettefettgsaeurenp100gml

1. atr_de_fasat
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

kohlhyalkp100gml

1. atr_de_polyl
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

kohlstrp100gml

1. atr_de_starch
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

kohlzkrp100gml

1. atr_de_sugar-
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

kohlp100gml

1. atr_de_choavl
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

fettefettmgsaeurenp100gml

1. atr_de_fapucis
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

salz100gml

1. atr_de_salteq
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

alkgeh

1. atr_de_alcohol_content
   • output of value: Value
   • calculated: no
   • preprocessing: no

mainimage_filename

1. atr_de_all_image_filenames
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

entallerg

1. atr_de_allergenes_contains
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no
   • multi value separator: ;

mentallerg

1. atr_de_allergenes_may_contain
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no
   • multi value separator: ;

zutaten

1. atr_de_all_image_filenames
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • insert before value: <p>Nährstoffangaben: <br>

bio

1. atr_de_bio_final
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

vegan

1. atr_de_vegan_final
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

vegetarisch

1. atr_de_vegetarian
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

laktosefrei

1. atr_de_lactose_free
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

glutenfrei

1. atr_de_glutenfree
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

fairtrade

1. atr_de_fair_trade
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

pfandpflicht

1. atr_de_deposit_type
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

pfandbetrag

1. atr_de_deposit_amount
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

artikeltyp

1. unidentified
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no
   • multi value separator: ;

fsk

1. atr_de_age_rating
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

inverkehrbringer

1. atr_de_distributor_long
   • output of value: Value and unit
   • calculated: yes
   • preprocessing:
     • replace Globus Logistik, , , with "" (space)

grundpreispflicht

1. atr_de_base_price_relevant
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • replacing Ja with 1
     • replace Nein with 0
     • replace "" (space) with 0

grundpreisinhalt

1. atr_de_content_calc
   • output of value: Value and unit
   • calculated: yes
   • preprocessing: no

grundpreismasseinheit

1. atr_de_basic_price_unit
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

grundeinheit

1. atr_de_vergleichspreiseinheit
   • output of value: Value and unit
   • calculated: yes
   • preprocessing: no

verpackungseinheit

1. unidentified
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • replace pro with "" (space)
     • replace "" with Stück
   • multi value separator: |

groupid

1. unidentified
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
   • multi value separator: ;

main

1. constant
   • value = "1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20"

metatitle

1. atr_de_seo_title
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • remove "

metadescription

1. atr_de_seo_description
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • remove "

active

1. atr_de_outbound_channel_globus_de_locked
   • output of value: Value
   • calculated: no
   • preprocessing:
     • replace Ja with 1
     • replace Nein with 1
     • repalce "" (space) with 1

variationoption

1. atr_de_variant_value
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

customarticle

1. atr_de_service_type
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

delete

1. constant
   • value = "0"

documents_filename

1. atr_de_all_document_filenames
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

properties

1. atr_de_opc_details
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

herkunftsland_o_g

1. atr_de_country_of_origin
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

nonfoodingredients

1. atr_de_nonfood_ingredient
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

warnhinweise

1. atr_de_warning_nf
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

verwendungshinweise

1. atr_de_consumer_usage_instructions
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no
   • multi value separator: ;

customerGroup

1. atr_de_customer_groups
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no
   • multi value separator: |

gcheck

1. atr_de_g_check
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no
   • multi value separator: |

fructosefrei

1. atr_de_fructose_free
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

fructosearm

1. atr_de_low_fructose
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

palmoelfrei

1. atr_de_palm_oil_free
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

zuckerfrei

1. atr_de_sugar_free
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

demeter

1. atr_de_demeter
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

einfach_wertvoll

1. atr_de_simply_valueable
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

pet_feeding_table

1. atr_de_petfood_instructions_table
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • remove null

terminal

1. atr_de_shelf_terminal
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no
   • multi value separator: ;

igp

1. atr_de_igp_flag
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

dop

1. atr_de_dop_flag
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace "" (space) with 0

EAN

1. atr_de_voucher_id
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

biozid

1. atr_de_contains_pesticidial
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no (replacement should be inserted)

gefahrenhinweise_h

1. atr_de_ghs_hazard_statements
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no
   • multi value separator: |

ghs_piktogramme

1. atr_de_ghs_symbol
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace NO_PICTOGRAM with 0
   • multi value separator: |

ghs_signalwort

1. atr_de_ghs_signal_word
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

sicherheitshinweise_p

1. atr_de_ghs_precaution_statement
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no
   • multi value separator: |

bulletpoints

1. atr_de_feature_benefit
   • output of value: Value and unit
   • calculated: no
   • preprocessing:
     • remove "
   • multi value separator: </li><li>

new

1. atr_de_opc_flag_new
   • output of value: Value and unit
   • calculated: yes
   • preprocessing: no

rezyklat

1. atr_de_opc_flag_recyclate
   • output of value: Value and unit
   • calculated: yes
   • preprocessing: no

sales_ranking

1. atr_de_opc_sortingorder
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

med_usecases

1. atr_de_application_areas
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

med_sideeffects

1. atr_de_medicine_sideeffects

   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

2. atr_de_medicinal_product

   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing:
     • replace MW00001 with <n>Zu Risiken und Nebenwirkungen fragen Sie Ihren Arzt oder Apotheker.
     • remove MW00002
     • remove MW00003

med_limitation

1. atr_de_medicine_dispensing_limit
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

med_recommendation

1. atr_de_dispensing_recommendation
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

med_interaction

1. atr_de_medicine_interaction
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no
   • multi value separator: ;

quality

1. atr_de_spc_quality
   • output of value: Value and unit
   • calculated: no
   • preprocessing: no

sap_wgr

1. atr_de_sapwgr_calc
   • output of value: Value and unit
   • calculated: yes
   • preprocessing: no

lowest_price

1. atr_de_lowest_price
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

incomplete

1. constant
   • value = "0"

emar_oekotex_100

1. atr_de_oekotex_100
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_oekotex_green

1. atr_de_oekotex_green
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_oekotex_leather

1. atr_de_oekotex_leather
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_fsc_100

1. atr_de_fsc_100
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_fsc_recycled

1. atr_de_fsc_recycled
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_fsc_mix

1. atr_de_fsc_mix
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_pefc

1. atr_de_pefc
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_blauer_engel

1. atr_de_blauer_engel
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_gots

1. atr_de_gots
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_utz

1. atr_de_utz
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_rainforest_alliance

1. atr_de_rainforest_alliance
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_ohne_gentechnik

1. atr_de_ohne_gentechnik
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_zertifiziertes_palmoel

1. atr_de_zertifiziertes_palmoel
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_animal_welfare

1. atr_de_animal_welfare
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_label_rouge

1. atr_de_label_rouge
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_kat

1. atr_de_kat
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_qs_pruefzeichen

1. atr_de_qs_pruefzeichen
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_mikroplastikfrei

1. atr_de_mikroplastikfrei
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_natrue

1. atr_de_natrue
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_ecocert

1. atr_de_ecocert
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_unverpackt

1. atr_de_unverpackt
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_eihaltungsform

1. atr_de_eihaltungsform
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_msc

1. atr_de_msc
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_asc

1. atr_de_asc
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

emar_ggn

1. atr_de_ggn
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no

weight

1. atr_de_weight_kg
   • output of value: Value
   • calculated: yes
   • preprocessing: no

emar_natural_cosmetic

1. atr_de_naturkosmetik
   • output of value: LOV Value-ID
   • calculated: no
   • preprocessing: no