database setup where price depends on size and color,style are options.
Hi Jason, I read one of your answers about product options but it seems it did not apply to my problem. My setup is as follows:
in the PRODUCT table I have products whose price depends on the size.I have three catagory products. WEFTED HAIR, PREBONDED HAIR and WIGS. Below I have listed the details. All product categories have different colors and different styles. So in the detail page I have three dropdown lists where the customer choose the product size, product color and product style.
How do you setup the database for such products in the OPTIONS table, OptionGroup and ProductOptions? Should I disregard the OPTIONS,OPTIONGROUP and PRODUCTOPTIONS table and just setup only Product table to simplify?
I have tried with all products in 20 inch size as one products but I could not keep track the ProductStock,color and style.
I am really stuck with this and appreciate a guidance on this.
The WEFTED HAIR, PREBONDED HAIR and WIGS all have the same data structure.I have attached the structure of the product table.