Duplicate Tags, Different Slugs – Way to Merge?
Hello, this is kind of a random problem, and I’m wondering if there’s an easy fix.
My blog at cnyradio.com has over 1,700 tags. In reporting about local radio and television happenings, I have a small handful of categories, but I tag every single (1) personality, (2) station call sign, (3) station owner and (4) show title mentioned in each article.
Quite awhile ago, I somehow managed to get into a situation where certain tags got duplicated. For example, when I type “Clear” in the tag window, the autocomplete box lists two separate “Clear Channel Communications” tags.
They are spelled exactly the same way; I am not sure how or why WordPress managed to create a second tag. One is slugged clear-channel and the other is clear-channel-communications.
Obviously, I want ALL the articles in ONE tag. In the past, I’ve occasionally gone through my tag list and I have cleaned these up manually. Here are the steps I take:
- See which tag has fewer posts.
- Click on the number of posts, since this will open a list of all posts with that tag.
- Edit each post, one-by-one, removing the “wrong” tag and then adding the “right” tag.
- Update each post.
- Make sure the “wrong” tag now has zero posts.
- Delete the “wrong” tag.
While I’ve gone through this process a few times, it seems that every so often, I’ll spot another pair of “duplicate” tags.
Does anyone know of a plugin that can clean these up? I tried searching… as you might imagine, a search for “tags” or even “duplicate tags” brings up plenty of results, but so far, I haven’t seen anything that does this particular task. I’m not sure if I’m just not using the right search terms, or if such a plugin simply doesn’t exist. Hoping that maybe someone else who had a similar situation might know of an answer.
Sorry, I only read the title of your topic…
Because I saw today an extension called Simple Tag that allows you to merge tags.
Thanks for that!
Looks like it might do what I need, but it also says it hasn’t been updated in almost a year (last August). The FAQ tab says the latest version is compatible up to WordPress 3.3.2 but WP is now up to 3.4.1. Not sure if this plugin would still work.
I’m going to think about it for a bit. Maybe I’ll try it, maybe not. If I do try it, I’ll post an update in case anyone else out there would benefit from knowing if this worked.
Another option is to directly edit the database with a sql query and then delete the term, you can do it with one query. Of course, only if you know and are comfortable with sql and in a database backup, development environment, etc. 🙂
I had a feeling, but I’m not knowledgeable enough about SQL, nor comfortable enough to try following a tutorial, if there were one. I know one tiny mistake when messing with the database can cause some horrific results… and it’s not worth having to try to restore a backup over something that’s honestly not much more than a minor, occasional annoyance.
- The topic ‘Duplicate Tags, Different Slugs – Way to Merge?’ is closed to new replies.