Products
Returns a list of products.
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 '=,IN' comparison operators.
- Title supports the '=,!=' comparison operators.
- ProductType supports the '=,!=' comparison operators.
- Status supports the '=,!=' comparison operators.
- Vendor supports the '=,!=' comparison operators.
- TotalInventory supports the '=,!=,<,>,>=,<=' comparison operators.
- HasOnlyDefaultVariant supports the '=,!=' comparison operators.
- UpdatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
- CreatedAt supports the '=,!=,<,>,>=,<=' comparison operators.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM Products WHERE Id='VALUE'
SELECT * FROM Products WHERE Title='VALUE'
SELECT * FROM Products WHERE ProductType='VALUE'
SELECT * FROM Products WHERE Status='VALUE'
SELECT * FROM Products WHERE Vendor='VALUE'
SELECT * FROM Products WHERE TotalInventory<'100'
SELECT * FROM Products WHERE HasOnlyDefaultVariant='true'
SELECT * FROM Products WHERE UpdatedAt<'2000-01-01 01:00:00.0'
SELECT * FROM Products WHERE CreatedAt<'2000-01-01 01:00:00.0'
Insert
The following columns can be used to create a new record:
DescriptionHtml, Title, Handle, ProductType, Tags, Status, Vendor, RequiresSellingPlan, GiftCardTemplateSuffix, IsGiftCard, SeoTitle, SeoDescription
The following pseudo-columns can be used to create a new record:
VariantPrice, VariantTaxable, VariantRequiresShipping
Update
The following columns can be updated:
DescriptionHtml, Title, Handle, ProductType, Tags, Status, Vendor, RequiresSellingPlan, GiftCardTemplateSuffix, SeoTitle, SeoDescription
The following pseudo-columns can be updated:
VariantPrice, VariantTaxable, VariantRequiresShipping
Delete
You can delete entries by specifying the Id.
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
A globally-unique identifier. | |
LegacyResourceId | Long | True |
The ID of the corresponding resource in the REST Admin API. | |
Description | String | True |
The description of the product, complete with HTML formatting. | |
DescriptionHtml | String | False |
The description of the product, complete with HTML formatting. | |
Title | String | False |
The title of the product. | |
Handle | String | False |
A unique human-friendly string of the product's title. | |
ProductType | String | False |
The product type specified by the merchant. | |
Tags | String | False |
A comma separated list of tags associated with the product. Updating 'tags' overwrites any existing tags that were previously added to the product. | |
Status | String | False |
The product status. This controls visibility across all channels. | |
Vendor | String | False |
The name of the product's vendor. | |
OnlineStorePreviewUrl | String | True |
The online store preview URL. | |
OnlineStoreUrl | String | True |
The online store URL for the product.A value of 'null' indicates that the product is not published to the Online Store sales channel. | |
RequiresSellingPlan | Bool | False |
Whether the product can only be purchased with a selling plan (subscription). Products that are sold on subscription ('requiresSellingPlan: true') can be updated only for online stores. If you update a product to be subscription only, then the product is unpublished from all channels except the online store. | |
SellingPlanGroupCount | Int | True |
Count of selling plan groups associated with the product. | |
TracksInventory | Bool | True |
Whether inventory tracking has been enabled for the product. | |
TotalInventory | Int | True |
The quantity of inventory in stock. | |
HasOnlyDefaultVariant | Bool | True |
Whether the product has only a single variant with the default option and value. | |
HasOutOfStockVariants | Bool | True |
Whether the product has out of stock variants. | |
TotalVariants | Int | True |
The number of variants that are associated with the product. | |
TemplateSuffix | String | True |
The theme template used when viewing the product in a store. | |
GiftCardTemplateSuffix | String | False |
The theme template used when viewing the gift card in a store. | |
IsGiftCard | Bool | True |
Whether the product is a gift card. | |
PublishedAt | Datetime | True |
The date and time when the product was published to the Online Store. | |
AvailablePublicationCount | Int | True |
The number of publications a resource is published to without feedback errors. | |
UpdatedAt | Datetime | True |
The date and time when the product was last modified.A product's 'updatedAt' value can change for different reasons. For example, if an order is placed for a product that has inventory tracking set up, then the inventory adjustment is counted as an update. | |
CreatedAt | Datetime | True |
The date and time when the product was created. | |
FeedbackSummary | String | True |
Summary of resource feedback pertaining to the resource. | |
PriceRangeMaxVariantPriceAmount | Decimal | True |
Decimal money amount. | |
PriceRangeMaxVariantPriceCurrencyCode | String | True |
Currency of the money. | |
PriceRangeMinVariantPriceAmount | Decimal | True |
Decimal money amount. | |
PriceRangeMinVariantPriceCurrencyCode | String | True |
Currency of the money. | |
SeoTitle | String | False |
SEO Title. | |
SeoDescription | String | False |
SEO Description. | |
MediaCount | Int | True |
Total count of media belonging to a product. | |
FeaturedImageId | String | True |
A unique identifier for the image. | |
FeaturedImageAltText | String | True |
A word or phrase to share the nature or contents of an image. | |
FeaturedImageHeight | Int | True |
The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
FeaturedImageWidth | Int | True |
The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify. | |
FeaturedImageUrl | String | True |
The location of the image as a URL. | |
ResourcePublicationOnCurrentPublicationIsPublished | Bool | True |
Whether the resource publication is published. If true, then the resource publication is published to the publication. If false, then the resource publication is staged to be published to the publication. | |
ResourcePublicationOnCurrentPublicationPublishDate | Datetime | True |
The date that the resource publication was or is going to be published to the publication. | |
ResourcePublicationOnCurrentPublicationPublicationId | String | True |
A globally-unique identifier. | |
ResourcePublicationOnCurrentPublicationPublicationName | String | True |
Name of the publication. | |
ResourcePublicationOnCurrentPublicationPublicationSupportsFuturePublishing | Bool | True |
Whether the publication supports future publishing. | |
ProductCategoryProductTaxonomyNodeId | String | True |
The ID of the product taxonomy node. | |
ProductCategoryProductTaxonomyNodeName | String | True |
The name of the product taxonomy node. For example, Dog Beds. | |
ProductCategoryProductTaxonomyNodeFullName | String | True |
The full name of the product taxonomy node. For example, Animals & Pet Supplies > Pet Supplies > Dog Supplies > Dog Beds. | |
ProductCategoryProductTaxonomyNodeIsLeaf | Bool | True |
Whether the node is a leaf node. | |
ProductCategoryProductTaxonomyNodeIsRoot | Bool | True |
Whether the node is a root node. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
VariantPrice | Double |
The price of the variant. |
VariantTaxable | Bool |
Whether the variant is taxable. |
VariantRequiresShipping | Bool |
Whether the variant requires shipping. |