CollectionProducts
Lists products contained within a specified collection.
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.
- CollectionId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM CollectionProducts WHERE CollectionId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The globally unique identifier of the collection product record. | |
| CollectionId [KEY] | String |
Collections.Id | The globally unique identifier of the collection that this product belongs to. |
| Title | String | The display title of the product within the collection. | |
| Position | Int | The position of the product in the collection's sort order. |