Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Ecommerce Problem

    Morning

    I currently manage a rather large web based commerce site selling items of clothing.

    Currently we have 'Products' and 'Product Options'. Products maybe something like 'Stripey Sweater', and each product option would be colour. Each colour has its own barcode.

    We're looking at adding sizes to the site. 'Stripey Sweater - Blue - Small' would really need to be a different product option to 'Stripey Sweater - Blue - Large'. However ideally I'd need to tie the two together.

    I have a few ideas floating around my head, but was just wondering whether anybody could give me some alternatives or suggestions?

    Thanks
    Jay

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    size would be another product option
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Posts
    9
    Yes I know, however I need a mechanism to say they're related somehow. Then the user can select a size from a dropdown box. I could either use a pigear approach or a linking table.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Jay1b View Post
    I need a mechanism to say they're related somehow.
    product_id should do nicely
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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