CollectionProducts
Lists all products contained within a specific collection, including display order and availability.
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 | A unique identifier for the record linking a product to a collection. | |
| CollectionId [KEY] | String |
Collections.Id | The unique identifier of the collection that contains this product. |
| Title | String | The title of the product as it appears within the collection. | |
| Position | Int | The display order or position of the product within the collection's sorting sequence. |