AbandonedCheckoutLineItems

Retrieves a list of line items in the associated resource.

View-Specific Information

Select

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

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 globally-unique ID.
ResourceId	String	Abandonment.AbandonedCheckoutPayloadId	A globally-unique ID.
Title	String		Title of the line item. Defaults to the product's title.
ProductId	String		A globally-unique ID.
VariantId	String		A globally-unique ID.
VariantTitle	String		The title of the variant at time of order creation.
Quantity	Int		The number of variant units ordered.
Sku	String		The variant SKU number.
ImageId	String		A unique ID for the image.
ImageWidth	Int		The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageAltText	String		A word or phrase to share the nature or contents of an image.
ImageHeight	Int		The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
ImageUrl	String		The location of the image as a URL.
DiscountedTotalPriceSetPresentmentMoneyAmount	Decimal		Final total price for the entire quantity of this line item, including discounts. Decimal money amount.
DiscountedTotalPriceSetPresentmentMoneyCurrencyCode	String		Final total price for the entire quantity of this line item, including discounts. Currency of the money.
DiscountedTotalPriceSetShopMoneyAmount	Decimal		Final total price for the entire quantity of this line item, including discounts. Decimal money amount.
DiscountedTotalPriceSetShopMoneyCurrencyCode	String		Final total price for the entire quantity of this line item, including discounts. Currency of the money.
DiscountedTotalPriceWithCodeDiscountPresentmentMoneyAmount	Decimal		The total price for the entire quantity of this line item, after all discounts are applied, at both the line item and code-based line item level. Decimal money amount.
DiscountedTotalPriceWithCodeDiscountPresentmentMoneyCurrencyCode	String		The total price for the entire quantity of this line item, after all discounts are applied, at both the line item and code-based line item level. Currency of the money.
DiscountedTotalPriceWithCodeDiscountShopMoneyAmount	Decimal		The total price for the entire quantity of this line item, after all discounts are applied, at both the line item and code-based line item level. Decimal money amount.
DiscountedTotalPriceWithCodeDiscountShopMoneyCurrencyCode	String		The total price for the entire quantity of this line item, after all discounts are applied, at both the line item and code-based line item level. Currency of the money.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		The price of a single variant unit after discounts are applied at the line item level, in shop and presentment currencies. Decimal money amount.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		The price of a single variant unit after discounts are applied at the line item level, in shop and presentment currencies. Currency of the money.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		The price of a single variant unit after discounts are applied at the line item level, in shop and presentment currencies. Decimal money amount.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		The price of a single variant unit after discounts are applied at the line item level, in shop and presentment currencies. Currency of the money.
DiscountedUnitPriceWithCodeDiscountPresentmentMoneyAmount	Decimal		The price of a single variant unit after all discounts are applied, at both the line item and code-based line item level. Decimal money amount.
DiscountedUnitPriceWithCodeDiscountPresentmentMoneyCurrencyCode	String		The price of a single variant unit after all discounts are applied, at both the line item and code-based line item level. Currency of the money.
DiscountedUnitPriceWithCodeDiscountShopMoneyAmount	Decimal		The price of a single variant unit after all discounts are applied, at both the line item and code-based line item level. Decimal money amount.
DiscountedUnitPriceWithCodeDiscountShopMoneyCurrencyCode	String		The price of a single variant unit after all discounts are applied, at both the line item and code-based line item level. Currency of the money.
OriginalTotalPriceSetPresentmentMoneyAmount	Decimal		Original total price for the entire quantity of this line item, before discounts. Decimal money amount.
OriginalTotalPriceSetPresentmentMoneyCurrencyCode	String		Original total price for the entire quantity of this line item, before discounts. Currency of the money.
OriginalTotalPriceSetShopMoneyAmount	Decimal		Original total price for the entire quantity of this line item, before discounts. Decimal money amount.
OriginalTotalPriceSetShopMoneyCurrencyCode	String		Original total price for the entire quantity of this line item, before discounts. Currency of the money.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		Original price for a single unit of this line item, before discounts. Decimal money amount.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		Original price for a single unit of this line item, before discounts. Currency of the money.
OriginalUnitPriceSetShopMoneyAmount	Decimal		Original price for a single unit of this line item, before discounts. Decimal money amount.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		Original price for a single unit of this line item, before discounts. Currency of the money.

SSIS Components for Shopify

AbandonedCheckoutLineItems

View-Specific Information

Select

Columns