AbandonedCheckoutLineItems

Lists the products, variants, and quantities that were in the cart when the checkout was abandoned.

View-Specific Information

Select

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

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		The globally unique identifier of the abandoned checkout line item.
ResourceId	String	Abandonment.AbandonedCheckoutPayloadId	The globally unique identifier of the abandoned checkout that this line item belongs to.
Title	String		The display title of the product or service in this line item. Defaults to the product's title at the time of checkout.
ProductId	String		The globally unique identifier of the product linked to this line item.
VariantId	String		The globally unique identifier of the product variant chosen in the line item.
VariantTitle	String		The title of the selected variant at the time the checkout was created.
Quantity	Int		The total number of variant units included in the line item.
Sku	String		The SKU (stock keeping unit) code associated with the product variant.
ImageId	String		The unique identifier of the image connected to this line item.
ImageWidth	Int		The original width of the product image in pixels. Returns null if the image is not hosted by Shopify.
ImageAltText	String		Alternative text that describes the content or purpose of the product image.
ImageHeight	Int		The original height of the product image in pixels. Returns null if the image is not hosted by Shopify.
ImageUrl	String		The URL that points to the product image.
DiscountedTotalPriceSetPresentmentMoneyAmount	Decimal		The final total cost for the full quantity of this line item after discounts, expressed as a decimal money amount in the presentment currency.
DiscountedTotalPriceSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the final discounted total price of the line item.
DiscountedTotalPriceSetShopMoneyAmount	Decimal		The final total cost for the full quantity of this line item after discounts, expressed as a decimal money amount in the shop's base currency.
DiscountedTotalPriceSetShopMoneyCurrencyCode	String		The shop currency code for the final discounted total price of the line item.
DiscountedTotalPriceWithCodeDiscountPresentmentMoneyAmount	Decimal		The final total cost for the full quantity of this line item after applying all discounts, including code-based discounts, expressed as a decimal money amount in the presentment currency.
DiscountedTotalPriceWithCodeDiscountPresentmentMoneyCurrencyCode	String		The presentment currency code for the final total price of the line item after all discounts, including code-based discounts.
DiscountedTotalPriceWithCodeDiscountShopMoneyAmount	Decimal		The final total cost for the full quantity of this line item after applying all discounts, including code-based discounts, expressed as a decimal money amount in the shop's base currency.
DiscountedTotalPriceWithCodeDiscountShopMoneyCurrencyCode	String		The shop currency code for the final total price of the line item after all discounts, including code-based discounts.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		The discounted price of a single unit in this line item, expressed as a decimal money amount in the presentment currency.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the discounted unit price of the line item.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		The discounted price of a single unit in this line item, expressed as a decimal money amount in the shop's base currency.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		The shop currency code for the discounted unit price of the line item.
DiscountedUnitPriceWithCodeDiscountPresentmentMoneyAmount	Decimal		The unit price of this line item after applying all discounts, including code-based discounts, expressed as a decimal money amount in the presentment currency.
DiscountedUnitPriceWithCodeDiscountPresentmentMoneyCurrencyCode	String		The presentment currency code for the unit price of this line item after all discounts, including code-based discounts.
DiscountedUnitPriceWithCodeDiscountShopMoneyAmount	Decimal		The unit price of this line item after applying all discounts, including code-based discounts, expressed as a decimal money amount in the shop's base currency.
DiscountedUnitPriceWithCodeDiscountShopMoneyCurrencyCode	String		The shop currency code for the unit price of this line item after all discounts, including code-based discounts.
OriginalTotalPriceSetPresentmentMoneyAmount	Decimal		The original total cost for the full quantity of this line item before discounts, expressed as a decimal money amount in the presentment currency.
OriginalTotalPriceSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the original total price of the line item before discounts.
OriginalTotalPriceSetShopMoneyAmount	Decimal		The original total cost for the full quantity of this line item before discounts, expressed as a decimal money amount in the shop's base currency.
OriginalTotalPriceSetShopMoneyCurrencyCode	String		The shop currency code for the original total price of the line item before discounts.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		The original unit price of this line item before discounts, expressed as a decimal money amount in the presentment currency.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		The presentment currency code for the original unit price of the line item before discounts.
OriginalUnitPriceSetShopMoneyAmount	Decimal		The original unit price of this line item before discounts, expressed as a decimal money amount in the shop's base currency.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		The shop currency code for the original unit price of the line item before discounts.

Excel Add-In for Shopify

AbandonedCheckoutLineItems

View-Specific Information

Select

Columns