BMEcat 2005 ETIM Version 5.0

text only available in english

For data suppliers who manage their product information on international level, the choice of a data exchange format is often the BMEcat 2005. This is also the recommended format by ETIM International. When suppliers want to use a BMEcat 2005, we strongly recommend to use the ETIM V5.0 guidelines. If you are using an older BMEcat ETIM guideline version, we advice to update as soon as possible.

We have tried to achieve as much similarity as possible between the BMEcat 5.0 (and 4.0) and the Dutch format DICO (previuously named as SALES005) managed by Ketenstandaard. The complete ETIM guideline can be downloaded at the download section of ETIM International

Think twice before you start

If you have files according to previous ETIM guideline versions, we recommend that you upgrade to the latest version 5.0 as soon as possible. Point your software or ICT partner to this online documentation of 2BA. It are not rules imposed by 2BA, but Extensible Markup Language rules, a standard of the World Wide Web Consortium.

Developing an XML message based on an XSD and the associated rules is a task that requires XML specialization.

Common mistakes:

  • Incorrect specified headers
  • Missing mandatory elements
  • No closed elements (only <ELEMENT> but missing </ELEMENT>)
  • No open elementes (missing <ELEMENT> only </ELEMENT>)
  • Empty optional elements (<ELEMENT></ELEMENT>)
  • Improperly defined NL Characteristics (e.g. wrong specified field types)
  • Failure to follow the order specified in the XSD
  • Not escaping symbols within strings such as an ampersand (&).

To avoid disappointment, we recommend that you use a specialized software party with sufficient XML knowledge. Of course, there are also various PIM software parties affiliated with 2BA that export a valid dataset via an efficient route so that you can easily deliver your valuable data to 2BA.

Mapping overview

2BA is conforming the data pool according to the Dutch standards of Ketenstandaard Bouw en Techniek with the INSBOU and DICO / SALES XML files. The supported exchange formats are mapped to the internal fields of the data model. Some internal fields may differ from the length or type as described in the guideline of the exchange formats. We create as much clarity as possible but there may be differences, which we mention in the mapping. For example, in BMEcat 2005 the short description has a length of 150 characters, in the data model only 70 characters.

Validation

The BMEcat 2005 ETIM V5.0 file should be validated according to the XSD to be sure of full compliance with 2BA. We recommend using the ETIM BMEcat validation tool (ETIM account needed) to validate your file.

Exceptions

There are a few exceptions in the current XSD (filedate: 2021-06-30).

  • ETIM classification is not mandatory for 2BA in the T_NEW_Catalogue.

Corrections

Corrections for the BMEcat 2005 ETIM V5.0 documentation are:

  • No corrections known yet

