variable options bulk import

[shivanib56]

I am trying to create a catalog item record in which there are nearly 400 + Variable options needs to be created. 

Is there a way I can do a bulk import of this data rather than creating each variable option manually.

If yes,what is it?

[Lakshmi888888]

Yes, you can bulk load variable options using Import Sets and Transform Maps.

The variable choices are stored in the Question Choice [question_choice] table. Create an Excel/CSV file containing the choice values (for example: Question, Value, Label, Order), load it using System Import Sets → Load Data, and transform the data into the question_choice table.

Typical columns include:

• Question (Variable Sys ID)
• Value
• Text/Label
• Order

If all 400+ options belong to the same Select Box or Multiple Choice variable, you can export the variable's sys_id once and populate it for every record in the import file.

Alternatively, if the list is generated from another table, consider using a Lookup Select Box instead of maintaining hundreds of static choices.

For one-time loads, many developers also use a background script to insert records into the question_choice table programmatically.

For 400+ options, Import Sets are usually the fastest and most maintainable approach.

Additional recommendation: If the choices are likely to change over time, create a custom table and use a Lookup Select Box or Reference variable rather than maintaining hundreds of static variable choices. This reduces future maintenance significantly.