Metafields
Stores custom key–value data attached to Shopify resources, enabling extensibility across entities such as products or orders.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- Id supports the '=, IN' comparison operators.
- OwnerId supports the '=, IN' comparison operators.
- OwnerResource supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM Metafields WHERE Id = 'Val1'
SELECT * FROM Metafields WHERE OwnerId = 'Val1'
SELECT * FROM Metafields WHERE OwnerResource = 'product'
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 columns:
Namespace, Key, OwnerId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the metafield record. | |
| LegacyResourceId | Long | True |
The identifier for the corresponding metafield resource in the Shopify REST Admin API, maintained for backward compatibility. | |
| Namespace | String | True |
The logical grouping or container used to organize metafields, ensuring that custom metafields are distinct from those created by other apps or integrations. | |
| Key | String | True |
The specific name of the metafield within its namespace, defining what kind of information it stores. | |
| Value | String | True |
The actual data or content stored in the metafield, representing additional metadata about a resource. | |
| Type | String | True |
The data type of the metafield value, such as string, integer, or date. | |
| Description | String | True |
A descriptive summary explaining the purpose or meaning of the data stored in this metafield. | |
| DefinitionId | String | True |
The unique identifier of the metafield definition that governs this metafield's structure and validation rules, if applicable. | |
| OwnerId | String | True |
The unique identifier of the Shopify resource that this metafield is associated with, such as a product, order, or customer. | |
| OwnerResource | String | True |
The type of Shopify resource that this metafield is attached to, indicating where the metadata applies. The allowed values are product, variant, shop, draft_order, order, customer, collection, media_image, selling_plan, article, blog, page. | |
| CreatedAt | Datetime | True |
The date and time when the metafield was created in the store. | |
| UpdatedAt | Datetime | True |
The date and time when the metafield was last modified or updated. |