ProductListings
Query and delete product listings.
Table-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the ProductId, UpdatedAt, and Handle columns. The supported SQL operators are '=' and 'IN' for ProductId, '=' for Handle, and '>' for the UpdatedAt column. The adapter processes other filters client-side within the adapter.
For example, the following queries are processed server side:
SELECT * FROM ProductListings
SELECT * FROM ProductListings WHERE ProductId='123'
SELECT * FROM ProductListings WHERE ProductId IN ('123','456')
SELECT * FROM ProductListings WHERE UpdatedAt>'2018-02-21'
SELECT * FROM ProductListings WHERE Handle='ipod-nano'
Delete
Delete a product listing to unpublish a product from your app (ProductId is required):
DELETE FROM ProductListings WHERE Productid=512433520663
Columns
Name | Type | ReadOnly | References | Description |
ProductId [KEY] | Long | False |
The unique identifer of the product this listing is for. The primary key for this resource. | |
Title | String | False |
The name of the product. | |
BodyHtml | String | False |
The description of the product, complete with HTML formatting. | |
Handle | String | True |
A human-friendly unique string for the Product automatically generated from its title. | |
Variants | String | True |
A list of variant objects, each one representing a slightly different version of the product. | |
Images | String | False |
A list of image objects, each one representing an image associated with the product. | |
ProductType | String | False |
A categorization that a product can be tagged with, commonly used for filtering and searching. | |
Options | String | True |
Custom product property names like 'Size', 'Color', and 'Material'. | |
Tags | String | False |
A categorization that a product can be tagged with, commonly used for filtering. | |
Vendor | String | False |
The name of the vendor of the product. | |
PublishedAt | Datetime | True |
The date and time when the product was published to the Online Store channel. | |
CreatedAt | Datetime | True |
The date and time when the product was created. | |
UpdatedAt | Datetime | True |
The date and time when the product was last modified. |