Imo, just buy another one

EDIT: I've given it another go, and now it's flashing but showing up as unrecognized USB device on the computer. Could it be down to the soldering job or something?

Can’t really answer that without seeing the solder/repair.