Rule: Set Product Parameters#

This rule is used to set product parameters and their values. With a single rule, you can set different parameters for different product groups (based on product queries). The rule is ideal for automatically adding parameters such as volume, color, material, or weight.

Extra features#

• Parameter name autocomplete
• Bulk copy values, for example from Google Sheets
• Parameter type query (text, numeric, boolean…)
• Option to add multiple rows

Practical examples#

Example 1: Set new parameters for all or selected products#

This example shows how to set new product parameters in bulk and automatically for different product segments.

1. Creating a new rule:

• Open the “Rules” page.
• Click the New rule button.

2. Selecting the rule type:

• In the Rule type field, select the Set Product Parameters option.

3. Choosing the element to change:

• You do not need to select the elements where new parameters will be inserted – Mergado selects them automatically based on the project’s output format, for example: g:product_detail in a Google project.

4. Adding rows:

• Each row in the Set Product Parameters rule has 3 columns:
  • Queries – allows you to select one or more queries
  • Parameter – specifies the parameter name to be set
  • Value – specifies the value to be assigned to the parameter
• Rows allow you to set parameters for different product segments.

5. Product queries:

• In the left column in the Queries field
  • from the Selectbox, choose existing saved product queries from the project (each on a separate row).
    • 💡 Tip: You can select one or more queries.
  • or from the Selectbox, choose “Create new query” and create new Product queries for specific products you want the rule to apply to.

6. Setting parameters for the chosen query:

• In the right column Parameter, add parameter names one below another as text values, e.g., Volume
  • If you select an existing parameter name, the value will be updated.
  • If you enter a new name, a new parameter will be created.
• In the right column Value, add parameter values one below another as:
  • a text value, for example: 250 ml
  • a variable, for example: %volume%
  • a combination of variable and text, for example: %volume% ml

7. Setting parameters for additional queries:

• Repeat the previous steps “Product queries” and “Setting parameters for the chosen query” in the next empty row.
• 💡 Tip: Filling in a new row automatically adds another empty row.

8. Naming the rule:

• In the last step, enter the rule name, for example “Set parameters”.

Example 2: Rewrite existing product parameters#

This example shows how to rewrite existing product parameters in bulk and automatically for different product segments.

1. Creating a new rule:

• Open the “Rules” page.
• Click the New rule button.

2. Selecting the rule type:

• In the Rule type field, select the Set Product Parameters option.

3. Choosing the element to change:

• You do not need to select the elements where existing parameters are stored – Mergado selects them automatically based on the project’s output format, e.g., g:product_detail in a Google project.

4. Adding rows:

• Each row in the Set Product Parameters rule has 3 columns:
  • Queries – allows you to select one or more queries
  • Parameter – allows you to set one or more parameters for the given row
  • Value – allows you to set the parameter value for each parameter
• Rows allow you to set parameters for different product segments.

5. Product queries:

• In the left column in the Queries field
  • from the Selectbox, choose prepared saved queries from the project, each on a separate row,
    • 💡 Tip: You can select one or more queries.
  • or from the Selectbox, choose “Create new query” and create new Product queries for specific products you want the rule to apply to.

6. Setting parameters for the chosen query:

• In the right column Parameter, select from the Selectbox the names of existing parameters in the project that you want to rewrite, e.g., Volume
  • You can select multiple parameters for the chosen query, always one parameter per row.
• In the right column Value, add new parameter values one below another as:
  • a text value, for example: 250 ml
  • a variable, for example: %volume%
  • a combination of variable and text, for example: %volume% ml

7. Setting parameters for additional queries:

• Repeat the previous steps “Product queries” and “Setting parameters for the chosen query” in the next empty row.

• 💡 Tip: Filling in a new row automatically adds another empty row.

• Naming the rule:

  • In the last step, enter the rule name, for example “Set parameters”.

Example 3: Delete all parameter values for products#

This example shows how to delete all parameter values for different product segments while keeping the parameter names.

💡 Tip: If you want to delete only specific parameter values or delete the entire parameter including the name and values, use the Remove Product Parameters rule.

1. Creating a new rule:

• Open the “Rules” page.
• Click the New rule button.

2. Selecting the rule type:

• In the Rule type field, select the Set Product Parameters option.

3. Choosing the element to change:

• You do not need to select the elements where existing parameters are stored – Mergado selects them automatically based on the project’s output format, e.g., g:product_detail in a Google project.

