Simple SQL Script For Ecommerce

We have an ecommerce system at [login to view URL], and we want an automated way to add a "variant" to our products... in the admin control panel you can add variants, which are like, ... if you have a VHS tape, you can add also a DVD type variant without creating a new product for the DVD.. it's just an extra option for the customer to choose. An example is on this page: <[login to view URL]> .. as you can see, at the bottom there is a variant to either buy a downloaded CD, or purchase a physical copy of our CD. In the admin we have to go through every tutorial that we sell and add a new variant if we want to add additions, like tutorial packs, compilations, etc..., which would take us many hours.. so we wanted a simple SQL script to be able to take in a product "category", like "C++", then go through all the C++ tutorials and add a variant that has the Title, specifies whether its a downloadable product or not, the download file if so, and the price. All the other data for the variant would be default. We would just have you connect to our database and see which fields need to be there to create a new variant... but that is what we want. It should be pretty simple. We use SQL 2000 on [login to view URL] as our webhost. Let me know what you think! You might have a better idea on how to do it. Thanks! ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform SQL2000 Windows