Skip to main content

Set a value based on an "if" condition

Use rule boxes to set the needed values in your attributes based on a condition in Productsup.

Introduction

Some of the attributes in your feed may depend on a certain condition or the values stored in other attributes. In Productsup, you can modify your values based on various conditions by using rule boxes in the following ways:

  • Adding a static value to your edited attribute if a chosen attribute meets a condition

  • Adding a dynamic value to your edited attribute if the chosen attribute meets a condition

  • Overwriting a value in your edited attribute if it contains a certain string

  • Setting a static value in the edited attribute if the current value is greater than a certain number

  • Adding a static or dynamic value to your edited attribute if the value of the edited attribute is empty

  • Adding a static value to your edited attribute if the value of the edited attribute isn't empty

  • Adding a dynamic value to your edited attribute if a chosen attribute isn't empty

  • Adding a dynamic value to your edited attribute if certain data doesn't already exist in your edited attribute

  • Comparing values in other attributes and assigning the needed value to the edited attribute based on the comparison results

When you add a rule box to an attribute at the intermediate stage and the rule box uses the values of another attribute, the values of the other attribute come from the import stage. If you are working at the export stage with a similar rule box, the values of the other attribute come from the intermediate stage.

Tip

If you are working with prices, you must ensure that they are valid numbers, either integers or floats, and that they don't contain any text symbols, such as commas or dots. Consider using the Make Valid Price rule box to normalize your prices. See Validate prices and convert strings to integers.

Prerequisites

This document explains how to set up the needed rule box without mentioning the steps you need to take in Dataflow or Data View to edit an attribute and open the menu where you can add a rule box.

To add a rule box in Dataflow or Data View, see Add a rule box.

Add a static value if a chosen attribute meets a condition

The following rule boxes can help you set a static value in your edited attribute based on the contents of a chosen attribute:

  • Set Value if Contains

  • Set Value if Column Contains

  • Set Value If Value In

  • Set Value If Value Not In

All these rule boxes function in a similar way. You need to choose an attribute where the rule box should search for your desired value and enter the desired value itself. If the rule box finds it, the platform assigns, prepends, or appends a desired string to the edited attribute.

See the following sections for the setup details.

Set Value if Contains

To let the platform search an attribute for a certain search term and modify the edited attribute with your desired string in case of a match, add and set up the Set Value if Contains rule box:

  1. Search for and select the rule box Set Value if Contains.

    Set value if contains

  2. In Source Column, select the attribute where the rule box should search for your search term.

  3. In the compare value field, enter the search term you want the rule box to search for in the attribute chosen above. The search term can be a text string or a number.

  4. In the contains drop-down menu, choose the needed search behavior:

    1. Contains

      If a value in the chosen attribute contains the provided search term, the rule box modifies the edited attribute.

    2. Contains not

      If a value in the chosen attribute doesn't contain the provided search term, the rule box modifies the edited attribute.

    3. <

      If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.

    4. <=

      If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.

    5. !=

      If a value in the chosen attribute is numeric and it doesn't equal the provided number, the rule box modifies the edited attribute.

      Note

      This option also works with text values and means that the full value doesn't match the provided search term. The option is case-sensitive.

    6. =

      If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.

      Note

      This option also works with text values and means that the full value matches the provided search term. The option is case-sensitive.

    7. >=

      If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.

    8. >

      If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.

  5. In the assign value field, enter the desired string that the rule box should use to modify the edited attribute.

  6. In the assign drop-down menu, choose the modifying mode that the rule box should use to change the edited attribute:

    1. assign overwrites the current value with the desired string.

    2. append adds the desired string at the end of the current value.

    3. prepend adds the desired string at the beginning of the current value.

    4. leave unchanged doesn't modify the current value at all.

  7. In the handle no match drop-down menu, select what the rule box should do with the values that don't match the set conditions:

    1. leave unchanged

    2. assign

    3. append

    4. prepend

    Note

    Provide the desired no-match value in change to if you choose assign, append, or prepend in this drop-down menu.

For example, you have the following data in your feed:

title

condition

Slippers

new

Blanket

used

Socks

new

If you add the rule box Set Value if Contains to the title attribute, you can set it up as shown below to add the string , not used to the titles of all products whose condition is new:

Source Column

contains

compare value

assign

assign value

handle no match

title (after)

condition

contains

new

append

, not used

leave unchanged

Slippers, not used

Blanket

Socks, not used

