SSIS Components for Shopify

Build 24.0.9060

Collections

Returns a list of collections.

Table-Specific Information

Select

The component uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The component processes other filters client-side within the component.

  • 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
  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 globally-unique ID.

LegacyResourceId String True

The ID of the corresponding resource in the REST Admin API.

Title String True

The name of the collection. It's displayed in the Shopify admin and is typically displayed in sales channels, such as an online store.

Handle String True

A unique string that identifies the collection. If a handle isn't specified when a collection is created, it's automatically generated from the collection's original title, and typically includes words from the title separated by hyphens. For example, a collection that was created with the title 'Summer Catalog 2022' might have the handle 'summer-catalog-2022'. If the title is changed, the handle doesn't automatically change. The handle can be used in themes by the Liquid templating language to refer to the collection, but using the ID is preferred because it never changes.

DescriptionHtml String True

The description of the collection, including any HTML tags and formatting. This content is typically displayed to customers, such as on an online store, depending on the theme.

ProductsCount Int True

The number of products in the collection.

SortOrder String False

The order in which the products in the collection are displayed by default in the Shopify admin and in sales channels, such as an online store.

TemplateSuffix String True

The suffix of the Liquid template being used to show the collection in an online store. For example, if the value is 'custom', then the collection is using the 'collection. custom. liquid' template. If the value is 'null', then the collection is using the default 'collection. liquid' template.

AvailablePublicationCount Int True

The number of publications a resource is published to without feedback errors.

PublishedOnCurrentPublication Bool True

Check to see whether the resource is published to the calling app's publication.

UpdatedAt Datetime True

The date and time when the collection was last modified.

FeedbackSummary String True

Summary of resource feedback pertaining to the resource.

ImageId String True

A unique ID for the image.

ImageWidth Int True

The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.

ImageAltText String True

A word or phrase to share the nature or contents of an image.

ImageHeight Int True

The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.

ImageUrl String True

The location of the image as a URL.

RuleSetAppliedDisjunctively Bool True

Whether products must match any or all of the rules to be included in the collection. If true, then products must match at least one of the rules to be included in the collection. If false, then products must match all of the rules to be included in the collection.

SeoTitle String True

SEO Title.

SeoDescription String True

SEO Description.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060