Using the Retail platform, you can import and export your products to retailers and other organizations. You set up where to import your data from in Imports and where to send your data in Exports. In Mappings, you choose which attributes from your import correspond to the attributes of a chosen data model and channel.
In the Import tab, you can map your import attributes to the attributes of the needed data model so that retailers can send product data in an optimized way that matches the attributes in your data models. In the Export tab, you can map the attributes in your workspace to the attributes of the needed data model and export channel to meet the requirements of retailers and other partners.
This document explains how to work with import mappings in the Imports tab. See Export mapping for information on the Exports tab.
To see all import mappings, select the Import tab. It contains the following information:
Name shows the name of an import mapping.
Datamodel shows the data model an import mapping belongs to.
Attributes mapped shows the number of already matched attributes in a mapping out of all attributes in the relevant data model.
Last updated shows the date and time of your last change to the import mapping.
Actions lets you manage your import mapping by selecting Edit, Rename, Duplicate, or Delete.
Create or edit an import mapping
To create a new import mapping:
Select CREATE MAPPING in the top-right corner of the page.
Give your mapping a name in Name.
From the Datamodel drop-down menu, select a data model with which you want to map attributes from your imports.
Select Save.
On the import mapping setup page, map the attribute names from your imports (highlighted in red on the left) to the attribute names of the chosen data model (highlighted in blue on the right).
You can map your attributes manually by entering attribute names from your imports in the Import source column. You can also use the automapping feature.
NOTE: To use the automapping feature, you need a CSV, XLS, or XLSX file containing the attribute names from your imports. If the attribute name in your file exactly matches the name of an attribute from the data model, the platform matches the two automatically and pre-fills the needed attribute name in the Import source column. An exact match means the same spelling and case.
To use the automapping feature:
Select Automap.
Choose the file with your import attributes in Upload.
In Enter the row number containing the headers, enter the number of the row in your file containing attribute names, or use the up and down arrows to choose the needed number.
In Apply automapping to, choose how the platform should map attributes from your file to the attributes of the data model:
Empty attributes only maps the attributes you haven't yet mapped in this import mapping.
All attributes maps all attributes from the file.
Select Automap.
If you used the automapping feature and the platform couldn't match all the relevant attributes, enter the remaining attribute names in the Import source column.
When finished, select Save.
To edit an import mapping:
Go to Mapping and find the necessary mapping in the Import tab.
Select the three dots in the Actions column of your mapping and select Edit.
Make the needed changes and select Save.
Duplicate import mappings
To copy an import mapping:
Select the three dots in the Actions column next to your mapping and select Duplicate. The pop-up window Duplicate import mappings opens up.
Give your new mapping a name in Name.
Select a workspace where you want to add the copied mapping in Workspace.
Select a relevant data model in Datamodel.
Select Duplicate.
Delete import mappings
To delete an import mapping:
Select the three dots in the Actions column of your mapping and select Delete.
The pop-up window asks you to confirm the action. Select Yes.