Set up ETIM Classification export

Set up the ETIM Classification export in Productsup so manufacturers in the electrical, HVAC, and building and construction industries can provide product data, classified by ETIM, to trade and industry partners. Productsup supports both ETIM versions 7 and 8.

Introduction

Manufacturers in the electrical, HVAC, and building and construction industries often need to provide product data, classified by ETIM, to trade and industry partners. Productsup supports both ETIM version 7 and version 8. To learn more, see ETIM.

This document explains how to set up the ETIM Classification export in the Productsup platform for:

  • Mapping imported product categories to ETIM classes

  • Setting up ETIM classification export channel(s)

  • Mapping imported product attributes to ETIM features

  • Confirming whether the mapped ETIM features contain the correct ETIM values and make necessary adjustments

Map imported product categories to ETIM classes

  1. Go to Lists from your site's main menu and select ADD A NEW LIST. In Type, select Classification List and give it a custom name, for example, ETIM 8 category to class mapping.

    add_list.png
  2. Select the Mapping Source tab and in Classification, choose the classification standard you want to map, either ETIM-7.0 Classification or ETIM-8.0 Classification. The following steps reference using ETIM-8.0 Classification as an example.

    etim8_0_overview_page.png
  3. In Stage, select Source.

    • Select the stage

    • Source

    • Intermediate

    The Source indicates the import source. Intermediate is the column that contains the product categories you want to map to the ETIM classes. 

  4. In Source Column, select a column that holds the product categories. In this example, the column name is category, select Set Source and Reset. A pop-up warning message appears stating that this action deletes any mappings that you previously created. Select Confirm.

    Note

    The Set Source and Reset button extend the list with every attribute that uses the list.

    mapping_source.png
  5. Now, return to the Settings tab, and on the left a list of values appears in category for the column you selected as a source.

  6. In the Replace Term field, as you begin typing, available ETIM classes appear. Select the relevant class and select the tick mark to save your selection. Continue with each field to assign ETIM classes to all product categories.

    replace_term.png
  7. You have now mapped your product categories to ETIM Classes.

Set up ETIM classification export channel

  1. Go to Exports A/B from your site's main menu and select ADD EXPORT. Search for ETIM-8.0 Classification and select Add.

    add_etim8_0.png
  2. Give your export a custom name if desired. In this example, use the name ETIM-8.0 Classification export. The custom name replaces the export name on the ETIM-8.0 Classification Overview page. Then select Add.

  3. Select Add Destination and choose your destination. For the following example, choose Productsup Server from the drop-down list. Give this destination a title in Name, for example, Internal FTP server, and select Save.

    Choose a channel destination for your BMEcat2005 - Single-feature/Bundled-features Approach export channel

    By default, the platform creates a small XML file and exports it to the selected destination. If desired, you can later use the product data that you previously mapped to ETIM for a specific export format, for example, BMEcat or FAB-DIS. Use the output from the export you set up as a data source for the BMEcat/FAB-DIS site.

  4. Now exit the Exports A/B view and go to Dataflow in your site's main menu.

  5. Select the ETIM export from the drop-down menu in the top ribbon and map the attributes to the Intermediate column. Use the category attribute you previously mapped to ETIM classes, to the ETIM-8.0 Classification export attribute Class code.

    connect_class_code.png
  6. Edit the attribute in the export column by hovering your mouse pointer over the Class code attribute, then select the arrow on the right.

    edit_class_code.png
  7. Next, search for the Classification Mapping rule box, then click and drag it to the blue area. In List, select the list you previously set up in the box drop-down list. In this example, ETIM 8 category to class mapping. Select Save.

    classification_mapping_rulebox.png
  8. Select Run in the top-right header to import the class attributes for the relevant classes. Wait for the run to finish and refresh your browser window. You can now see a new drop-down menu in the top ribbon titled Classifications. The classifications menu contains the ETIM classes present in your catalog.

    classifications_header.png

Map product attributes to ETIM features

  1. In Dataflow, select a class you want to work on by selecting the Classifications drop-down menu in the top ribbon. You can see the class attributes displayed on the right side.

    classifications_attributes.png
  2. Map the attributes for this class, then continue to the next ETIM class you want to work on. Some export attributes appear twice, first with their standard name and the second time with [details] after their name. For example:

    attributes_appear_twice.png

    The Material attribute field expects a correct ETIM value.  The Material [details] attribute field is a free text field where you provide more details or additional information. Use it in case you want to offer more information than ETIM requires. Or if an ETIM value doesn’t fit your case.

  3. Once you finish mapping the attributes for your ETIM classes, go to Data View and check whether your export attributes contain satisfactory ETIM values.

Confirm and correct ETIM values

  1. Go to Data View and select your ETIM export from the channels drop-down menu located in the top ribbon. Then select the ETIM class you want to first check from the Classification drop-down menu.

  2. Select the Analyze button for the column you want to check. The side panel then displays whether your values are compliant with ETIM values and if they contain the expected ETIM values. You can fill out the ETIM values using English text or ETIM codes. Once you create the final export, the platform outputs ETIM codes in either case. If you have problematic values, use the rule boxes to make content adjustments as usual.

    analyze.png