Publications
Lists sales channel publications configured for the shop.
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.
- CatalogType supports the '=, IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM Publications WHERE Id = 'Val1'
SELECT * FROM Publications WHERE CatalogType = 'Val1'
Insert
The following columns can be used to create a new record:
AutoPublish, CatalogId
The following pseudo-column can be used to create a new record:
DefaultState
Update
The following column can be updated:
AutoPublish
The following pseudo-columns can be used to update a record:
PublishablesToAdd, PublishablesToRemove
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally unique Id of the publication. | |
| AutoPublish | Bool | False |
Indicates whether new products are automatically published to this publication. | |
| SupportsFuturePublishing | Bool | True |
Indicates whether the publication supports future publishing. | |
| CatalogId | String | True |
A globally unique Id of the catalog. | |
| AddAllProductsOperationId | String | True |
A globally unique Id of the add-all-products operation. | |
| AddAllProductsOperationStatus | String | True |
The status of the add-all-products operation. | |
| AddAllProductsOperationProcessedRowCount | Int | True |
The total number of processed rows, including imported, failed, and skipped rows. | |
| AddAllProductsOperationRowCountCount | Int | True |
The estimated total number of rows in the background operation. | |
| AddAllProductsOperationRowCountExceedsMax | Bool | True |
Indicates whether the operation exceeds the maximum number of reportable rows. | |
| CatalogCsvOperationId | String | True |
A globally unique Id of the catalog CSV operation. | |
| CatalogCsvOperationStatus | String | True |
The status of the catalog CSV operation. | |
| CatalogCsvOperationProcessedRowCount | Int | True |
The total number of processed rows, including imported, failed, and skipped rows. | |
| CatalogCsvOperationRowCountCount | Int | True |
The estimated total number of rows in the background CSV operation. | |
| CatalogCsvOperationRowCountExceedsMax | Bool | True |
Indicates whether the CSV operation exceeds the maximum number of reportable rows. | |
| PublicationResourceOperationId | String | True |
A globally unique Id of the publication resource operation. | |
| PublicationResourceOperationStatus | String | True |
The status of the publication resource operation. | |
| PublicationResourceOperationProcessedRowCount | Int | True |
The total number of processed rows, including imported, failed, and skipped rows. | |
| PublicationResourceOperationRowCountCount | Int | True |
The estimated total number of rows in the publication resource operation. | |
| PublicationResourceOperationRowCountExceedsMax | Bool | True |
Indicates whether the resource operation exceeds the maximum number of reportable rows. | |
| CatalogType | String | True |
The catalog type used to filter publications. |
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 |
| DefaultState | String |
Indicates whether to create an empty publication or prepopulate it with all products. The allowed values are ALL_PRODUCTS, EMPTY. |
| PublishablesToAdd | String |
A comma-separated list of publishable Ids to add. A maximum of 50 can be updated at once. |
| PublishablesToRemove | String |
A comma-separated list of publishable Ids to remove. A maximum of 50 can be updated at once. |