4. Adding rows:

• Each row in the Set Product Parameters rule has 3 columns:
  • Queries – allows you to select one or more queries
  • Parameter – allows you to set one or more parameters for the given row
  • Value – allows you to set the parameter value for each parameter
• Rows allow you to set parameters for different product segments.

5. Product queries:

• In the left column in the Queries field
  • from the Selectbox, choose prepared saved queries from the project, each on a separate row,
    • 💡 Tip: You can select one or more queries.
  • or from the Selectbox, choose “Create new query” and create new Product queries for specific products you want the rule to apply to.

6. Setting parameters for the chosen query:

• In the right column Parameter, select from the Selectbox the names of existing parameters in the project whose values you want to delete, e.g., Volume
  • You can select multiple parameters for the chosen query, always one parameter per row.
• In the right column Value, leave the field empty for each parameter whose values you want to delete.

7. Setting parameters for additional queries:

• Repeat the previous steps “Product queries” and “Setting parameters for the chosen query” in the next empty row.
• 💡 Tip: Filling in a new row automatically adds another empty row.

8. Naming the rule:

• In the last step, enter the rule name, for example “Delete parameter values”.

FAQ#

What is the Set Product Parameters rule for?#

The rule allows you to set, modify, or delete parameter values for products. Each parameter has a name and a value (e.g., Color = Red). It can be used for:

• adding missing parameters (e.g., Volume, Material),
• rewriting existing parameters by query,
• deleting parameter values without removing the parameter name itself,
• automatically adding values for different product segments.

What is the difference between this rule and the Remove Product Parameters rule?#

• Set Product Parameters – can add, rewrite, and delete parameter values (the name is preserved).
• Remove Product Parameters – removes the entire parameter including the name and values, or allows removing specific values for a given parameter.

💡 If you only want to clear the value but keep the name (e.g., an empty parameter), use Set Product Parameters with an empty Value field.

Can I create new parameters using this rule?#

Yes. If you type a name in the Parameter column that does not yet exist in the project, Mergado automatically creates a new parameter. Conversely, if you choose an existing name from the Selectbox, the value will be rewritten.

What format can I use for parameter values?#

In the Value field, you can use:

• a text value – e.g., 250 ml,
• a variable – e.g., %volume%,
• a combination of variable and text – e.g., %volume% ml.

💡 This allows you to combine values from different elements or add units automatically.

How do product queries work in this rule?#

Each rule row contains three parts:

• Query – defines which products the rule applies to,
• Parameter – specifies which parameter to add or modify,
• Value – specifies what value to assign to the parameter.

This allows you to set different parameters for different product groups within a single rule.

Can I add multiple parameters for a single query?#

Yes. Simply create multiple rows for the same query – each with a different parameter name and value. 💡 After filling in the last row, a new empty row is automatically added.

Can I use this rule to delete a parameter value?#

Yes. If you leave the Value field empty, Mergado will remove the content (value) of the given parameter but keep the parameter name itself. 💡 If you want to remove the entire parameter, use the Remove Product Parameters rule instead.

Can I use variables in the parameter name?#

No. Only text can be entered in the parameter name – variables are not supported there. Variables can only be used in the Value field.

What types of parameters can I set?#

You can choose from multiple types:

• text (e.g., Color = Blue),
• numeric (e.g., Weight = 250),
• boolean (e.g., Available = true).

💡 Adjust the parameter type according to the project’s output format – e.g., Google Merchant Center requires specific value formats.

Can the rule be used for bulk parameter edits?#

Yes. Using the “Smart paste mode” checkbox, you can prepare values in Google Sheets, for example, and then paste them in bulk into the rule. Mergado automatically splits the individual values into the corresponding fields based on the table structure.

What if I want to set a parameter only for a specific category or brand?#

Create a Product query containing only those products (e.g., CATEGORYTEXT CONTAINS "Handbags"). Then apply the rule only to this query – other products remain unchanged.

Can the rule be combined with other rules?#

Yes. The most common combinations:

• Remove Product Parameters – for cleaning parameters before setting new ones,
• Rewrite – for inserting parameter values into product names,
• Letter case converter – for adjusting the format of text parameters.

How do I verify that the parameters were set correctly?#

After saving and applying the rules or after regenerating the feed, check the result:

• in the product preview, or
• using the Rule walkthrough feature, where you can see which parameters were added or changed.