Developer forum

Thanks Morten; I have a follow up question:

FieldOptionFieldId sometimes has a special structure ('ProductCategory|Reference_Bike|Wheel_size')  if it's part of a product category. In which table is this constructed? What are the 'rules' for this structure?

I'm asking because I want to import the list option values via an Excel template

The FieldOptionFieldId for a product category field is constructed like this...

ProductCategory|{category id}|{category field id}

where

{category id} = [EcomProductCategoryField].[FieldCategoryId] (references [EcomProductCategory].[CategoryId])
{category field id} = [EcomProductCategoryField].[FieldId]

So, in your example, "ProductCategory|Reference_Bike|Wheel_size", the "ProductCategory" part is just a prefix, the "Reference_Bike" part is the category id and the "Wheel_size" part is the category field id.

I hope this makes sense.

/Morten