Announcement:Materials and articles for ProductCart 5 can be found at our brand new support center.

Create an account to edit articles | See Formatting Syntax for Wiki syntax | We look forward to your contribution!

Technical Notes

Product Options: database structure

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.

QR Code
QR Code Technical Notes (generated for current page)