Caleb Burks on "[Plugin: WooCommerce] Modified URL in wp_postmeta for _downloadable_files"

Hello,

I am using woocommerce version 2.6.4. We sell downloadable audio files and have more than 5000 files. Recently, we were forced to move all of our files to Amazon S3 while our WordPress install remains with GoDaddy. I ran the following query to update path, but this is causing the file download link to be removed from the order page and the order email. Plus when we go look at the Variations for each product, the file name and file url is missing there as well. I can clearly see it in the database though.

My question is, does anyone know of specific instructions for changing the download path? Changing them one at a time would be quite time consuming.

Query:
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'http://www.amotaudio.com/wp-content/uploads/', 'https://s3.amazonaws.com/PAthToFile') WHERE meta_key = '_downloadable_files'

https://wordpress.org/plugins/woocommerce/