PublicationProducts
Lists products published to specific channels or publications.
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.
- ProductId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM PublicationProducts WHERE ProductId = 'Val1'
Columns
| Name | Type | References | Description |
| ProductId [KEY] | String |
Products.Id | The globally unique identifier of the product associated with this publication record. |
| PublishDate | Datetime | The date and time when the product was or is scheduled to be published to the specified publication channel. | |
| IsPublished | Bool | Indicates whether the product is currently published and visible on the associated publication channel. | |
| PublicationId [KEY] | String | The globally unique identifier of the publication, such as an Online Store, Point of Sale, or custom sales channel. | |
| PublicationName | String | The display name of the publication channel to which the product is or will be published. |