The digitalization of purchasing processes between business partners (B2B) is progressing continuously. This requires product data to be uploaded to online stores, e-procurement systems or e-marketplaces. This is where BMEcat converters come into play. Find out all about the best BMEcat converters for your company. I compare the top 5 providers and explain how the software automates your product data management, saves costs and increases efficiency.

What is a BMEcat converter?

A BMEcat converter, also known as a BMEcat generator or BMEcat software, helps to convert Product Data into an XML format. XML is a structured data format that exchanges information between IT systems. The structure of BMEcat is standardized according to the specifications of the German Association of Materials Management, Purchasing and Logistics (BME). BMEcat is now the standard for exchanging product information in the industry. A BMEcat converter translates various file formats into the electronic catalog of the same name. The basic functions include creation, validation and distribution. We will take a look at how these functions interact in the next section.

Structure of a BMEcat opened in the XML Tree Editor program

How does such software work?

To create a BMEcat, product information such as images, texts, article characteristics, customer prices and classifications (e.g. E-CLASS or UNSPSC) are required. These are made available via import channels. Depending on the maturity level of the software, various formats such as Excel, CSV, JSON or XML can be imported. The BMEcat converter takes over the “translation” into BMEcat. Validations are carried out in this step. These depend on the target system or the customer requirement. The units of measure (UOMs) are a classic example. To illustrate this, let’s take the following example. In the import file, the designation “ST” is specified for the unit of measure “piece”. However, the target system requires “PCE”. Such differences can be analyzed by the validation and translated into the language of the customer system. Once the catalog has successfully passed the check, the third step is “Distribution”. If the target system enables an automatic upload, the software can do this automatically.

Infrastructure of a BMEcat converter

bmecat software
bmecat software
bmecat software

What are the advantages of introducing a BMEcat converter?

A BMEcat converter supplements existing solutions such as PIM systems (Product Information Management) or ERP systems with the following advantages:

  • Improved data quality: Thanks to the standardization of BMEcat, Product Data can be positioned in the right place. This leads to an increase in quality, as the information arrives correctly in the target system and the search results are positively influenced. Manual errors can also be avoided.
  • Increased efficiency: Automating the creation and management of electronic catalogs saves time and resources.
  • Seamless integration: BMEcat’s XML-based format ensures seamless integration with existing systems such as ERP (enterprise resource planning), PIM (product information management) systems, e-marketplaces and e-procurement systems. This optimizes the data flow and eliminates the need for manual data maintenance.
  • Cost savings: By reducing errors through automated validation and optimizing processes, process costs can be saved. By process costs, I mean the time spent on maintaining, creating and distributing BMEcats.
  • Customer loyalty: By uploading Product Data to purchasing systems, customers can order quickly and easily. In addition, manual input errors are avoided and the customer can access up-to-date information.

How is BMEcat software developing?

In addition to BMEcat, there are other electronic catalog formats. These include Datanorm, Ariba cif or coupa’s own CSV format. There are also numerous API interfaces that exchange Product Data between systems in real time. Customer-specific CSV formats are also on the increase and pose major challenges for data suppliers. To cope with this complexity, BMEcat software solutions are evolving into e-catalog management solutions. In addition, AI (artificial intelligence) will simplify the “refinement” of electronic catalogs in the future. One possible application is the automated assignment of classifications (e.g. E-CLASS, UNSPSC, ETIM) at item level. There are also initial approaches in the creation of texts. Individual texts for target groups and systems can be created automatically.

Infrastructure of e-catalog management solutions

Top 5 BMEcat converters at a glance: e-proCAT, nexoma, Pro3Con, Storeserver, and PIM providers

e-pro – e-proCAT

bmecat software

e-pro CAT GmbH is one of the leading providers of catalog solutions with over 1,000 customers. With its roots in the Fraunhofer Institute IAO and as a co-founder of the BMEcat standard, e-pro CAT GmbH has over 20 years of experience in the development of electronic catalogs.

Selected features:

  • Classify from E-CLASS to UNSPSC and from UNSPSC to E-CLASS
  • Extensive validation options
  • Delete links of invalid MIME files. Images, data sheets and other attachments are processed under MIME.

nexoma – CatalogExpress

bmecat software

The interdisciplinary team at nexoma combines expertise from the fields of project management, software development and architecture, design and media design. Its focus is on the development and implementation of powerful software solutions for product data management. With the CatalogExpress software solution, nexoma supports companies in the efficient transformation and distribution of data via various channels.

Selected features:

  • Conversion to complex standards such as FAB-DIS, BMEcat ETIM or ETIM xChange
  • Standard interfaces to PIM systems such as Akeneo, Apollon, Contentserv, ViaMedici, Pimcore or the Shopware store system

Pro3Con – Primus Catalog

bmecat software

