Table: shopify_abandoned_checkouts

This table shows data for Shopify Abandoned Checkouts.

The primary key for this table is id. It supports incremental syncs based on the updated_at column.

Columns

NameType
_cq_source_nameString
_cq_sync_timeTimestamp
_cq_idUUID
_cq_parent_idUUID
id (PK)Int
updated_at (Incremental Key)Timestamp
tokenString
cart_tokenString
emailString
gatewayString
buyer_accepts_marketingBool
created_atTimestamp
landing_siteString
note_attributesJSON
referring_siteString
shipping_linesJSON
taxes_includedBool
total_weightInt
currencyString
completed_atTimestamp
closed_atTimestamp
user_idInt
customer_localeString
line_itemsJSON
nameString
abandoned_checkout_urlString
discount_codesJSON
tax_linesJSON
source_nameString
presentment_currencyString
buyer_accepts_sms_marketingBool
total_discountsString
total_line_items_priceString
total_priceString
total_taxString
subtotal_priceString
customerJSON