To import basic and advanced attributes, first you need to map them. The Import Mapping feature lets you manage your import mappings for basic and advanced attributes.
Basic attributes are standard attributes for everyday use.
Advanced attributes are additional attributes capable of containing other attributes within their structure for complex use cases.
When you create a new import mapping or select an existing one, the Import Mapping page opens, displaying the following tabs:
Basic tab displays all basic attributes from your import file and lets you add not-mapped attributes.
Advanced tab displays and lets you add the Tab and Group advanced attributes.
Settings tab contains the configuration options that help define how the platform recognizes certain patterns in your data.
Map import for basic attributes
To map import for the basic attributes:
Go to the Basic tab from your selected import mapping.
Enter the names of the attributes in the Import source column in the fields corresponding to the attributes in the Target data model attribute column. For example, enter GTIN in the field corresponding to GTIN in the Target data model attribute.
Select Save.
Map import for advanced attributes
The Advanced tab displays the Tab and Group attributes.
Tab attributes create separate tabs for certain values, helping you organize different sets of information under distinct sections. This is useful for displaying different categories or aspects of a product in a clear and accessible way.
Group attributes bundle related attributes together, making it easy to organize similar product features or information into a single section.
The advanced attributes help organize complex product data, making it easier to manage and navigate.
NOTE: Your Admin should create Tab and Group fields before you map them.
The advanced fields have a hierarchy of attributes such as:
Tab Attribute
Input Source: “input”
Child Attribute 1
Input Source: “child input”
Group Attribute
Child Attribute
Input Source: “child group input”
Child Attribute 2
Input Source: “child 2 input”
To map import for the advanced attributes:
Go to the Settings tab from your selected import mapping.
In the Regex drop-down, select from the existing regex options or select Custom to create your regular expression:
DataDump/Pup Standard [*] is for the import file with headers containing indexes in square brackets
[*].GS1 pull api /*/ is for the import file with headers containing indexes in between two slashes
/*/.Custom for the import file with headers containing indexes in other than
[*]or/*/format, for example, between two underscores_*_.
In Select delimiter, enter any delimiter. The delimiter replaces the numbered index in the input source.
Select Save.
In the Path validator section, test if the platform correctly extracts the paths based on the provided regular expression and delimiter entered in the Path configuration:
In Test source, enter a header from your import file.
Check the result in the following fields:
Source result shows the expected source input, which fills in the paths or information within your mapped items after applying the regex and delimiter.
Path result shows the index of the tab if the path is correct.
Copy the source result.
Go to the Advanced tab.
Enter the source result in the corresponding tab or group attribute.
For example, the imported Excel file consists of the following data:
GTIN | New tab | Child of tab[0] | Child of tab[1] | Child of group[0] | Child of group[1] |
12345678 | Tab 1, Tab 2 | Tab 1 | Tab 2 | Group 1 | Group 2 |
If you have the following path configurations and then enter Child of tab [0] from the file in the Test source, you can see the following Source and Path results:
You need to enter the result in the Advanced tab:
Copy the source result Child of tab.
Go to the Advanced tab and enter the result in the Import source for Tab and Group of the corresponding attribute.
Go to Import and create an import for your file.
Set up export advanced attributes
To export advanced attributes, you need to create export mapping:
Go to Mappings from the main menu.
Select Export.
Search for the necessary data model or channel by filtering the columns Datamodel and Module. Check if the mapping type is Unsupported. Or create a new mapping by selecting CREATE MAPPING.
Select the attribute in the drop-down in the Attribute column.
Select a source from the drop-down in the Source column. Enter the target in the Target field or copy the target from Select a field definition by selecting the arrows icon.
To match the format of the imported Excel file, add [{{INDEX}}] to sources. This will ensure that the export headers are in the same format as your import file headers, such as [*]. The platform will replace * with the corresponding numbered index and the exported structure will be the same as in the import file.
Select the plus (+) icon to add the attribute to the unsupported item.
Select Save.
Go to Products from the main menu.
Select the needed products.
Select Export products at the top right corner of the page.
In the Export produts pop-up window:
Select Mapping export and select Next.
Choose Generic (.xlsx) in Channel and select Next.
Select sources to export and select Next.
Select the contacts you want to share the file with if needed, and select Next.
Check the data in the overview and select Start.
Go to Exports from the main menu.
In the Actions column, select Download export for Generic (.xlsx).
Open the downloaded file and ensure that the exported file contains the needed structure.