How to move an Episerver category under another

Ever needed to move an Episerver Category under another?

Episerver Categories UI

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:

  update [dbo].[tblCategory]
  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.