Challenges in Craft Industry

Craftspeople are familiar with the problem: high demand and many parallel projects on the one hand – a shortage of skilled workers, time pressure, and rising material prices on the other. In our fast-paced world, most craft businesses handle more orders than a traditional 40-hour week would actually allow. It quickly becomes clear that efficient and reliable construction site management has become the cornerstone of every business. With our modern HERO software, businesses can map various organizational processes, from digital construction site planning and mobile time tracking to invoice management. The entire team can collaborate digitally in the central interface, ensuring that working time is used efficiently and no construction site is forgotten.

“HERO impressed us in customer projects with its sympathetic team and easy-to-use software. I am therefore delighted about the following ideas for the article master and automation.”

Peter Prütting

ERP Craft Industry
Daily construction reports can be written in no time at all in the HERO software – this makes digital construction site management much easier.

Digital Construction Site Management

With HERO, construction site management is completely digital – but what exactly does that mean? Quite simply, users can use HERO to perform various tasks involved in organizing, processing, and successfully completing a project digitally and centrally in one software program. These include, for example, preparing quotes, scheduling, construction documentation, and accurate post-calculation. The craftsman software offers users various practical features as well as a mobile craftsman app that has been proven to make work in the office, in the workshop, and on construction sites easier.
“My favorite feature in the mobile app is the ability for the end customer to sign the respective document directly on their smartphone.”
Quote from Peter Prütting

It gets even better with our state-of-the-art automation tools, which can be easily integrated into the HERO software and help users with repetitive office work in particular. For example, customer emails can be sent automatically, construction site photos can be shared at the touch of a button, and project status reports can be updated automatically. The all-in-one operating software thus reduces manual effort and helps tradespeople spend less time in the office and more time on the construction site.

ERP Craft Industry
The digital planning board enables craftsmen to optimally allocate their employees and resources to projects in terms of time.

The key: a well-maintained product master

A well-maintained article master is the key to smooth processes for construction companies—from quotation to invoicing. Whether concrete, bricks, insulation materials, windows, or door fittings: the article master contains all the materials, components, and services required on the construction site. Only when this data is up-to-date and complete can construction managers and estimators prepare accurate quotes, schedule materials on time, and keep track of costs. This makes the article master an indispensable basis for modern, digital construction site management. The digital article master is like a central database that contains all the products, materials, services, prices, and supplier information that a craft business needs in its day-to-day work. In HERO, maintaining article master data is completely digital and super easy. And why is that so important? The better and more up-to-date this item data is maintained, the faster and more accurately quotes and calculations can be created. This means customers receive feedback much faster, employees spend less time manually searching for the right article data, and errors in material selection and pricing can be significantly reduced.

ERP Craft Industry
Maintaining article master data and current prices is easier than ever in HERO thanks to our interfaces.

Time wasters: Article master data maintenance in everyday life

Regularly maintaining hundreds of product entries and keeping the relevant data up to date takes time and effort. Material availability changes, new products come onto the market, and manufacturers change their prices at will. In the hectic day-to-day running of a business, maintaining product master data is a considerable problem—especially when data is updated exclusively manually or even irregularly. The effort involved is considerable, order fulfillment suffers as a result, and if the use of outdated article master data leads to incorrect calculations, this creates yet another problem. At HERO Software, we are aware of these issues and have come up with a practical solution for efficient master data maintenance that helps every craft business:

Solution: Automated item master maintenance via interfaces

In HERO craftsman software, article master data can be easily maintained via practical interfaces. This significantly reduces the amount of work involved and ensures that craftsmen can always work with correct product information and up-to-date prices. In HERO, users have access to interfaces to IDS Connect and Datanorm for master data maintenance and contact with wholesalers. Thanks to the seamless integration of these interfaces, item master data can be imported easily and article items can be added to quotes and invoices in no time at all using drag & drop. With a single click, data is synchronized between HERO and IDS Connect or Datanorm, allowing HERO users to update their entire article master in seconds. The advantages of the interfaces at a glance:

