How to Merge Comments from more than 2 Topics into a Single one?

I’d imagine you can just update the post ID assigned to the relevant comments, so they belong to the post you’re keeping.

I can write the query for you, but i’ll need to know the post ID the comments need to be moved to, and the post IDs for the posts that they currently belong to.

^^ Thanks.

The 2 topics which I want to delete have IDs as following:

2935 and 2506

The topic ID which I want to keep:

1304

Assuming you’ll run this in phpmyadmin or similar, and you’re using wp_ as the prefix for your tables.

UPDATE wp_comments SET comment_post_ID = 1304 WHERE comment_post_ID IN (2935,2506)

Please do backup beforehand.

^^ Thanks. The query worked without any problem.

But! The main topic which now contains all comments, still shows the old comment count. I mean previously, the total comments were 81 in the main topic but now it contains approx. 300 comments after merging other topic comments but it still shows 81 as total comments.

How to update the comment count?

Run this to get the comment count.

SELECT COUNT(comment_post_ID) FROM wp_comments WHERE comment_post_ID = 1304 AND comment_approved = 1

That should give you the new total, jot it down or remember the total, then run this..

UPDATE wp_posts SET comment_count = XX WHERE ID = 1304

Replace XX with the total you got from the first query.

Hope that helps, again backup beforehand, just incase.. ??

Awesome. Thank you so much mate. Worked like a charm. ??

You’re welcome.. ??