Lists product catalogs belonging to the shop for business-to-business (B2B) or channel use.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

• 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.