Set Value if Column Contains

Add and set up the Set Value if Column Contains rule box to let the platform search an attribute for a certain search term and modify the edited attribute with your desired string in case of a match.

The difference between Set Value if Contains and Set Value if Column Contains is the ability of the latter to consider multiple search terms and desired strings.

  1. Search for and select the rule box Set Value if Column Contains.

    Set value if column contains

  2. In Column, select the attribute where the rule box should search for your search term.

  3. In the text area below, enter the search terms and add the desired strings that the rule box should use to modify the edited attribute.

    The input in this field should use the format search term:desired string. See an example of applying this rule box after the setup instructions.

    Tip

    If you want to enter multiple search terms and desired strings, start each pair from a new line.

  4. In Mode, choose how the rule box should modify the edited attribute:

    1. assign overwrites the current value with the desired string.

    2. append adds the desired string at the end of the current value and separates the string and the value with a space.

    3. prepend adds the desired string at the beginning of the current value and separates the string and the value with a space.

  5. In Match Mode, select how strict the match of the search term should be:

    1. broad matches any part of the value with the search term and isn't case-sensitive.

    2. exact matches the whole value with the search term and is case-sensitive.

  6. In Find, select first to consider only the first match of the search term within a value or all to consider all matches within a value.

For example, you have the following data in your feed:

title

brand

Slippers

Gucci

Socks

Prada

Car

Tesla

If you add the rule box Set Value if Column Contains to the title attribute, you can set it up as shown below to add the strings High-Fashion or Haute Couture to the titles of all products whose brands are Gucci or Prada, respectively:

Column

Text area

Mode

Match Mode

Find

title (after)

brand

Gucci:High-Fashion

Prada:Haute Couture

Note

Each pair of a search term and a desired string starts from a new line.

prepend

broad

first

High-Fashion Slippers

Haute Couture Socks

Car

Set Value If Value In

To search another attribute for a specific search term and assign a desired string to the edited attribute if there is a match, add and set up the Set Value If Value In rule box.

  1. Search for and select the rule box Set Value If Value In.

    Set value if value in

  2. In Source Column, select the attribute where the rule box should search for your search term.

  3. In Match, select how strict the match of the search term should be:

    1. broad matches any part of the value with the search term and isn't case-sensitive.

    2. exact matches the whole value with the search term and is case-sensitive.

  4. In Set Value, enter the desired string that the rule box should assign to your edited attribute in case of a match.

  5. In the text field, enter the search terms you want the rule box to search for in the attribute chosen above.

    Tip

    If you want to search for multiple search terms, start each search term from a new line.

For example, you have the following data in your feed:

sizes

availability

S, M, XXL

in stock

L

out of stock

XXS, M

out of stock

If you add the rule box Set Value If Value In to the sizes attribute, you can set it up as shown below to assign the string No sizes available to the sizes of all products whose availability status is out of stock:

Source Column

Match

Set Value

Text area

sizes (after)

availability

broad

No sizes available

out of stock

S, M, XXL

No sizes available

No sizes available

Set Value If Value Not In

To search another attribute for a specific search term and assign a desired string to the edited attribute if there is no match, add and set up the Set Value If Value Not In rule box:

  1. Search for and select the rule box Set Value If Value Not In.

    Set value if value not in

  2. In Source Column, select the attribute where the rule box should search for your search term.

  3. In Match, select how strict the match of the search term should be:

    1. broad matches any part of the value with the search term and isn't case-sensitive.

    2. exact matches the whole value with the search term and is case-sensitive.

  4. In Then, choose how the rule box should modify the edited attribute in case of no search term match:

    1. assign overwrites the current value with the desired string.

    2. append adds the desired string at the end of the current value and separates the string and the value with a space.

    3. prepend adds the desired string at the beginning of the current value and separates the string and the value with a space.

  5. In Set Value, enter the desired string that the rule box should use to modify your edited attribute in case of no match.

  6. In the text field, enter the search terms you want the rule box to search for in the attribute chosen above.

    Tip

    If you want to search for multiple search terms, start each search term from a new line.

For example, you have the following data in your feed:

sizes

availability

S, M, XXL

in stock

L

out of stock

XXS, M

out of stock

If you add the rule box Set Value If Value Not In to the sizes attribute, you can set it up as shown below to assign the string No sizes available to the sizes of all products whose availability status is anything but in stock:

Source Column

Match

Then

Set Value

Text area

sizes (after)

