The only way to fix a non-working USB port is to replace the entire logic board. It would also cost a few hundred dollars or more and would have to be shipped to a service center.
Buying our new original USB-C DC power jack board connector is your best bet and will save you time and money!

-Identifying Numbers:
--APN: 923-10051,923-06760,923-10892,923-10062
--PPN: 821-04548-A
-Package:
--1 x A2991 DC in Power Jack
-Compatible Models:
--Compatible with MacBook Pro 16" Late 2023 A2991 (EMC 8408)
Late 2023 For MacBook Pro Retina 16-inch EMC 8408 MRW13LL/A
Late 2023 For MacBook Pro Retina 16-inch EMC 8408 MRW33LL/A
Late 2023 For MacBook Pro Retina 16-inch EMC 8408 MUW63LL/A
--Compatible with MacBook Pro 14" Late 2023 A2992 (EMC 8407)
Early 2023 For MacBook Pro Retina 14-inch EMC 8407 MRX33LL/A
--Compatible with MacBook Pro 14"16" 2023-2024 year A3403 A3186 A3112 A3401 A3185.
-Both of the Model "Axxxx" and EMC "xxxx " Number are located beneath the lower case of the laptop, please double check it to determine the compatibility.