My advice-

Get some favorite treats out and some gentle noise makers, such as bells, etc.

Try to get him to associate rewards with these sounds.

Especially when the door bell goes off, find him and leave him a treat, before tending to the door.

Best of luck