Catalogs
Represents product catalogs available to the shop, often used for B2B or channel-specific listings.
Table-Specific Information
Select
The 本製品 processes all filters client-side within the 本製品. The following query is the only one processed server-side:
SELECT * FROM Catalogs
Insert
The following columns can be used to create a new record:
Status, Title, PriceListId, PublicationId
The following pseudo-column can be used to create a new record:
CompanyLocationIds
Update
The following columns can be updated:
Status, Title, PriceListId, PublicationId
The following pseudo-column can be used to update a record:
CompanyLocationIds
Delete
You can delete entries by specifying the following column:
Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the catalog record. | |
| Status | String | False |
The current status of the catalog, such as active, draft, or archived. | |
| Title | String | False |
The display name or title of the catalog as defined by the merchant or system. | |
| PriceListId | String | False |
The unique identifier of the price list associated with this catalog, used to define product pricing. | |
| PublicationId | String | False |
The unique identifier of the publication through which the catalog is made available. | |
| OperationId | String | True |
The unique identifier of the operation or process that generated or updated the catalog. |
Pseudo-Columns
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description |
| CompanyLocationIds | String |
A list of unique identifiers for company locations associated with this catalog, defining which locations the catalog applies to. |