AbandonedCheckoutsItems
Query abandoned checkouts items.
View-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The driver processes other filters client-side within the driver. For example, the following queries are processed server-side.SELECT * FROM AbandonedCheckoutsItems WHERE CreatedAt > '2017-10-25'
Columns
Name | Type | References | Description |
AbandonedCheckoutId [KEY] | Long | The unique numeric identifier for the order. | |
ProductId [KEY] | Long |
Products.Id | The product ID od the item. |
ItemVariantId [KEY] | Long | The product variant ID of item. | |
ItemTitle | String | The title of the product. | |
ItemQuantity | Int | The number of products that were purchased. | |
ItemPrice | Decimal | The price of the item in presentment currency. | |
ItemGrams | Int | The weight of the item in grams. | |
SKU | String | A unique identifier for the item in the shop. | |
VariantTitle | String | The title of the product variant. | |
Vendor | String | The name of the item's supplier. | |
FulFillmentsService | String | The fulfillment service provider for the item. | |
CreatedAt | Datetime | The date and time when the order was created. | |
UpdatedAt | Datetime | The date and time when the order was last modified. |