Contains theme metadata, including theme names, roles (main, unpublished), and publication details for storefront design management.

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.
• Name supports the '=, IN' comparison operators.
• Role supports the '=, IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM Themes WHERE Id = 'Val1'
  SELECT * FROM Themes WHERE Name = 'Val1'
  SELECT * FROM Themes WHERE Role = 'Val1'

Insert

The following column can be used to create a new record:

Name

The following pseudo-column can be used to create a new record:

Source

Update

The following column can be updated:

Name

Delete

You can delete entries by specifying the following column:

Id

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally unique identifier for the theme.
ThemeStoreId	Int	True		The unique identifier of the theme in the Shopify Theme Store, if applicable.
Name	String	False		The name of the theme as defined by the merchant.
Prefix	String	True		The prefix assigned to the theme, typically used to distinguish or categorize themes.
Processing	Bool	True		Indicates whether the theme is currently being processed, such as during upload or compilation.
ProcessingFailed	Bool	True		Indicates whether the theme processing encountered an error or failed to complete successfully.
Role	String	True		Specifies the role of the theme, such as 'main', 'unpublished', or 'development'.
UpdatedAt	Datetime	True		The date and time when the theme was most recently updated.
CreatedAt	Datetime	True		The date and time when the theme was originally created.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.

Name	Type	Description
Source	String	An external or staged upload URL used to import the theme into Shopify.