• Time savings, as manual data maintenance is no longer necessary.
• Always up-to-date prices and product data.
• Fast and reliable quotation creation.
• Reliable calculations and less need for additional work.
• Data synchronization with a single click.

Tip from Peter Prütting:

Ask your supplier directly for a Datanorm 4.0 file containing the items you have already purchased and the current net prices.

ERP Craft Industry
Datanorm and IDS Connect are just two of the many interfaces available to users in the HERO software.

HERO Automation: Going one step further

At HERO, we have long been aware that automated processes relieve the entire team and create more time for the essentials. No craftsmen wants to spend hours sitting in the office, maintaining Excel lists, and repeatedly chasing customers to arrange appointments. That’s why we are automating more and more processes in the HERO software: writing customer emails, maintaining project status, following up on quotes, and arranging on-site appointments with customers can all be done completely automatically with HERO. Craftsmen also benefit from HERO Automation when it comes to digital construction site management:

• Task lists are automatically generated for project work on construction sites.
• Field staff are automatically reminded of upcoming customer appointments in HERO.
• Construction site photos are automatically structured and made available to colleagues and customers thanks to cloud storage synchronization.
• Upon completion of a project step, such as an on-site appointment at a construction site, the order automatically moves to the next project step—no manual follow-up necessary!

ERP Craft Industry
State-of-the-art automation enables craftsmen to work smoothly and reduces tedious paperwork.

Conclusion: Future-proof craftsmanship

The crafts sector is undergoing change: digitalization, skilled labor shortages, and material bottlenecks are just some of the current challenges facing craft businesses. Anyone who wants to master today’s requirements and remain competitive should digitize their business and, ideally, automate it. HERO Software offers a wide range of features and automation solutions to help you accomplish this task: from digital construction site management and automated customer communication to the synchronization of article master data in seconds, craftsmen and women will find a variety of digital functions in the cloud software to future-proof their business and work processes. In short, digitized and automated working methods are a real competitive advantage in the craft industry. Companies can see for themselves what HERO has to offer at any time and test the comprehensive operating software for 14 days free of charge and without obligation.

HERO is even available as a convenient app! Ideal for writing construction diaries on the construction site.

Lea Oltersdorf is an online editor at HERO and brings a wealth of experience to the team. At HERO, she writes about the features and applications of cloud software, introduces craftspeople in exciting practical articles, and fills the craftspeople’s blog with creative specialist articles. Through her practical work in a car repair shop and in the catering industry, Lea has also gained first-hand knowledge of the world of craftsmanship and developed a real feel for industry-specific content.

FAQ – frequently asked questions

What features does HERO Software offer for digital construction site management?

Digital construction site management works particularly well in HERO thanks to the digital planning board. Users can display the planning board in daily, weekly, monthly, or yearly views and coordinate orders in terms of time. Responsible tradespeople, machines, and tools can be added to the respective orders and scheduled for the corresponding periods. The clear project pipeline, digital construction documentation, and intuitive customer management in HERO also help companies manage their orders and construction sites digitally and centrally in one interface.

Which interfaces are available in HERO for item master data maintenance?

HERO has interfaces to IDS Connect and Datanorm for importing article master data, inserting it into quotes via drag & drop, and using the corresponding prices for calculations. Thanks to the seamless integration of the interfaces, article data is updated with a single click and synchronized in the HERO interface. This allows craftsmen to ensure that they are always working with the correct material data and prices.

Can HERO also be used on the go at construction sites?

Yes, of course! HERO has a cloud connection and a craftsman app, so the software can also be used on the go without any problems. The app provides craftspeople with access to HERO’s core functions, allowing them to view task lists or order documents while on the go, for example. Thanks to the HERO Cloud, data and documents can also be easily shared on the construction site and synchronized in real time on other devices. This enables reliable and efficient teamwork, regardless of whether employees are in the office or on a construction site.

To what extent can workflows be automated with HERO craftsmen software?

HERO offers various automation solutions that can be integrated into the operating software in just a few simple steps. These include automated customer emailing, project status updates upon completion of a project step, cloud storage synchronization for employees and customers, practical lead forms including automatic transfer of customer data, and many other state-of-the-art modules. This not only facilitates project planning, but also execution and collaboration on the construction site.

