Collections
Stores metadata for all collections in the shop, both manual and automated, including titles and publication status.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- Id supports the '=, IN' comparison operators.
- Title supports the '=, !=' comparison operators.
- UpdatedAt supports the '=, !=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM Collections WHERE Id = 'Val1'
SELECT * FROM Collections WHERE Title = 'Val1'
SELECT * FROM Collections WHERE UpdatedAt = '2023-01-01 11:10:00'
Update
The following column can be updated:
SortOrder
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the collection record. | |
| LegacyResourceId | String | True |
The identifier of the corresponding collection resource in the REST Admin API. | |
| Title | String | True |
The name of the collection, displayed in the Shopify Admin and across sales channels such as the online store. | |
| Handle | String | True |
A unique, URL-friendly string used to identify the collection. If not specified, it's automatically generated from the title and used in Liquid templates to reference the collection. | |
| DescriptionHtml | String | True |
The HTML-formatted description of the collection, often displayed to customers in storefronts depending on the theme. | |
| ProductsCount | Int | True |
The total number of products currently assigned to the collection. | |
| ProductsCountPrecision | String | True |
Indicates the precision or reliability of the product count, specifying whether the value is exact or approximate. | |
| SortOrder | String | False |
Specifies how products within the collection are sorted by default in the Shopify Admin and storefront (for example, by title, best-selling, or manual). | |
| TemplateSuffix | String | True |
The suffix of the Liquid template used to render the collection page in the storefront. A value of 'custom' corresponds to 'collection.custom.liquid'. Null indicates the default 'collection.liquid' template. | |
| AvailablePublicationsCount | Int | True |
The total number of publications where this collection is currently published without feedback errors. | |
| AvailablePublicationsCountPrecision | String | True |
Indicates the precision or reliability of the available publications count. | |
| PublishedOnCurrentPublication | Bool | True |
Indicates whether the collection is published to the current app's active publication context. | |
| UpdatedAt | Datetime | True |
The timestamp marking when the collection was last updated or modified. | |
| FeedbackSummary | String | True |
A summary of feedback or diagnostic messages related to the collection resource. | |
| ImageId | String | True |
The unique identifier of the image associated with the collection. | |
| ImageWidth | Int | True |
The width of the collection's image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageAltText | String | True |
A short descriptive phrase explaining the content or purpose of the collection's image, used for accessibility and SEO. | |
| ImageHeight | Int | True |
The height of the collection's image in pixels. Returns null if the image is not hosted by Shopify. | |
| ImageUrl | String | True |
The direct URL where the collection's image is hosted. | |
| RuleSetAppliedDisjunctively | Bool | True |
Indicates how product inclusion rules are applied. If true, a product must meet any of the rules to be included; if false, it must meet all rules. | |
| SeoTitle | String | True |
The search engine optimization (SEO) title for the collection page, displayed in search engine results. | |
| SeoDescription | String | True |
The SEO description for the collection page, used as the meta description in search engine listings. |