Results 1 to 13 of 13

Thread: online shop

  1. #1
    Join Date
    Jun 2011
    Posts
    2

    online shop

    I want to develop online computer shop website.in which a number of products(computer,its parts) are available to purchase.but i am confuse to design database and its table.which is the best one strategy?
    1. Store all products in one table
      Store administrator and customer members in one table.

    1. store desktop and laptop computers in one table and mouse,printer etc are stored in another table
      store administrator and customer in different tables
    Last edited by Waseempki; 06-10-11 at 00:57.

  2. #2
    Join Date
    Jun 2011
    Posts
    40
    If you are confused on how to design your database, then you would do well to use one of the many open source webshops available, or even a paid solution if that takes your fancy.

  3. #3
    Join Date
    Jun 2011
    Posts
    2

    Can you give me suggestion?

    I want to do myself.I does not use existing one.Can you give me suggestion?

  4. #4
    Join Date
    Jun 2011
    Posts
    40
    I would still suggest that you LOOK at a few open source solutions as they will best show you ways to do it.

    Product databases can be extremely complex and I have yet to work with an eCommerce solution that uses a single table for products.

    Lets say for example you have a graphics card for sale, but that card comes with several memory options. How are you going to handle that? Or you have a mouse, but that comes in several different colors... and so on...

    For me, the best way to handle these kind of options is to have sub-products, a solution I created in 2003 and now used by Google, Mozilla and many others.

  5. #5
    Join Date
    Apr 2010
    Location
    London, England
    Posts
    24
    Hi

    I suggest you use an online Database supplier to try to build your own - it will help you clarify your thinking about your design options.

    Zoho used to offer something suitable that I think they are now calling Zoho Creator :-
    https://www.zoho.com/creator/

    If that doesn't work out I have listed a page of other choices on jy Database Answers Web Site :-
    Online Databases

    I would be interested in knowing how you egt on ;-0)

    HTH

    Barry Williams
    London, England

  6. #6
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by Waseempki View Post
    I want to do myself.I does not use existing one.
    Why?

    (this message is too short for some reason)

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by Waseempki View Post
    I want to develop online computer shop website.in which a number of products(computer,its parts) are available to purchase.but i am confuse to design database and its table.which is the best one strategy?
    1. Store all products in one table
      Store administrator and customer members in one table.

    1. store desktop and laptop computers in one table and mouse,printer etc are stored in another table
      store administrator and customer in different tables
    Of these two options, the first is much preferable to the second.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Jun 2011
    Posts
    40
    Quote Originally Posted by blindman View Post
    Of these two options, the first is much preferable to the second.
    Oh yes, a single table full of NULLs.

    I have yet to see one eCommerce platform where it would be either possible or practical to store all product data in a single table. It just could never work unless possibly you are selling a single product. Certainly not with computers and computer parts.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Look up "Recursion".
    Either an Adjacency model or Celko's Nested Set Model will be robust and efficient.

    And by the way Backslider, where are teh codez?
    http://www.dbforums.com/database-con...ml#post6506999
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Jun 2011
    Posts
    40
    Quote Originally Posted by blindman View Post
    Look up "Recursion".
    Either an Adjacency model or Celko's Nested Set Model will be robust and efficient.
    Yes, these are both good techniques for handling product categories, but not product data. Looks like we need more tables.

    Quote Originally Posted by blindman View Post
    And by the way Backslider, where are teh codez?
    http://www.dbforums.com/database-con...ml#post6506999
    I didn't see your currencies table......

  11. #11
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Teh CODEZ, Backslider, teh CODEZ! We needz thm! LOL!
    http://www.dbforums.com/database-con...ml#post6506999
    Plz 2 share ur gr8t solushin w us?
    ROFLMAO
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  12. #12
    Join Date
    Jun 2011
    Posts
    40
    Quote Originally Posted by blindman View Post
    Teh CODEZ, Backslider, teh CODEZ! We needz thm! LOL!
    http://www.dbforums.com/database-con...ml#post6506999
    Plz 2 share ur gr8t solushin w us?
    ROFLMAO
    Well gee, lets stay on topic and perhaps you can show our friend your great single table eCommerce solution?

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    No idea what you are talking about.
    Where did I claim to have a great single table eCommerce solution?
    Are you resorting to making stuff up now?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •