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

Table-Specific Information

Select

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

• 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

疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。

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