So, I wandered into Riften for the first time in ages to discover no Balimund anywhere. By teleporting to him, I found him in some kind of hall of the dead place when I teleported to him (I have no idea how/when he died, he was alive last I saw him).
I managed to bring him back using the placeatme console comand, but he no longer operates as a vendor. I can talk to him and get the general chitchat options, but nothing for sale.
Is there any way to reset this using the console? I like Riften a lot, but it seems fairly useless without a blacksmith.

The placeatme command is not recommended for named NPCs


http://www.uesp.net/wiki/Skyrim:Console

If a named NPC has died, the only way I know to get them back and fully functional is to find them and use resurrect. It may also be necessary to use enable but honestly I can't remember the correct procedure... I only had to do it once. Someone else here will know exactly what to do though.

Placeatme makes a copy of a character, so that's not the real Balimund.

You could try loading up an older save use the console to select him, go to Riften then use the command moveto player. After that try resurrect 1 on him.
You may also need to kill some thieves in his basemant, if that's why he died.

Could it have been thieves in his basemant? He was alive and well the last time I was in Riften (which was a ways back) and when I returned he was gone, no body.
I think I tried the moveto command, but it only worked to move me to him walking around inside the hall of the dead. If I use moveto player and his Base ID I don't think it worked. I'll give it another try incase.

I wish I can make a copy of my self so my clone can do all of my deeds while I'm sitting back and drinking some of the finest mead in Skyrim

The normal moveto should move you to him, but once at him you can target him for the moveto player command for after you go to where ever you want him to spawn. The thing is never use placeatme, because it creates a copy of whatever you are trying to generate. Also, if you resurrect something, it is thought to not work that simply, and using resurrect 1 is better for making the game believe it's the original thing. The '1' being the important thing to add.

Lyn1964 posted while I was still posting, and I think her post would be more useful to you, since it has how to use the command with prid. Without seeing him die, you won't know what killed him, but it's known that entering Riften often prompts the random encounter of generic thief sneaking around. Sometimes the guards don't kill them because they hide in buildings and a favorite spot is the Blacksmith's basemant. Theives will fight back if they are attacked, but not sure if they will attack unprovoked.

Perhaps relevant - I found three thieves hiding in the Pawned Prawn one time. I just walked in and they were there. They didn't attack the couple living there, they just ran away from me. I killed them all and none of them ever attacked.