availability

broad

assign

No sizes available

in stock

S, M, XXL

No sizes available

No sizes available

Add a dynamic value if a chosen attribute meets a condition

To let the platform search attribute A for a certain search term and, in case of a match, modify the edited attribute B by adding the value from attribute C, add and set up the Set Column if Contains rule box:

Note

If the values in attributes A and C change, so do the values in attribute B. That is why this attribute modification method is dynamic.

  1. Search for and select the rule box Set Column if Contains.

    Set value if contains

  2. In Source Column, select the attribute where the rule box should search for your search term.

  3. In the compare value field, enter the search term you want the rule box to search for in the attribute chosen above. The search term can be a text string or a number.

  4. In the contains not drop-down menu, choose the needed search behavior:

    1. Contains not

      If a value in the chosen attribute doesn't contain the provided search term, the rule box modifies the edited attribute.

    2. Contains

      If a value in the chosen attribute contains the provided search term, the rule box modifies the edited attribute.

    3. <

      If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.

    4. <=

      If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.

    5. !=

      If a value in the chosen attribute is numeric and it doesn't equal the provided number, the rule box modifies the edited attribute.

      Note

      This option also works with text values and means that the full value doesn't match the provided search term. The option is case-sensitive.

    6. =

      If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.

      Note

      This option also works with text values and means that the full value matches the provided search term. The option is case-sensitive.

    7. >=

      If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.

    8. >

      If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.

  5. In the second Select an Option drop-down list, select the attribute storing the values that the rule box should use to modify the edited attribute.

    Tip

    You can choose the same attribute here as in Step 2.

  6. In the assign drop-down menu, choose the modifying mode that the rule box should use to change the edited attribute:

    1. assign overwrites the current value with the value of the attribute selected in Step 5.

    2. append adds the value of the attribute selected in Step 5 at the end of the current value.

    3. prepend adds the value of the attribute selected in Step 5 at the beginning of the current value.

    4. leave unchanged doesn't modify the current value at all.

  7. In the handle no match drop-down menu, select what the rule box should do with the values that don't match the set conditions:

    1. leave unchanged

    2. assign

    3. append

    4. prepend

    Note

    Provide the desired no-match value in change to if you choose assign, append, or prepend in this drop-down menu.

For example, you have the following data in your feed:

title

brand

price_€

Slippers

Gucci

510

Socks

Prada

250

Slippers

adidas

18

If you add the rule box Set Column if Contains to the title attribute, you can set it up as shown below to prepend the value in brand to the titles of all products whose values in price_€ are over 200:

Source Column

compare value

contains not

Select an Option

assign

handle no match

title (after)

price_€

200

>

brand

prepend

leave unchanged

Gucci Slippers

Prada Socks

Slippers

Overwrite a value if it contains a certain string

To let the platform search your edited attribute for a certain string and, in case of a match, overwrite the entire value with a new desired string, add and set up the Contains String rule box:

  1. Search for and select the rule box Contains String.

    Contains string

  2. In If value contains, enter the search term that the rule box should search for in your edited attribute.

  3. In Set value to, enter a new desired string that should overwrite the current value in case of a search term match.

  4. If you want to manage the non-matching cases, you can use the Otherwise set value to field to enter the string that should overwrite the current value in case of no match with the search term.

For example, you have the following data in your feed:

availability

in stock

unavailable

unavailable

If you add the rule box Contains Strings to the availability attribute, you can set it up as shown below to overwrite the value unavailable with the string out of stock:

If value contains

Set value to

availability (after)

unavailable

out of stock

in stock

out of stock

out of stock

Set a static value if the current value is greater than a certain number

To let the platform search your edited attribute for numbers exceeding a certain threshold and, in case of a match, overwrite the entire value with a new desired string, add and set up the Set Value if Greater Than rule box:

  1. Search for and select the rule box Set Value if Greater Than.

    Set value if greater than

  2. In Value >, enter a threshold for the rule box to compare your current values against.

  3. In Output, enter a new desired string that should overwrite the current value if it exceeds the threshold.

  4. If your attribute contains not only numbers but also text strings, you can use the If column value is not a number drop-down menu to select the desired behavior:

    1. leave unchanged doesn't modify text values at all.

    2. treat as 0 overwrites text values with 0.

    3. return empty string removes text and makes the values empty.

For example, you have the following data in your feed:

price_$

5

55

555

