Classification with PIM

Conversion possibilities

By using product information that is classified by the manufacturer, you save a lot of work as a wholesaler and 100% correct information is guaranteed.

Excel or ERP files into ETIM/2ba format

Do you, as a manufacturer, have extensive item information with the associated properties available in Excel or your ERP system? Then this can form the basis for the ETIM classification file you want to deliver to your customers or the 2ba datapoo. Guidance has developed a converter that can convert ERP or Excel files into the ETIM format.

How does it work?

Your Excel file or ERP export must be equipped with column names that match the ETIM properties (EF codes). The entered property value of a product must (ideally) match the values used in ETIM (the EV codes). If this is not the case, a mapping table can be set up. This is a table that links the properties and values of both documents. This table can be used to link the correct ETIM EV code.

After that, the converter created an ETIM file from Excel or the ERP. This file can be delivered directly to 2ba.

Excel, ERP or ETIM format into EZ-base format

Do you want to deliver your product information to EZ-base and do you have the information with the associated properties available in Excel, your ERP system or in ETIM format?

Guidance has developed a converter that can convert these files into the EZ-base format.

How does it work?

Depending on the structure of your file, a mapping must be set up. This is a table in which the relation between the values and properties of both documents is recorded. Based on this mapping, the converter creates the correct EZ-base file.

The EZ-base file can be delivered directly to EZ-base.

Convert Technische Unie files into ETIM/2ba

Have you already classified your files for delivery to Technische Unie? And do you also want to deliver your data in ETIM format to, for instance, 2ba without the need to construct a new file?

Guidance has developed a converter that can convert files in the delivery format of Technische Unie (TU) into the ETIM (2ba) format.

How does it work?

First, a relationship must be established between the 2 files. The properties and values of the Technische Unie (TU) document and the ETIM document (EC code) must be matched. The entered alphanumeric values will also need to be matched with the ETIM EV code. For instance, a color (such as baby blue) will need to be linked to an available ETIM EV code for that colour (such as light blue).

Once the relationship is established, the converter will turn the Technische Unie file into an ETIM file. This file can be delivered directly to 2ba or be read in (Catalogger) PIM.

Converter for creating a price catalog file for 2ba

Do you as a wholesaler want to deliver your price data to 2ba so that installers can look it up and use it? Guidance has a converter that allows you to easily select your range from a 2ba supplier file and add your pricing to it.

How does it work?

The wholesaler receives files from manufacturers or downloads supplier files from 2ba. Because a wholesaler often does not offer the entire range of a manufacturer, only the products the wholesaler has in its range should be selected. This can be done using a selection file, which often comes from the ERP system. Then the wholesaler prices/data is linked (also coming from the ERP), and a price catalog file is created that can be delivered to 2ba by the wholesaler.

Request information

More information

Please fill in the form below for more information.

We use cookies just to track visits to our website, we store no personal details. We also us commercial cookies, accept them for a better user experience. Please refer to our Privacy Policy.