Change Image Url structure

  • Resolved audiosteps

    (@audiosteps)


    3 months, 1 week ago

    Hello, we had a problem with WP Offload Media and Amazon S3, we had to re-upload all images to the S3 server. In the process, the timestamps in the url structure of the images changed. All image urls in our database and media library have been automatically adjusted so that we have no problems with missing images – except with the product configurators. To prevent this in the future, we have deactivated the timestamp url schema option so that all images are now located in a folder in an S3 bucket.

    The following problem. In the Woocommerce products, most of the images are missing when I open a product configurator in the admin area on the product page. There is only the question mark symbol and behind it the old link. In the database in _mkl_product_configurator_content meta_value the old image links are also stored. In the frontend on the product page, however, all images are displayed correctly in the configurator with the new link. Strangely enough, there are also some images in the configurator settings in the admin area that are displayed and also have the new link.

    Due to the timestamp that is stored in the old image urls in _mkl_product_configurator_content meta_value, we cannot perform mass editing, e.g. using the Better Search & Replace plugin. So I tried it directly manually in the database. As soon as I change / correct a link in the database entry _mkl_product_configurator_content, I can no longer see any content in the admin area under Configurator settings > Content. All are set to 0 content. I don’t understand this because I only correct the image url and everything else stays 100% the same.

    Since we have several thousand images for configurator content, reselecting the images via the media library is not an option for us. How can I correct the urls in the database?


    A solution using tools to repair images does not work either. It is reported that 0 images were found.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Marc Lacroix

    (@marcusig)

    Hi there,

    You cannot edit the meta _mkl_product_configurator_content directly, as it is a serialized value, which would need to be “unserialized” first.

    A solution using tools to repair images does not work either. It is reported that 0 images were found.

    Is that the tool which is part of the configurator?

    An other solution for replacing URLs would be to export the configuration to JSON (from the Import/export tool in the configurator), edit the json in a text editor, and re-import that file.

    The data contains 2 informations:

    • the image URL
    • the image ID in the library.

    The frontend uses the ID in order to fetch the right size image, which is why the right ones show on the frontend.

    Marc

    Thread Starter audiosteps

    (@audiosteps)

    Hi Marc,

    many thanks for your fast response and valuable information.

    Is that the tool which is part of the configurator?

    Yes, it is the tool from your plugin

    An other solution for replacing URLs would be to export the configuration to JSON (from the Import/export tool in the configurator), edit the json in a text editor, and re-import that file.

    That sounds very promising and I will try it. I’ll let you know whether I’m successful or not

    The frontend uses the ID
    ok, it makes sense that the images in the frontend continue to work and can already be accessed via the new url structure.

    Cheers

    André

    Thread Starter audiosteps

    (@audiosteps)

    Hi Marc,

    An other solution for replacing URLs would be to export the configuration to JSON (from the Import/export tool in the configurator), edit the json in a text editor, and re-import that file.?

    That works fine and with ChatGPT it is not much work to change the urls in the “manually”. Thanks again for help and great support!

    André

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.