Hey Y'all,
I work for a small business that does most of our business online. We only
offer a product a month (usually) and these promotions are time sensitive
(people are only eligible to order at certain times based on past
participation) Currently we use an .ASP order form, the client fills out all
the information (contact info/Shipping, CC, etc) every promotion and then hits
a submit button to a SQL Server Database. We then export the SQL server table
and import it to a MS Access Database, then manually cancel orders placed at
the wrong time, and then go through and assign a customer ID to each order so
that we can keep track of who ordered what, has paid, shipped etc. This has a
few pros, its easy to maintain, and simple to use. However the cons outweigh
the pros, its slow, manual work causes errors, and before each promotion I get
a thousand phone calls asking how many times that client has participated
before.

I would like to migrate this database to be entirely online, the client would
login, be shown a summary of their past participation, have a credit card on
file and be able to order the product if it is the right time. And then place
the order without any other work than that. I call it the three click system,

Click 1: Login
Click 2: Buy
Click 3: Confirm

So here is my problem, I need a user system database, a shopping cart system,
and I would like it to work with SQL Server. Does anyone know of a canned
system that will meet my needs above, or do I have to develop it all myself (or
a database guy cause I still dont know all of that stuff) ? Any thoughts or
suggestions would be usefull

-Adam