Syncing Variant Metafields on a Non-Matrix item

Integration Apps
, ,
1

Hey all,

Is there a way, outside of the fields in the settings, to sync metafields to a simple product (no variants) as variant metafields on the product in Shopify? We are using the Netsuite to Shopify connector.

We can include variant metafields in the saved search for matrix items and those work just fine. We can include parent product metafields in the simple item saved search and those sync just fine. But it does not seem to work when you try adding variant metafields in the saved search for a simple item.

We use the settings for several things and they work great over the saved search but you cannot create calculated values to return in that spot, only direct referencing fields works.

We have conditional values in saved searches that we would need to sync as variant metafields in Shopify, but on simple items and it doesn't seem that the IA is set up to pick those up in the simple item flow.

Any insight or direction is appreciated on how we can get calculated/conditional field values set as variant metafields on our products is appreciated.

2

Hello Craig,

At this time, variant-level metafields for Simple Items can only be synced using the standard metafield sync settings available in the Shopify-NetSuite Integration App. We currently have an enhancement request to provide more flexibility in this area, but there is no estimated timeline for when it will be implemented.

One limitation of the current configuration is that the "Sync as variant metafield for simple item" option in the Celigo Settings UI only accepts direct field references. As a result, it cannot evaluate conditional logic, expressions, or NetSuite formulas directly within the mapping.

As a workaround, instead of calculating the conditional value in the saved search, you can have NetSuite calculate the value on the item record itself and then expose that field to Celigo.

Recommended approach:

  1. Create a custom item field in NetSuite (for example, custitem_calc_meta_holder).
  2. Under the Validation & Defaulting tab, uncheck Store Value.
  3. Place your conditional formula in the Default Value formula field. NetSuite will then calculate the value dynamically whenever the item record is queried.
  4. In the Integration App settings, navigate to Product Settings and configure the variant metafield mapping.
  5. Enable Sync as variant metafield for simple item and map the newly created custom field directly.

This approach allows NetSuite to handle the calculation while Celigo simply reads the resulting value from the custom field and syncs it as a variant metafield.

I hope this helps. Thanks!