CData Python Connector for Shopify

Build 23.0.8839

AbandonedCheckoutsItems

Query abandoned checkouts items.

View-Specific Information

Select

The connector uses the Shopify API to process search criteria that refer to the CreatedAt and UpdatedAt columns. The connector processes other filters client-side within the connector. 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

AbandonedCheckouts.Id

The unique numeric identifier for the order.
ProductId [KEY] Long

Products.Id

The product ID od the item.
ItemVariantId [KEY] Long

ProductVariants.Id

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839