Themes
Create, read, update or delete themes
Table-Specific Information
Select
The connector processes all filters client-side within the connector. The following queries are the only ones processed server-side:SELECT * FROM Theme
SELECT * FROM Themes WHERE Id = '123'
Insert
You must specify name to create a Theme.
INSERT INTO Themes (name) VALUES ('NewTheme')
Update
You must specify the id to update a Theme. For example:
UPDATE Themes SET name = 'NewTheme' WHERE Id = '77171130'
Delete
You must specify the Id of the Theme to delete it.
DELETE FROM Themes WHERE Id = '555695'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the theme. | |
| AdminGraphqlApiId | String | True |
Displays the Admin Graphql API id. | |
| CreatedAt | Datetime | True |
The date and time (ISO 8601 format) when the theme was created. | |
| Name | String | False |
The name of the theme. | |
| Previewable | Bool | True |
Whether the theme can currently be previewed. | |
| Processing | Bool | True |
Whether files are still being copied into place for this theme. | |
| Role | String | False |
Specifies how the theme is being used within the shop. The allowed values are main, published, demo. | |
| ThemeStoreId | Long | True |
A unique identifier applied to Shopify-made themes that are installed from the Shopify Theme Store Theme Store. | |
| UpdatedAt | Datetime | True |
The date and time ( ISO 8601 format) when the theme was last updated. |