Metafields

Retrieves a list of metafields that belong to one or many resource IDs.

Table-Specific Information

OwnerResource or the metafield Id is required for any query against Metafields.

OwnerResource must be one of the following values:

shop
draft_order
product
variant
page
article
order
customer
collection
blog
product_image

Any other value will run the query against "shop" instead.

Select

The add-in uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.

Id supports the '=,IN' comparison operators.
OwnerId supports the '=,IN' comparison operators.
OwnerResource supports the '=,IN' comparison operators.

OwnerResource is a required column, and eligible values include "product","variant","shop","draft_order","order","customer","collection".

For example, the following queries are processed server side:

	SELECT * FROM Metafields WHERE OwnerResource = 'product'
	SELECT * FROM Metafields WHERE OwnerResource = 'product' AND Id = 'gid://shopify/Metafield/19334473318423'
	SELECT * FROM Metafields WHERE OwnerId = 'gid://shopify/ProductVariant/39378393497623' AND OwnerResource = 'variant'
	SELECT * FROM Metafields WHERE OwnerId IN ('gid://shopify/ProductVariant/39378393497623', 'gid://shopify/Product/1418248224791') AND OwnerResource = 'variant'

Insert

The following columns can be used to create a new record:

Namespace, Key, Value, Type, OwnerId

Delete

You can delete entries by specifying the following column:

Columns