Sorry to hear about that. You can submit a support ticket to get it fixed.
If you prefer fixing it yourself, you don’t really need to connect all 4 pins — assuming OTA firmware update works, the USB really just provides power, so you only need VIN (5V) and GND pins. It’s probably easier to solder wires onto the 1117 voltage regulator than the microUSB connector, since the connector’s pins are so close together. On the 1117 voltage regulator:
https://emmarobinsondit.files.wordpress.com/2015/01/ams117_er.png
solder the 5V wire to pin 3 (input) and GND wire to pin 1. You can cut open a USB cable, locate the 5V and GND wires (generally RED is 5V and BLACK is GND), then solder those to the two pins above. That should do it.