WordPress Hosting — Search & Replace Tool

Efficiently update text across your hosted WordPress site's database directly from your CRM, eliminating the need for external plugins or code. The built-in Search & Replace tool allows you to safely preview matches before applying changes to your Live or Staging environment. This is ideal for tasks like updating domain names after a migration, changing HTTP links to HTTPS, or performing bulk corrections to URLs and email addresses.

What is the Search & Replace Tool?

The Search & Replace tool is a native feature for WordPress hosting within the CRM. It scans your site's database for a specific text string and gives you the option to replace it across relevant database tables. It is designed to simplify essential maintenance work, such as cleaning up after a site migration or correcting links in bulk, while promoting safe practices like creating backups and testing changes in a Staging environment first.

Key Benefits

Using this tool provides several key advantages for managing your site's content safely and efficiently.

• Integrated and Secure: Operates natively within the CRM, with no need to install or trust third-party plugins.
• Preview Changes: Run a search-only scan to see how many matches exist before making any permanent changes.
• Environment Aware: Functionality is available for both Live and Staging sites, enabling safe testing workflows.
• Guided Safety: The process includes prompts for creating backups and confirmation steps to prevent accidental data modification.
• Reduced Errors: A centralized, consistent process for common text updates minimizes manual mistakes.
• Time Efficient: Bulk updates are significantly faster than editing content page by page.

Using Preview Mode

Preview mode is a critical safety feature that lets you verify what will be changed before any data is altered. To use it, enter your search string and select the option to perform a search without a replacement. The tool will return a count of matches. Review this number to check for potential issues, such as an unexpectedly high count that might indicate your search term is too broad. Refine your search for greater specificity before proceeding with the replacement.

Replacement Options and Matching Behavior

Understanding how the tool matches text is key to targeting the correct content and avoiding unintended changes.

• Case Sensitivity: Matches are case-sensitive. For example, searching for "HTTP" will not find "http".
• Partial Matches: The tool uses standard string matching. Use specific, full phrases to avoid overly broad replacements.
• Tables and Data Safety: The tool is designed to work safely with standard WordPress data. Avoid targeting extremely sensitive system fields.
• Regex and Wildcards: Regular expressions and wildcards are not supported. Use precise, literal text strings for predictable results.

How to Use the Search & Replace Tool

Follow these steps to perform a search and replace operation safely.

1. Navigate to Sites, then WordPress, and select your desired site.
2. From the Quick Actions menu, choose Search & Replace.
3. Enter the text you want to find and the text you want to replace it with. The tool will display the database tables that will be scanned.
4. Click Next to proceed.
5. Wait for the process to complete and a confirmation to appear.
6. After completion, review the summary and manually check a few pages or posts to confirm the changes are correct.

Frequently Asked Questions

Q: Can I undo a replacement?
A: Yes. Use the Backup & Restore function to revert to the backup that is created automatically before the tool runs.

Q: Does the tool support regular expressions (regex) or wildcards?
A: No. For reliable results, use exact, literal text strings.

Q: Will the tool handle serialized data safely?
A: It is designed for common WordPress data structures. For sites with complex custom tables or plugins, always validate changes in the Staging environment first.

Q: Can I limit the replacement to specific database tables?
A: Currently, you cannot select individual tables. Control the scope of your changes by using very specific search strings and carefully reviewing the preview count.

Q: Is the matching case-sensitive?
A: Yes. The search is case-sensitive to help prevent unintended matches.

Q: Can I use this tool on a WordPress Multisite network?
A: The tool operates on a per-site basis. It does not support network-wide replacements in a single operation.

Q: Where can I see a log of who used the tool?
A: Check your WordPress site's access, activity, or audit logs for a record of administrative actions.

Q: How long does the process take?
A: The duration depends on the size of your site's database and current server load. For large sites, it is recommended to run the tool during periods of low traffic and to test in Staging first.