Recommended options to configure large number of choices under a variable in catalog item

[Parvathy B1]

There are scenarios that require more than 100 choices under a single variable in a catalog item without creating a custom table. Will creating too many choices create bad User experience and is there any limit to the choices that can be configured under a variable as per best practice?
Also, please suggest the recommended options to configure many choices under a variable in catalog item.

Thanks in advance!

[RaghavSh]

One solution could be, make the choice in "sys_choice" table and make your variable lookup selectbox.

The table name could be "sc_cat_item" and can have any unique element like "abc_your_item_name. In the lookup select box , select sys_choice as reference table and reference qualifier will be "element=abc_your_item_name".

This way you can make multiple choices, without creating custom table and incase any choice need to be changed in future you don't need to make any change to variable as it refers the sys_choice table.

Please mark the answer correct/helpful accordingly.