---
title: How to Bulk Update Target URLs
description: "As your affiliate marketing campaigns grow, you may need to update multiple Target URLs in ClickWhale at the same time. This often happens when: - You switch to a new affiliate network - An affiliate program changes its tracking parameters…"
url: "https://clickwhale.pro/docs/article/how-to-bulk-update-target-url/"
updated: "2026-08-10"
category: "How To's & Tutorials"
---

# How to Bulk Update Target URLs

As your affiliate marketing campaigns grow, you may need to update multiple Target URLs in ClickWhale at the same time.

This often happens when:

- You switch to a new affiliate network
- An affiliate program changes its tracking parameters
- You need to update outdated destination URLs
- You want to replace tracking IDs across multiple links

Instead of editing each ClickWhale link one by one, you can use the [Better Search Replace](https://wordpress.org/plugins/better-search-replace/) plugin to update multiple Target URLs in just a few clicks.

## Video Tutorial

Prefer to watch instead? Follow the complete walkthrough below.

[How to Bulk Update ClickWhale Target URLs](https://www.youtube.com/embed/SFl_bRp4bdg?feature=oembed)

## Before You Start

Before making any bulk changes, we recommend:

- Creating a full database backup
- Having administrator access to your WordPress site
- Installing and activating the Better Search Replace plugin

## Step 1: Open Better Search Replace

From your WordPress dashboard, navigate to:

**Tools → Better Search Replace**

You will see fields for searching and replacing text within your database.

![Better search replace dashboard](https://clickwhale.pro/wp-content/uploads/2026/06/better-search-replace-dashboard.png)
better search replace dashboard

## Step 2: Enter the Values to Replace

In the **Search For** field, enter the URL or parameter you want to replace.

Example:

```
?aff_id=922
```

In the **Replace With** field, enter the new value.

Example:

```
?aff_code=demo123
```

Next, select the **wp_clickwhale_links** table.

This ensures that only your ClickWhale links are updated.

## Step 3: Run a Dry Run

Before making any changes, enable the **Run as dry run** option.

A dry run scans your database and shows how many records would be updated without making any actual changes.

Click **Run Search/Replace**.

Review the results to confirm that the correct links have been identified.

![Better search replace dryrun](https://clickwhale.pro/wp-content/uploads/2026/06/better-search-replace-dryrun.png)
better search replace dryrun

A Dry Run notice will appear. If the dry run appears to have found a cell to be updated, you can disable the “Run as Dry run” to proceed with updating the links.

![Bsr notice](https://clickwhale.pro/wp-content/uploads/2026/05/bsr-notice.png)

## Step 4: Apply the Changes

If the dry run results look correct:

1. Disable the **Run as dry run** option.
2. Click **Run Search/Replace** again.

Better Search Replace will update all matching ClickWhale links in the selected table.

### Example

#### Before

```
https://example.com/product?aff_id=922
```

![Bsr before](https://clickwhale.pro/wp-content/uploads/2026/05/bsr-before-1024x276.png)

#### After

And here’s after updating the Links with Better Search Replace

```
https://example.com/product?aff_code=demo123
```

![Bsr after](https://clickwhale.pro/wp-content/uploads/2026/05/bsr-after-1024x275.png)

## Why Use Better Search Replace?

Using Better Search Replace allows you to:

- Update multiple ClickWhale Target URLs at once
- Replace affiliate parameters in bulk
- Save time by avoiding manual edits
- Keep your links accurate and up to date

Always perform a dry run before applying changes to verify that the correct links will be updated.

That's it. Your ClickWhale Target URLs have now been updated in bulk.

## FAQS

### **Can I bulk update affiliate IDs in ClickWhale?**

Yes. You can use Better Search Replace to replace affiliate IDs, tracking parameters, or destination URLs stored in your ClickWhale links.

### **Is it safe to use Better Search Replace?**

Yes, but always create a backup and perform a dry run before making changes.

### **Which database table should I select?**

Select the `wp_clickwhale_links` table to update ClickWhale Target URLs. If your site uses a custom database prefix, the table name may be different.