<p>This could easily be accomplished with a MySQL query on your DB. Of course, <strong>BACK UP YOUR DATABASE FIRST</strong>!</p>

<p>Example, assuming the old category ID is 1 and the new one is 2... </p>

<pre><code>UPDATE `craft_relations` 
SET `target_id` = 2 
WHERE `field_id` = [your field id] AND `target_id` = 1;
</code></pre>

CC BY-SA 3.0
2016-09-26T10:01:52.020Z
This worked brilliantly thanks. Finally got round to doing it properly. Test on Dev server and be very methodical with no distractions for each time you do it.

There’s an advanced category manager plugin to be had here perhaps. Another day.
Simon Clayson
CC BY-SA 3.0
2016-03-03T17:16:22.933Z
2016-03-03T17:16:22.933Z
Ben Wilkins
<p>I’ve got 2 categories each with lots of entries. The client wants to delete one category, and transfer it’s entries into the other one.</p>

<p>If I delete the category, it just disappears, but I somehow need to mass assign all those entires into another category without going through each entry manually.</p>

<p>Any ideas welcome.</p>

<categories><merge>
How to merge/combine/transfer-entries-between two categories in the CP?
# How to merge/combine/transfer-entries-between two categories in the CP?

(Asked by: username_0 on 2016-03-03)

I’ve got 2 categories each with lots of entries. The client wants to delete one category, and transfer it’s entries into the other one.

If I delete the category, it just disappears, but I somehow need to mass assign all those entires into another category without going through each entry manually.

Any ideas welcome.

**Tags:** categories, merge


---

## 1 answers

### Answer by username_1 on 2016-03-03. Score: 2

This could easily be accomplished with a MySQL query on your DB. Of course, BACK UP YOUR DATABASE FIRST!
Example, assuming the old category ID is 1 and the new one is 2... 
UPDATE `craft_relations` 
SET `target_id` = 2 
WHERE `field_id` = [your field id] AND `target_id` = 1;

> **Comments:**
> **username_0**: This worked brilliantly thanks. Finally got round to doing it properly. Test on Dev server and be very methodical with no distractions for each time you do it.  There’s an advanced category manager plugin to be had here perhaps. Another day.  

---

