CData Python Connector for Shopify

Build 23.0.8839

AbandonedCheckouts

Query abandoned checkouts.

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 AbandonedCheckouts WHERE CreatedAt > '2017-10-25'

Columns

Name Type References Description
Id [KEY] Long The unique numeric identifier for the order.
AbandonedCheckoutUrl String The full recovery URL to be sent to a customer to recover their abandoned checkout.
BuyerAcceptsMarketing Bool Indicates whether or not the person who placed the order would like to receive email updates from the shop.
CancelReason String The reason why the order was cancelled.
CartToken String Unique identifier for a particular cart that is attached to a particular order.
Currency String The three letter code (ISO 4217) for the currency used for the payment.
CustomerId Long

Customers.Id

A unique numeric identifier for the customer.
DiscountCodes String Applicable discount codes that can be applied to the order.
Email String The customer's email address.
Note String The text of an optional note that a shop owner can attach to the order.
LandingSite String The URL for the page where the buyer landed when entering the shop.
ReferringSite String The website that the customer clicked on to come to the shop.
SourceName String Where the order originated.
SubtotalPrice Decimal Price of the order before shipping and taxes.
TotalDiscounts Decimal The total amount of the discounts to be applied to the price of the order.
TotalLineItemsPrice Decimal The sum of all the prices of all the items in the order.
TotalPrice Decimal The sum of all the prices of all the items in the order, taxes and discounts included.
TotalTax Decimal The sum of all the taxes applied to the order.
TotalWeight Double The sum of all the weights of the line items in the order, in grams.
TaxesIncluded Bool States whether or not taxes are included in the order subtotal.
Token String Unique identifier for a particular order.
BillingAddressFirstName String The first name of the person associated with the payment method.
BillingAddressLastName String The last name of the person associated with the payment method.
BillingAddressAdress1 String The street address of the billing address.
BillingAddressAdress2 String An optional additional field for the street address of the billing address.
BillingAddressPhone String The phone number at the billing address.
BillingAddressCity String The city of the billing address.
BillingAddressCompany String The company of the person associated with the billing address.
BillingAddressZip String The zip or postal code of the billing address.
BillingAddressProvince String The name of the state or province of the billing address.
BillingAddressCountry String The name of the country of the billing address.
BillingAddressLatitude Double The latitude of the billing address.
BillingAddressLongitude Double The longitude of the billing address.
BillingAddressName String The full name of the person associated with the payment method.
BillingAddressCountryCode String The two-letter code for the country of the billing address.
BillingAddressProvinceCode String The two-letter abbreviation of the state or province of the billing address.
BillingAddressDefault Bool Whether this address is the default one or not.
ShippingAddressFirstName String The first name of the person associated with the shipping address.
ShippingAddressLastName String The last name of the person associated with the shipping address.
ShippingAddressAdress1 String The street address of the shipping address.
ShippingAddressAdress2 String An optional additional field for the street address of the shipping address.
ShippingAddressPhone String The phone number at the shipping address.
ShippingAddressCity String The city of the shipping address.
ShippingAddressCompany String The company of the person associated with the shipping address.
ShippingAddressZip String The zip or postal code of the shipping address.
ShippingAddressProvince String The name of the state or province of the shipping address.
ShippingAddressCountry String The name of the country of the shipping address.
ShippingAddressLatitude Double The latitude of the shipping address.
ShippingAddressLongitude Double The longitude of the shipping address.
ShippingAddressName String The full name of the person associated with the shipping address.
ShippingAddressCountryCode String The two-letter code for the country of the shipping address.
ShippingAddressProvinceCode String The two-letter abbreviation of the state or province of the shipping address.
ShippingAddressDefault Bool Whether this address is the default one or not.
ClosedAt Datetime The date and time when the order was closed.
CompletedAt Datetime CompletedAt
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