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
| Name | Type |
|---|---|
| _cq_source_name | utf8 |
| _cq_sync_time | timestamp[us, tz=UTC] |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| id (PK) | int64 |
| updated_at (Incremental Key) | timestamp[us, tz=UTC] |
| token | utf8 |
| cart_token | utf8 |
| utf8 | |
| gateway | utf8 |
| buyer_accepts_marketing | bool |
| created_at | timestamp[us, tz=UTC] |
| landing_site | utf8 |
| note_attributes | json |
| referring_site | utf8 |
| shipping_lines | json |
| taxes_included | bool |
| total_weight | int64 |
| currency | utf8 |
| completed_at | timestamp[us, tz=UTC] |
| closed_at | timestamp[us, tz=UTC] |
| user_id | int64 |
| customer_locale | utf8 |
| line_items | json |
| name | utf8 |
| abandoned_checkout_url | utf8 |
| discount_codes | json |
| tax_lines | json |
| source_name | utf8 |
| presentment_currency | utf8 |
| buyer_accepts_sms_marketing | bool |
| total_discounts | utf8 |
| total_line_items_price | utf8 |
| total_price | utf8 |
| total_tax | utf8 |
| subtotal_price | utf8 |
| customer | json |
