Skip to main content

BMEcat 2005 - ETIM-7.0 Classification export (legacy document)

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, the international classification standard for technical products.

To export data including classification specific attributes we created the BMEcat 2005 - ETIM-7.0 Classification export.

1. Add the BMEcat 2005 - ETIM-7.0 Classification export

Go to Exports A/B and click on the blue Add Export button in the top right corner.

Choose the export ** BMEcat 2005 - ETIM-7.0 Classification** and click on Add.

Add a destination of your choice e.g. the Productsup Server.

3ff1cbb6bcb06952ccd98c5f031bb588.png

2. Setup Dataflow to get classification specific attributes

Go to the Dataflowand connect your data accordingly. The class code column should contain the ETIM like EC012345.

If you export, our platform will check the ETIM within the class code column and generate the classification specific attributes. You can choose the classification in the Dataflow to map the classification specific attributes.

eeace0db7852182376d9cdaa63bee561.png

3. Add rules to classification specific attributes

In the Data View for the "BMEcat 2005 - ETIM-7..." you will find a filter for the ETIM class in the classification dropdown.

750d62458ee39429d5dfaed251877d56.png

To see and edit the classification specific attributes you have to select an ETIM class in the classification dropdown (which is "All classifications" by default).

You will see all basic columns like SUPPLIER_PID, PRODUCT@mode or Class code for all classifications also if you only have selected a specific classification. Specific attributes are only shown for the classification they are needed for.

046d3f6ee418f03c9066778b2e39e260.png

4. Provide Header Information

BMEcat files require detailed information about the supplier and catalog content. This information can be added under the settings tab in the export setup. In most cases the neccessary details will be provided by partner.

9b8c817283a6245334bb96f96223a3fc.png

5. Indexed Attributes

5.1 What are indexed attributes?

Some attributes can have more than one instance, for example descriptions, which can come in several languages for an item.We are referring to these attribues as indexed attributes. Some of the indexed attributes consist of several sub-attributes. The relationship between these sub-attributes is marked by an index number per attribute in the output file.

5.2 How is that reflected in the setup?

To prevent the user from having to create a field in the dataflow for every instance, Productsup is using a delimiter within the fields, to let the user add several instances.

This is best to be explained with an example:

The attribute Description Short can contain short descriptions for several languages. Sub-attributes are the description itself and the language.The user needs to populate the two sub-attributes DESCRIPTION_SHORT@lang and DESCRIPTION_SHORT, so the output file will be properly populated.It is imported to provide the information for the instances in the same order in every sub-attribute.

  • Description Short DE: Hochwertiges Werkzeug

  • Description Short EN: High quality tool

  • Description Short FR: Outil de haute qualité

This needs to be added to the sub-attributes like this:

DESCRIPTION_SHORT@lang

DESCRIPTION_SHORT

DE<###>EN<###>FR

Hochwertiges Werkzeug<###>High quality tool<###>Outil de haute qualité

In case one of the sub-attributes is missing for an instance, an empty value needs to be used. Just skipping it will lead to inconsistencies within the output file.

5.3 List of indexed attributes and their sub-attributes

Note: When using the ETIM-7.0 Classification export, the classification will take care of the Product Features, so there is no need to manually adjust them.

Description Short

DESCRIPTION_SHORT@langDESCRIPTION_SHORT

Description Long

DESCRIPTION_LONG@langDESCRIPTION_LONG

Product Details

KEYWORDREMARKS

Product Features

FNAMEFVALUEFUNITFVALUE_DETAILS

Price

PRICE@price_typePRICE_AMOUNTPRICE_CURRENCYTAXLOWER_BOUND

MIME

MIME_TYPEMIME_SOURCEMIME_DESCRMIME_PURPOSE

User Defined Extensions

MIME

UDX.EDXF.MIME_SOURCEUDX.EDXF.MIME_CODExUDX.EDXF.MIME_FILENAMEUDX.EDXF.MIME_DESIGNATIONUDX.EDXF.MIME_ALTUDX.EDXF.MIME_ISSUE_DATEUDX.EDXF.MIME_EXPIRY_DATE

Description Very Short

UDX.EDXF.DESCRIPTION_VERY_SHORT@langUDX.EDXF.DESCRIPTION_VERY_SHORT

Packing Unit

UDX.EDXF.GTINUDX.EDXF.GS1_128UDX.EDXF.QUANTITY_MINUDX.EDXF.QUANTITY_MAXUDX.EDXF.PACKING_UNIT_CODEUDX.EDXF.PACKING_UNIT_NAMEUDX.EDXF.PACKAGE_BREAKUDX.EDXF.PACKING_PARTSUDX.EDXF.VOLUMEUDX.EDXF.WEIGHTUDX.EDXF.LENGTHUDX.EDXF.WIDTHUDX.EDXF.DEPTHUDX.EDXF.DIAMETER

Product Characteristic

UDX.EDXF.PRODUCT_CHARACTERISTIC_CODEUDX.EDXF.PRODUCT_CHARACTERISTIC_NAMEUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_NUMERICUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_STRINGUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_BOOLEANUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_RANGE_FROMUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_RANGE_TOUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_SETUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_SELECTUDX.EDXF.PRODUCT_CHARACTERISTIC_VALUE_UNIT_CODEUDX.EDXF.PRODUCT_CHARACTERISTIC_REFERENCE_GTIN