BMEcat 2005 ETIM Version 3.1 and older

text only available in english

BMEcat ETIM version 3.1

Warning: This format does not support the 2BA Extention’s (UDX.2BA)

The complete documentation is available at the download section of ETIM International.


BMEcat 2005 and BMEcat ETIM version 2.2

2BA supports imports and export in the BMEcat 2005 format. BMEcat 2005 is a German standard for distributing catalogue information. Technically it is a very comprehensive and extensible XML format. The format is mainly focussed on sellable products from manufactures. It pays less attention to the method of distinguishing manufacturer products from wholesalers trade items in comparison to GS1 (on which 2BA is based). BMEcat 2005 format is very well documented and “fused” with an XML schema. We will validate every import against this XSD schema.

Different model

It is good to keep in mind that the BMEcat 2005 format has some other roots in comparison to the GS1 standard on which 2BA is based. As noted earlier a main difference is the way of distinguishing manufacturer products from wholesalers trade items within 2BA. Another difference is the method of describing the trade item information. Following BMEcat you will order a product one or more times but in GS1 world you order a packaging (for example using a GTIN) with some products in it. There are lot more differences, probably every field has a slightly different naunce.

Mapping MIME MD codes

ETIM Guide and Extension

ETIM International has created a manual and some extensions to BMEcat 2005, especially for the electrical industry. 2BA follows the ETIM guidelines as far as possible, we are supporting the ETIM Guideline 2.2 supplemented with some elements of version 3.1. Although we can also import a standard BMEcat 2005 file but we prefer a BMEcat 2005 file formatted and extended using the ETIM Guidlines. Unfortunately there is not a complete XML schema available. 2BA has created a schema with the most essential parts.

To be sure that the BMEcat file is specified along the right schema, ETIM International developed a XML Validation tool. This tool will check the BMEcat file on specific elements along the XSD schema.

The BMEcat2005 XSD ETIM 2.2 schema is available here.
The BMEcat2005 ETIM Guideline 2.2 PDF is available here

2BA Extension

Although much can be imported and/or converted from BMEcat 2005 + ETIM to our database we had the need to import some additional or slightly different information. We have made a minimum of additions to the ETIM Extended fields in two categories. The first are extensions to the main PRODUCT and the second some extensions to the ETIM PACKAGING_UNIT.

Extension to BMECAT/T_NEW_CATALOG/PRODUCT/USER_DEFINED_EXTENSIONS
FieldTypeDescriptionMapping
UDX.2BA.SERIESdtSTRING(0..35)The product series / model2BA.Product.Serie
UDX.2BA.TYPEdtSTRING(0..35)The product type / variation2BA.Product.Type
UDX.2BA.DEEPLINKdtSTRING(0..512)Link to the product details on the website of the manufacturer2BA.Product.Deeplink
UDX.2BA.STATUSCODEdtSTRING(0..3)Statuscode in GS1 format (84E, 94E, 130)2BA.Product.Statuscode
UDX.2BA.PRODUCTPREDECESSOR/UDX.EDXF.TRADEITEMIDdtSTRING(0..35)The manufacturers productnumber to the predecessor2BA.Product.ProductcodeVoorganger
UDX.2BA.PRODUCTPREDECESSOR/UDX.EDXF.GTINdtSTRING(0..14) The GTIN of the predecessor 2BA.Product.GTINVoorganger 
UDX.2BA.PRODUCTSUCCESSOR/UDX.EDXF.TRADEITEMIDdtSTRING(0..35) The manufacturers productnumber to the successor 2BA.Product.ProductcodeOpvolger
UDX.2BA.PRODUCTSUCCESSOR/UDX.EDXF.GTINdtSTRING(0..14) The GTIN of the successor 2BA.Product.GTINOpvolger
Extension to BMECAT/T_NEW_CATALOG/PRODUCT/USER_DEFINED_EXTENSIONS/UDX.EDXF.PACKING_UNITS/UDX.EDXF.PACKING_UNIT
FieldTypeDescriptionMapping
UDX.2BA.FREETEXT01dtSTRING(0..70)Free value 12BA.Artikel.KM01
… 02 to 09
UDX.2BA.FREETEXT10dtSTRING(0..70)Free value 102BA.Artikel.KM10 
UDX.2BA.ARTICLEPREDECESSOR/UDX.EDXF.TRADEITEMIDdtSTRING(0..35)The suppliers articlenumber to the predecessor2BA.Artikel.ArtikelnummerVoorganger
UDX.2BA.ARTICLEPREDECESSOR/UDX.EDXF.GTINdtSTRING(0..14) The GTIN of the predecessor 2BA.Artikel.GTINVoorganger 
UDX.2BA.ARTICLESUCCESSOR/UDX.EDXF.TRADEITEMIDdtSTRING(0..35) The suppliers articlenumber to the successor 2BA.Artikel.ArtikelnummerOpvolger
UDX.2BA.ARTICLESUCCESSOR/UDX.EDXF.GTINdtSTRING(0..14) The GTIN of the successor 2BA.Artikel.GTINOpvolger
UDX.2BA.DEEPLINKdtSTRING(0..512) Link to the tradeitem details on the website of the supplier2BA.Artikel.Deeplink 
UDX.2BA.STATUSCODEdtSTRING(0..3) Statuscode in GS1 format (84E, 94E)2BA.Artikel.Statuscode
UDX.2BA.BUYINGGROUPdtSTRING(0..17) 2BA.Artikel.Afnamegroep
UDX.2BA.PROCESSABLEINDICATORdtBOOLEANIs the article direct processable “True; If article is packed use “False”2BA.Artikel.Verwerkbaar
UDX.2BA.ORDERABLEINDICATORdtBOOLEANIs article orderable? Orderable “True”; Not orderable “False”2BA.Artikel.Bestelbaar
UDX.2BA.MAKETOSTOCKINDICATORdtBOOLEAN Is article default on stock?2BA.Artikel.CodeVoorraadArtikel

