Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1344
  • Last Modified:

Ecommerce database structure

I am building an online gift shop and need help deciding how to relate the shopping cart table to the orders table without alitteration.
Customers are not required to log in in order to add items to the shopping baske, but are required to log in or create an account in order to checkout.
here is the information:

ORDERS
-----------
orderid
customerid
orderitems
subtotal
shipmethod
shipcosts
ordertotal
orderdate
ordertrackingNo

SHOPPINGCART
------------------
cartid
customerid
product
quantity

Any suggestions on improvement would be greatly appreciated.

Thanks in advance
0
dotinfiniti
Asked:
dotinfiniti
2 Solutions
 
dportasCommented:
>> dotinfiniti: I am building an online gift shop
Obvious question: Why? There is an enormous number of pre-packaged solutions available to meet most requirements.

If you want to do this properly then I suggest you seek out the services of an experienced database designer. It's impossible for us to know your requirements just based on two lists of attributes.
0
 
Jinesh KamdarCommented:
I think the logical thing would be store the basket items in the SHOPPINGCART table until the user selects to check-out (not sure how to and if u want to keep the cart persistent thru multiple sessions). Once the user logs in and finalises the order, move the items to the ORDERS and ORDERLINES tables, which would hold the order details and delete them from the SHOPPINGCART table.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now