Map Shopify item metafields at the variant level using NetSuite saved search

Gogula R Bhavana

Updated September 16, 2024 18:56

Metafields allows you to store additional information for the item’s variants. You can use metafields to add custom fields to objects such as products, customers, and orders. Using the saved search option in NetSuite you can create and update the metafields at the variant level in Shopify, from the data or value provided in the NetSuite child matrix item field. A metafield in Shopify consists of a namespace, a key, a value, and a description (optional).

Note

Notes:

This approach is recommended only if a meta field value cannot be written directly from a single custom field. Example : If a single metafield is sourcing from two custom fields or formulas.>
Celigo supports all Shopify metafields except list types and metaobjects.

For more information about metafields and their different parts, refer to Metafields .

In NetSuite, you can create and update metafields using the appropriate saved search. Create or choose the standard or custom field(s) in NetSuite that you would like to map to a corresponding metafield in Shopify. Use the saved search in NetSuite that is being used for exporting Items from NetSuite to Shopify. If you are using the saved search that comes from the bundle, the name of the search should start like "Celigo Shopify Matrix Item Export [your store name]".

Create metafields using a saved search

The Integration App enables you to map the NetSuite standard or custom fields to Shopify metafields (if they already exist) and/or also create the metafields in Shopify directly via the Integration App and then map and update them.

In NetSuite, search for the appropriate saved search.

Example : In this instance, “ Celigo Shopify Matrix Item Export [US Store] ”.
On the “Celigo Shopify Matrix Item Export [US Store]: Results“ page, click Edit this Search .
Click Results .

Note
Note: Assuming that the required custom fields are already created and values are specified. To create new custom fields, refer to the Custom Fields section in the NetSuite Help.
In order to map a NetSuite field to a corresponding Shopify metafield, you need to add an additional row by choosing the desired NetSuite field from the dropdown. In the Field column, search for a relevant custom field and click Add .
In the Custom Label column, enter the details in the following format:
- <Namespace>:<key>:value (Variant Meta)
- <Namespace>:<key>:description (Variant Meta)
  Note
  Notes:
  
  Enter the actual Namespace and key in the above format.
  
  Namespace, Key, and value or description are colon separated
  
  Important : The label name must be suffixed with (Variant Meta) to be identified as a metafield by the Integration App (see image below).
Click Save .

Create metafields

The scenario is to create metafields that provide additional details about a mobile phone. The Camera Details and Dual Camera Details fields are custom fields created in NetSuite for the Mobile matrix item. In the NetSuite saved search, provide the Field and Custom Label values as shown in the table below:

Field

Custom Label

Custom Field Values

Camera Details (Custom)

Mobile Details:Camera:value

(Variant Meta)

48 MP + 16 MP + 8 MP Triple Primary Cameras

Dual Camera Details (Custom)

Mobile Details:Camera:description (Variant Meta)

16 MP Front Camera and Dual LED Flash

In the Shopify - NetSuite Integration App, in the Product - Advanced Settings section, provide the settings as follows:

Note : Ensure that you “do not” specify the Namsespace, Key, or Field IDs in the Specify your Shopify metafields’ components section.

After you run the “NetSuite Matrix Item to Shopify Product Add/Update” flow, the field mapping variants[*].metafields (Export Field - NetSuite) - product.variants[*].metafields (Import Field) generates the variants and their metafields as below. The Integration App automatically sets the value type as “integer” and “string” based on the value provided in NetSuite fields. As metafields are not available directly on the Shopify store’s user interface, refer to Support product metafields at variant level .