Back to plugin list
Official
Premium
Shopify
The CloudQuery Shopify plugin pulls data from Shopify and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v5.1.4
Type
Source
Platforms
Date Published
Mar 12, 2024
Price per 1M rows
$20
free quota
1M rows
Shopify Abandoned Checkouts
The shopify_abandoned_checkouts 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
Name | Type |
---|---|
abandoned_checkout_url | utf8 |
billing_address | json |
buyer_accepts_marketing | bool |
buyer_accepts_sms_marketing | bool |
cart_token | utf8 |
closed_at | timestamp[us, tz=UTC] |
completed_at | timestamp[us, tz=UTC] |
_cq_id | uuid |
_cq_parent_id | uuid |
created_at | timestamp[us, tz=UTC] |
currency | utf8 |
customer | json |
customer_locale | utf8 |
device_id | utf8 |
discount_codes | json |
utf8 | |
gateway | utf8 |
id | int64 |
landing_site | utf8 |
line_items | json |
location_id | int64 |
name | utf8 |
note | utf8 |
note_attributes | json |
phone | utf8 |
presentment_currency | utf8 |
referring_site | utf8 |
shipping_line | json |
shipping_rate | json |
sms_marketing_phone | utf8 |
source | utf8 |
source_identifier | utf8 |
source_name | utf8 |
source_url | utf8 |
subtotal_price | utf8 |
taxes_included | bool |
tax_lines | json |
token | utf8 |
total_discounts | utf8 |
total_duties | json |
total_line_items_price | utf8 |
total_price | utf8 |
total_tax | utf8 |
total_weight | int64 |
updated_at | timestamp[us, tz=UTC] |
user_id | int64 |