Product is a remotely hosted video- how to send a link to it once order has processed

Exactly that

The product is a video hosted elsewhere, all i want to do is be able to "sell" it and provide the link to it, the link is pretty much always going to the same anyway, just really basic for now.

Any help appreciated

You can use products_url of products_description table, enter your video URL and send it when order processed.

The product url is displayed on the product page, so that probably wouldn't work unless I am missing something, and i would like it to be automatic once the order has processed

OK Figured it out

This works for me as the link doesn't change and there is no security on it

I just created a product with a downloadable attribute, added the url as the file.

Then i edited the /includes/templates/my_template/templates/tpl_modules_donload.php (I think)

Found the section that creates the download button and added a condition to check if the url has http in it and if so create a button that takes the customer there