Pro3Con GmbH is a software provider in the field of automated distribution of Product Data. The focus is on providing customized solutions for the creation and integration of e-catalogues and webshop systems. With a deep understanding of the digital transformation of business processes, Pro3Con supports companies in making their procurement and sales processes more efficient.

Selected features:

Store server

bmecat software

Founded by Managing Director Sven Sprandel in close cooperation with the Fraunhofer IAO, the company’s origins lie in the development of the openTRANS/BMEcat exchange format. This was implemented as the first focus with the store server BMEcat generator and continuously developed further.

Selected features:

  • Converter works on an Excel basis and can be used locally
  • Flexible extension of BMEcat fields

PIM systems (Product Information Management)

bmecat software

Many PIM providers have implemented the BMEcat format. In contrast to the BMEcat converters, PIM systems are based on internal logics. These reach their limits as soon as customers and target systems make specific requirements. The solutions can be requested and implemented as programming requirements using change requests. If this is too time-consuming and expensive, the specialist department can rework them manually.

Selected features:

  • BMEcat standard with internal logic

Five important steps for the introduction of BMEcat software

bmecat software
  1. Needs analysis: Before implementing a BMEcat converter, it is important to assess your business needs. Determine the size of your item portfolio, the complexity of the item data and the integration requirements.
  2. Selecting the right software: The right software must be selected based on the needs analysis. Important criteria are user-friendliness, existing interfaces, scalability, the provider’s knowledge of the target channels, joint development potential and the price model.
  3. Data preparation: Product Data is the be-all and end-all. Prepare your existing Product Data for migration. This can include cleansing data, standardizing formats and ensuring the completeness and accuracy of all necessary information.
  4. Integration: Integrate the BMEcat converter into your existing systems. It is best to get your IT colleagues on board as early as step 1. Seamless integration into existing systems is recommended in order to reduce manual activities. If you mainly work with Excel, you can start directly with the integration of the target systems.
  5. Training and support: Provide training for your team to help them learn how to use the new software. Also make sure they have access to ongoing support to resolve any issues that arise.

Conclusion

The introduction of a BMEcat converter is a valuable tool for setting up professional Product Data and catalog management. It allows manual and small-scale work steps to be automated step by step. This results in up-to-date data in the target systems and an increase in customer satisfaction.

With standardized data formats, comprehensive functions and scalability, software providers for generating BMEcats offer numerous advantages, including improved data quality, increased efficiency and cost savings. Through careful needs analysis, selection of the right software and focused implementation, rapid optimization can be achieved.

At a time when digital transformation is progressing and e-commerce is becoming increasingly important, high-quality product data updates at short notice are the foundation for sales. Are you ready to optimize your digital sales processes and take advantage of BMEcat software?

B2B E-Commece Expert

Peter Prütting is an expert in value-oriented and digital business development. With over 15 years of sales experience in wholesale, manufacturing and e-marketplaces, he takes a holistic view. His colleagues value him as a customer-centric and focused leader who guides teams through digital change. Away from his day-to-day work, he recharges his batteries by mountain biking.

FAQ – frequently asked questions

What is a BMEcat converter?

A BMEcat converter is software that converts Product Data into the standardized XML format BMEcat. This format enables the exchange of product information between different systems in the B2B sector. The software validates and distributes the data automatically.

How does a BMEcat converter work?

A BMEcat converter imports product information from various file formats such as Excel or CSV and translates it into BMEcat format. The data is checked for errors and adapted to the requirements of the target system. After successful validation, the data can be distributed automatically.

What advantages does a BMEcat converter offer?

A BMEcat converter improves data quality, automates processes and therefore saves time and money. It also enables seamless integration into existing systems and increases efficiency in product data maintenance.

How do I choose the right BMEcat converter?

The selection depends on various factors such as the complexity of the Product Data, the integration requirements and the scalability of the software. Other important criteria are user-friendliness and the interfaces to other systems such as PIM or ERP.

How are BMEcat converters developing?

BMEcat software is evolving into comprehensive e-catalog management solutions that support other catalog formats and APIs in addition to the BMEcat format. In the future, AI will be used to automate classification and text generation, further simplifying the process.

Sources

If you want to list items in the Coupa Supplier Portal, there is no way around the catalog format Coupa CSV Catalog or Punchout Catalog. Find out what the “Coupa CSV Catalog” is and how your company can create such catalogs.

What is the Coupa catalog?

The Coupa catalog is an electronic catalog in CSV format. It was developed to provide Product Data, images and prices for customers who use the “Coupa” e-procurement portal. The customer can choose from these products and place orders.

What advantages does the Coupa catalog offer?

