CollectionProducts
Lists products contained within a specified collection.
Table-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following column and operators. The provider processes other filters client-side within the provider.
- CollectionId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM CollectionProducts WHERE CollectionId = 'Val1'
Insert
The following columns can be used to create a new record:
Id, CollectionId
Delete
You can delete entries by specifying the following columns:
Id, CollectionId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Products.Id |
The globally unique identifier of the collection product record. |
| CollectionId [KEY] | String | True |
Collections.Id |
The globally unique identifier of the collection that this product belongs to. |
| Title | String | True |
The display title of the product within the collection. | |
| Position | Int | True |
The position of the product in the collection's sort order. |