EZ Exporter: Shopify Abandoned Checkout Fields Reference

You can reference the Field IDs below in a Custom Field or Calculated Field by enclosing them in double curly braces (e.g. {{ updated_at }}).

Field ID	Description
`abandoned_checkout_url`	Abandoned Checkout URL (type: text). The URL for the buyer to recover their checkout.
`billing_address.address1`	Billing Address1 (type: text).
`billing_address.address2`	Billing Address2 (type: text).
`billing_address.city`	Billing City (type: text).
`billing_address.company`	Billing Company (type: text).
`billing_address.country`	Billing Country (type: text).
`billing_address.first_name`	Billing First Name (type: text).
`billing_address.last_name`	Billing Last Name (type: text).
`billing_address.name`	Billing Name (type: text).
`billing_address.phone`	Billing Phone (type: text).
`billing_address.province`	Billing Province (type: text).
`billing_address.zip`	Billing Zip (type: text).
`completed_at`	Completed At (type: datetime). The date and time when the buyer completed the checkout. Null/blank if the checkout has not been completed.
`created_at`	Created At (type: datetime). The date and time when the checkout was created.
`custom_attributes`	Custom Attributes (type: text). (aka "Note Attributes", "Cart Attributes"). A list of extra information that has been added to the checkout in JSON format.
`custom_attributes.key`	Custom Attributes Keys (type: text). A comma-separated list of keys in the custom_attributes.
`custom_attributes.value`	Custom Attributes Values (type: text). A comma-separated list of values in the custom_attributes.
`customer.default_email_address.email_address`	Customer Email (type: text).
`customer.default_email_address.marketing_state`	Customer Email Marketing State (type: text). Whether the customer has subscribed to email marketing. Valid values: INVALID: The customer’s email address marketing state is invalid. NOT_SUBSCRIBED: The customer is not subscribed to email marketing. PENDING: The customer is in the process of subscribing to email marketing. SUBSCRIBED: The customer is subscribed to email marketing. UNSUBSCRIBED: The customer is not subscribed to email marketing but was previously subscribed.
`customer.default_phone_number.marketing_state`	Customer Phone Marketing State (type: text). Whether the customer has subscribed to SMS marketing material. Valid values: NOT_SUBSCRIBED: The customer has not subscribed to SMS marketing. PENDING: The customer is in the process of subscribing to SMS marketing. REDACTED: The personal data of the customer is erased. This value is internally-set and read-only. SUBSCRIBED: The customer is subscribed to SMS marketing. UNSUBSCRIBED: The customer is not currently subscribed to SMS marketing but was previously subscribed.
`customer.default_phone_number.phone_number`	Customer Phone (type: text).
`customer.first_name`	Customer First Name (type: text).
`customer.id`	Customer ID (type: text).
`customer.last_name`	Customer Last Name (type: text).
`customer.tags`	Customer Tags (type: text).
`discount_codes`	Discount Codes (type: text). A list of discount codes entered by the buyer at checkout in JSON format.
`id`	Abandoned Checkout ID (type: number).
`line_items.custom_attributes`	Lineitem Custom Attributes (type: text). (aka "Line Item Properties", "Custom Product Options"). A list of extra information that has been added to the line item in JSON format.
`line_items.custom_attributes.key`	Lineitem Custom Attributes Keys (type: text). A comma-separated list of keys in the line_items.custom_attributes.
`line_items.custom_attributes.value`	Lineitem Custom Attributes Values (type: text). A comma-separated list of values in the line_items.custom_attributes.
`line_items.discounted_total_price_set.presentment_money.amount`	Lineitem Discounted Total Price (Presentment Currency) (type: number). Final total price for the entire quantity of this line item, including discounts.
`line_items.discounted_total_price_set.shop_money.amount`	Lineitem Discounted Total Price (Shop Currency) (type: number). Final total price for the entire quantity of this line item, including discounts.
`line_items.discounted_unit_price_set.presentment_money.amount`	Lineitem Discounted Unit Price (Presentment Currency) (type: number). The price of a single variant unit after discounts are applied at the line item level.
`line_items.discounted_unit_price_set.shop_money.amount`	Lineitem Discounted Unit Price (Shop Currency) (type: number). The price of a single variant unit after discounts are applied at the line item level.
`line_items.original_total_price_set.presentment_money.amount`	Lineitem Original Total Price (Presentment Currency) (type: number). Original price for the entire quantity of this line item, before discounts.
`line_items.original_total_price_set.shop_money.amount`	Lineitem Original Total Price (Shop Currency) (type: number). Original price for the entire quantity of this line item, before discounts.
`line_items.original_unit_price_set.presentment_money.amount`	Lineitem Original Unit Price (Presentment Currency) (type: number). Original price for a single unit of this line item, before discounts.
`line_items.original_unit_price_set.shop_money.amount`	Lineitem Original Unit Price (Shop Currency) (type: number). Original price for a single unit of this line item, before discounts.
`line_items.product.id`	Lineitem Product ID (type: text).
`line_items.product.tags`	Lineitem Product Tags (type: text).
`line_items.quantity`	Lineitem Quantity (type: number).
`line_items.sku`	Lineitem SKU (type: text).
`line_items.title`	Lineitem Title (type: text). Title of the line item. Defaults to the product's title.
`line_items.variant.id`	Lineitem Variant ID (type: text).
`line_items.variant_title`	Lineitem Variant Title (type: text). Title of the variant for this line item. Null/blank for custom line items and products that don't have distinct variants.
`name`	Abandoned Checkout Name (type: text). Unique merchant-facing identifier for the checkout.
`note`	Notes (type: text). A merchant-facing note added to the checkout. Not visible to the buyer.
`shipping_address.address1`	Shipping Address1 (type: text).
`shipping_address.address2`	Shipping Address2 (type: text).
`shipping_address.city`	Shipping City (type: text).
`shipping_address.company`	Shipping Company (type: text).
`shipping_address.country`	Shipping Country (type: text).
`shipping_address.first_name`	Shipping First Name (type: text).
`shipping_address.last_name`	Shipping Last Name (type: text).
`shipping_address.name`	Shipping Name (type: text).
`shipping_address.phone`	Shipping Phone (type: text).
`shipping_address.province`	Shipping Province (type: text).
`shipping_address.zip`	Shipping Zip (type: text).
`subtotal_price_set.presentment_money.amount`	Subtotal Price (Presentment Currency) (type: number). The sum of all items in the checkout, including discounts but excluding shipping, taxes and tips.
`subtotal_price_set.shop_money.amount`	Subtotal Price (Shop Currency) (type: number). The sum of all items in the checkout, including discounts but excluding shipping, taxes and tips.
`tax_lines.price_set.presentment_money.amount`	Tax Lines Prices (Presentment Currency) (type: text). A comma-separated list of tax line prices in the presentment currency.
`tax_lines.price_set.shop_money.amount`	Tax Lines Prices (Shop Currency) (type: text). A comma-separated list of tax line prices in the shop currency.
`tax_lines.rate`	Tax Lines Rates (type: text). A comma-separated list of tax rates.
`tax_lines.title`	Tax Lines Titles (type: text). A comma-separated list of tax titles.
`total_discount_set.presentment_money.amount`	Total Discount (Presentment Currency) (type: number).
`total_discount_set.shop_money.amount`	Total Discount (Shop Currency) (type: number).
`total_line_items_price_set.presentment_money.amount`	Total Lineitems Price (Presentment Currency) (type: number). The sum of the prices of all line items in the checkout.
`total_line_items_price_set.shop_money.amount`	Total Lineitems Price (Shop Currency) (type: number). The sum of the prices of all line items in the checkout.
`total_price_set.presentment_money.amount`	Total Price (Presentment Currency) (type: number). The sum of all items in the checkout, including discounts, shipping, taxes, and tips.
`total_price_set.presentment_money.currency_code`	Presentment Currency Code (type: text).
`total_price_set.shop_money.amount`	Total Price (Shop Currency) (type: number). The sum of all items in the checkout, including discounts, shipping, taxes, and tips.
`total_price_set.shop_money.currency_code`	Shop Currency Code (type: text).
`total_tax_set.presentment_money.amount`	Total Tax (Presentment Currency) (type: number).
`total_tax_set.shop_money.amount`	Total Tax (Shop Currency) (type: number).
`updated_at`	Updated At (type: datetime). The date and time when the checkout was most recently updated.

App: EZ Exporter

Tags: abandoned checkouts, field reference, shopify, shopify fields