What advantages does HERO offer for the digitization of businesses?

HERO software offers a host of advantages for digitizing businesses and automating work processes. The cloud software is intuitive to use and allows users to quickly work independently. In addition, many different functions are bundled into one interface, so HERO users don’t have to switch back and forth between multiple programs. Craftsmen and women benefit from the software’s digital time tracking, practical construction site management, accounting, interfaces for maintaining article master data, customer relationship management, and many other functions that have been tailored to the practical requirements of craftsmen and women.


Digitalization is revolutionizing the skilled craftsman and with it the way skilled craft businesses organize their processes. The IDS Connect interface plays a central role in this. It enables a seamless connection between craftsman software and suppliers’ online stores. But what specific use cases does this technology open up? And how do businesses benefit from it? In this article, I shed light on the potential of IDS Connect and highlight practical applications.

Craftsman software interface
IDS Connect connects the craftsman software with the supplier’s online store

Why IDS Connect is indispensable!

The demands on craft businesses are growing. Customers expect fast quotations, precise calculations and swift order processing. At the same time, internal processes must be designed efficiently in order to remain competitive. Craftsman software supports these processes. Providing them with up-to-date information requires a great deal of manual maintenance. This is where the IDS Connect interface comes in. IDS stands for “Integrated Data Interface” and enables the following applications:

  • Direct access to current article data such as prices, images, texts and availability
  • Automated data exchange between craftsman software and suppliers’ online stores
  • Reduction of manual work steps, which saves time and minimizes errors

For example, craftspeople used to have to manually transfer product data from catalogs or quotations into their system. This is a time-consuming and error-prone process, especially in dynamic markets. IDS Connect digitizes this step.

Use cases of the IDS Connect interface in practice

Various use cases can be optimized with this interface. Below you will find five possible applications:

Efficient shopping cart processing

A central use case of IDS Connect is the processing of shopping baskets.

Craftsman software interface
IDS Connect – Shopping cart processing

Practical example:

A company in the air conditioning technology sector uses its craftsman software to create a shopping cart with the materials required for the customer order. This is sent directly to the supplier via IDS Connect. Alternatively, the company can import a shopping cart created in the online store into its software for further processing – whether for calculations, quotations or orders.

Advantages:

  • No double data entry
  • Time savings through automated processes
  • Direct further processing of the data in your own software

Direct access to article data

IDS Connect makes it possible to call up article information such as prices, availability or technical details in real time. There is no need to leave the system and the interface accesses the required information in the “background”.

Craftsman software interface
IDS Connect – Article-Deep-Link

Practical example:

An installer is on site with a customer and realizes that a spare part is needed. Using the “Article Deep Link” function, he calls up the availability of the article from the wholesaler directly from his software. He can order the item within a few seconds. And without any detours via the office.

Advantages:

  • Real-time data saves unnecessary inquiries
  • Inspire customers by passing on information quickly
  • Optimization of the entire process from the quotation to the order to invoice processing with the supplier

Quotation preparation

IDS Connect makes it much easier to create quotations, as current article data can be integrated directly.

Craftsman software interface
IDS Connect – Offer processing

Practical example:

A roofer visits a customer on site and discusses the plans for the new roof with them. Using the integrated data interface (IDS Connect), he adds current prices and availability directly to his quotation. The finished quotation is sent to the customer by e-mail within a few minutes.

Advantages:

  • Fast quotation preparation increases customer satisfaction
  • More precise calculations thanks to daily updated data
  • Reduced administrative effort thanks to automated processes

Order processing

The IDS interface also offers considerable advantages when processing orders, as all relevant data is available centrally.

Craftsman software interface
IDS Connect – Order processing

Practical example:

A drywall builder receives an order for additional objects. He uses IDS Connect to access his supplier’s item data and imports it directly into his order. Changes or additions can be made in real time without having to overcome media disruptions between different systems.

