Skip to main content

Map your product data

An overview on preparing product data for export to external channels via the Productsup Dataflow.

Introduction

Export channels only accept product data that match their specifications. In Dataflow, you can map attributes derived from imported data to meet these requirements.

By default, most of your data's attributes automatically map to an export channel after you set one up. You can also map your product data manually via a drag-and-drop interface between the three large columns in Dataflow. These columns are:

  • Import - Contains attributes based on your import source.

  • Intermediate - Contains the most common attributes found on a range of external channels.

  • Export channel - Contains attributes specific to one export channel.

This document covers the basics of attribute mapping. For a more thorough description, see Dataflow functionalities and advanced features.

Prerequisites

Before you can export product data, you must complete the following steps:

  • Set up at least one site

  • Complete a product import

  • Set up at least one export channel

Map import data attributes for export

The following example demonstrates how to map imported product data to Google Merchant Center.

  1. Go to Dataflow from your site's main menu.

  2. Select which export channel you want to export to; this example uses Google Merchant Center.

    Productsup platform Dataflow view - demonstrating export channel selection
  3. To map Import attributes to Intermediate attributes:

    • In the Import column, select a node on an attribute.

    • In the Intermediate column, select a node on an attribute.

    Guide to mapping product attributes to intermediate layer
  4. Map Intermediate attributes to the export channel, following the same steps noted in step 3.

    Guide to map intermediate attributes to export attributes

Tip

Alternatively, you can map an attribute to another by placing your cursor over an attribute's node, holding the mouse button down, and dragging a guideline that appears to the second attribute.

Export your data

There are two ways to export data in Dataflow. If you want to initiate a complete data flow process, from import to export to all channels:

  • Select the Run button.

    dataflow-run_button.png

If you want to export current imported data to all export channels:

  • Select the Export button.

    dataflow-export_button.png

If you want to export existing data to only one export channel:

  1. Go to Exports A/B from your site's main menu.

  2. Select the Export button for that channel. This example exports only to Google Merchant Center.

    Exporting product data for specific channels via Exports A/B view

Delete attribute maps

You can delete connections between import and intermediate attributes as follows:

  1. Rest your cursor over the guideline connecting the attributes.

  2. Select the guideline.

  3. Select Yes from the pop-up menu.

    Deleting connections between columns in Dataflow view

Create new attributes

To add new attributes to the Intermediate and Export columns:

  1. Scroll to the bottom of the column to add a new field and select Drop or Click to add new field.

  2. In the dialogue box, enter a name for the attribute.

  3. Select Save, and this attribute is now available for mapping.

Creating user-defined labels 1
Creating user-defined labels 2

Delete user-defined attributes

To delete any attributes you previously created:

  1. Rest your cursor over the attribute.

  2. Select the X icon.

  3. Confirm you want to delete this attribute by selecting Yes.

Deleting user-defined labels 1
Deleting user-defined labels 2

Bulk Operations

If you have several sites, you can sequence actions to run on them at the same time. To set up bulk operations:

  1. Go to Account from your sites' main menu.

    pup-account_select.png
  2. Select Bulk Options.

    account-bulk_operations.png
  3. Choose which sites to include in the bulk operation. This example runs a bulk operation for two sites. If you want to set up a bulk operation for all sites in a project, select the check-box beside the project's name. When you are ready, select Next Step.

    account_bulk_operations-1_1.png
    account_bulk_operations-1_2.png
  4. Select which bulk operation you want to implement from the list. Since this example is to add a new connection, select Add Dataflow Connection, and select Next Step.

    Defining Bulk Operation behavior 1
  5. Specify where the bulk operation should happen. This example uses Import-Intermediate, but Intermediate-Export is also possible.

    Defining Bulk Operation behavior 3.1
  6. Assign attributes for the Intermediate Column and Source Column. A list with all available attributes appears as you type. If you want the operation to take place at the Intermediate - Export stage, you must also specify an export channel in Export.

    bulk_operations-import-intermediate.png
    bulk_operations-intermediate-export.png
  7. Select Execute.

    bulk_operations-import-intermediate-select.png
  8. A final confirmation screen shows that the bulk operation is successful.

    Defining Bulk Operation behavior 4