If you add the rule box Set Value if Greater Than to the price_$ attribute, you can set it up as shown below to overwrite the values greater than 500 with the string too expensive:

Value >

Output

If column value is not a number

price_$ (after)

500

too expensive

leave unchanged

5

55

too expensive

Add a value if the current value is empty

To let the platform add data to the empty values of your edited attribute, you can add and set up the following rule boxes:

  • Set Value if Empty overwrites empty values in the edited attribute with a desired static string.

  • Set Value if Empty (Conditional) overwrites empty values in the edited attribute with a desired static string if another attribute meets a condition.

  • Set Column if Empty checks whether the edited attribute has empty values and overwrites empty values with the values of another attribute.

To set up the rule boxes Set Value if Empty and Set Column if Empty, do the following:

  1. Search for and select the rule box Set Value if Empty or Set Column if Empty.

    Set value if empty
    Set column if empty

  2. Enter the desired value in Static value to set or choose the needed attribute from the Select an Option drop-down menu.

To set up the rule box Set Value if Empty (Conditional), do the following:

  1. Search for and select the rule box Set Value if Empty (Conditional).

    Set value if empty (conditional)

  2. In Source Column, select the attribute where the rule box should search for your search term.

  3. In the compare value field, enter the search term you want the rule box to search for in the attribute chosen above. The search term can be a text string or a number.

  4. In the contains drop-down menu, choose the needed search behavior:

    1. Contains

      If a value in the chosen attribute contains the provided search term, the rule box modifies the edited attribute.

    2. Contains not

      If a value in the chosen attribute doesn't contain the provided search term, the rule box modifies the edited attribute.

    3. <

      If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.

    4. <=

      If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.

    5. !=

      If a value in the chosen attribute is numeric and it doesn't equal the provided number, the rule box modifies the edited attribute.

      Note

      This option also works with text values and means that the full value doesn't match the provided search term. The option is case-sensitive.

    6. =

      If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.

      Note

      This option also works with text values and means that the full value matches the provided search term. The option is case-sensitive.

    7. >=

      If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.

    8. >

      If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.

  5. In Set Value, enter the desired string that should overwrite your current empty values in case of a search term match.

Add a string if the current value isn't empty

To let the platform add data to non-empty values in your edited attribute, you can add and set up the following rule box:

  • Append/Prepend Value if not Empty adds a static string at the beginning or end of the values in the edited attribute if they contain data.

To set up the rule box Append/Prepend Value if not Empty, do the following:

  1. Search for and select the rule box Append/Prepend Value if not Empty.

    Append/prepend value if not empty

  2. In Mode, choose how the rule box should modify the edited attribute with the desired string:

    1. append adds the desired string at the end of the current value without adding a space before it.

    2. prepend adds the desired string at the beginning of the current value without adding a space after it.

  3. Enter the desired string in Static value to set.

Add a dynamic value if a chosen attribute isn't empty

To let the platform add non-empty values of a chosen attribute into your edited attribute, you can add and set up the following rule box:

  • Set Column if not Empty overwrites the values in the edited attribute with the dynamic non-empty values of another attribute. If the chosen attribute contains an empty value, the rule box doesn't overwrite the value of the edited attribute with it.

To set up the rule box Set Column if not Empty, do the following:

  1. Search for and select the rule box Set Column if not Empty.

    Set column if not empty

  2. Choose the needed attribute from the Select an Option drop-down menu.

Add a dynamic value if certain data doesn't already exist in the attribute

To let the platform add data from a chosen attribute to the values of your edited attribute if this data doesn't yet exist in the edited attribute, add and set up the Append/Prepend Column if Value Not Present rule box:

  1. Search for and select the rule box Append/Prepend Column if Value Not Present.

    Append/prepend column if value not present

  2. In Column, select the attribute that stores the needed data. The rule box searches this attribute and compares its values with the current values of the edited attribute. If a current value doesn't have the data stored in the chosen attribute, the rule box adds this data to the value.

  3. In Mode, choose how the rule box should modify the edited attribute:

    1. append adds the data from the chosen attribute at the end of the current value and separates the string and the value with a space.

    2. prepend adds the data from the chosen attribute at the beginning of the current value and separates the string and the value with a space.

  4. If you want to add some text before or after the data from the chosen attribute, you can use the text field to enter the desired string and select one of the options of where the rule box should add the desired string:

    1. Text Before

    2. Text After

For example, you have the following data in your feed:

title

brand

Slippers

Gucci

Prada Socks

