I have been beating my head against the wall trying to add my downloadable ebooks to the product list.  I am new to Visual Web Developer.  I do know some VBA but I am not an expert.  I am following the code but I don't know how to get my downloable ebook into the product catalog.  I tried adding a field to the products table called "download".  I received all kinds of errors trying to do it this way.  I also tried creating a table called "Download" and creating a relationship with the ordersitem table.  That didn't work.

Essentially what I would like to do is allow a user to download their ebook after they have completed their purchase and their payment has been validated.  I have several ebooks and it appears that this is where I am running into problems.  Any help would be appreciated.

Hi vipichi,

There are probably many ways to do this but I guess you want to keep it as simple as possible. Here is one way to do it. Each E-book has an orderID and that orderID goes into the order DB when someone heads to PP. Once they return etc and the IPN validates their payment you can allow them to download it by making it a link in there account orders page (if you have one). Usually a customer can login and see what they have ordered and click on the order link to reveal the product - instead of viewing it they could download it. You provide security for your Ebooks this way due to the fact that the ebook will only download if the link is from the orders page. That stops anyone getting the link and downloading the book. The order can perish after a period of time or number of downloads. Confused? let me know if that makes any sense.

Cheers,

Mark

---

Ultima Hosts

Virtual Private Servers from $49 / mth

Dot Net Panel Hosters

Developer Friendly Hosting