Hi, this post is directed at Giles and/or other DNN programmers who are able to comment on my questions.

I have been attempting to make changes to my local DNN store application. (using VS2008 and SQL Express 2008)
Thanks to Giles in previous posts who assisted me in getting the development environment up and running.

I am looking to impliment downloadable media using the store. The core store suits my purposes well apart from the need to add various new fields to the products / orders tables. (I done the exact same changes with "Commerse Starter Kit" some years ago)

OK this is my issue: I am having no success in adding new fields to the Products table for example. Lets say i want an additional new field "IsDownload" (bit) I can happily add this field to the table, then alter the select stored proc to suit... fine, However when i follow the code through to the create and updates, there are functions that are littered all over the place and i have to say i am now totally lost as to how to make changes to the store.

Q: is there a particlar methodology to adding new fields?
Is there a "script" that regenerates the \Store\Catalog\Providers\DataProviders\SqlDataProvider\SqlDataProvider.cs code ? as well.
These are general "why and how" questions... so,
What general advise can someone give me to get me started on progmatically changing this store?

I believe i am quite competent in conventional .net n-tier coding, however the sheer extent of the store code has got me stuck.

Thanks you guys for any advise or help !

Hi Maximus,
first: read and understand “DotNetNuke Data Access” from dnn documentation.
Next steps:

1. Edit ProductInfo object (project Catalog)
2. Edit DataProvider
3. Edit SqlDataProvider
4. Edit sql stuff: stored procedures and tables

I hope this “general” advice helps you...

This is (I think) what I would like to do with the store module as well; sell original music mp3's using the store and then allowing download of the selected song.  Unlike the above individual, I am not a good programmer and wondered if there is a way using dnn store module to list mp3's in the store, allow customers to select buy now, proceed to checkout using paypal then make the file avaliable for download.  I've got the store up and running but don't know where to go from checkout via paypal.  Can anyone help?

Thanks,

jlbuchan