The sale of products via coupa is possible via the aforementioned catalog or via WebEDI processing. The customer places the order there and the supplier collects it from the online portal. In contrast to the coupa catalog, this process has numerous disadvantages. In addition to the manual activity, data quality is not guaranteed and the supplier can be replaced quickly. In contrast, suppliers who provide a catalog have the following advantages.

  • Customer loyalty: In order to upload a catalog to the Coupa Supplier Portal, the customer’s supplier invitation is required. The articles can be uploaded on this basis.
  • Increased visibility: By providing well-structured and high-quality Product Data, suppliers gain visibility with employees authorized to place orders.
  • Automation: The integration of Product Data, via the CSV catalog in Coupa, ensures up-to-date prices and product information. This means that the subsequent process can be automated without errors using EDI. EDI stands for Electronic Data Interchange and describes the electronic exchange of messages.

What is the difference between the Coupa-Catalog and the Punchout-Catalog?

Coupa offers the integration of articles via two different catalog types. Punchout catalogs offer the advantage that they always provide up-to-date product information and prices. As the data is linked directly via the supplier’s website or online store. This means that customers always have the latest data available. The static Coupa catalog offers the advantage that items can be found via the comprehensive search. By storing the information locally in the Coupa system, items can also be included in favorites lists and workflows. Customers who often buy the same items appreciate this option.

  • Punchout catalog: This type of catalog makes it possible to integrate the supplier’s website or online store into the Coupa platform. In the case of an order, the customer’s employee jumps to the supplier’s website and selects the products there. After the shopping cart is completed, the data is transferred back to Coupa. There, the order is finalized and sent to the supplier. Punchout catalogs are dynamic and automatically update prices or availability.
  • Coupa CSV Catalog: This type of catalog is also known as a static catalog. Product Data, prices and images are uploaded to Coupa via a structured CSV file. After the upload, the customer checks the catalog content and releases it for the requisitioners (employees authorized to order). If the product range or prices change, a new upload and approval by the customer is required.

What does the static catalog look like in csv format?

A Coupa catalog in CSV format contains a wide range of information that is important for your customers. Each line in the CSV document represents a product. The most important Product Data includes product names, product descriptions, article numbers, prices, images and delivery times. The following image shows an example catalog, each separated by a semicolon. It can be opened in Excel and displayed in a structured format for maintenance purposes.

coupa csv format
Example of a Coupa catalog

What options are available for creating this catalog file?

There are three catalog creation systems that support you in creating the Coupa catalog. The choice of the right “tool” depends on a few basic conditions. These include the number of catalog files to be created, the maturity level of your organization and whether automation of the process is being considered.

  • Excel to CSV file converter: Coupa provides an Excel template for each project. The information can be maintained manually and then converted to a CSV file.
  • Software for catalog creation: Professional software is used to import the product portfolio from a source system or file, validate it and output it again in the appropriate format. Depending on the target system, the catalog upload can be automated via FTP server. If you are interested, you can read the blog post “Software for electronic catalog creation”.
  • PIM systems (Product Information Management System): If your company already has such a system, you can check whether an export function for individual CSV templates exists or can be programmed.

Conclusion

The Coupa catalog is an important tool for suppliers who want to serve customers and sell items via the Coupa Supplier Portal. Product Data, prices and images can be listed with this catalog in CSV format. The advantage for suppliers is that customers have access to up-to-date data. This increases customer visibility, which generally leads to increased sales and customer loyalty. In addition, up-to-date data is the basic prerequisite for the successful digitalization of subsequent processes. EDI (electronic data interchange) can be used to automatically exchange messages such as orders and invoices. We are currently experiencing a change in the purchasing behavior of business customers. Increasingly, user experiences from the private customer sector, e.g. with Amazon and Zalando, are expected in the business environment. Coupa takes this into account and enables suppliers to position themselves with the Coupa catalog.

B2B E-Commece Expert

Peter Prütting is an expert in value-oriented and digital business development. With over 15 years of sales experience in wholesale, manufacturing and e-marketplaces, he takes a holistic view. His colleagues value him as a customer-centric and focused leader who guides teams through digital change. Away from his day-to-day work, he recharges his batteries by mountain biking.

FAQ – frequently asked questions

What is the Coupa catalog?

The Coupa catalog is an electronic catalog in CSV format that provides Product Data, images and prices for customers using the e-procurement portal “Coupa”. Suppliers can upload Product Data, prices and images from which customers can select and place orders.

What advantages does the Coupa catalog offer?

Firstly, customer loyalty: Requires a supplier invitation from the customer to upload items. Second, increased visibility: Well-structured Product Data increases visibility to employees authorized to order. Third, automation: Integration of Product Data via CSV catalog ensures up-to-date prices and information, reducing process error through EDI (Electronic Data Interchange).

What is the difference between the Coupa catalog and the Punchout catalog?