Extra information:

  • The file name (page 9 of the ETIM 5.0 guidelines is free adjustable when it will be uploaded to the datapool.
  • According to the BMEcat 2005 ETIM V5.0, each optional element can be marked as mandatory on the level of an individual ETIM country.

 

Country specific characteristics

Every country requires more fields then originally available in the BMEcat 2005 structure. In cooperation with ETIM Netherlands, we have defined country specific guidelines for the Netherlands.

Please use this UDX fields (UDX.EDXF.PRODUCT_CHARACTERISTICS) as defined in the ETIM guideline 5.0 starting at page 157 to page 191. The NL characteristics for BMEcat 2005 ETIM V5.0 differ from version 4.0. Please note that NL characteristics that are no longer present will not be accepted when you submit a BMEcat 2005 ETIM V5.0 dataset

The BMEcat 2005 ETIM V5.0 contains clear examples of how to define them in your data file.

NL CHARACTERISTIC Name Explanation
NL_002-1 DIN-number link
NL_002-2 ISO-number link
NL_004 Single use quantity link
NL_005 List date_SDS link
NL_006 Country of production origin link
NL_007 Delivery time link
NL_008 Long ERP description link
NL_009 Supplier_IDref link
NL_010 Manufacturer_IDref link
NL_011 Buying group link
NL_012 Orderable indicator link
NL_014 Fragile on package link
NL_015 Best before date on package link
NL_016-1 Cuttable indicator link
NL_016-2 Maximum cutting length link
NL_018 Code VAT rate link

Deleted NL Characteristics

A small number of NL characteristics are included in the regular product line. As a result, these have been removed as NL Characteristic:

DELETED NL CHARACTERISTIC Name Explanation Substitute element
NL_013 CE indicator link UDX.EDXF.CE_MARKING
NL_017 Contains Batteries link UDX.EDXF.BATTERY_CONTAINED
NL_019 ROHS indicator link UDX.EDXF.ROHS_INDICATOR
NL_020 UNSPSC code link REFERENCE_FEATURE_SYSTEM_NAME

 

Transaction settings

2BA supports complete or update (mutation) files of the BMECat 5.0. A complete BMEcat files has to contain all active products. A new complete file will overwrite all records in the database!. To define the file as a complete file, use T_NEW_CATALOG. Existing productrecords which are not present in the complete file will be set as "expired". Existing trade itemsrecords which are not present in the complete file will be deleted.

Delivery of mutation files is also possible.

EXAMPLE complete files:

1
2
3
4
<T_NEW_CATALOG>
    <PRODUCT mode="new">
    </PRODUCT>
</T_NEW_CATALOG>
 

EXAMPLE mutation file:

1
2
3
4
<T_UPDATE_PRODUCTS>
    <PRODUCT mode="update">
    </PRODUCT>
</T_UPDATE_PRODUCTS>

 

Identification

2BA distinguishes two entities, the product information and related trade item information. Product information concerns data from the manufacturer about the manufactured product such as attachments and ETIM classification. The related trade item information contains all data indicating how to order the item such as gross price, order unit, minimum purchase amount and delivery time. In many cases (standard manufacturers), this information will be equal to each other, but a distinction can be made here for importers.

SUPPLIER_PID Trade item number
UDX.EDXF.GTIN GTIN trade item
MANUFACTURER_PID Product number (smallest unpacked unit)
INTERNATIONAL_PID type="gtin" GTIN product
Important notes:
  1. When UDX.EDXF.GTIN is empty, the INTERNATIONAL_PID type="gtin" will be set as trade item GTIN.

 

Product status / Statuscode

The product status codes are different between BMEcat 2005 ETIM V5.0 and the data model. The mapping is based on product status type, the value is informative (except for expired products). The product status will be set at product and trade item level (exept for expired products (model code 130).

The mapping of product status types versus the data model is available here.

BMEcat type Data model descripiton Data model code
core_product Regular available 126 or NULL
others Regular available 126 or NULL
new_product New product 84E
new New product 84E
old_product Discontinued product 94E
others Expired product (only at product level; see important notes below) 130
refurbished Refurbished product (only at trade item level) no modelcode; true/false indicator
used Used (second hand) product (only at trade item level) no modelcode; true/false indicator
Important notes:
  1. PRODUCT_STATUS is optional within BMEcat V5.0 format, when no product status is given the productrecord and trade item record will be intrepreted as core_product.
  2. Refurbished products can be specified via type "refurbished" where the value will be skipped. The trade item will be specified through an indicator.
  3. Second-hand (reuse) products can be specified via type "used" where the value will be skipped. The trade item will be specified through an indicator.
  4. Expired products (model code 130) can be specified via type "others" in combination with the value "expired". If the product status is specified as 'expired' the product record will be imported as 'expired' (model code '130') and the trade item record (e.g. pricing and logistical info) will not be imported (T_NEW_CATALOG) or will be deleleted (T_UPDATE_PRODUCTS)

  5.  

EXAMPLE expired products:

1
<PRODUCT_STATUS type="others">expired</PRODUCT_STATUS>

 

Multiple packing units for the same product

It is possible for a manufacturer or supplier to distribute more than one type of package for the same product. According to the ETIM International Guidelines there are some strict rules:

Important notes:
  1. Only the values within the packing unit with the lowest UDX.EDXF.QUANTITY_MIN will be imported. Other specified packing units elements will be ignored.
  2. Normally, the complete product structure must be given for every unique trade item number (from <PRODUCT> to </PRODUCT>). In case of multiple packing units there is an exception: when a reference to a MANUFACTURER_PID is used more than once (from more than one SUPPLIER_PID's) after the first appearance, the fields below don't have to be given in order to avoid redundant data:
  • Attachments: UDX.EDXF.MIME_INFO
  • ETIM classification: PRODUCT_FEATURES
  • ETIM version: UDX.EDXF.PRODUCT_ETIM_DYNAMIC
  • ETIM MC classification: UDX.EDXF.PRODUCT_FEATURES_MC
  • Brand, series, type: will be ignored during the import

 

Logistic information

For trade items, the logistic information can be given for each unique trade item in the elements UDX.EDXF.PACKING_UNITSPRODUCT_LOGISTIC_DETAILS and UDX.EDXF.PRODUCT_CHARACTERISTIC. Measurements must be given in meters and weights must to be given in kilograms. If there are more than one trade items for the same product see chapter Multiple packing units for the same product. The mapping below applies to the packaging information for all trade items:

EXAMPLE I:
1
2
3
4
5
6
7
8
9
10
11
12
13
<UDX.EDXF.PACKING_UNITS>
    <UDX.EDXF.PACKING_UNIT>
        <UDX.EDXF.QUANTITY_MIN>1</UDX.EDXF.QUANTITY_MIN>
        <UDX.EDXF.QUANTITY_MAX>1</UDX.EDXF.QUANTITY_MAX>
        <UDX.EDXF.PACKING_UNIT_CODE>CT</UDX.EDXF.PACKING_UNIT_CODE>
        <UDX.EDXF.PACKING_PARTS>1</UDX.EDXF.PACKING_PARTS>
        <UDX.EDXF.WEIGHT>7.6</UDX.EDXF.WEIGHT>
        <UDX.EDXF.LENGTH>0.34</UDX.EDXF.LENGTH>
        <UDX.EDXF.WIDTH>0.52</UDX.EDXF.WIDTH>
        <UDX.EDXF.DEPTH>0.52</UDX.EDXF.DEPTH>
        <UDX.EDXF.GTIN>GTIN trade item</UDX.EDXF.GTIN>
    </UDX.EDXF.PACKING_UNIT>
</UDX.EDXF.PACKING_UNITS>
Important notes:
  1. ETIM has determined that C62 is interpreted as unpacked
  2. ETIM has determined that PA is interpreted as blister
  3. Not recommended:
    • BE (Bundle)
    • PR (Pair)
    • SET (set)
    • Z2 (Chest)
    • Z3 (Cask)
  4. Not accepted:
    • CQ (Cartridge)
    • EV (Envelope)
    • WR (Wrap)

The mapping of packing codes versus 2BA is available here

The country of origin is the country of shipment of the order. The country of production is the actual production location. Please use the country specific UDX.EDXF.PRODUCT_CHARACTERISTIC field "Country of production origin" with code "NL_006", see chapter 11 of the ETIM 5.0 guideline.

EXAMPLE II:
1
2
3
4
5
6
<PRODUCT_LOGISTIC_DETAILS>
    <CUSTOMS_TARIFF_NUMBER>
        <CUSTOMS_NUMBER>12345678</CUSTOMS_NUMBER>
    </CUSTOMS_TARIFF_NUMBER>
    <COUNTRY_OF_ORIGIN>NL</COUNTRY_OF_ORIGIN>
</PRODUCT_LOGISTIC_DETAILS>
EXAMPLE III:
1
2
3
4
5
<UDX.EDXF.PRODUCT_CHARACTERISTIC>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_CODE>NL_006</UDX.EDXF.PRODUCT_CHARACTERISTIC_CODE>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_NAME> Country of production origin </UDX.EDXF.PRODUCT_CHARACTERISTIC_NAME>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING>DE</UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING>
</UDX.EDXF.PRODUCT_CHARACTERISTIC>

 

Order price details

For each trade item can be defined how the trade item can be ordered, on which unit the price is based and how the product can be used. The mapping of the order and price details in the import of BMEcat 5.0 differs from older guideline versions.

  • The CONTENT_UNIT defines how the product is used, this can be expressed in piece, meters, litres ad square meters. All other cases should be specified as C62. In case of piece, use also code C62.
  • The ORDER_UNIT defines how the trade item can be ordered, this can be expressed in piece, meters, litres and square meters. All other cases should be specified as C62. In case of piece, use also code C62.
  • The QUANTITY_MIN defines the minimum order quantity of the trade item, expressed in ORDER_UNIT. The quantity steps in which the trade item can be ordered is the QUANTITY_INTERVAL.
Applied formulas:
Data model:   Formula:
QuantityOfUseUnits = NO_CU_PER_OU * UDX.EDXF.QUANTITY_MIN
Gross price = PRICE_AMOUNT
Gross price per purchase unit = (PRICE_AMOUNT / PRICE_QUANTITY) * PRICE_FACTOR
Gross price per content unit = ((PRICE_AMOUNT / PRICE_QUANTITY) * PRICE_FACTOR) / (NO_CU_PER_OU * UDX.EDXF.QUANTITY_MIN)
Important notes:
  1. All PRICE_FACTOR elements per SUPPLIER_PID must have the same value.
  2. Gross price: @price_type "net_list" should be used as gross price.
  3. Gross price: @price_type "net_customer" should be used as net price.
  4. TAX will be multiplied with 100.
  5. DAILY_PRICE "true" is mapped as "price on request".
  6. Suggested price: @price_type "nrp" should be used as suggested price.
  7. Please note, the nonbinding recommended (retail) price (nrp), suggested retail price is within BMEcat specified including sales tax. The import proces reduces the speciied value with the specified VAT, because the suggested price in the data model is without sales tax.
Surcharge

Only the surcharge type "WEEE" is mapped to the Dutch "Afvalbeheersbijdrage".

EXAMPLE
1
2
3
4
5
6
7
<UDX.EDXF.SURCHARGE_LIST>
    <UDX.EDXF.SURCHARGE>
        <UDX.EDXF.SURCHARGE_TYPE>recycling WEEE</UDX.EDXF.SURCHARGE_TYPE>
        <UDX.EDXF.SURCHARGE_MANNER>base</UDX.EDXF.SURCHARGE_MANNER>
        <UDX.EDXF.SURCHARGE_PRICE_AMOUNT>0.28</UDX.EDXF.SURCHARGE_PRICE_AMOUNT>
    </UDX.EDXF.SURCHARGE>
</UDX.EDXF.SURCHARGE_LIST>

 

 

 

Descriptions

Given the various purposes, different types of descriptions are possible to describe a trade item or product. There are three possibilities:

EXAMPLE I:
1
2
3
4
5
6
<PRODUCT_DETAILS>
    <DESCRIPTION_SHORT lang="dut">BG/SR 611-4/6-0 SM Brievenbus</DESCRIPTION_SHORT>
    <DESCRIPTION_SHORT lang="eng">BG/SR 611-4/6-0 SM Letterbox</DESCRIPTION_SHORT>
    <DESCRIPTION_LONG lang="dut">Vrijstaande brievenbus met staande buis voor de opname van een brievenbus- of opbergvakmodule. 8 moduleplaatsen voor de opname van infobordmodules, vlaklampen en functiemodules in het bovenste deel. Spraakmodule en verdere functiemodules in een ergonomisch gemakkelijk te bedienen bereik. Aluminiumprofiel met bodemflens. Brievenbusbehuizing met aluminium achterwand kompleet met coating resp. gelakt. Kompleet met brievenbusbehuizing, staande buis en bodemflens met bevestigingsaccessoires zoals duvels voor zware lasten etc.</DESCRIPTION_LONG>
    <DESCRIPTION_LONG lang="eng">Free-standing letterbox with standpipes to accommodate a letterbox or storage compartment module. 8 module slots to accommodate info sign modules, surface area lights and function modules in the upper section. Intercom module and additional functional modules within easy ergonomical operating reach. Aluminium profile with base flange. Letterbox housing with aluminium rear panel with complete coating / paintwork finish. Complete with letterbox housing, standpipes and base flange with fixing accessories such as heavy-duty dowels, etc.</DESCRIPTION_LONG>
</PRODUCT_DETAILS>
EXAMPLE II:
1
2
3
4
5
6
<UDX.EDXF.PRODUCT_CHARACTERISTIC>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_CODE>NL_008</UDX.EDXF.PRODUCT_CHARACTERISTIC_CODE>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_NAME>Long ERP description</UDX.EDXF.PRODUCT_CHARACTERISTIC_NAME>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING>This field is used for a long ERP description</UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING lang="eng">ENG This field is used for a long ERP description</UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING>
</UDX.EDXF.PRODUCT_CHARACTERISTIC>
  1. DESCRIPTION_SHORTdescribes the product short and concise, to recognize its kind and function among a large quantity of products - preferably unambiguous.. The maximum field length within the data pool is 70 characters (not 150 characters according to the XSD of BMEcat). If the short description contains more characters the description will be cut to length of 70 characters.
  2. DESCRIPTION_LONG is mapped to the marketing text with a maximum of 1.000 characters. If the long description contains more characters, the description will be cut to specified length of 1.000 characters.
  3. The long description to support the short description is defined in the country specific UDX.EDXF.PRODUCT_CHARACTERISTIC "Long ERP description" with code "NL_008" and has a maximum of 256 characters.
Important notes:
  1. The descriptions (short, long and long ERP description) should not contain any HTML tags or font formatting like bold, italic, underline, etc.
  2. The descriptions (short, long and long ERP description) should not contain controls characters like CR & LF (Enter / Return), tabs, and other non-western characters. Please use the Character Entity Reference Table to specify new lines, lists, special characters etc.
  3. The element LANGUAGE in the header is used as default language when no language code is specified at descriptions.
  4. The default language is Dutch and is mandatory. If no Dutch description is set, the English description will be adopted as Dutch description.
  5. If neither a Dutch nor an English description is specified the specific record will blocked.
  6. The mapping of the language codes versus 2BA is available here Brand, serie and type

    Wholesalers uses the structure of brand, serie, type as a filtering method and search engine optimisation (SEO), for example on their webshop. For this reason these fields are mandatory for each product record. For records which are only used as trade item data, these fields can be skipped (see chapter: multiple packing units for the same product).

    Some manufactures don't use serie and type grouping. In this case use the value RNV_NA. More information click here.

    1. Brand; UDX.EDXF.BRAND_NAME
    2. Series; UDX.EDXF.PRODUCT_SERIES
    3. Type; UDX.EDXF.PRODUCT_VARIATION

    In older BMEcat guidelines there were more mappings and 2BA UDX fields, these fields and mappings are no longer supported.

 

Hazardous substances and certificates

Safety Data Sheets

When a Safety Data Sheet (SDS) is applicable, these three elements are mandatory:

  1. The indication that SDS is applicable for this product in SPECIAL_TREATMENT_CLASS. Only the value true or false is expected in this string field.
  2. There must be an attachment with code MD03 in UDX.EDXF.MIME.
  3. The SDS listdata must be filled in the UDX.EDXF.PRODUCT_CHARACTERISTIC with code NL_005.
EXAMPLE
1
2
3
4
5
6
7
8
9
10
11
<SPECIAL_TREATMENT_CLASS type="SDS">true</SPECIAL_TREATMENT_CLASS>
<UDX.EDXF.MIME>
    <UDX.EDXF.MIME_SOURCE>MD03.pdf</UDX.EDXF.MIME_SOURCE>
    <UDX.EDXF.MIME_CODE>MD03</UDX.EDXF.MIME_CODE>
    <UDX.EDXF.MIME_FILENAME>safety data sheet MD03</UDX.EDXF.MIME_FILENAME>
</UDX.EDXF.MIME>
<UDX.EDXF.PRODUCT_CHARACTERISTIC>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_CODE>NL_005</UDX.EDXF.PRODUCT_CHARACTERISTIC_CODE>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_NAME> List date_MSDS</UDX.EDXF.PRODUCT_CHARACTERISTIC_NAME>
    <UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING>2018-05-31</UDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRING>
</UDX.EDXF.PRODUCT_CHARACTERISTIC>
REACH

When Registration, Evaluation, Authorization and restriction of Chemicals (REACH) is applicable for the record, these three elements are mandatory:

  1. The indication that REACH is applicable for this product in UDX.EDXF.REACH.INFO.
  2. The REACH revision date must be filled in the UDX.EDXF.REACH.LISTDATE.
  3. There must be a website location to the document, given as attachment with code MD05 in UDX.EDXF.MIME.
EXAMPLE
1
2
3
4
5
6
7
8
9
<UDX.EDXF.REACH>
    <UDX.EDXF.REACH.LISTDATE>2021-07-21</UDX.EDXF.REACH.LISTDATE>
    <UDX.EDXF.REACH.INFO>true</UDX.EDXF.REACH.INFO>
</UDX.EDXF.REACH>
<UDX.EDXF.MIME>
    <UDX.EDXF.MIME_SOURCE>https://www.deeplink.nl/Reach.pdf</UDX.EDXF.MIME_SOURCE>
    <UDX.EDXF.MIME_CODE>MD05</UDX.EDXF.MIME_CODE>
    <UDX.EDXF.MIME_FILENAME>reach deeplink MD05</UDX.EDXF.MIME_FILENAME>
</UDX.EDXF.MIME>

 

ETIM Classification

The element PRODUCT_FEATURES can be used for the ETIM Classification. REFERENCE_FEATURE_SYSTEM_NAME must be filled with the ETIM version of the data. In the format ETIM-x.x. or like DYNAMIC.

  1. REFERENCE_FEATURE_GROUP_ID is the ETIM class of the product. According to the 5.0 guidelines this field is mandatory and must be filled with "EC000000" if the product has no known ETIM class. For 2BA this field is not mandatory.
  2. FNAME is the ETIM Feature. According to the 5.0 guidelines this field is mandatory and must be filled with "EF000000" or "-" when there is no feature. For 2BA this field is not mandatory.
  3. FVALUE is the ETIM value. According to the 5.0 guidelines this field is mandatory and must be filled with "EV000000" or "-" when there is no feature. For 2BA this field is not mandatory.
  4. In case of a range, the element FVALUE is used twice. 2BA will use the first element as the lowest value, and the second value as the highest.

If a value cannot be assigned, according to the ETIM guideline the data supplier has the opportunity to use a minus sign. Values with a minus sign will be skipped by 2BA. Instead use one of the following reasons in FVALUE_DETAILS:

  • NA; Not applicable (this feature is not applicable in the context of a product in this class).
  • MV; Missing value (an alphanumeric feature is relevant, but no correct value exists in this ETIM version).
  • UN; Unknown (currently, the data supplier is not able to specifiy a value; but basically it is possible).
EXAMPLE I:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<REFERENCE_FEATURE_SYSTEM_NAME>ETIM-8.0</REFERENCE_FEATURE_SYSTEM_NAME>
<REFERENCE_FEATURE_GROUP_ID>EC000905</REFERENCE_FEATURE_GROUP_ID>
<FEATURE>
    <FNAME>EF008618</FNAME>
    <FVALUE>2</FVALUE>
    <FEATURE>
        <FNAME>EF007515</FNAME>
        <FVALUE>-10</FVALUE>
        <FVALUE>60</FVALUE>
    </FEATURE>
    <FEATURE>
        <FNAME>EF001366</FNAME>
        <FVALUE>-</FVALUE>
        <FVALUE_DETAILS>NA</FVALUE_DETAILS>
    </FEATURE>
</FEATURE>
EXAMPLE II:
1
2
3
4
5
6
<REFERENCE_FEATURE_SYSTEM_NAME>ETIM-8.0</REFERENCE_FEATURE_SYSTEM_NAME>
<REFERENCE_FEATURE_GROUP_ID>EC000000</REFERENCE_FEATURE_GROUP_ID>
<FEATURE>
    <FNAME>-</FNAME>
    <FVALUE>-</FVALUE>
</FEATURE>

 

MIME Information

According to the ETIM 5.0 guidelines the UDX.EDXF.MIME_INFO element should be used to exchange attachments. Because of the different export formats the predefined values (MD codes) are mapped to the attachment type code list.

The mapping of MD codes versus the data model is available here

EXAMPLE:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<UDX.EDXF.MIME_INFO>
    <UDX.EDXF.MIME>
        <UDX.EDXF.MIME_SOURCE>MD01.jpg</UDX.EDXF.MIME_SOURCE>
        <UDX.EDXF.MIME_CODE>MD01</UDX.EDXF.MIME_CODE>
        <UDX.EDXF.MIME_FILENAME>Low resolution picture</UDX.EDXF.MIME_FILENAME>
        <UDX.EDXF.MIME_DESIGNATION>normal</UDX.EDXF.MIME_DESIGNATION>
    </UDX.EDXF.MIME>
    <UDX.EDXF.MIME>
        <UDX.EDXF.MIME_SOURCE>MD01.tif</UDX.EDXF.MIME_SOURCE>
        <UDX.EDXF.MIME_CODE>MD01</UDX.EDXF.MIME_CODE>
        <UDX.EDXF.MIME_FILENAME>High resolution picture</UDX.EDXF.MIME_FILENAME>
        <UDX.EDXF.MIME_DESIGNATION>detail</UDX.EDXF.MIME_DESIGNATION>
    </UDX.EDXF.MIME>
    <UDX.EDXF.MIME>
        <UDX.EDXF.MIME_SOURCE>https://www.2ba.nl/productpage</UDX.EDXF.MIME_SOURCE>
        <UDX.EDXF.MIME_CODE>MD04</UDX.EDXF.MIME_CODE>
    </UDX.EDXF.MIME>
</UDX.EDXF.MIME_INFO>
Important notes:
  • UDX.EDXF.MIME_DESIGNATION specifies if an attachment is in high resolution (detail) or low resolution (normal) picture. If UDX.EDXF.MIME_DESIGNATION is not specified, the picture will be specified as a low resolution picture (PPI). The element UDX.EDXF.MIME_DESIGNATION will be also used to specify the description of the attachment. The value normal or detail will be skipped as description
  • We strongly recommend to specify only one primary image as MD01 and specifiy other images as MD02 (simular picture).
  • The minimum quality of a high resolution should be 300 DPI for 1772x1772 pixels (15x15cm).
  • If only a high resolution (detail) MD01 picture is specified, the import system will generate a low resolution picture.
  • The MIME_ROOT can define a root map for attachments. This field is used in combination with UDX.EDXF.MIME_SOURCE. Be careful not to use the same directory structure in both fields.
  • The UDX.EDXF.MIME_SOURCE is used for the file name or URL. When the value starts with an URL, the import system will download the attachment.
  • Per UDX.EDXF.MIME_SOURCE can be indicated trough a language code in which language the content is written. If the language code is not specified the specified header language code will be used. with the exception of the product picture MD codes: MD01, MD02, MD20, MD23, MD24, MD25, MD26, MD27, MD28, MD29, MD30, MD47, MD59, MD65.
  • The UDX.EDXF.MIME_CODE defines the type of attachment with MD codes.
  • The MIME_CODE MD04 will be saved as (data) deeplink and is not mapped as an attachment type. If you specify multiple deeplinks (mime code MD04), the deeplinks will be imported as attachment model type 'other' (OTA).
  • MD06, Energy label must be a JPG. In 2BA mapped to certificates, with attribute "ENERGY".
  • MD47 (thumbnail) is not imported by 2BA.

 

Reference items

In the data model reference items will be mapped at product level, not on trade item level.

The mapping of product references versus the data model is available here.

Important notes:
  • BMEcat code "others" can only be used in combination with REFERENCE_DESCR "fits to" and "predecessor".
  • BMEcat code "Base product" is used for hierarchy, see chapter 10 hierarchy.
  • BMEcat code "Followup" can be used to refer to a successor at product level (not for trade items).
EXAMPLE:
1
2
3
4
5
6
7
8
<PRODUCT_REFERENCE type="consists_of" quantity="4">
    <PROD_ID_TO>252525</PROD_ID_TO>
    <REFERENCE_DESCR>test reference consists</REFERENCE_DESCR>
</PRODUCT_REFERENCE>
<PRODUCT_REFERENCE type="similar" quantity="1">
    <PROD_ID_TO>252525</PROD_ID_TO>
    <REFERENCE_DESCR>test reference similar</REFERENCE_DESCR>
</PRODUCT_REFERENCE>

 

Files containing data from multiple data suppliers

  • In case of catalogue messages containing products of more than one manufacturer, on every product the field the country specific UDX.EDXF.PRODUCT_CHARACTERISTIC field "Manufacturer_IDref" with code "NL_010" must be used, see chapter 11.
  • In case of a multi supplier catalogue, every trade item needs to be identified with the GLN of the supplier, the field the country specific UDX.EDXF.PRODUCT_CHARACTERISTIC field "Supplier_IDref" with code "NL_009" must be used, see chapter 11.
  • When a multi catalogue message contains multiple suppliers of the same product, redundant product information should be avoided. The ETIM classification and "mime info" should only be added the first time it is mentioned in the catalogue. The function PRODUCT_REFERENCE "base_product" must be used on all the other trade items elements which refer to the same product.
Cookie statement