Looking for input – replacing media URLs

Hi Philip,

It would help us consider options to see an example an image URL before and after with all images sizes included. Something like:

OLD

1. https://example.com/wp-content/uploads/2023/12/01/test-image
2. https://example.com/wp-content/uploads/2023/12/01/test-image-300X400
3. https://example.com/wp-content/uploads/2023/12/01/test-image-900×600

NEW

1. https://google-something.com/some-hash/2023/12/01/test-image
2. https://google-something.com/some-hash/2023/12/01/test-image-300X400
3. https://google-something.com/some-hash/2023/12/01/test-image-900×600

Some additional questions to help narrow this down:

1. Are you able to use WP-CLI as an option?
2. Does every image have the same thumbnail sizes?

Whatever we come up with will have to be thought of as running small batches as I’m pretty sure that running Go Live update process 1,500 times at once will crash.

I agree the tricky part will be generating the CSV because the Google URL does not have any common parts with the image URL.

If you can create the CSV, I can write a WP-CLI command which will loop through it and run the Go Live update process for each line in the CSV. Pausing between batches to free up memory and let the MySQL server calm down.

Or if you just want some inspiration, here is a WP-CLI command which supports passing multiple URL on the command line.

<?php namespace Go_Live_Update_Urls\WP_CLI; use WP_CLI\ExitException; /** * Extend the Go Live Update Urls command to handle multiple URLs. * * Registered via WP_CLI::add_command( Go_Live::COMMAND, Multiple_Url::class ); after the go-live-update-urls-pro plugin is loaded. */ class Multiple_Url extends Go_Live { /** * ## OPTIONS * * * : The old URL to replace. * Optionally pass a CSV to replace multiple URLs. * * * : The new URL to replace the old URL with. * Optionally pass a CSV to have multiple new url. * If a CSV is passed, the number of old URLs must match the number of new URLs. * If a single new URL is passed, all old URLs will be replaced with the new URL regardless of the number old URLs passed. * * @param array $old_urls - [,]. * @param array $flags - Optional parameters. * * @throws ExitException If this command does not have all required arguments or incorrect format, will exit. * * @return void */ public function update( $old_urls, $flags ) { if ( empty( $old_urls[0] ) ) { \WP_CLI::error( __( 'You must specify an old URL', 'go-live-update-urls' ) ); } if ( empty( $old_urls[1] ) ) { \WP_CLI::error( __( 'You must specify a new URL', 'go-live-update-urls' ) ); } list( $old, $new ) = $old_urls; $old_urls = \explode( ',', $old ); $old_urls = \array_map( '\trim', $old_urls ); $new_urls = \explode( ',', $new ); $new_urls = \array_map( '\trim', $new_urls ); if ( \count( $new_urls ) > 1 && \count( $old_urls ) !== \count( $new_urls ) ) { \WP_CLI::error( 'The number of old URLs must match the number of new URLs.' ); } foreach ( $old_urls as $k => $url ) { if ( isset( $new_urls[ $k ] ) ) { $urls = [ $url, $new_urls[ $k ] ]; } else { $urls = [ $url, $new_urls[0] ]; } parent::update( $urls, $flags ); } } }

The provided CLI code is just an example of how to run multiple URL at once in case you wanted to write the full command yourself. It does not yet support a CSV file nor running in batches.

The example code:

1. Adds a new wp go-live multiple-url command which accepts a string CSV value like so --old=http://example.com,http://test.com and --new=https://first-new.com,http://second-new.com
2. Could be added to a plugin or theme.
3. Registered like so WP_CLI::add_command( Go_Live::COMMAND, Multiple_Url::class );

It would still need to be modified to accept a CSV file and run in batches, but it provides a good starting point.