Using a simple example, this chapter explains how to update product data in iPIM using a datafeed export. First, the product data of an exemplary product is exported as a .xlsx file using a datafeed export. Following this, the product data in the export file is updated. The export file is re-imported via an iPIM Supply catalog, whereby the attributes from the export file are mapped to the appropriate iPIM Supply attributes. And finally, a synchronisation is carried out in order to update the product data in iPIM accordingly.
In this example, an attribute of the exemplary product with the product number “P7000247501” is to be updated:
Set up datafeed
In this example, an existing datafeed is used. For this datafeed, the appropriate attribute mappings and filters are created in order to export the attributes of the exemplary product shown above.
Set up attribute mappings
In this step, the appropriate attribute mappings are set up:
- Access the iPIM Export module.
- Go to the “Datafeed exports” section and select the appropriate datafeed.
- Activate the “Attribute mapping” tab.
- Set up attribute mappings for the individual attributes.
Set up filters
In this step, a product filter is set up. The product filter effects that only the product data of the exemplary product is exported:
- Activate the “Filter” tab.
- Set up a product filter for the product with the product number “P7000247501”. Make sure that the value YES is set in the “Whitelist” column.
Execute the datafeed
In this step, the datafeed export is executed to generate the export file:
- Choose the datafeed from the list of datafeeds. Optional: Enter a search term in the search field
to filter the list of datafeeds by a search term. - Move the mouse cursor over the datafeed
.
The 
button is shown. - Click on the button to show the action menu.
- In the action menu, click on the option “Export”
to trigger the export. A success message is shown and the export is carried out. Once the export is completed, the export file can be downloaded via the “Tasks” menu in the header.
Edit the export file
In this step, the export file is edited:
- Download the export file and open it.
- Edit the attribute value accordingly.
Import the file in iPIM Supply
In this step, a new catalog is created in iPIM Supply. The datafeed export file from the previous step is now the import file. The file is imported, the attributes are mapped and the product data is synchronized with iPIM in order to update the product data there according to the import file:
- Access the iPIM Supply module.
Create the catalog
In this step, the catalog for the import is created:
- Go to the “Catalogs” section.
- Click on the
- Enter resp. select the appropriate parameters to configure the catalog .
- Click on the
button to finalise the catalog creation. 
The dialog box closes, a success message is shown and the catalog process overview of the newly created catalog is called up. The catalog is now created.
Configure the import
In this step, the import is configured:
- In the “Import” card, click on “Import” to proceed to the import configuration.
- Select the option “Assortment update” from the “Import mode” menu as existing product data is to be updated.
- Select the option “Excel 2007-2013 (XSLX)” from the “Format” menu as the import file is in the .xlsx format.
- Tick the “Update existing items” checkbox as existing product data is to be updated
- Enter the name of the sheet in the import file in the “Excel sheet name” field
. - Enter the number of the table row containing the column headers in the “Attribute names in row” field
. - Enter the number of the table row where the actual product data begins in the “Data area from row” field
. - Enter the name of the column containing the product number in the “Unique item ID column” field
. The product number serves as the unique identifier for the imported product so that the imported product data is allocated to the appropriate product in iPIM. - Enter the name of the column containing the product name in the “Supplier item name” field
. - Click on the
button in the lower right corner to finalise the import configuration. A success message is shown. The import is now configured.
Import the import file
In this step, the import file is imported:
- Go back to the catalog process overview.
- In the “Import” card, click on the
button to call up the corresponding dialog box.
- Drag the import file over the drop area and drop it there. Or click on the
button to call up the file via the file manager.The file is loaded into the cache and the file name is shown below the drop area. - Click on the
button to trigger the import. A success message is shown and the dialog box closes. The product data is now imported in iPIM Supply.
Configure the transformation
In this step, the transformation is configured in order to map the imported attributes on the appropriate iPIM Supply attributes.
- In the “Transformation” card, click on “Transformation” to proceed to the transformation configuration.
- Map the imported attributes to the appropriate iPIM Supply attributes . In the process, map the imported product number to the product number attribute in iPIM. And map the imported category to the corresponding category of the primary taxonomy so that the synchronisation can be carried out.
- Click on the button to finalise the set up of the mappings. The dialog box closes and a success message is shown. The mappings are now created.
Execute the transformation
In this step, the transformation is carried out. In the process of the transformation, the imported product data is written on the appropriate iPIM Supply attributes:
- Go back to the catalog process overview.
- In the “Transformation” card, click on the button.A prompt window is shown.
- Click on the
button to trigger the import. A success message is shown. The transformation is now executed. Following this, you can carry out the approval as well as the synchronisation to update the product data in iPIM accordingly.
