Catalogs
Represents product catalogs available to the shop, often used for B2B or channel-specific listings.
Table-Specific Information
Select
The connector processes all filters client-side within the connector. 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
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 |
A list of unique identifiers for company locations associated with this catalog, defining which locations the catalog applies to. |