Punchout catalog: Links directly to the supplier’s website to provide up-to-date product information and prices. The customer selects products directly on the supplier’s website and the data is then transferred to Coupa.
Coupa CSV Catalog: A static catalog where Product Data, prices and images are uploaded via a CSV file. Changes require a new upload and approval by the customer. Items can be integrated into favorites lists and workflows.

What options are available for creating this catalog file?

Excel to CSV file converter: Coupa provides an Excel template that can be maintained manually and converted to a CSV file.
Software for catalog creation: Professional software imports the product portfolio, validates it and outputs it in the appropriate format. The catalog can be uploaded automatically via an FTP server.
PIM systems: Existing product information management systems can be used to export or program individual CSV templates.

Sources

Coupa, catalogs: https://supplier.coupa.com/catalogs/

Would your customer like to receive data via Datanorm? Does he mean a system, specific product information or documents? This article will help you to understand the DATANORM concept.

What is DATANORM?

DATANORM is a standardized file structure for the exchange of product information such as article number, tender text, price and image names. This format is mainly used in the construction industry. The aim is to enable the listing of articles from manufacturers and wholesalers in Enterprise Resource Planning (ERP) or calculation programs with just a few clicks.

catalog type datanorm
Source: datanorm.de – Logo

This means that product information such as item prices no longer needs to be maintained manually, but can be transferred directly to the software via the interface. This saves a lot of time and keeps the product information up to date.

The structure and content are defined and developed by the DATANORM working group. The working group consists of associations, manufacturers, dealers, publishers and software providers from the construction and craftsman sectors. This standard is therefore manufacturer-independent.

Which versions of DATANORM are available?

This file structure was published in 1986. Three versions have been published since then:

  • 1990 Version 3
  • 1994 Version 4
  • 1999 Version 5 (current version)

Version 5 added further information such as tile product features, customs tariff numbers or multimedia elements such as images or drawings.

catalog type datanorm
Source: datanorm.de – Comparison of versions

Structure of the DATANORM structure

DATANORM is not mapped using a single file, but the information is stored in several files. The individual data records are identified via the article numbers and group numbers.

catalog type datanorm
Source: datanorm.de – Basic product information

A complete “DATANORM record” consists of the following files:

  • Basic product information: DATANORM.001- .999
  • Product groups: DATANORM.WRG
  • Price file: PREISDAT. 001 – .999
  • Discount groups: DATANORM.RAB

Which systems have a standard interface to DATANORM?

The format has become the industry standard in the construction and craftsman sectors. For this reason, many software providers have a standard interface that can read DATANORM files. These include

Craftsman software

Enterprise resource planning system (ERP)

Accounting software

Challenge: Keeping article data up to date

DATANORM is a static catalog format. I like to compare this to a stone tablet. Because as soon as the data has been sent from the wholesaler to the trade business, it is already out of date again. There is a smart approach to this problem. Many providers of craftsman software have an additional interface for integrating dynamic catalogs. This allows current prices and availability to be called up for quotations and orders. The interface described is called IDS. This abbreviation stands for “Integrated Data Interface” and connects craftsman software with the supplier’s online store.

➡️ Would you like to provide your customers with up-to-date images, prices and delivery times in quotations? In this case, it is worth taking a closer look at the IDS Connect interface. Read here to find out what this interface can do and how it is revolutionizing the craftsman’s trade.

Conclusion

DATANORM is the industry standard in the construction sector. It allows data to be exchanged quickly and easily. If the construction industry is a focus target group for your company, then it is worth investing in the structure of DATANORM files. Before you dive into the technical details of this structure, my tip is to take a look at your customers’ must-have DATANORM information and analyze whether this information is available in a structured form.

B2B E-Commece Expert

Peter Prütting is an expert in value-oriented and digital business development. With over 15 years of sales experience in wholesale, manufacturing and e-marketplaces, he takes a holistic view. His colleagues value him as a customer-centric and focused leader who guides teams through digital change. Away from his day-to-day work, he recharges his batteries by mountain biking.

FAQ – Frequently asked questions

What is DATANORM?

A structured file that can be used to pass on product information from wholesalers and manufacturers. This structure is widely used in the construction industry.

What is DATANORM not?

It is not software or a program. Nor does it automatically update any product information. It is also not a ASCII plain text.

Which versions of DATANORM are available?

There are currently versions D3, D4 and D5.

Do enterprise resource planning (ERP) systems or invoicing programs offer a DATANORM interface?

Yes, providers of software for craftsmen in particular have provided such an interface to DATANORM.

What advantages does DATANORM offer over manual data maintenance?

Time savings, error reduction and automatic updates.

Is DATANORM also suitable for small craft businesses?

Yes, the benefits are available to small and large companies.

Are there alternatives to DATANORM?

Depending on the application and software, other static catalog formats such as BMEcat or EXCEL can also be used. Dynamic catalogs such as OCI or IDS are also exciting alternatives.

Sources