OSCommerce Product Manager

The table configuration_group contains the metadata of the groups of configuration options.

We can load the id, title and maybe the description to populate the configuration interface. then we can load the configuration options from the configuration table.

From the configuration table we can load the following fields:
Title (a string containing the name of the option).
Description (a string containing the description of the option).
Key (a unique identifier string).
Value (a string with the current value of the option).
Group ID (the id of the group the option belong to).
Use function (a osCommerce PHP function associated with the option).
Set function (a osCommerce PHP function associated with the option).

We can build the user interface by creating a grid with the options, grouped by configuration group, with the current decoded value (not the raw value bit the the value returned by the Use Function).

Then the user can double-click an option and a dialog will appear. The dialog will show an edit field, a memo field, or a dropdown list to set the option. The dropdown list is only used if the Set Function is "tep_cfg_select_option". As the values of tep_cfg_select_option are included in the data field, we can just parse the field to find out the options and populate the dropdown list.

There are others possible functions used in the Set Function field, those can be parsed and retrieved server-side and then sent to the client application.