Rule: Set Shipping Rates#

This rule is used to easily set carriers and shipping prices for your products. It allows you to bulk add carriers and the shipping cost, either as a numeric value or a variable.

Extra features#

• Bulk copy values, for example from Google Sheets
• Remove rows without a price
• Pre-defined list of carriers + ability to add new ones
• The price field accepts a numeric value or a variable
• Option to add multiple rows

Practical examples#

Example 1: Add a shipping price to all or selected products#

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 Shipping Rates option.

3. Selecting products:

• In the Query field, choose either All products or create your own Product query for specific products you want the rule to apply to.

4. Fill in the carriers:

• In the Carrier field, enter the carrier name (for example, DHL, DPD, FedEx).
• You can use the pre-defined list of carriers or add new carriers as needed.
• The number of rows is unlimited – add as many carriers as you need.

5. Setting the shipping price:

• In the Prepaid field, enter the shipping price value.
• You can enter:
  • a specific numeric value (for example, 89), or
  • a variable containing the price from the feed (for example, %delivery_price%).

6. Naming the rule:

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

Example 2: Rewrite the existing price for a specific carrier#

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 Shipping Rates option.

3. Selecting products:

• In the Query field, choose either All products or create your own Product query for specific products you want the rule to apply to.

4. Fill in the carriers:

• In the Carrier field, enter the carrier name whose value you want to rewrite (for example, DHL, DPD, FedEx).

5. Setting the shipping price:

• In the Prepaid field, enter the new shipping price value.
• You can enter:
  • a specific numeric value (for example, 89), or
  • a variable containing the price from the feed (for example, %delivery_price%).

6. Naming the rule:

• In the last step, enter the rule name, for example “DPD – new shipping price”.

Example 3: Set free shipping for all or selected products#

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 Shipping Rates option.

3. Selecting products:

• In the Query field, choose either All products or create your own Product query for specific products you want the rule to apply to.

4. Fill in the carriers:

• In the Carrier field, enter the carrier name (for example, DHL, DPD, FedEx).
• You can use the pre-defined list of carriers or add new carriers as needed.
• The number of rows is unlimited – add as many carriers as you need.

5. Setting the shipping price:

• In the Prepaid field, enter the new numeric value.
• In our case, enter 0, because shipping will be free.
• 💡 Tip: If you have multiple carriers, you can set a zero value for all or only selected carriers.

6. Naming the rule:

• In the last step, enter the rule name, for example: “Free shipping”.

Example 4: Set free shipping only on weekends#

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 Shipping Rates option.

3. Selecting products:

• In the Query field, choose either All products or create your own Product query for specific products you want the rule to apply to.

4. Fill in the carriers:

• In the Carrier field, enter the carrier name (for example, DHL, DPD, FedEx).
• You can use the pre-defined list of carriers or add new carriers as needed.
• The number of rows is unlimited – add as many carriers as you need.

5. Setting the shipping price:

• In the Prepaid field, enter the new numeric value.
• In our case, enter 0, because shipping will be free.
• 💡 Tip: If you have multiple carriers, you can set a zero value for all or only selected carriers.

6. Naming the rule:

• In the last step, enter the rule name, for example “Free shipping – weekend”.

7. Setting the rule timer:

• Go to the bottom of the page and click the “Additional options” button.
• After expanding the section, click “Enable timer”.
• A table will open where you can specify the days and hours when the rule should be active.
  • Active time slots are marked with a checkmark.
  • In our case, select Friday, Saturday, and Sunday.
  • Leave the other days (Monday–Thursday) inactive.
• At the top of the timer, you can optionally set a validity date (from when to when the rule should be active).
  • If you do not set these values, the rule will be valid from the moment it is saved until you disable the timer.

Additional uses#

• Remove a selected carrier from the feed.

FAQ#

What is this rule for?#

With this rule, you can bulk add carriers and shipping prices to all or selected products. The value can be entered as a specific number or a variable containing the price from the feed.

Can I set different prices for different carriers?#

Yes. For each row, you can enter a different carrier (e.g., DHL, DPD, FedEx) and a different shipping price. The number of rows is unlimited.

Can the price be entered as a variable?#

Yes. Instead of a fixed amount, you can use a variable, for example %delivery_price%. This way, the price is automatically loaded from the feed.

How do I set free shipping for all products?#

In the “Prepaid” field, enter the value 0. This sets free shipping for all products that fall within the selected query.

Can free shipping be set for selected products only?#

Yes. In the “Query” field, choose a saved product query – for example, products with a price higher than 1,000 CZK – and enter a shipping price of 0. The rule will apply only to this query.

Can I overwrite an existing shipping price?#

Yes. If the same carrier already has a price in the feed, the rule will rewrite it with the new value. Prices for other carriers remain unchanged.

How do I add a new carrier that is not in the list?#

Simply type its name manually in the “Carrier” field – for example, “GLS” or “Express Delivery”.

Can I set multiple carriers at once?#

Yes. Add more rows to the rule – one for each carrier – and set a different price for each. When the feed is regenerated, the rule will create the corresponding records.

Can the rule be time-limited (e.g., free shipping on weekends)?#

Yes. In the “Additional options” section, enable the rule timer and select the days or time slots when the rule should be active. For example, you can set free shipping to apply only from Friday to Sunday.

What happens if the carrier does not exist in the project?#

Mergado will automatically create the carrier as a new record. You do not need to set up carriers manually in advance.

How do I verify that the rule works correctly?#

After saving and regenerating the feed, open the Elements page and find shipping (or the corresponding element based on the format). Check that the new carriers and their prices are displayed correctly.

You can also verify the result:

• on the Products page, where the newly set values will be reflected in the product overview, or
• directly in the output feed, which you can open in a browser and search for the specific element.

💡 For a detailed check of individual products, you can use the Rule walkthrough feature, which shows how the rule was applied to a given product.