AbandonedCheckoutsItems
Query abandoned checkouts items.
View-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The adapter processes other filters client-side within the adapter. For example, the following queries are processed server side.
SELECT * FROM AbandonedCheckoutsItems
SELECT * FROM AbandonedCheckoutsItems WHERE CreatedAt > '2017-10-25'
Columns
| Name | Type | References | Description |
| AbandonedCheckoutId | Long | The unique numeric identifier for the order. | |
| ProductId | Long |
Products.Id | The product ID od the item. |
| ItemVariantId | Long | The product variant ID of item. | |
| ItemTitle | String | The title of the product. | |
| ItemQuantity | Integer | The number of products that were purchased. | |
| ItemPrice | Decimal | The price of the item in presentment currency. | |
| ItemGrams | Integer | 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. |