How to migrate variation images from Additional Variation Images to WooThumbs

If you are currently using the Additional Variation Images plugin from WooCommerce and want to switch over to use WooThumbs, then you'll be pleased to know it is easy to transfer the image data you may have already configured.

  1. Firstly, you'll need to log into your database using a program like Sequel Pro or phpMyAdmin.
  2. Once logged in, it's probably wise to take a backup of your database.
  3. Then, you'll want to execute a custom query. In Sequel Pro, click on the Query icon.
  4. Enter the following code: UPDATE `wp_postmeta` SET `meta_key` = 'variation_image_gallery' WHERE `meta_key` = '_wc_additional_variation_images'
  5. Click Run Current.

This snippet will simply replace the meta key that was used with the one that WooThumbs uses. After doing this, you may want to clear the WooThumbs image cache. Go to WooCommerce > WooThumbs and click Clear Image Cache.