Publications
Lists sales channel publications configured for the shop.
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.
- 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
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description |
| DefaultState | String |
Indicates whether to create an empty publication or prepopulate it with all products. 使用できる値は次のとおりです。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. |