Datafeed example

This chapter explains the setup of a manually executable datafeed that bears the ID “Randomdatafeed”. In the form of an .xlsx file that has the name “randomfile.xlsx”, the datafeed exports the product number and the product name of products which are located in the category “Randomcategory” of the primary taxonomy and where the value of the attribute “Random text” equals “Hamburg”. What is more, the datafeed exports the product data of the main context plane and the locale “English”.

Create a datafeed in the “Datafeed” tab

2. Click on the button. Then a new dataset with empty input fields is created. Only in the input field “Datafeed ID” you will find a datafeed identifier that was created by the system.
3. Enter the datafeed identifier “Randomdatafeed” in the input field “Datafeed-ID”.
4. From the drop-down menu “Version”, select the primary taxonomy.
5. From the drop-down menu “Version”, select the main context.
6. From the drop-down menu “Locale”, select the export language “English”.
7. From the drop-down menu “Export area”, select the option “Product”.
8. From the drop-down menu “Validity range”, select the option “All active products”.

 

8. Move the “Activation” toggle switch to the position to activate the datafeed.
9. From the drop-down menu “Type”, select the option “iPIM Standard datafeed”.

 

10. Enter the file name “randomfilename.xlsx” in the input field “File name”.
11. From the drop-down menu “Transfer profile”, select the option “local”.
12. From the drop-down menu “Export format”, select the option “XLSX”.

Set up the attribute maping in the “Attribute mapping” tab

In the second step you need to specify via the attribute mapping that the attributes “Product number” and “Product name” as well as their attribute values are exported. To do so, proceed as follows:

1. Go to the “Attribute mapping” tab.

 

2. Specify the mapping for the product number:
   1. From the drop-down menu in the “Mappings” card, select the option “Standard information”.
   2. Click on the button. Then a new mapping entry appears in the table.
   3. Click on the mapping entry. Then the corresponding input fields and drop-down menus appear in the “Mapping configuration” card.
   4. Click on the “iPIM value” field to access the drop-down menu behind it.
   5. From the drop-down menu, select the attribute “Product number”.
   6. From the drop-down menu “1. Target column configuration”, select the option “Constant”.
   7. In the input field “1st target column”, enter the text “Product number” which will be the header for the corresponding column in the export file.

3. Specify the mapping for the product name:
   1. From the drop-down menu in the “Mappings” card, select the option “Attribute”.
   2. Click on the button. Then a new mapping entry appears in the table.
   3. Click on the mapping entry. Then the corresponding input fields and drop-down menus appear in the “Mapping configuration” card.
   4. Click on the “iPIM value” field to access the drop-down menu behind it.
   5. From the drop-down menu, select the attribute “Product name”.
      Possibly use the text search to filter the list of attributes by a search term.
   6. From the drop-down menu “1. Target column configuration”, select the option “Constant”.
   7. In the input field “1st target column”, enter the text “Product number” which will be the header for the corresponding column in the export file.

4. Click on the “SAVE” button to save your settings.

 

Set up filters in the “Filters” tab

In the third step you need to set up filters that limit the export to products of the category “Random category” and where the value of the attribute “Random text” equals “Hamburg”. To to so, proceed as follows:

1. Go to the “Filter” tab.

 

2. Set up the category filter that limits the export to products of the category “Random category”.
   1. Click on the “CREATE” button in the footer of the “Category filer” card. Then appears a dialog box that shows a directory structure of the taxonomy which was selected in the “Datafeed” tab.
   2. In the directory structure, tick the category “Random category”.
   3. Click on the “SAVE” button. Afterwards the dialog box closes and the newly created category filter appears in the table of the “Category filter” card.
   4. Double-click in the table cell of the “Whitelist” column and select the option “YES” from the drop-down menu.
   5. Click on the “SAVE” button to save your settings.

3. Set up the attribute filter that limits the export to products where the value of the attribute “Random text” is “Hamburg”.
   1. Click on the “CREATE” button in the footer of the “Attribute filter” card. Then appears the corresponding dialog box.
   2. Select the attribute “Random text” by transfering it from the “Available attributes” column to the “Visible attributes” column. To do so, click on the attribute.
      Possibly use the text search to filter the list of attributes by a search term.
   3. Click on the “ACCEPT” button to create the attribute filter. Afterwards the dialog box closes and the newly created attribute filter appears in the table of the “Attribute filter” card.
   4. Double-click in the table cell of the “Value” column and enter the value “Hamburg”.
   5. Double-click in the table cell of the “Condition” column and select the option “equals” from the drop-down menu.
   6. Click on the “SAVE” button to save your settings.

Execute the datafeed export manually

In the last step, execute the datafeed export for the first time via the corresponding button in the datafeed overview and in this way create a job for future manual executions of the datafeed export.

1. In the datafeed overview, seearch for the datafeed.
   Possibly use the text search to filter the list of datafeeds by a search term.
2. Move the mouse cursor over the datafeed. Then different buttons will appear.
3. Click on thebutton to access the action menu behind it.
4. Click on the option “ Export” to trigger the export. If the process was successful, a corresponding message will appear.
5. Download the export file via the “History” tab of the “Process information” window which can be accessed via the button in the header.

When running a datafeed export for the first time, a job for future manual executions of the datafeed export is created. The job can be executed via the corresponding button in the “Jobs” tab.