ProductVariantEvents
Logs lifecycle events for product variants, such as creation, updates, and inventory changes.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- HostId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ProductVariantEvents WHERE HostId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the product variant event record. | |
| HostId | String | The unique identifier of the shop or environment where the product variant event occurred. | |
| AppTitle | String | The name of the app or integration that generated the event. | |
| AttributeToApp | Bool | Indicates whether the event originated from an installed app rather than a manual admin action. | |
| AttributeToUser | Bool | Indicates whether the event was triggered by an admin user performing an action on a product variant. | |
| CreatedAt | Datetime | The date and time when the product variant event was created and logged in Shopify. | |
| CriticalAlert | Bool | Specifies whether the event is considered critical, signaling a potentially important or time-sensitive change. | |
| Action | String | Describes the type of action that occurred on the variant, such as 'created', 'updated', 'deleted', or 'restocked'. | |
| Message | String | A human-readable summary of the event that describes the change made to the product variant. | |
| BasicEventSubjectId | String | The unique identifier of the product variant or related resource that triggered this event. | |
| BasicEventSubjectType | String | Specifies the type of resource associated with the event, such as 'ProductVariant'. | |
| BasicEventHasAdditionalContent | Bool | Indicates whether this event contains additional data or extended details for display in a timeline. | |
| BasicEventAdditionalContent | String | Provides supplementary descriptive information for timeline or activity log displays. | |
| BasicEventAdditionalData | String | Holds structured data or metadata that gives context for event consumers and integrations. | |
| BasicEventSecondaryMessage | String | A supporting human-readable message providing extra context for the main event description. | |
| BasicEventArguments | String | Lists parameters or related identifiers that provide context for the event's subject and its resources. | |
| CommentEventAuthorId | String | The identifier of the staff member who created a comment associated with this event. | |
| CommentEventCanDelete | Bool | Indicates whether the comment event can be deleted by authorized users. | |
| CommentEventCanEdit | Bool | Indicates whether the comment event can be edited after creation. | |
| CommentEventEdited | Bool | Specifies whether the comment event has been modified since it was first created. | |
| CommentEventRawMessage | String | The raw, unformatted text of the comment event before it is processed or displayed. | |
| CommentEventSubjectId | String | The identifier of the parent resource associated with this comment event, such as a product variant. | |
| CommentEventSubjectHasTimelineComment | Bool | Indicates whether the parent resource's timeline contains a comment event. | |
| CommentEventEmbedCustomerId | String | References a related customer record linked to the comment event, if applicable. | |
| CommentEventEmbedDraftOrderId | String | References a related draft order associated with the comment event. | |
| CommentEventEmbedOrderId | String | References the related order associated with the comment event. | |
| CommentEventEmbedProductId | String | References the related product record linked to this comment event. | |
| CommentEventEmbedProductVariantId | String | References the specific product variant associated with this comment event. |