Technical Notes

Question: How are product options organized in the database?

Answer: They are stored as follows:

• Option groups are stored in the OptionGroups table (e.g. “Color”, “Size”, etc.).

• Option attributes are stored in the Options table (e.g. “Blue”, “Red”, “Small”, “Large”, etc.).

The relationship between option groups and attributes is defined in the optGrps table.

The products table contains the ID of the option group(s) assigned to those products, which is used to determine whether the product is using product options or not. The options_optionsGroups table holds details about the relationship between products and options assigned to them.