<p>I think that, right now, the only way to deal with that is at the DB level. I believe you would only have to deal with the <code>craft_relations</code> table for adding / removing categories to entries.</p>

CC BY-SA 4.0
2022-02-28T10:14:14.113Z
It is now nearly 8 years since this question was asked, and I ended up here because I have the same question. Is this _still_ not possible to do somehow? I mean, it feels almost a bit rudimentary to be perfectly honest.
InanisAtheos
CC BY-SA 3.0
2014-07-30T21:10:29.410Z
Looking through the sql dump this doesn't seem too bad! I'd love to see something more elegant. I'll wait a bit and see if anything pops up before I accept.
Bill Criswell
CC BY-SA 3.0
2014-07-31T13:21:56.283Z
You could build a plugin to do it but I think that, in the use case you describe, SQL queries would be the easiest
Jérôme Coupé
CC BY-SA 3.0
2014-07-31T13:59:47.513Z
Agreed. My issue is definitely taken care of. I'm also trying to think about it for the long run, though. I have no problem editing a SQL dump but a client would poop their pants!
Bill Criswell
CC BY-SA 3.0
2014-07-30T19:23:08.933Z
2014-07-30T19:23:08.933Z
Jérôme Coupé
<p>I just accidentally dragged a root category onto another. Now, all of the entries that were assigned to that category are assigned to the one I accidentally dragged it onto. </p>

<p>Luckily, I have like 7 entries but if this happened with a lot of them I'd be pretty screwed. It seems like a disaster waiting to happen.</p>

<p>Is there an easy way to "bulk assign" categories? If that's not possible is there anyway to add a "Save" button to the category manager so I'd have to click save before the database actually updates? Am I overlooking something really, really obvious here? Definitely wouldn't be the first time.</p>

<categories><admin>
Assign entries to categories in bulk?
# Assign entries to categories in bulk?

(Asked by: username_0 on 2014-07-30)

I just accidentally dragged a root category onto another. Now, all of the entries that were assigned to that category are assigned to the one I accidentally dragged it onto.

Luckily, I have like 7 entries but if this happened with a lot of them I'd be pretty screwed. It seems like a disaster waiting to happen.

Is there an easy way to "bulk assign" categories? If that's not possible is there anyway to add a "Save" button to the category manager so I'd have to click save before the database actually updates? Am I overlooking something really, really obvious here? Definitely wouldn't be the first time.

**Tags:** categories, admin

---

## 1 answers

### Answer by username_1 on 2014-07-30. Score: 2 | Accepted answer

I think that, right now, the only way to deal with that is at the DB level. I believe you would only have to deal with the `craft_relations` table for adding / removing categories to entries.

> **Comments:**
> **username_0**: Looking through the sql dump this doesn't seem too bad! I'd love to see something more elegant. I'll wait a bit and see if anything pops up before I accept.  
> **username_1**: You could build a plugin to do it but I think that, in the use case you describe, SQL queries would be the easiest  
> **username_0**: Agreed. My issue is definitely taken care of. I'm also trying to think about it for the long run, though. I have no problem editing a SQL dump but a client would poop their pants!  
> **username_2**: It is now nearly 8 years since this question was asked, and I ended up here because I have the same question. Is this _still_ not possible to do somehow? I mean, it feels almost a bit rudimentary to be perfectly honest.  

---

