Back to source list
Official
Shopify
The CloudQuery Shopify plugin pulls data from Shopify and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v8.4.7
Type
Source
Platforms
Date Published
Shopify Abandoned Checkouts
The shopify_abandoned_checkouts table shows data for Shopify Abandoned Checkouts.
This table supports incremental syncing. Read more about incremental syncing here.
Primary Keys #
| Name | Type |
|---|---|
| id | int64 |
Incremental Sync Keys #
| Name | Type |
|---|---|
| updated_at | timestamp[us, tz=UTC] |
Columns #
| Name | Type |
|---|---|
| abandoned_checkout_url | utf8 |
| admin_graphql_api_id | 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 |
| default_address | json |
| device_id | int64 |
| discount_codes | json |
utf8 | |
| gateway | utf8 |
| id | int64 |
| landing_site | utf8 |
| name | utf8 |
| note | utf8 |
| note_attributes | json |
| phone | utf8 |
| presentment_currency | utf8 |
| referring_site | utf8 |
| shipping_address | json |
| shipping_lines | json |
| sms_marketing_consent | json |
| sms_marketing_phone | utf8 |
| source | utf8 |
| source_identifier | utf8 |
| source_name | utf8 |
| source_url | utf8 |
| subtotal_price | json |
| taxes_included | bool |
| tax_lines | json |
| token | utf8 |
| total_discounts | json |
| total_duties | utf8 |
| total_line_items_price | json |
| total_price | json |
| total_weight | int64 |
| updated_at | timestamp[us, tz=UTC] |
| user_id | int64 |