Merge posts from the same author

You could probably do a complicated SQL statement but what would you do with the originals?

If you combine all posts into one huge post, then there will be several questions:
– Which one of the post titles should you keep?
– Which URL should you keep?
– Which post’s image should you keep?
– Are you going to keep all the individual posts, too? In that case you’re going to have duplicated content on your site, something that Google may not like?
… and so on.

So what’s your use case?
Why isn’t the built in “Author” archive page sufficient for your needs?

Hello, thank you @tobifjellner and @joyously for your prompt reply. I want to delete the originals and keep the merged files with the author’s first post’s title, url, and image. But I still want it to have all the other post’s data, categories, and tags. Is it possible.
Thank you very much for your help.

• This reply was modified 4 years ago by yhazem.

There are no files with the content. There are database entries containing the content.

You could use a plugin to export the posts to a CSV format, then edit them in a spreadsheet. Once they look like you prefer, delete originals and import the changed ones. If you do it this way, practice on a sandbox, like https://wpsandbox.net/
Definitely make a backup before you start.

@joyously I want to make it automated, so is there a possible code to make so when an author creates a new post it automatically merges with the current one.

Hey there! Here are a few resources that may help in your search for a solution:
1. https://github.com/ibotty/wp-post-merge
2. https://wptavern.com/duplicate-and-merge-posts-a-new-editorial-plugin-for-wordpress-publishers

ok @sarmstead , thanks a lot for your help.

All the best, @yhazem!