My question is how do I get ubercart to grant a download after the
order status changes from pending to payment received?
1. Ubercart conditional action (Notify customer when a file is granted) will send e-mail to customer with a link to download file. 2. Like you said Go to My account > file tab and download the file