Skip to main content

Optimize your data in Data View with rule boxes

Optimize your product feed data in Data View using rule boxes in Productsup.

You can add optimization rules using rule boxes in Data View or Dataflow. Rule boxes let you clean and optimize your data before you run a data export. For example, if you want to add a specific value to all products in a column, such as the US Dollar sign ($), you can use a rule box. Or, if you want to add a logo to an entire column, add a rule box for that. There are many different rule boxes available to help you optimize your product data more efficiently.

It is best to use rule boxes in Data View instead of Dataflow, which lets you oversee your actual product data.

Add a rule box in Data View

To add a rule box:

  1. Go to Data View and select Intermediate to choose the stage where you wish to add a box.

    • You can also select Intermediate or the export stage in Dataflow by selecting the small arrow that appears when you hover over an attribute in either column.

      Select the small arrow that appears when you hover over an attribute in either column.
  2. Select Edit for the column where you want to add a box. You can now see an open tab on the right-hand side.

  3. Select the Add Box drop-down menu to search and select the relevant box.

  4. If necessary, configure the box and select Save.

adding_box_small.gif

Note

You can only add boxes on the intermediate stage in Data View. You can add boxes in both the intermediate and export stages in Dataflow. The reason is that the import stage contains the data source you provided, and you cannot change that data directly within the Productsup platform.

Add a box using Large View

To gain more information on various boxes and for additional filtering options, you can use Large View.

  1. Go to Data View and select Intermediate to choose the stage where you wish to add a box.

    • You can also select Intermediate or the export stage in Dataflow by selecting the small arrow that appears when you hover over an attribute in either column.

      Select the small arrow that appears when you hover over an attribute in either column.
  2. Select Edit for the column where you want to add a box. A tab opens on the right-hand side.

  3. Select Large View.

  4. Locate the relevant box using the filtering options on the top ribbon or scroll to it in the list.

  5. Drag the relevant box to the appropriate stage. The green area is for import to intermediate stages, and the blue area is for intermediate to export stages.

    box_stage_colors.png
  6. If necessary, configure the box and select Save.

Edit box setups

You can also edit any boxes you have previously set up in Data View.

  1. Go to Data View and choose the stage where you wish to edit a box.

  2. Select Edit for the column where you want to add a box. This action opens a tab on the right-hand side.

  3. Edit the current box set up as desired and select Save.

Implement rules in bulk across multiple sites

If you need to add the same rules to multiple sites, you can consider using Bulk Option to save time.

Note

Column names must match in each site for Bulk Option to function.

  1. First, create the boxes in one site. This site is now the main site. Use it for copying rules to other sites.

  2. Go to the account or project level and select Bulk Option.

    Bulk Option button
  3. Select the site where you previously created the rules before selecting Next Step.

  4. Select the option Add Dataflow Boxes, then Next Step.

  5. In the Dataflow drop-down menu, choose where you created rules; in the Import-Intermediate or Intermediate-Export stage.

    Note

    If you chose the Intermediate-Export stage, select the channel in Export where you set the rules, using the drop-down menu. Remember to add this export channel to all sites.

  6. Select the column(s) that you want to copy the rules from. Here you can see a brief overview of the boxes for each connection.

  7. In Target Sites, search for or select the target site(s) or target channels

  8. Select Execute. Execute removes all existing boxes on the connection and replaces them with your recently selected boxes.