Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Database Design Question - Shopping Cart
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts

Posted - 29 March 2002 :  19:58:05  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Ok I am trying to build a shopping cart that i will allow people to use. I want to add it where they can have options like select a large, medium or small shirt. How should all of this be stored? I would like to find the best performance way. Here are some ways that I am thinking....

1. Store the items in a session array while the customer is browsing the site. when they checkout in the ORDERS table there is one column for the items they ordered which is inserted as a long string that is broke apart when viewing the order at a later date

2. When a users adds a item to a cart it creates them a unique id and is insert into a ShoppingUser table where the unique number, date, and other data. then another table called ShoppingTempItems. When an item is placed into a shopping cart it is inserted as one line in the ShoppingTempItems table which a reference number to their unique number that is in the ShoppingUser table. The unique number could be stored in a cookie or session for each user. Then when they check out a order is inserted into the ORDERS table and then each item would be inserted into a OrdersDeatiled table. This way all items could easy be available.

Do any of these sound like a good way to build it, or do you have another idea? Also has anyone built a ASP Shopping Cart before?

Brad
Web Hosting with SQL Server @ $24.95 per month

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 30 March 2002 :  03:54:55  Show Profile  Visit HuwR's Homepage
I would suggest you store them in a db not a session object, that why if your server dies or resets half way through someones shopping experience, they won't have to start again, so stick with 2)

Go to Top of Page

D3mon
Senior Member

United Kingdom
1685 Posts

Posted - 31 March 2002 :  19:20:12  Show Profile  Visit D3mon's Homepage
Allow me to shake you by the hand, redbrad0. You endure the same terror as I!
I'm currently wrestling/writing my own e-store and the database design aspect is making me tear my hear out - my minimal grasp of SQL isn't helping either!

Keep fighting on!
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 31 March 2002 :  21:45:21  Show Profile
Unless there is some functionality you just can't find in a prebuilt ecommerce solution, I wouldn't want to write one from scratch.



======
Doug G
======
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 31 March 2002 :  22:41:53  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
Definately store the items in the database. You can have the customers basket deleted after some amount of time if the customer doesn't return to finish the order.

Check out this basic cart: http://www.skepticfriends.org/download/010412.zip

It's super simple but has some nifty features like saving an order in case the customer wants order it regularly or see what they bought in the past.

@tomic

http://www.skepticfriends.org
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 01 April 2002 :  16:56:55  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
well thanks guys for your input.

I did write a e-commerce store a long time ago that i never finished. I think it had some great features. Check it out and tell me what you think..

http://www.exhibitparts.com

Brad
Web Hosting with SQL Server @ $24.95 per month
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07