Back to plugin list
Official
Premium
Shopify
This plugin is in preview.
The CloudQuery Shopify plugin pulls data from Shopify and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v4.0.0
Type
Source
Date Published
Nov 9, 2023
Category
Sales & Marketing
Price
Free while in preview
Shopify Customers
The shopify_customers table shows data for Shopify Customers.
The primary key for this table is id.
It supports incremental syncs based on the updated_at column.
Columns
| Name | Type |
|---|---|
| accepts_marketing | bool |
| accepts_marketing_updated_at | timestamp[us, tz=UTC] |
| addresses | json |
| admin_graphql_api_id | utf8 |
| _cq_id | uuid |
| _cq_parent_id | uuid |
| created_at | timestamp[us, tz=UTC] |
| currency | utf8 |
| default_address | json |
utf8 | |
| email_marketing_consent | json |
| first_name | utf8 |
| id | int64 |
| last_name | utf8 |
| last_order_id | int64 |
| last_order_name | utf8 |
| marketing_opt_in_level | utf8 |
| orders_count | int64 |
| state | utf8 |
| tags | utf8 |
| tax_exempt | bool |
| tax_exemptions | json |
| total_spent | utf8 |
| updated_at | timestamp[us, tz=UTC] |
| verified_email | bool |
