I imported a few hundred products with Shopmaster. All the images that were imported with the products are unattached. I want to use Media File Renamer to rename the images to the post title but it doesn't work because the images aren't attached for some reason. I have spent all day trying to figure this out but I'm at a loss. Any ideas? thanks
i have found that this code in SQL attaches the featured image of all the posts, but not the rest. any ideas to update it would be great.
UPDATE wp_posts AS p
INNER JOIN (
SELECT p.ID AS attachment_id, pm.post_id AS post_id
FROM wp_posts p
JOIN wp_postmeta pm
ON pm.meta_value = p.ID
WHERE (
pm.meta_key = '_thumbnail_id'
AND
p.post_type = 'attachment'
AND
p.post_parent = 0
)
) AS b ON p.ID = b.attachment_id
SET p.post_parent = b.post_id