Product database

The flexible product data model for features, relationships and views

In most cases, item master data from the ERP system is not sufficient to ensure market- and media-oriented and customer-oriented product communication. Therefore, the supplementary maintenance of product structures, product features and product relationships, such as spare parts, accessories and product recommendations, follows. Mandatory fields and inheritance functions can be used to optimize data maintenance.

Flexible data model

The crossbase database offers great flexibility. The administrator can define all parameters freely. The integration of new requirements can be executed immediately by configuring the product data model. It is possible to define mandatory fields and to use the inheritance possibilities to optimize data maintenance.

Easy data transfer

The standard import interface allows an initial transfer of the data stock to Excel or the integration of the ERP system. Data import via Excel or XML can be carried out independently, so that no additional external services are required. Most of the time, data from the ERP system cannot be transferred to the letter in marketing. However, the data should not be entered a second time. This is why a possibility of mapping has been integrated. This allows you to assign a description adapted to marketing to a feature of the ERP system. 

Mechanical and electrical engineering

With the crossbase solution, planners can integrate CAD and configuration into their product communication. crossbase offers solutions for integrating these tools into classic marketing themes: provision of multilingual marketing information data for CAD and configuration, e.g. product categories, product features, text descriptions, PDF files and product photos. Integration into the online catalog is also possible, e.g. by providing photo-realistic CAD graphics, characteristic curves of designed products and the display and provision of 2D and 3D CAD files for all common CAD systems.

Building Information Modeling (BIM) 

The BIM model is a kind of database which contains all geometric and alphanumeric parameters and characteristic values belonging to the project or building and makes them available to all members of the project team. The CAD / BIM component catalog from our partner KiM provides designers and architects with the ability to access CAD or BIM files. crossbase makes the necessary PIM data available via an interface. This allows, for example, BIM formats such as IFC (consisting of CAD drawing and PIM data) to be generated from the crossbase database.


The information for a configurator can be managed in the crossbase database. For this purpose, various information is maintained.
Together with the partner Plan Software, a configuration interface from crossbase to 3PQ® was implemented. crossbase manages the selection options on the configuration interface: Drop Down, List, Slider, etc. The advantage is that no marketing-related information has to be maintained in the configurator, which is already available in crossbase. In the configurator, the rules for the configuration options are then maintained in addition and the output on the web interface is defined.

Product features

Product characteristics can be used to describe products in a structured way, e.g. to enable a dynamic filter search in the online store or to automatically generate the product tables in the printed catalog. To clearly organize maintenance, product features can be classified.
An attribute can be defined numerically or alphanumerically, with a unit of measure, language-dependent or language-neutral. For each attribute or value, a textual description or an image can be stored, which can be displayed media-specifically, e.g. in tables. The formatting of the numbers can also be adapted to the country, the values can be converted by means of formulas or texts can be combined.

Product views

Products are displayed in various views in the company, e.g. in the ERP system in a controlling view, in the design department in a functional view, in marketing in views for online and print, and for trading partners in different classification views such as ECLASS, ETIM, or UNSPSC.
With crossbase, you have integrated all views in a single database. In addition, it is possible to manage these differentiated product views as independent outlines and to reference the products within them. This means that they only have to be created and maintained once, but can be linked many times. The original creation of the products is done in an unambiguous product structure which is most often the result of a existing product hierarchy.

Product relationships

Spare parts, parts lists, accessories, sets, product recommendation and follow-up items are typical product relationships.
In some cases, these are maintained in the ERP or PDM system, but are usually incomplete. In crossbase, it is possible to define types and to grasp the relationships between products, e.g. under the form of an item-to-item relationship. Data maintenance is possible on an item-oriented basis (n items to 1 item) or as mass maintenance (n items to m items) and is thus much simpler than in the ERP system.
In addition, reference attributes can be maintained in the context of a relationship. In the context of a spare parts bill of material, for example, the item number and the quantity can be assigned. It is also possible to to specify in the link of an accessory to an item if it is mandatory, or optional. 

We respect your privacy
AThis website does not use cookies to collect visitor data or behavior!

2024 crossbase mediasolution GmbH