Ever needed to move an Episerver Category under another?
I could not find a way to do this in the UI so I had to it the old-fashioned way of jumping straight to the database.
Warning: You’re not supposed to change data against CMS databases directly as you can easily break sh*t. If you’re in a dev environment and you know what you’re doing (and you better do), then go for it.
You can run the following SQL command against the database:
set fkParentID = 36 /*new parent category id*/
where pkID in (29,26) /*category ids to move*/
Once done, make sure to run an IISReset on your dev machine. This purges the in-memory cache of your application.