Prada

Shirt

Balenciaga

If you add the rule box Append/Prepend Column if Value Not Present to the title attribute, you can set it up as shown below to add the values in brand to the current titles if the data in brand isn't already present in the titles:

Column

Mode

text

Text Before

title (after)

brand

prepend

Genuine

Note

There is a space at the end of this string.

Text Before

Genuine Gucci Slippers

Prada Socks

Genuine Balenciaga Shirt

Compare data in multiple attributes and assign a value based on the outcome

The following rule boxes can help you set a static or dynamic value in your edited attribute based on a comparison of data in one or more chosen attributes:

  • Set Value by Compare

  • Set Value by Column Compare

  • Set Value by Column Compare (Multicondition)

See the following sections for the differences between these rule boxes and the setup details.

Set Value by Compare

To let the platform compare the values of the chosen attribute with your desired condition and modify your edited attribute with the desired string, add and set up the Set Value by Compare rule box:

  1. Search for and select the rule box Set Value by Compare.

    Set value by compare

  2. In If, select the attribute where the rule box should compare values to your condition.

  3. In Is, select the condition that the values of the chosen attribute should meet:

    1. less than

      If a value in the chosen attribute is numeric and it is less than the provided number, the rule box modifies the edited attribute.

    2. less or equal

      If a value in the chosen attribute is numeric and it is less than or equals the provided number, the rule box modifies the edited attribute.

    3. equal to

      If a value in the chosen attribute is numeric and equals the provided number, the rule box modifies the edited attribute.

      Note

      This option also works with text values and means that the full value matches the provided string. The condition is case-sensitive.

    4. greater than

      If a value in the chosen attribute is numeric and it is greater than the provided number, the rule box modifies the edited attribute.

    5. greater than or equal

      If a value in the chosen attribute is numeric and it is greater than or equals the provided number, the rule box modifies the edited attribute.

  4. In value to compare, enter a number for the specified condition.

  5. In Then, choose how the rule box should modify the edited attribute if the value in the chosen attribute meets the specified condition:

    1. assign column to overwrites the current value with the desired string.

    2. append adds the desired string at the end of the current value.

    3. prepend adds the desired string at the beginning of the current value.

  6. In output if comparison is true, enter the desired string that should modify your edited attribute if the value in the chosen attribute meets the specified condition.

For example, you have the following data in your feed:

title

price_$

Slippers

10

Socks

1

Shirt

55

If you add the rule box Set Value by Compare to the title attribute, you can set it up as shown below to add the string Cheap if the value in price_$ is less than 10:

If

Is

value to compare

Then

output if comparison is true

title (after)

price_$

less than

10

prepend

Cheap

Note

There is a space at the end of this string.

Slippers

Cheap Socks

Shirt

Set Value by Column Compare

Add and set up the Set Value by Column Compare rule box to create two (2) connected conditions with two (2) chosen attributes and modify your edited attribute with the desired static or dynamic value if both conditions are satisfied:

Note

You don't have to use both conditions for the Set Value by Column Compare rule box to work. You can set up only one condition if you need one.

  1. Search for and select the rule box Set Value by Column Compare.

    Set value by column compare

  2. In Source Column, select the attribute where the rule box should compare values to meet your first condition.

  3. In the first contains drop-down menu, choose your first condition:

    1. Contains

      A value in the chosen attribute should contain the provided string or number.

    2. Contains not

      A value in the chosen attribute shouldn't contain the provided string or number.

    3. <

      A value in the chosen attribute should be numeric and less than the provided number.

    4. <=

      A value in the chosen attribute should be numeric and less than or equal to the provided number.

    5. !=

      A value in the chosen attribute should be numeric and shouldn't equal the provided number.

      Note

      This option also works with text values and means that the full value shouldn't match the provided string. The condition is case-sensitive.

    6. =

      A value in the chosen attribute should be numeric and should equal the provided number.

      Note

      This option also works with text values and means that the full value should match the provided string. The condition is case-sensitive.

    7. >=

      A value in the chosen attribute should be numeric and greater than or equal to the provided number.

    8. >

      A value in the chosen attribute should be numeric and greater than the provided number.

  4. In the first compare source value field, enter a string or a number for your first condition.

  5. In Optional Column, you can select another attribute where the rule box should compare values to meet your second condition.

  6. In the second contains drop-down menu, you can choose your second condition.

  7. In the second compare source value field, you can enter a string or a number for your second condition.

  8. To specify what the rule box should do if the data in both chosen attributes meets the defined conditions, choose whether you want to assign a static value to all your products or set a dynamic value depending on the values of another attribute:

    1. In Set Value, enter the desired string to modify your edited attribute with a static value.

    2. In the Select an Option drop-down list, select the needed attribute to modify your edited attribute with dynamic values.

  9. In the assign drop-down menu, choose how the rule box should modify the edited attribute if the data in both chosen attributes meets the specified conditions:

    1. assign overwrites the current value with the desired string.

    2. append adds the desired string at the end of the current value.

    3. prepend adds the desired string at the beginning of the current value.

