How can I export the corresponding option names for the option1, option2, and option3 fields of a Shopify product variant?

When creating a Data Settings for Product data, you'll see the following fields which will export the values of the different options:

  • variants.option1
  • variants.option2
  • variants.option2

The API doesn't provide dedicated fields that will return the name of each opiton, but we can use the formulas below in the Calculated Fields section of the Data Settings to figure them out:

Option1 Name

get_value_by_position(to_list({{ options.name }}), 1)

Option2 Name

get_value_by_position(to_list({{ options.name }}), 2)

Option3 Name

get_value_by_position(to_list({{ options.name }}), 3)

App: EZ Exporter

Tags: shopify products