Import process

First of all we validate the delivered file to the corresponding XML schema. Please take care of delivering a VALID file. Although we try to import invalid files, we will not take any time to fix import problems caused by an invalid file!

From the BMEcat file we try to import every product as a product AND as an base trade item to the 2BA database. We are using, if available, the ETIM packaging information from the MIN=1 and MAX=1 level at creating the base trade item. In the near future we will create multiple trade items from multiple packaging levels in BMEcat.

Example

Please see below an example of one product with the ETIM and 2BA extensions. All Element names should be in capitals.
Don’t copy/paste the code, you can download the example source code here.

<BMECAT version="2005" xmlns="https://www.bmecat.org/bmecat/2005fd">
  <HEADER>
    <CATALOG>
      <LANGUAGE>nld</LANGUAGE>
      <CATALOG_ID>123456</CATALOG_ID>
      <CATALOG_VERSION>1.0</CATALOG_VERSION>
      <CATALOG_NAME>2BA Etim 2.2 TEST FILE</CATALOG_NAME>
      <DATETIME type="generation_date">
        <DATE>2015-01-16</DATE>
      </DATETIME>
      <TERRITORY>NL</TERRITORY>
      <CURRENCY>EUR</CURRENCY>
    </CATALOG>
    <BUYER>
      <BUYER_ID>8714252005929</BUYER_ID>
      <BUYER_NAME>2BA B.V.</BUYER_NAME>
    </BUYER>
    <SUPPLIER>
      <SUPPLIER_ID type="duns">123456789</SUPPLIER_ID>
      <SUPPLIER_ID type="iln">2220000067546</SUPPLIER_ID>
      <SUPPLIER_NAME>2BA</SUPPLIER_NAME>
      <ADDRESS type="supplier">
        <STREET>COMPUTERWEG 4</STREET>
        <ZIP>3542 DR</ZIP>
        <CITY>UTRECHT</CITY>
        <COUNTRY>NL</COUNTRY>
        <ADDRESS_REMARKS>CIRKEL</ADDRESS_REMARKS>
      </ADDRESS>
    </SUPPLIER>
    <USER_DEFINED_EXTENSIONS>
      <UDX.EDXF.VERSION>2.2</UDX.EDXF.VERSION>
    </USER_DEFINED_EXTENSIONS>
  </HEADER>
  <T_NEW_CATALOG>
    <PRODUCT mode="new">
      <SUPPLIER_PID>SUPPLIER_PID(ARTNR)</SUPPLIER_PID>
      <PRODUCT_DETAILS>
        <DESCRIPTION_SHORT lang="nld">DESCRIPTION_SHORT_NL(MAX 70 CHAR)</DESCRIPTION_SHORT>
        <DESCRIPTION_SHORT lang="eng">DESCRIPTION_SHORT_ENG(MAX 70 CHAR)</DESCRIPTION_SHORT>
        <DESCRIPTION_LONG lang="nld">DESCRIPTION_LONG_NL</DESCRIPTION_LONG>
        <DESCRIPTION_LONG lang="eng">DESCRIPTION_LONG_ENG</DESCRIPTION_LONG>
        <EAN>1234567891231</EAN>
        <MANUFACTURER_PID>MANUFACTURER_PID(PRDNR)</MANUFACTURER_PID>
        <MANUFACTURER_NAME>MAN_NAME(BRAND)</MANUFACTURER_NAME>
        <MANUFACTURER_TYPE_DESCR>MAN_TYPE_DESCR(PRDTYPE)</MANUFACTURER_TYPE_DESCR>
        <ERP_GROUP_SUPPLIER>ERP_GROU</ERP_GROUP_SUPPLIER>
        <DELIVERY_TIME>6</DELIVERY_TIME>
        <SPECIAL_TREATMENT_CLASS type="MSDS">true</SPECIAL_TREATMENT_CLASS>
        <SPECIAL_TREATMENT_CLASS type="UNCODE">1449</SPECIAL_TREATMENT_CLASS>
        <SPECIAL_TREATMENT_CLASS type="ECCN">3A001</SPECIAL_TREATMENT_CLASS>
        <KEYWORD>KEYWORDX</KEYWORD>
      </PRODUCT_DETAILS>
      <PRODUCT_FEATURES>
        <REFERENCE_FEATURE_SYSTEM_NAME>ETIM-5.0</REFERENCE_FEATURE_SYSTEM_NAME>
        <REFERENCE_FEATURE_GROUP_ID type="hierarchy">EC000103</REFERENCE_FEATURE_GROUP_ID>
        <FEATURE>
          <FNAME>EF000551</FNAME>
          <FVALUE>2.2</FVALUE>
        </FEATURE>
        <FEATURE>
          <FNAME>EF001438</FNAME>
          <FVALUE>45</FVALUE>
        </FEATURE>
        <FEATURE>
          <FNAME>EF000010</FNAME>
          <FVALUE>EV005866</FVALUE>
        </FEATURE>
        <FEATURE>
          <FNAME>EF000012</FNAME>
          <FVALUE>EV000161</FVALUE>
        </FEATURE>
        <FEATURE>
          <FNAME>EF002169</FNAME>
          <FVALUE>EV000179 </FVALUE>
        </FEATURE>
        <FEATURE>
          <FNAME>EF000139</FNAME>
          <FVALUE>EV003454</FVALUE>
        </FEATURE>
        <FEATURE>
          <FNAME>EF004739</FNAME>
          <FVALUE>TRUE</FVALUE>
        </FEATURE>
      </PRODUCT_FEATURES>
      <PRODUCT_ORDER_DETAILS>
        <ORDER_UNIT>CT</ORDER_UNIT>
        <CONTENT_UNIT>C62</CONTENT_UNIT>
        <NO_CU_PER_OU>256</NO_CU_PER_OU>
        <PRICE_QUANTITY>1</PRICE_QUANTITY>
        <QUANTITY_MIN>1</QUANTITY_MIN>
        <QUANTITY_INTERVAL>1</QUANTITY_INTERVAL>
      </PRODUCT_ORDER_DETAILS>
      <PRODUCT_PRICE_DETAILS>
        <DATETIME type="valid_start_date">
          <DATE>2015-11-01</DATE>
        </DATETIME>
        <DATETIME type="valid_end_date">
          <DATE>2016-10-31</DATE>
        </DATETIME>
        <PRODUCT_PRICE price_type="net_list">
          <PRICE_AMOUNT>28.60</PRICE_AMOUNT>
          <PRICE_CURRENCY>EUR</PRICE_CURRENCY>
          <TAX>0.21</TAX>
          <PRICE_FACTOR>1</PRICE_FACTOR>
          <LOWER_BOUND>1</LOWER_BOUND>
          <TERRITORY>NL</TERRITORY>
        </PRODUCT_PRICE>
      </PRODUCT_PRICE_DETAILS>
      <MIME_INFO>
        <MIME>
          <MIME_TYPE>image/tif</MIME_TYPE>
          <MIME_SOURCE>PICTURE2.JPG</MIME_SOURCE>
          <MIME_DESCR>PICTURE INTERNET LARGE</MIME_DESCR>
          <MIME_PURPOSE>normal</MIME_PURPOSE>
          <MIME_ORDER>2</MIME_ORDER>
        </MIME>
        <MIME>
          <MIME_TYPE>image/jpeg</MIME_TYPE>
          <MIME_SOURCE>PICTURE1.JPG</MIME_SOURCE>
          <MIME_DESCR>PICTURE INTERNET SMALL</MIME_DESCR>
          <MIME_PURPOSE>normal</MIME_PURPOSE>
          <MIME_ORDER>1</MIME_ORDER>
        </MIME>
        <MIME>
          <MIME_TYPE>image/tif</MIME_TYPE>
          <MIME_SOURCE>PICTURE.TIF</MIME_SOURCE>
          <MIME_DESCR>PICTURE HIGH RESOLUTION</MIME_DESCR>
          <MIME_PURPOSE>detail</MIME_PURPOSE>
          <MIME_ORDER>3</MIME_ORDER>
        </MIME>
        <MIME>
          <MIME_TYPE>url</MIME_TYPE>
          <MIME_SOURCE>HTTP://WWW.TEST.NL/</MIME_SOURCE>
          <MIME_DESCR>DEEPLINK</MIME_DESCR>
          <MIME_PURPOSE>data_sheet</MIME_PURPOSE>
          <MIME_ORDER>4</MIME_ORDER>
        </MIME>
        <MIME>
          <MIME_TYPE>url</MIME_TYPE>
          <MIME_SOURCE>HTTP://WWW.TEST.NL/PRODUCTX/</MIME_SOURCE>
          <MIME_DESCR>DEEPLINK</MIME_DESCR>
          <MIME_PURPOSE>data_sheet</MIME_PURPOSE>
          <MIME_ORDER>5</MIME_ORDER>
        </MIME>
        <MIME>
          <MIME_TYPE>application/pdf</MIME_TYPE>
          <MIME_SOURCE>DATA_SHEET.PDF</MIME_SOURCE>
          <MIME_DESCR>DATA_SHEET</MIME_DESCR>
          <MIME_PURPOSE>data_sheet</MIME_PURPOSE>
          <MIME_ORDER>6</MIME_ORDER>
        </MIME>
      </MIME_INFO>
      <USER_DEFINED_EXTENSIONS>
        <UDX.EDXF.MANUFACTURER_ACRONYM>MAN. BRAND</UDX.EDXF.MANUFACTURER_ACRONYM>
        <UDX.EDXF.DISCOUNT_GROUP_MANUFACTURER>DISCOUNT</UDX.EDXF.DISCOUNT_GROUP_MANUFACTURER>
        <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.WEIGHT>7.6</UDX.EDXF.WEIGHT>
            <UDX.EDXF.LENGTH>0.3</UDX.EDXF.LENGTH>
            <UDX.EDXF.WIDTH>0.16</UDX.EDXF.WIDTH>
            <UDX.EDXF.DEPTH>0.3</UDX.EDXF.DEPTH>
            <UDX.EDXF.EAN>04444400000015</UDX.EDXF.EAN>
            <UDX.2BA.FREETEXT01>FREETEXT01 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT01>
            <UDX.2BA.FREETEXT02>FREETEXT02 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT02>
            <UDX.2BA.FREETEXT03>FREETEXT03 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT03>
            <UDX.2BA.FREETEXT04>FREETEXT04 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT04>
            <UDX.2BA.FREETEXT05>FREETEXT05 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT05>
            <UDX.2BA.FREETEXT06>FREETEXT06 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT06>
            <UDX.2BA.FREETEXT07>FREETEXT07 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT07>
            <UDX.2BA.FREETEXT08>FREETEXT08 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT08>
            <UDX.2BA.FREETEXT09>FREETEXT09 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT09>
            <UDX.2BA.FREETEXT10>FREETEXT10 (MAX 70 CHARACTERS)</UDX.2BA.FREETEXT10>
            <UDX.2BA.ARTICLEPREDECESSOR>
              <UDX.EDXF.TRADEITEMID>ARTICLEPREDECESSOR</UDX.EDXF.TRADEITEMID>
              <UDX.EDXF.GTIN>4444400000028</UDX.EDXF.GTIN>
            </UDX.2BA.ARTICLEPREDECESSOR>
            <UDX.2BA.ARTICLESUCCESSOR>
              <UDX.EDXF.TRADEITEMID>ARTICLESUCCESSOR</UDX.EDXF.TRADEITEMID>
              <UDX.EDXF.GTIN>4444400000035</UDX.EDXF.GTIN>
            </UDX.2BA.ARTICLESUCCESSOR>
            <UDX.2BA.DEEPLINK>HTTPS://WWW.2BA.NL/MYDEEPLINK/ARTICLEX</UDX.2BA.DEEPLINK>
            <UDX.2BA.STATUSCODE>84E</UDX.2BA.STATUSCODE>
            <UDX.2BA.BUYINGGROUP>BUYINGGROUP</UDX.2BA.BUYINGGROUP>
            <UDX.2BA.PROCESSABLEINDICATOR>SU</UDX.2BA.PROCESSABLEINDICATOR>
            <UDX.2BA.ORDERABLEINDICATOR>TU</UDX.2BA.ORDERABLEINDICATOR>
            <UDX.2BA.MAKETOSTOCKINDICATOR>True</UDX.2BA.MAKETOSTOCKINDICATOR>
          </UDX.EDXF.PACKING_UNIT>
        </UDX.EDXF.PACKING_UNITS>
        <UDX.EDXF.REACH>
          <UDX.EDXF.REACH.LISTDATE>2018-01-01</UDX.EDXF.REACH.LISTDATE>
          <UDX.EDXF.REACH.INFO>false</UDX.EDXF.REACH.INFO>
        </UDX.EDXF.REACH>
        <UDX.EDXF.PRODUCT_LOGISTIC_DETAILS>
          <UDX.EDXF.NETWEIGHT>6.5</UDX.EDXF.NETWEIGHT>
        </UDX.EDXF.PRODUCT_LOGISTIC_DETAILS>
        <UDX.2BA.DEEPLINK>HTTPS://WWW.2BA.NL/MYDEEPLINK/PRODUCTX</UDX.2BA.DEEPLINK>
        <UDX.2BA.PRODUCTPREDECESSOR>
          <UDX.EDXF.PRODUCTID>PRODUCTPREDECESSOR</UDX.EDXF.PRODUCTID>
          <UDX.EDXF.GTIN>4444400000042</UDX.EDXF.GTIN>
        </UDX.2BA.PRODUCTPREDECESSOR>
        <UDX.2BA.PRODUCTSUCCESSOR>
          <UDX.EDXF.PRODUCTID>PRODUCTSUCCESSOR</UDX.EDXF.PRODUCTID>
          <UDX.EDXF.GTIN>4444400000059</UDX.EDXF.GTIN>
        </UDX.2BA.PRODUCTSUCCESSOR>
        <UDX.2BA.STATUSCODE>94E</UDX.2BA.STATUSCODE>
        <UDX.2BA.SERIES>2BA.SERIES</UDX.2BA.SERIES>
        <UDX.2BA.TYPE>2BA.TYPE</UDX.2BA.TYPE>
      </USER_DEFINED_EXTENSIONS>
      <PRODUCT_LOGISTIC_DETAILS>
        <CUSTOMS_TARIFF_NUMBER>
          <CUSTOMS_NUMBER>84137029</CUSTOMS_NUMBER>
        </CUSTOMS_TARIFF_NUMBER>
        <COUNTRY_OF_ORIGIN>NL</COUNTRY_OF_ORIGIN>
      </PRODUCT_LOGISTIC_DETAILS>
    </PRODUCT>
  </T_NEW_CATALOG>
</BMECAT>
Wat biedt 2BA voor u als Installateur Wat biedt 2BA voor u als Groothandel Wat biedt 2BA voor u als Fabrikant Wat biedt 2BA voor u als Software Partner
This site is registered on wpml.org as a development site.