ETIM-Mapper 6.17 User Manual

Two versions (suppliers and wholesalers)

ETIM-Mapper is available in two versions:

The version for wholesalers in addition to the functionalities available for suppliers, enables handling of products assigned to different suppliers. For this reason, three additional variables are used:

In the further part of the document, descriptions referring to wholesalers version will be indicated. All descriptions without explicit distinction refer to both versions.

Import | File

In order to speed up data transfer and to avoid problems with uploading large files (over 128MB) it is recommended to import compressed (zipped) files.

Excel file (product data) – in practice, classification is performed most often on the basis of the existing files containing the list of products, such as pricelists. Except prices, these files usually contain values of some basic parameters that must be assigned to the appropriate parameters required by the ETIM standard. To start the classification work, such list of products should be transformed into Excel template (see below) and imported to the classification software. For example, if you know in advance the ETIM description of your products, you can generate the import templates (Excel files) for the corresponding ETIM class or classes. ETIM templates contain the structure of the ETIM classes with all required features and values to be used within this class. In this way, the whole ETIM classification can be prepared in Excel templates and then the template files filled with the product data can be imported into the classification software. It is the easiest and recommended way, under the condition that you know in advance the ETIM description of your products. In the same way it is possible to generate Excel file with product information, such as: general, ordering, packaging, pricing or MIME information and ETIM class codes. In similar way, the usage of the ETIM-Mapper template allows to import all product data used internally in ETIM-Mapper application, such as labels and additional technical description. All incorrect information is omitted during the import process, for example: values with incorrect header names, incorrect codes of ETIM classes, features or values, incorrect types of values, etc. To see how to generate Excel template files, go to the next section.

BMEcat file (product data) – if you have previously classified product information in the BMEcat format (supported files in BMEcat version 1.2 and 2005), it is possible to import the whole classification automatically.

Import modes (product data) – the following modes are available for the import of products existing already in the database (duplicate handling):

For the safety reason, the "merge" import can be done in two different ways, concerning the handling of empty values. The choice can be done in the import form ("Empty fields overwrite existing values").

If "Empty fields overwrite existing values" option is set to "no" (default value):

If "Empty fields overwrite existing values" option is set to "yes":

Excel file (category trees) – it is possible to import the whole category tree or multiple category trees defined in one Excel file. Important: every category tree is identified by an unique code (identifier), therefore the imported category tree will delete and replace the existing category tree having the same identifier (all the assignments of product to the existing category tree will be lost).

Import of supplier's files (only wholesalers) – it is possible to import files of an indicated supplier. In the "File/Import" form a supplier corresponding to the imported file should be selected (important: the supplier has to be formerly defined in the "Settings/Suppliers" page; only defined suppliers are available in the import form). When importing a BMEcat or Excel file with the selected supplier, the main product identifier (SUPPLIER_PID in BMEcat file or "Product ID" in Excel file) is stored as "Product ID by supplier". In similar way, the alternative product ID (SUPPLIER_ALT_PID in BMEcat file or "Alt. product ID" in Excel file) is stored as "Alt. product ID by supplier". In the case of duplicate values ​​of the "Product ID by supplier" field, the application merges products. For new products, the value of the "Product ID" field is automatically generated as a 12-character alphanumeric string.