For example, you have the following data in your feed:

title

price_$

stock

Slippers

10

out of stock

Socks

1

in stock

Shirt

55

in stock

If you add the rule box Set Value by Column Compare to the title attribute, you can set it up as shown below to add the string - Best Price at the end of the value if both conditions are met:

  • The number in price_$ is less than 15

  • The value in stock is in stock.

Source Column

contains (1)

compare source value (1)

Optional Column

contains (2)

compare source value (2)

Set Value

assign

title (after)

price_$

<

15

stock

=

in stock

- Best Price

Note

There is a space at the beginning of this string.

append

Slippers

Socks - Best Price

Shirt

Set Value by Column Compare (Multicondition)

Add and set up the Set Value by Column Compare (Multicondition) rule box to create two (2) connected conditions with two (2) chosen attributes and modify your edited attribute with the desired static string if both conditions are satisfied:

Note

The difference between the rule boxes Set Value by Column Compare and Set Value by Column Compare (Multicondition) is that the latter lets you specify multiple combinations of values for the conditions. It also lets you add static values only.

  1. Search for and select the rule box Set Value by Column Compare (Multicondition).

    Set value by column compare (multicondition)

  2. In Source Column 1, select the attribute where the rule box should compare values to meet your first condition.

  3. In the first Match type drop-down menu, choose your first condition:

    1. Contains

      A value in the chosen attribute should contain the provided string or number.

    2. Contains not

      A value in the chosen attribute shouldn't contain the provided string or number.

    3. <

      A value in the chosen attribute should be numeric and less than the provided number.

    4. <=

      A value in the chosen attribute should be numeric and less than or equal to the provided number.

    5. !=

      A value in the chosen attribute should be numeric and shouldn't equal the provided number.

      Note

      This option also works with text values and means that the full value shouldn't match the provided string. The condition is case-sensitive.

    6. =

      A value in the chosen attribute should be numeric and should equal the provided number.

      Note

      This option also works with text values and means that the full value should match the provided string. The condition is case-sensitive.

    7. >=

      A value in the chosen attribute should be numeric and greater than or equal to the provided number.

    8. >

      A value in the chosen attribute should be numeric and greater than the provided number.

  4. In Source Column 2, select another attribute where the rule box should compare values to meet your second condition.

  5. In the second Match type drop-down menu, choose your second condition.

  6. In the text field Search Values Column1:Column2, enter the strings or numbers for your conditions in the following format: desired string for condition 1:desired string for condition 2.

    Tip

    To enter multiple combinations of values for both conditions, start each pair from a new line.

  7. In Set Value, enter the desired string to modify your edited attribute with a static value if the data in both chosen attributes meets the specified conditions.

  8. In the assign drop-down menu, choose how the rule box should modify the edited attribute if the data in both chosen attributes meets the specified conditions:

    1. assign overwrites the current value with the desired string.

    2. append adds the desired string at the end of the current value.

    3. prepend adds the desired string at the beginning of the current value.

For example, you have the following data in your feed:

title

price_$

age_group

Pants

80

kids

Skirt

15

kids

Shirt

55

adults

If you add the rule box Set Value by Column Compare (Multicondition) to the title attribute, you can set it up as shown below to add the string - Best Price at the end of the value if one of the conditions is met:

  • The number in price_$ is less than 20 for the products with the value kids in age_group.

  • The number in price_$ is less than 60 for the products with the value adult in age_group.

Source Column 1

Match Type (1)

Source Column 2

Match Type (2)

Search Values Column1:Column2

Set Value

assign

title (after)

price_$

<

age_group

=

20:kids

60:adults

Note

Each pair of values starts from a new line.

- Best Price

Note

There is a space at the beginning of this string.

append

Pants

Skirt - Best Price

Shirt - Best Price

In this section: