I got it now! Thank you so much. So now each row in the PRODUCTOPTIONS selects only one color to be associated with the PRODUCTS table. So if I need to choose say
Wefted hair | 12" | jet black | straight
I have to select 3 rows from the PRODUCTOPTIONS table to specify the above selection.
productOptionID | productID | optionID | optionGroupID | optionPriceIncrement
1 |1|1|1|0 here only color(jet black) is selected
20|1|20|2|0 here only size(12") is selected. OptionpriceIncrement is 0(price depends on size and 12" has the base price 200 which is listed in the product table)
26|1|26|3|1 here only style(straight) is selected.
For the inventory product stock, which is option dependent, how would you suggest its fields(columns) look like? so far I know that it must have inventoryID, and a foreign key to connect it to at least one table. which table? will the inventory table be only for the option-dependent products or for all products? after the creation of the inventory table, will eCart handle the webshop or there will be a need for major PHP coding?I think you know the problem I am facing.