Map your product data

Map your product data in Productsup.

The Dataflow is used to map the ‘flow’ of your data. You can differentiate which data you send to which export channel, allowing you to specialize in the mapping of product attributes per feed. The Dataflow consists of three stages: import, intermediate, and export.

This article guides you through the basic process of mapping. For an overview, see Dataflow functionalities and advanced features.

Note

You need to activate at least one export channel first, in order to use the Dataflow.

Access the Dataflow

  1. Navigate to a site

  2. Navigate to the Dataflow tab in the left-hand menu

Select the export feed to map

You can work on one export feed at a time. To select which feed you are mapping:

  1. Navigate to the Dataflow

  2. Select the relevant export feed in the drop-down menu in the top left-hand corner

    selecting_export.gif

Create mapping connections

Based on the export template you select, you can see columns in the Dataflow that you can map. Mapping to one of these columns determines the product attributes that fill the column. Only export attributes with input from the intermediate column. You can not export an attribute that you have not mapped from the intermediate column.

  1. Navigate to the Dataflow

  2. Drag-and-drop the node of a column to the node of a column in the next stage (import > intermediate or intermediate > export)

    • alternatively, you can click on any node and map it to a node in the next stage by clicking on it

create_mapping.gif

Bulk creating mapping connections across multiple sites

You also have the option to map columns in multiple sites at once.

  1. Navigate to either the account level or the project level

  2. Select the Bulk Option button

    access_bulk.png
  3. Select the sites for which you wish to create connections, before clicking the next step

  4. Select the option add Dataflow connection and then next step

  5. Select whether the connections should be between the import-intermediate stage, or between the intermediate-export stage

    • if you chose the intermediate-export stage, please select an export channel where you want to do this from the dropdown export menu. Please note that this export channel has to be in all sites.

  6. Enter either the intermediate and source columns or the intermediate and export columns you want to map

    • if the columns exist, they will be shown in the dropdown menu when you type

    • if you selected the import-intermediate stage and the columns don’t exist, you will not be able to map anything

    • if you selected the intermediate-export stage and the columns don’t exist, they will be created as custom columns

  7. Select Execute

Delete mapping connections

To delete mapping connections you have made:

  1. Navigate to the Dataflow

  2. Select the mapping connection between two columns

  3. Select Delete

  4. Select Yes

delete.gif

Custom columns

Creating custom columns

You can create a custom column that is not part of the export channel template or intermediate stage.

  1. Navigate to the Dataflow

  2. Click drop or click to add a new field on the relevant stage where you want to create a custom column

  3. Input your column name

  4. Select Save/press the enter key on your keyboard

Alternatively, you can drag a column from the previous stage to the drop or click to add a new field, to create a custom column with the same name as the column.

Here are both methods in action:

custom_column.gif

Rename a custom column

You can only rename a custom column on export-level.

  1. Navigate to the Dataflow

  2. Hover over the custom column and click the pen icon

    rename.png
  3. Enter the new column name

  4. Select Save

Delete a custom column

You can also delete custom columns:

  1. Navigate to the Dataflow

  2. Delete all mapping connections to the custom column you want to delete

  3. Hover over the custom column and click the red X icon

    delete_custom.png
  4. Select Yes