Themes

Create, read, update or delete themes

Table-Specific Information

The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:

SELECT * FROM Themes

SELECT * FROM Themes WHERE Id='123'

You must specify name to create a Theme.

INSERT INTO Themes(name) VALUES ('NewTheme')

You must specify the id to update a Theme. For example:

UPDATE Themes SET name='NewTheme' WHERE Id = '77171130'

You must specify the Id of the Theme to delete it.

DELETE FROM Themes WHERE Id = '555695'

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	Boolean	True		Whether the theme can currently be previewed.
Processing	Boolean	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.