Catalogs
Lists product catalogs belonging to the shop for business-to-business (B2B) or channel use.
Table-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The provider processes other filters client-side within the provider.
- Id supports the '=' comparison operator.
- Status supports the '=' comparison operator.
- Title supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM Catalogs WHERE Id = 'Val1'
SELECT * FROM Catalogs WHERE Status = 'Val1'
SELECT * FROM Catalogs WHERE Title = 'Val1'
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 | False |
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. |
Pseudocolumns
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. |