Advantages:

  • Efficient order processing through direct integration of article data
  • Seamless communication between tradesman software and online store
  • Error reduction through automatic data transfer

Always up-to-date data thanks to integration of supplier systems

IDS Connect creates a seamless connection between craftsmen’s software or their ERP system and the suppliers’ online stores. This means that article data is always up-to-date in your own system.

Craftsman software interface
IDS Connect – Updating article master and transaction data

Practical example:

A painting company uses IDS Connect to access its wholesaler’s store system directly from its software. There he can search for products, compare prices and place orders. And all this without leaving the software.

Advantages:

  • Centralized processes without media disruptions
  • Increased efficiency in product search and ordering
  • Better overview of available products

Advantages of IDS Connect for trade businesses

The introduction of IDS Connect brings numerous advantages:

  1. Time saving: routine tasks such as manually transferring data are no longer necessary
  2. Error reduction: Automated processes minimize input errors
  3. Cost control: Costs can be calculated more precisely thanks to daily price queries
  4. Flexibility: data can be called up at any time, whether in the office or on the construction site
  5. Customer satisfaction: Fast quotation and order processing strengthens the relationship with the customer

Which ERP or craftsmen software offers this interface?

Here you will find an overview of software providers that offer the IDS Connect interface. Depending on the license model and software maturity, providers may be missing. I recommend contacting the current or potential software provider directly to discuss the details.

What needs to be considered during implementation?

Data quality is the foundation of the process. Article master data should be stored cleanly in the craftsman software. This means that the article number must contain a unique number. The manufacturer’s article number or the EAN number can be used here. This is important so that the items can be identified via the interface.

It is also important to look at the processes and objectives . Not every option that can be implemented with this interface is relevant for your company. The individual steps need to be defined before the technical implementation.

If colleagues and employees are involved, they should be involved at an early stage. Acceptance can arise through participation. After all, what good is the best data quality and a first-class process if they are not used?

Magic triangle – prerequisite for a successful introduction of the IDS interface

What is the difference to OCI, UGL, OMD, cXML Punchout and the DATANORM catalog format?

In addition to IDS Connect, there are other interfaces and data formats that enable cross-system work. The following section should help to highlight the differences. These “tools” for optimal processes depend on the selected system (e.g. tradesman software, ERP system), the objective and the technical capabilities of your most important suppliers.

OCI interface

OCI stands for Open Catalog Interface. This interface was developed by SAP and has become standard in many ERP systems. Companies from the manufacturing industry in particular rely on this interface. There are now also special purchasing systems, also known as e-procurement systems, that rely on this interface.

Function:

  • Import articles from the supplier’s online store into the tradesman software or ERP system.

Difference to IDS-Connect:

  • A separate interface (e.g. EDI) is required for the transmission of orders

DATANORM Catalog

DATANORM is a structured data format that was developed for the creation and maintenance of article data in craftsman software. It contains rudimentary data such as article number, description and price. This catalog format is also referred to as static, as a new DATANORM catalog must be created by the supplier each time a change is made and must be imported into the craftsman’s software.

Function:

  • Creation and maintenance of article data

Difference to IDS-Connect:

  • Static catalog format as opposed to the dynamic IDS interface, also known as dynamic catalog
  • Article creation possible in the craftsman software
  • Supplement to IDS Connect. First create the articles with DATANORM and then keep prices up to date with IDS Connect

OMD interface

OMD stands for Open Masterdata. Like the IDS Connect interface, OMD was developed by ITEK GmbH. Anyone working with the DATANORM catalog format can use it to add missing information such as images or data sheets as required. In the medium term, OMD is intended to replace the outdated DATANORM format.

Function:

  • With Open Masterdata, article data can be retrieved from the supplier in real time. This requires an article number or the EAN (or GTIN). This can be entered manually or selected from the DATANORM catalog.

Difference to IDS-Connect:

  • For articles that are not in the article data master in the craftsman software, images, texts, prices or service specifications can be called up, for example
  • Creation of new articles in the craftsman software possible
  • Similar function to the “article deep link” of IDS 2.5, but a different data standard

