AbandonedCheckoutLineItems

Lists line items included in an abandoned checkout, including product, quantity, and pricing details.

View-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.

ResourceId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM AbandonedCheckoutLineItems WHERE ResourceId = 'Val1'

Columns


Name	Type	References	Description
Id [KEY]	String		A unique identifier for the individual line item associated with an abandoned checkout.
ResourceId	String	Abandonment.AbandonedCheckoutPayloadId	The unique identifier of the abandoned checkout record this line item belongs to.
Title	String		The display name of the product or variant at the time the checkout was abandoned.
ProductId	String		A globally unique identifier for the product associated with this line item.
VariantId	String		A globally unique identifier for the product variant included in the abandoned checkout.
VariantTitle	String		The descriptive title of the product variant at the time of checkout creation.
Quantity	Int		The total number of units for this variant that were added to the checkout.
Sku	String		The SKU code identifying the specific product variant in the merchant's inventory system.
ImageId	String		A unique identifier for the image associated with this line item's product variant.
ImageWidth	Int		The width of the product image in pixels. Returns null if the image is not hosted by Shopify.
ImageAltText	String		A descriptive phrase that explains the content or purpose of the product image for accessibility.
ImageHeight	Int		The height of the product image in pixels. Returns null if the image is not hosted by Shopify.
ImageUrl	String		The direct URL where the product image is stored or accessed.
DiscountedTotalPriceSetPresentmentMoneyAmount	Decimal		The total discounted price for all units of this line item in the customer's presentment currency.
DiscountedTotalPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted total price in the customer's presentment currency.
DiscountedTotalPriceSetShopMoneyAmount	Decimal		The total discounted price for all units of this line item in the shop's base currency.
DiscountedTotalPriceSetShopMoneyCurrencyCode	String		The currency code for the discounted total price in the shop's base currency.
DiscountedTotalPriceWithCodeDiscountPresentmentMoneyAmount	Decimal		The total price for this line item after applying all discounts, including code-based discounts, in presentment currency.
DiscountedTotalPriceWithCodeDiscountPresentmentMoneyCurrencyCode	String		The currency code for the fully discounted total price in the presentment currency.
DiscountedTotalPriceWithCodeDiscountShopMoneyAmount	Decimal		The total price for this line item after applying all discounts, including code-based discounts, in shop currency.
DiscountedTotalPriceWithCodeDiscountShopMoneyCurrencyCode	String		The currency code for the fully discounted total price in the shop's base currency.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		The discounted price for a single unit of this variant in the presentment currency.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted unit price in the presentment currency.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		The discounted price for a single unit of this variant in the shop's base currency.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		The currency code for the discounted unit price in the shop's base currency.
DiscountedUnitPriceWithCodeDiscountPresentmentMoneyAmount	Decimal		The unit price after all discounts, including code-based discounts, in the presentment currency.
DiscountedUnitPriceWithCodeDiscountPresentmentMoneyCurrencyCode	String		The currency code for the fully discounted unit price in the presentment currency.
DiscountedUnitPriceWithCodeDiscountShopMoneyAmount	Decimal		The unit price after all discounts, including code-based discounts, in the shop's base currency.
DiscountedUnitPriceWithCodeDiscountShopMoneyCurrencyCode	String		The currency code for the fully discounted unit price in the shop's base currency.
OriginalTotalPriceSetPresentmentMoneyAmount	Decimal		The total pre-discount price for all units of this line item in the presentment currency.
OriginalTotalPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the original total price in the presentment currency.
OriginalTotalPriceSetShopMoneyAmount	Decimal		The total pre-discount price for all units of this line item in the shop's base currency.
OriginalTotalPriceSetShopMoneyCurrencyCode	String		The currency code for the original total price in the shop's base currency.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		The original, undiscounted price for a single unit in the presentment currency.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the original unit price in the presentment currency.
OriginalUnitPriceSetShopMoneyAmount	Decimal		The original, undiscounted price for a single unit in the shop's base currency.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		The currency code for the original unit price in the shop's base currency.

CData Python Connector for Shopify

AbandonedCheckoutLineItems

View-Specific Information

Select

Columns