Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Red face Unanswered: Database structure for CMS


    I am making a CMS system for an e-shop.
    The goal is client would be able to manage their own catalogue including categories and products.
    I don't have any problem creating categories that has many products.
    But I cant think of how to allow user configure their own product's attributes.
    For example: a fashion store has color and size for their product, while others don't.

    How to make the structure without duplicating the item record? all i can think of is having several records of the items with same name, price, summary, description but with different color and size (color and size column is customized, so may not be there also).

    I hope everyone can understand what I'm trying to explain.
    Please help me. Many thanks in advance.

  2. #2
    Join Date
    Oct 2009


Posting Permissions

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