UGL interface

UGL is the abbreviation for “Übergabeschnittstelle Lang”. This was originally developed by the wholesale group “GC Group”. The UGS description (transfer interface) served as the basis for this.

Function:

  • An Excel file will be downloaded from the supplier’s online store. The information it contains is used to create quotations or orders. The focus of this “interface”, which is more like a catalog such as DATANORM, is the exchange of documents.

Difference to IDS-Connect:

  • IDS-Connect is an automatic and modern interface. With UGL and UGS, the data must be imported manually
  • Pure focus on the exchange of documents such as orders

cXML Punchout Catalog

The Punchout catalog works in a similar way to the OCI standard and was developed by Ariba in the USA. Systems from Oracle, coupa or SAP Ariba rely on this standard. Orders can be transmitted via this interface in a similar way to IDS Connect. It is also possible to return order confirmations, shipping notifications or invoices.

Function:

  • Import articles from the supplier’s online store into the tradesman software or ERP system.

Difference to IDS-Connect:

  • A separate interface (e.g. EDI) is required for the transmission of orders
  • Can import the supplier’s return messages into the craftsman’s system via the interface in addition to the order

Conclusion

IDS Connect professionalizes the working methods of trade businesses through seamless digital processes. Whether shopping cart processing, article data updates or quotation creation, the possibilities are diverse and offer enormous potential for increasing efficiency. For businesses, this not only means time savings and error minimization, but also increased customer satisfaction. In my many years of experience, three points are crucial for you to achieve first-class processes. Get your team on board and actively involve them in the change. Focus on high data quality. This will not only help you with quotations and orders, but also with warehouse processes in the long term. And finally, clearly define the goal and implement the planned process in the short term. Make your company fit for the digital future!

Digital Transformation Manager

Peter Prütting is an expert in value-oriented and digital business development. With over 15 years of sales experience from the perspectives of 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 transformation. Away from his daily work, he recharges his batteries by mountain biking.

FAQ – Frequently asked questions

Who developed the IDS interface?

The IDS Connect interface was developed by the associations BVBS (Bundesverband Bausoftware e.V.), DG Haustechnik (Deutscher Großhandelsverband Haustechnik) and ZVSHK (Zentralverband Sanitär Heizung Klima) in cooperation with ITEK GmbH.

Which software does IDS Connect support?

Many craftsman software solutions such as HERO, Handwerksdata, Haufe X360, Streit V.1, Landrix Handwerk, Das Programm, Pds Software, M-Soft and LC-Top offer IDS Connect integration.

What needs to be considered when introducing IDS Connect?

Data quality is the foundation of the process, which is why clean article master data with unique article numbers should be stored in the craftsman software. It is important to define the relevant processes and involve colleagues and employees at an early stage in order to create acceptance.

What advantages does IDS Connect offer for trade businesses?

IDS Connect offers time savings by eliminating manual data transfer, error reduction through automated processes and better cost control through daily price queries. It also enables greater flexibility thanks to data that can be called up at any time and increases customer satisfaction through faster quotation and order processing.

Can I access multiple suppliers with IDS Connect?

Yes, IDS Connect enables a seamless connection between your craftsman software and the online stores of various suppliers. You can search for products, compare prices and place orders without leaving your software.

Can I also use IDS Connect to order items directly on site?

Yes, IDS Connect makes it possible to check item availability and place orders directly on site at the customer’s premises without having to leave the software or return to the office.

Which wholesalers and manufacturers support the IDS Connect interface?

It is worth checking with your supplier. Here is a short selection of companies: Building materials trade – Baustoff Union, HVAC sector – Richter & Frenzel, electrical wholesalers – Fega & Schmitt.

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.

Digital Transformation Manager

Peter Prütting is an expert in value-oriented and digital business development. With over 15 years of sales experience from the perspectives of 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 transformation. Away from his daily 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.

Digital Transformation Manager

Peter Prütting is an expert in value-oriented and digital business development. With over 15 years of sales experience from the perspectives of 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 transformation. Away from his daily 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