Variable Sets - Table of fields

[AN2023]

Hi there,

Can anyone tell me what table has the variable field in the "Variables" tab in a variable set?

I've already found the tables for:

 - the "Included in" tab = Catalog Variable Set [io_set_item]

 - the List of Variable Sets = Catalog Items and Variable Sets [st_sys_catalog_items_and_variable_sets]

Thanks, Audrey

[AshishKM · Accepted solution]

Hi @AN2023, 

The catalog item variables and variable ( from Variable Set ) both are saved in same table ( item_option_new ).

There is Variable set column, which is empty for catalog item variables and filled with variable set name for variable set's variables.

-Thanks,
AshishKM

[AshishKM · Accepted solution]

Hi @AN2023, 

The catalog item variables and variable ( from Variable Set ) both are saved in same table ( item_option_new ).

There is Variable set column, which is empty for catalog item variables and filled with variable set name for variable set's variables.

-Thanks,
AshishKM

[AN2023 · Accepted solution]

Thanks Ashish... I didn't think to look back in the same table... that really helps 🙂 Audrey