Catalogs
Lists product catalogs belonging to the shop for business-to-business (B2B) or channel use.
Table-Specific Information
Select
The server processes all filters client-side within the server. 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 |
The globally unique identifier of the catalog. | |
| Status | String | False |
The current status of the catalog, such as active or inactive. | |
| Title | String | False |
The display name of the catalog. | |
| PriceListId | String | False |
The globally unique identifier of the price list associated with the catalog. | |
| PublicationId | String | False |
The globally unique identifier of the publication linked to the catalog. | |
| OperationId | String | True |
The globally unique identifier of the operation that created or last modified the catalog. |
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 |
| CompanyLocationIds | String |
The identifiers of the company locations associated with the catalog. |