COPYING OVER WOOCOMMERCE PRODUCT CATEGORY IMAGES FROM A SOURCE TO TARGET SERVER
-
wp_posts
-
wp_postmeta
-
wp_termmeta
--- EXPORT the product cat image "post ids" (used for the rest of the import/) --- note: `meta_value` contains the wp_posts post IDs we will be using SELECT meta_value FROM wp_termmeta INNER JOIN wp_term_taxonomy ON wp_termmeta.term_id = wp_term_taxonomy.term_id WHERE wp_termmeta.meta_key LIKE 'thumbnail_id' AND wp_term_taxonomy.taxonomy LIKE 'product_cat';