{"id":2471,"date":"2026-05-18T14:30:51","date_gmt":"2026-05-18T12:30:51","guid":{"rendered":"https:\/\/dynamictools.io\/?post_type=glossar&p=2471"},"modified":"2026-05-20T10:36:41","modified_gmt":"2026-05-20T08:36:41","slug":"importer-stammdaten-im-pim-einstellen","status":"publish","type":"glossar","link":"https:\/\/dynamictools.io\/en\/glossar\/importer-stammdaten-im-pim-einstellen\/","title":{"rendered":"How do I configure the master data importer in the PIM?"},"content":{"rendered":"

To set up master data import, the importer must be activated and configured. This article explains how to do it.<\/p>\n\n\n\n

The Import Module<\/h3>\n\n\n\n

The module can be accessed via the administration interface. The menu item is called: Importer. There are several setting options in this area. Field mapping is essential at first.<\/p>\n\n\n\n

The field mapping was created using the JSON language.<\/p>\n\n\n\n

Import Code, Field Mapping<\/strong><\/p>\n\n\n\n

{
\u201eexcel\u201c: {
\u201eindexRow\u201c: 1
},
\u201euniqueKey\u201c: \u201cIRC\u201c,
\u201eproduct_country\u201c: \u201cde\u201c,
\u201e1\u201c: {
\u201esource\u201c: \u201circ\u201c,
\u201etarget\u201c: \u201cmasterdata.IRC\u201c,
\u201etransform\u201c: false,
\u201eerror\u201c: \u201clog\u201c
},
\u201e2\u201c: {
\u201esource\u201c: \u201ctitle\u201c,
\u201etarget\u201c: \u201cproduct.title\u201c,
\u201etransform\u201c: false,
\u201eerror\u201c: \u201clog\u201c
}
}<\/p>\n\n\n\n

JSON Formatter and Validator<\/h3>\n\n\n\n

This application can validate imported JSON. This means the validator can detect, for example, if a bracket is missing or if there are too many. Simply copy the above code into the validator and start.<\/p>\n\n\n\n

JSON Validator<\/a><\/p>\n\n\n\n

Definition of the Title Row<\/h3>\n\n\n\n

indexRow here refers to row 1 as the title row.<\/p>\n\n\n\n

\u201eexcel\u201c: {
\u201eindexRow\u201c: 1
},<\/p>\n\n\n\n

Definition of the primary key and the destination country<\/h3>\n\n\n\n

The primary key or key, here uniqueKey, is the ID, e.g., an article number, PZN, GTIN, etc. In the brackets \u201e\u201cIRC\u201c\u201c is the code of this master data field of the PIM system. Care must be taken to ensure that this code is identical.<\/p>\n\n\n\n

product_country defines the target country. Here Germany = de.<\/p>\n\n\n\n

\u201euniqueKey\u201c: \u201cIRC\u201c,
\u201eproduct_country\u201c: \u201cde\u201c,<\/p>\n\n\n\n

Mapping of master data fields<\/h3>\n\n\n\n

Each import field routine begins with an arbitrary sequence number, here 1, 2, 3 etc.<\/p>\n\n\n\n

Source refers to the title of the source, i.e., the import file. This is the column header in the Excel file.<\/p>\n\n\n\n

target<\/strong> = masterdata.IRC defines a Master Data field. .IRC in turn the code of the field in question.<\/p>\n\n\n\n

transform<\/strong> = false means that the data will not be manipulated before import.<\/p>\n\n\n\n

error<\/strong> = log means that errors are shown in the log file.<\/p>\n\n\n\n

product.title defines a different field. Here is a field from the product view, the title.<\/p>\n\n\n\n

\u201e1\u201c: {
\u201esource\u201c: \u201circ\u201c,
\u201etarget\u201c: \u201cmasterdata.IRC\u201c,
\u201etransform\u201c: false,
\u201eerror\u201c: \u201clog\u201c
},
\u201e2\u201c: {
\u201esource\u201c: \u201ctitle\u201c,
\u201etarget\u201c: \u201cproduct.title\u201c,
\u201etransform\u201c: false,
\u201eerror\u201c: \u201clog\u201c
}<\/p>\n\n\n\n

Provided the fields are not calculated or manipulated, the importer can thus also be set up from scratch by non-technical users.<\/p>\n\n\n\n

The importer's basic settings<\/h3>\n\n\n\n

Name<\/strong> = Any importer name<\/p>\n\n\n\n

Input Driver<\/strong> = Upload of the file or drag from a server, e.g., sFTP<\/p>\n\n\n\n

File<\/strong> Excel or CSV<\/p>\n\n\n\n

Status<\/strong> = active or inactive<\/p>\n\n\n\n

Schedule<\/strong> = if the importer is to run nightly, for example, the file must be stored on a server and simply replaced.<\/p>\n\n\n\n

Our conclusion<\/h3>\n\n\n\n

Currently, a simple graphical user interface is missing. Nevertheless, administration is easily possible with this guide.<\/p>\n\n\n\n

Important<\/strong><\/p>\n\n\n\n

The validator must always be used, as it's easy to copy and paste one bracket too many or too few, which immediately invalidates the importer's full functionality.<\/p>","protected":false},"excerpt":{"rendered":"

To set up master data import, the importer must be activated and configured. This article explains how to do it.<\/p>","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false},"register":[48],"thema":[65],"class_list":["post-2471","glossar","type-glossar","status-publish","hentry","register-i","thema-handbuch"],"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t