Import of own (distributor's) files (only wholesalers) – when importing a BMEcat file without a selected supplier, all products are imported as distributor products. The fields "Supplier", "Product ID by supplier", "Alt. product ID by supplier" are empty, meaning "no data". In the case of importing of Excel files without a selected supplier, all products are imported as distributor products. In comparison to the supplier's Excel file, the distributor’s own Excel file can contain three additional fields: "Supplier" (an existing in ETIM-Mapper supplier identifier), "Product ID by supplier" and "Alt. product ID by supplier". In the case of duplicate values of the "Product ID" field, the application merges products. The application takes care of the uniqueness of the field pair: ("Supplier", "Product ID by supplier").

Templates | File

ETIM-Mapper templates are Excel files containing the structure for managing of the whole information about products and their classification. They allow to prepare any data information in Excel and then to import it into ETIM-Mapper. When generating a template, you can choose the type of template: concerting the products or products categories (category trees). For products, it is also possible to choose which type of product information should be included in the template. The Excel templates are structured in sheets containing different types of information, described below.

Important: when importing product information from Excel templates, the names of the Excel sheets must be preserved. Sheets with different names will be omitted.

Template for product data – as a general rule, the first column in every template sheet should contain identifiers of products (column named "Product ID"). Other columns should contain the most accurate description of the product, depending on the particular template sheet and column. Template sheets for product data can be the following:

Template for category trees – this kind of template can be used to define and import one or many category tree(s):

Export | File

The default values of all export settings can be customized in the "Settings/Export" page. All files are exported in a compressed form (zipped).

Product data (BMEcat 2005 ETIM) – the default format for product data exchange, recommended by ETIM International. The following export options are available here:

Product data (Excel) – the auxiliary product data exchange format used for export/import of all product data in ETIM-Mapper. The following export options are available here:

Product cards (PDF, up to 50 products) – product description in the form of PDF file. The following export options are available here:

Category trees (Excel) – category tree or trees created in the ETIM-Mapper application can be exported in the form of Excel file. They are exported on the sheet named "Category trees" containing the following columns: "Category tree identifier", "Parent category identifier" and "Category identifier"; these columns are followed by columns corresponding to names of categories in languages available for the user.

Create a link to the current export – you can create an "export link" to the current export form. You can distribute such link to the data receiver, instead of sending him a catalogue file. The receiver will be able to download your file (no login needed) according to selected export settings. All generated exports links are available in the "Settings/Export links" page.

Export of products (only wholesalers) – all products are exported as distributor's product. It is not possible to execute any export for an indicated product supplier (the distributor becomes a new supplier of the exported product data). In the case of BMEcat export, products are exported without any information about the previous supplier – the fields "Supplier", "Product ID by supplier", "Alt. product ID by supplier" are not exported, because they are not part of the BMEcat structure. However, in the case of Excel file export, the fields "Supplier", "Product ID by supplier", "Alt. product ID by supplier" are exported in the corresponding columns.

Classification

Classifying screen is the main component of the application. It is divided into two parts:

Products – it contains a list of all user products. The elements of the list are: product ID, completeness of product description, ETIM class identifier (if the class has been assigned) and name of the product. If the product has a label or photos, their presence is indicated by icons. It is possible to sort products, and filter them to restrict the number of displayed products, which greatly simplifies the navigation. To start the classification process, one product must be selected in this screen.

Classification window – it is the most important part of the application: all the values for the ETIM and BMEcat description are entered here. The window consists of seven tabs:

A completeness of the product description is measured in each information category: ETIM, general, order, packing, price and MIME. The completeness description for every category represents the coverage of the mandatory fields, required by ETIM International*. The total completeness of the product description is a weighted average of the values in each category. The completeness indicators (total and for each category) for a single selected product are shown in the classification window tabs.

* The completeness measure is based on the fields, which are mandatory in at least one country (such fields are marked in bold in the application).

All products | Products

This page contains a list of all the products loaded for classification.

It allows you to filter products: you can use a set of filters for each column (the completeness of the product description can be use in filters, among others filtering criteria). Filter can be saved ("Save filter") – in this way, the list of products "seen" by a particular user will be limited to products that meet the criteria set in the filter. Some special characters can be used in filter: % (percent) or (underscore), denoting respectively any text or any single character. The active filter is signaled – name of the currently selected filter is displayed in red. The filter will remain active until it is removed or modified. You can define several filters, but only one of them can be active.

You can sort the products by a particular column or delete the selected product from the list. To delete product(s), select the corresponding checkbox and click on the button "Delete selected products" that appear if at least one product is selected.

Group modification for multiple product is possible for certain features. To collectively modify such parameters of selected products, you must open the modification form (link: "Modification for multiple products"), then enter the corresponding values for the columns to be modified and click the button "Save" (that appears when at least one of the form fields is modified). Columns for which values are modified are highlighted in light blue. Note: activating the form for any column without typing values can mean the propagation of an empty value. To deactivate such column, you should click on this column once again.

This screen offers also a possibility to add a new product manually (icon: ). To create a new product, you only need to provide its unique identifier. The remaining elements of the description should be completed in the Classification screen or by import.

You can also create a new product based on an existing one by copying its description, classification and labels – the so-called "product cloning" function (icon: ) is used for this purpose. It is required to provide only an unique identifier of the new product. The other elements are copied from the original.

Products by ETIM | Products

A list of classified products is available in this page. Products are grouped according to the ETIM classification (group/class/products). A list of products classified in a single class helps to check the correctness of filling of individual parameters of every product.

This view allows you to sort, filter, selectively delete products or globally modify parameters of selected products. The special characters: % (percent) or _ (underscore) can be used in the filter, denoting respectively: any text or any single character.

To delete product(s), select the corresponding checkbox and click on the button "Delete selected products" that appear if at least one product is selected.

To collectively modify parameters of selected products, you must open the modification form (link: "Modification for multiple products"), then enter the corresponding values for the columns to be modified and click the button "Save" (that appears when at least one of the form fields is modified). Columns for which values are modified are highlighted in light blue. Note: activating the form for any column without typing values can mean the propagation of an empty value. To deactivate such column, you should click on this column once again.

Products by categories | Products

Products can be accessed by the user-defined category tree(s). After selecting a category tree it is possible to navigate in its structure, seeing all subcategories or products assigned to the current category.

ETIM-Mapper allows to assign products at all levels of the category-tree structure (not only at the leaves-level). In the current version of the application, you can assign product to categories only via Excel import or API.

Migration ETIMv6 → ETIMv7 (optional) | Products

In this page there is a list of classified products, affected by the migration (if there were no such products, this page is not visible or is empty). They are called "products for approval". The following changes in the classification of products are shown:

In this view, the user can filter products and modify values globally for multiple products (button "Save") and approve its migration (button "Confirm"). In this way, the modification and the approval of all migrated products can be done in one place.

All the products approved by the user are no longer visible on this page. It is recommended to review and approve all products affected by the migration. In order to verify the initial number of products for approval, click on the link "show initial list".

Statistics

Statistics page shows you the total average completeness of the product description and average completeness description in each information category: ETIM, general, order, packing, price and MIME. Besides these completeness indicators, there are pie-charts showing the distribution of products in five ranges of the description completeness:

This product distribution can be helpful to improve and monitor the completeness of the product description.

Account | Settings

User can edit account settings (e-mail, password, interface language, load limit of products to be displayed).

Company | Settings

User can edit the information concerning his company.

Suppliers (only wholesalers) | Settings

Allows wholesalers to manage the information concerning the product data suppliers. When user creates a supplier, an unique alphanumeric identifier must be assigned to the supplier. This identifier is then used for referencing a supplier in ETIM-Mapper (for example in import options).

Export | Settings

User can edit default values for all export options.

Labels | Settings

User can view, modfiy or delete labels, for product identification. If existing label is deleted, it is removed from all products marked with it. In addition to the visual indication of products, the label can also be used to filter products.

Filters | Settings

User can view, rename, delete or activate defined product filters.

Category trees | Settings

This setting option allows to define or modify category trees to be able to assign product to user-defined categories. To create a category tree it is necessary to give an unique identifier. Optionally, it is possible also to define a tree name (in every language available for the user). Then, it is possible to define a hierarchy of categories by giving their identifiers and names. Categories can be nested (every category can have one or more subcategories). It is possible to cut (remove) categories or subcategories together with the whole branch or move it into another place in the category tree (important: cutting a category or subcategory removes all the assignments of product for the removed branch). Category tree(s) can be also imported and exported via Excel files or API.

Disk space | Settings

User can place MIME files (photos, drawings, certificates, index cards, etc.) available for customers.

Start using ETIM-Mapper

Contact

MediaLab s.c.
Bożena Rożenek, Zbigniew Rożenek

Beskidzka 25
91-612 Lodz, Poland

+48 512 555 879
+48 42 209 14 39
+48 42 633 29 46

zbyszek@medialab.pl
gnowak@medialab.pl


Some of our customers

EurotermABBPolam NakłoGrudnikPrometUTC Fire & Security