Variant Metafields on Non-Matrix Products

[craigscott]

Not-matrix products in Shopify have variant metafields, even though there are no 'variants' because it technically works off a default variant id.

In the matrix saved search from Netsuite to Shopify we can easily use the format shown here.

When trying to do that same thing in our non-matrix flow it does not work. We also know that we can specify our metafield components in the settings for the product flow and this would map data to a variant metafield, but this only works if you are using a normal Netsuite field not a custom field.

We have a custom field for inventory status and it looks at a list for the value. When mapping to Celigo using the specify metafield components setting we end up just getting the internal id of the field value, so 1, 2, 3 etc, not the actual value.

Is there a way to either get the non-matrix flow/saved search to recognize the variant metafield based on the link above (like it does in the matrix flow) OR get the actual value from the custom netsuite field and not just the internal id of the item on the list?

Hopefully all that makes sense.

[michaelsmith]

can you share the format you have your variant setup as in the saved search? And also can you share how you have it configured in the settings section, including the check box drop down like this:

[craigscott]

Yeah we have set it to the one in your image. Variant metafields for simple item. But because the custom field is what we are pulling in, and that custom field is an option from a list, it is just pulling in the list id, which is just the index position. Here is how it is in the saved search, which I don't think even matters if we are adding it in the way that you are showing in the screenshot?

In the screenshot you posted we had it set

namespace: details
key: ns_inventory_status
Value: this was blank for one try, and for another try we set it to the field id in netsuite. first try nothing happened. Second try it just mapped the list id like I mentioned above.