Shopify

Setting up the Shopify connector

No	Item	Required	Example	Notes
1	Shopify Store	Yes		The name of your Shopify store found in the URL. For example, if your URL was https://NAME.myshopify.com, then the name would be 'NAME'.
2	Shopify Authorization Method	Yes		The authorization method to use to retrieve data from Shopify Refer to the documentation in the form while using the connector API Password OAuth2.0
3	Replication Start Date	Yes	2021-01-01	The date you would like to replicate data from. Format: YYYY-MM-DD. Any data before this date will not be replicated.

Tables in the Shopify connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	products_graph_ql	22		Incremental, Full Refresh	updatedAt
2	metafield_products	13		Incremental, Full Refresh	updated_at
3	smart_collections	13		Incremental, Full Refresh	updated_at
4	shop	55		Full Refresh		API Reference
5	blogs	12		Incremental, Full Refresh	updated_at	API Reference
6	metafield_articles	13		Incremental, Full Refresh	updated_at
7	metafield_product_variants	13		Incremental, Full Refresh	updated_at
8	tender_transactions	10		Incremental, Full Refresh	processed_at
9	metafield_orders	13		Incremental, Full Refresh	updated_at
10	inventory_levels	6		Full Refresh, Incremental	updated_at
11	products	19		Incremental, Full Refresh	updated_at	API Reference
12	product_images	9		Incremental, Full Refresh	updated_at
13	fulfillments	19		Full Refresh, Incremental	updated_at	API Reference
14	pages	11		Full Refresh, Incremental	updated_at	API Reference
15	balance_transactions	15		Incremental, Full Refresh	id
16	collections	13		Incremental, Full Refresh	updated_at	API Reference
17	price_rules	30		Full Refresh, Incremental	updated_at
18	abandoned_checkouts	42		Incremental, Full Refresh	updated_at
19	order_risks	11		Incremental, Full Refresh	id
20	customers	24		Incremental, Full Refresh	updated_at	API Reference
21	metafield_blogs	12		Incremental, Full Refresh	updated_at
22	collects	8		Incremental, Full Refresh	id	API Reference
23	metafield_collections	12		Incremental, Full Refresh	updated_at
24	metafield_pages	13		Incremental, Full Refresh	updated_at
25	custom_collections	12		Incremental, Full Refresh	updated_at
26	fulfillment_orders	15		Full Refresh, Incremental	id
27	draft_orders	28		Incremental, Full Refresh	updated_at
28	metafield_draft_orders	13		Incremental, Full Refresh	updated_at
29	product_variants	28		Incremental, Full Refresh	updated_at
30	transactions	21		Incremental, Full Refresh	created_at	API Reference
31	inventory_items	7		Full Refresh, Incremental	updated_at
32	metafield_locations	13		Incremental, Full Refresh	updated_at
33	metafield_customers	13		Incremental, Full Refresh	updated_at
34	metafield_product_images	13		Incremental, Full Refresh	updated_at
35	metafield_smart_collections	13		Incremental, Full Refresh	updated_at
36	order_refunds	12		Incremental, Full Refresh	created_at
37	locations	17		Full Refresh	id	API Reference
38	orders	85		Incremental, Full Refresh	updated_at	API Reference
39	metafield_shops	13		Incremental, Full Refresh	updated_at
40	discount_codes	7		Full Refresh, Incremental	updated_at
41	articles	15		Incremental, Full Refresh	updated_at	API Reference

Table: products_graph_ql

No	Column Name	Type	Notes
1	isGiftCard	BOOLEAN
2	publishedAt	VARCHAR
3	description	VARCHAR
4	onlineStorePreviewUrl	VARCHAR
5	handle	VARCHAR
6	totalVariants	INTEGER
7	totalInventory	INTEGER
8	tracksInventory	BOOLEAN
9	title	VARCHAR
10	tags	VARCHAR
11	createdAt	VARCHAR
12	legacyResourceId	VARCHAR
13	shop_url	VARCHAR
14	vendor	VARCHAR
15	mediaCount	INTEGER
16	options	VARCHAR
17	onlineStoreUrl	VARCHAR
18	descriptionHtml	VARCHAR
19	id	VARCHAR
20	productType	VARCHAR
21	status	VARCHAR
22	updatedAt	VARCHAR	Incremental sync key

Table: metafield_products

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: smart_collections

No	Column Name	Type	Notes
1	body_html	VARCHAR
2	handle	VARCHAR
3	rules	VARCHAR
4	title	VARCHAR
5	published_scope	VARCHAR
6	template_suffix	VARCHAR
7	updated_at	VARCHAR	Incremental sync key
8	disjunctive	BOOLEAN
9	shop_url	VARCHAR
10	admin_graphql_api_id	VARCHAR
11	id	INTEGER
12	published_at	VARCHAR
13	sort_order	VARCHAR

Table: shop

No	Column Name	Type	Notes
1	country	VARCHAR
2	multi_location_enabled	BOOLEAN
3	source	VARCHAR
4	money_with_currency_in_emails_format	VARCHAR
5	province_code	VARCHAR
6	plan_display_name	VARCHAR
7	province	VARCHAR
8	eligible_for_payments	BOOLEAN
9	id	INTEGER
10	longitude	DOUBLE
11	has_discounts	BOOLEAN
12	zip	VARCHAR
13	force_ssl	BOOLEAN
14	password_enabled	BOOLEAN
15	eligible_for_card_reader_giveaway	BOOLEAN
16	iana_timezone	VARCHAR
17	auto_configure_tax_inclusivity	VARCHAR
18	enabled_presentment_currencies	VARCHAR
19	plan_name	VARCHAR
20	requires_extra_payments_agreement	BOOLEAN
21	country_code	VARCHAR
22	cookie_consent_level	VARCHAR
23	weight_unit	VARCHAR
24	phone	VARCHAR
25	customer_email	VARCHAR
26	domain	VARCHAR
27	county_taxes	BOOLEAN
28	money_with_currency_format	VARCHAR
29	name	VARCHAR
30	money_in_emails_format	VARCHAR
31	finances	BOOLEAN
32	shop_owner	VARCHAR
33	pre_launch_enabled	BOOLEAN
34	city	VARCHAR
35	timezone	VARCHAR
36	latitude	DOUBLE
37	created_at	VARCHAR
38	checkout_api_supported	BOOLEAN
39	taxes_included	BOOLEAN
40	setup_required	BOOLEAN
41	money_format	VARCHAR
42	updated_at	VARCHAR
43	shop_url	VARCHAR
44	country_name	VARCHAR
45	currency	VARCHAR
46	email	VARCHAR
47	primary_location_id	INTEGER
48	google_apps_login_enabled	BOOLEAN
49	address2	VARCHAR
50	address1	VARCHAR
51	primary_locale	VARCHAR
52	has_storefront	BOOLEAN
53	tax_shipping	BOOLEAN
54	google_apps_domain	VARCHAR
55	myshopify_domain	VARCHAR

Table: blogs

No	Column Name	Type	Notes
1	feedburner	VARCHAR
2	template_suffix	VARCHAR
3	updated_at	VARCHAR	Incremental sync key
4	shop_url	VARCHAR
5	feedburner_location	INTEGER
6	admin_graphql_api_id	VARCHAR
7	created_at	VARCHAR
8	handle	VARCHAR
9	id	INTEGER
10	title	VARCHAR
11	commentable	VARCHAR
12	tags	VARCHAR

Table: metafield_articles

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: metafield_product_variants

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: tender_transactions

No	Column Name	Type	Notes
1	amount	VARCHAR
2	test	BOOLEAN
3	payment_details	VARCHAR
4	user_id	INTEGER
5	remote_reference	VARCHAR
6	processed_at	VARCHAR	Incremental sync key
7	currency	VARCHAR
8	id	INTEGER
9	order_id	INTEGER
10	payment_method	VARCHAR

Table: metafield_orders

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: inventory_levels

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	inventory_item_id	INTEGER
3	shop_url	VARCHAR
4	available	INTEGER
5	id	VARCHAR
6	location_id	INTEGER

Table: products

No	Column Name	Type	Notes
1	image	VARCHAR
2	body_html	VARCHAR
3	images	VARCHAR
4	created_at	VARCHAR
5	handle	VARCHAR
6	variants	VARCHAR
7	title	VARCHAR
8	tags	VARCHAR
9	published_scope	VARCHAR
10	product_type	VARCHAR
11	template_suffix	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	vendor	VARCHAR
14	shop_url	VARCHAR
15	admin_graphql_api_id	VARCHAR
16	options	VARCHAR
17	id	INTEGER
18	published_at	VARCHAR
19	status	VARCHAR

Table: product_images

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	src	VARCHAR
3	product_id	INTEGER
4	width	INTEGER
5	created_at	VARCHAR
6	variant_ids	VARCHAR
7	id	INTEGER
8	position	INTEGER
9	height	INTEGER

Table: fulfillments

No	Column Name	Type	Notes
1	created_at	VARCHAR
2	origin_address	VARCHAR
3	tracking_company	VARCHAR
4	line_items	VARCHAR
5	variant_inventory_management	VARCHAR
6	tracking_urls	VARCHAR
7	location_id	INTEGER
8	updated_at	VARCHAR	Incremental sync key
9	service	VARCHAR
10	shop_url	VARCHAR
11	name	VARCHAR
12	receipt	VARCHAR
13	id	INTEGER
14	tracking_numbers	VARCHAR
15	order_id	INTEGER
16	notify_customer	BOOLEAN
17	shipment_status	VARCHAR
18	status	VARCHAR
19	duties	VARCHAR

Table: pages

No	Column Name	Type	Notes
1	shop_id	INTEGER
2	body_html	VARCHAR
3	template_suffix	VARCHAR
4	updated_at	VARCHAR	Incremental sync key
5	author	VARCHAR
6	shop_url	VARCHAR
7	created_at	VARCHAR
8	handle	VARCHAR
9	id	INTEGER
10	published_at	VARCHAR
11	title	VARCHAR

Table: balance_transactions

No	Column Name	Type	Notes
1	amount	DOUBLE
2	test	BOOLEAN
3	fee	DOUBLE
4	payoucurrencyt_status	VARCHAR
5	source_type	VARCHAR
6	source_order_id	INTEGER
7	type	VARCHAR
8	payout_id	INTEGER
9	payout_status	VARCHAR
10	shop_url	VARCHAR
11	source_order_transaction_id	INTEGER
12	processed_at	VARCHAR
13	id	INTEGER	Incremental sync key
14	source_id	INTEGER
15	net	DOUBLE

Table: collections

No	Column Name	Type	Notes
1	body_html	VARCHAR
2	products_count	INTEGER
3	handle	VARCHAR
4	title	VARCHAR
5	collection_type	VARCHAR
6	published_scope	VARCHAR
7	template_suffix	VARCHAR
8	updated_at	VARCHAR	Incremental sync key
9	shop_url	VARCHAR
10	admin_graphql_api_id	VARCHAR
11	id	INTEGER
12	published_at	VARCHAR
13	sort_order	VARCHAR

Table: price_rules

No	Column Name	Type	Notes
1	once_per_customer	BOOLEAN
2	starts_at	VARCHAR
3	usage_limit	INTEGER
4	value_type	VARCHAR
5	created_at	VARCHAR
6	prerequisite_customer_ids	VARCHAR
7	title	VARCHAR
8	entitled_collection_ids	VARCHAR
9	updated_at	VARCHAR	Incremental sync key
10	prerequisite_product_ids	VARCHAR
11	prerequisite_shipping_price_range	VARCHAR
12	shop_url	VARCHAR
13	entitled_country_ids	VARCHAR
14	entitled_variant_ids	VARCHAR
15	ends_at	VARCHAR
16	id	INTEGER
17	value	VARCHAR
18	prerequisite_subtotal_range	VARCHAR
19	allocation_method	VARCHAR
20	prerequisite_to_entitlement_quantity_ratio	VARCHAR
21	prerequisite_quantity_range	VARCHAR
22	allocation_limit	INTEGER
23	target_type	VARCHAR
24	entitled_product_ids	VARCHAR
25	customer_selection	VARCHAR
26	prerequisite_saved_search_ids	VARCHAR
27	prerequisite_variant_ids	VARCHAR
28	target_selection	VARCHAR
29	prerequisite_to_entitlement_purchase	VARCHAR
30	prerequisite_collection_ids	VARCHAR

Table: abandoned_checkouts

No	Column Name	Type	Notes
1	note	VARCHAR
2	created_at	VARCHAR
3	billing_address	VARCHAR
4	line_items	VARCHAR
5	source	VARCHAR
6	taxes_included	BOOLEAN
7	buyer_accepts_marketing	BOOLEAN
8	presentment_currency	VARCHAR
9	location_id	INTEGER
10	total_weight	INTEGER
11	source_url	VARCHAR
12	source_identifier	VARCHAR
13	landing_site	VARCHAR
14	total_discounts	DOUBLE
15	updated_at	VARCHAR	Incremental sync key
16	referring_site	VARCHAR
17	tax_lines	VARCHAR
18	shop_url	VARCHAR
19	customer_locale	VARCHAR
20	currency	VARCHAR
21	id	INTEGER
22	shipping_address	VARCHAR
23	abandoned_checkout_url	VARCHAR
24	email	VARCHAR
25	source_name	VARCHAR
26	subtotal_price	DOUBLE
27	closed_at	VARCHAR
28	device_id	INTEGER
29	total_price	DOUBLE
30	total_line_items_price	DOUBLE
31	total_tax	DOUBLE
32	token	VARCHAR
33	completed_at	VARCHAR
34	shipping_lines	VARCHAR
35	phone	VARCHAR
36	user_id	INTEGER
37	note_attributes	VARCHAR
38	name	VARCHAR
39	cart_token	VARCHAR
40	discount_codes	VARCHAR
41	gateway	VARCHAR
42	customer	VARCHAR

Table: order_risks

No	Column Name	Type	Notes
1	score	DOUBLE
2	checkout_id	INTEGER
3	shop_url	VARCHAR
4	display	BOOLEAN
5	recommendation	VARCHAR
6	cause_cancel	BOOLEAN
7	merchant_message	VARCHAR
8	id	INTEGER	Incremental sync key
9	source	VARCHAR
10	message	VARCHAR
11	order_id	INTEGER

Table: customers

No	Column Name	Type	Notes
1	total_spent	DOUBLE
2	note	VARCHAR
3	addresses	VARCHAR
4	last_order_name	VARCHAR
5	last_order_id	INTEGER
6	tax_exempt	BOOLEAN
7	multipass_identifier	VARCHAR
8	last_name	VARCHAR
9	created_at	VARCHAR
10	verified_email	BOOLEAN
11	tags	VARCHAR
12	accepts_marketing_updated_at	VARCHAR
13	orders_count	INTEGER
14	default_address	VARCHAR
15	updated_at	VARCHAR	Incremental sync key
16	phone	VARCHAR
17	accepts_marketing	BOOLEAN
18	shop_url	VARCHAR
19	admin_graphql_api_id	VARCHAR
20	currency	VARCHAR
21	state	VARCHAR
22	id	INTEGER
23	first_name	VARCHAR
24	email	VARCHAR

Table: metafield_blogs

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	updated_at	VARCHAR	Incremental sync key
3	owner_id	INTEGER
4	shop_url	VARCHAR
5	admin_graphql_api_id	VARCHAR
6	namespace	VARCHAR
7	created_at	VARCHAR
8	description	VARCHAR
9	id	INTEGER
10	owner_resource	VARCHAR
11	value	VARCHAR
12	key	VARCHAR

Table: collects

No	Column Name	Type	Notes
1	collection_id	INTEGER
2	updated_at	VARCHAR
3	shop_url	VARCHAR
4	product_id	INTEGER
5	created_at	VARCHAR
6	id	INTEGER	Incremental sync key
7	position	INTEGER
8	sort_value	VARCHAR

Table: metafield_collections

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	updated_at	VARCHAR	Incremental sync key
3	owner_id	INTEGER
4	shop_url	VARCHAR
5	admin_graphql_api_id	VARCHAR
6	namespace	VARCHAR
7	created_at	VARCHAR
8	description	VARCHAR
9	id	INTEGER
10	owner_resource	VARCHAR
11	value	VARCHAR
12	key	VARCHAR

Table: metafield_pages

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: custom_collections

No	Column Name	Type	Notes
1	published_scope	VARCHAR
2	image	VARCHAR
3	body_html	VARCHAR
4	template_suffix	VARCHAR
5	updated_at	VARCHAR	Incremental sync key
6	shop_url	VARCHAR
7	admin_graphql_api_id	VARCHAR
8	handle	VARCHAR
9	id	INTEGER
10	title	VARCHAR
11	published_at	VARCHAR
12	sort_order	VARCHAR

Table: fulfillment_orders

No	Column Name	Type	Notes
1	fulfilled_at	VARCHAR
2	request_status	VARCHAR
3	fulfillment_holds	VARCHAR
4	destination	VARCHAR
5	line_items	VARCHAR
6	shop_id	INTEGER
7	shop_url	VARCHAR
8	delivery_method	VARCHAR
9	assigned_location_id	INTEGER
10	id	INTEGER	Incremental sync key
11	order_id	INTEGER
12	supported_actions	VARCHAR
13	merchant_requests	VARCHAR
14	assigned_location	VARCHAR
15	status	VARCHAR

Table: draft_orders

No	Column Name	Type	Notes
1	note	VARCHAR
2	applied_discount	VARCHAR
3	created_at	VARCHAR
4	billing_address	VARCHAR
5	taxes_included	BOOLEAN
6	line_items	VARCHAR
7	updated_at	VARCHAR	Incremental sync key
8	tax_lines	VARCHAR
9	shop_url	VARCHAR
10	currency	VARCHAR
11	id	INTEGER
12	shipping_address	VARCHAR
13	email	VARCHAR
14	subtotal_price	VARCHAR
15	total_price	VARCHAR
16	tax_exempt	BOOLEAN
17	invoice_sent_at	VARCHAR
18	total_tax	VARCHAR
19	tags	VARCHAR
20	completed_at	VARCHAR
21	note_attributes	VARCHAR
22	admin_graphql_api_id	VARCHAR
23	name	VARCHAR
24	shipping_line	VARCHAR
25	order_id	INTEGER
26	invoice_url	VARCHAR
27	status	VARCHAR
28	customer	VARCHAR

Table: metafield_draft_orders

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: product_variants

No	Column Name	Type	Notes
1	presentment_prices	VARCHAR
2	inventory_management	VARCHAR
3	old_inventory_quantity	INTEGER
4	requires_shipping	BOOLEAN
5	created_at	VARCHAR
6	title	VARCHAR
7	updated_at	VARCHAR	Incremental sync key
8	inventory_item_id	INTEGER
9	price	DOUBLE
10	shop_url	VARCHAR
11	product_id	INTEGER
12	option3	VARCHAR
13	option1	VARCHAR
14	id	INTEGER
15	option2	VARCHAR
16	sku	VARCHAR
17	grams	INTEGER
18	barcode	VARCHAR
19	inventory_quantity	INTEGER
20	compare_at_price	VARCHAR
21	fulfillment_service	VARCHAR
22	taxable	BOOLEAN
23	weight	DOUBLE
24	inventory_policy	VARCHAR
25	weight_unit	VARCHAR
26	admin_graphql_api_id	VARCHAR
27	position	INTEGER
28	image_id	INTEGER

Table: transactions

No	Column Name	Type	Notes
1	amount	DOUBLE
2	device_id	INTEGER
3	test	BOOLEAN
4	payment_details	VARCHAR
5	kind	VARCHAR
6	created_at	VARCHAR	Incremental sync key
7	message	VARCHAR
8	location_id	INTEGER
9	authorization	VARCHAR
10	user_id	INTEGER
11	parent_id	INTEGER
12	shop_url	VARCHAR
13	admin_graphql_api_id	VARCHAR
14	error_code	VARCHAR
15	currency	VARCHAR
16	receipt	VARCHAR
17	id	INTEGER
18	order_id	INTEGER
19	source_name	VARCHAR
20	gateway	VARCHAR
21	status	VARCHAR

Table: inventory_items

No	Column Name	Type	Notes
1	cost	DOUBLE
2	updated_at	VARCHAR	Incremental sync key
3	shop_url	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER
6	country_code_of_origin	VARCHAR
7	sku	VARCHAR

Table: metafield_locations

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: metafield_customers

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: metafield_product_images

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: metafield_smart_collections

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: order_refunds

No	Column Name	Type	Notes
1	note	VARCHAR
2	refund_line_items	VARCHAR
3	user_id	INTEGER
4	shop_url	VARCHAR
5	admin_graphql_api_id	VARCHAR
6	order_adjustments	VARCHAR
7	restock	BOOLEAN
8	processed_at	VARCHAR
9	created_at	VARCHAR	Incremental sync key
10	id	INTEGER
11	transactions	VARCHAR
12	order_id	INTEGER

Table: locations

No	Column Name	Type	Notes
1	zip	VARCHAR
2	country	VARCHAR
3	legacy	BOOLEAN
4	localized_country_name	VARCHAR
5	address2	VARCHAR
6	city	VARCHAR
7	address1	VARCHAR
8	localized_province_name	VARCHAR
9	active	BOOLEAN
10	created_at	VARCHAR
11	country_code	VARCHAR
12	province	VARCHAR
13	updated_at	VARCHAR
14	phone	VARCHAR
15	shop_url	VARCHAR
16	name	VARCHAR
17	id	INTEGER	Incremental sync key

Table: orders

No	Column Name	Type	Notes
1	cancelled_at	VARCHAR
2	fulfillment_status	VARCHAR
3	total_price_usd	DOUBLE
4	current_total_discounts_set	VARCHAR
5	billing_address	VARCHAR
6	line_items	VARCHAR
7	original_total_duties_set	VARCHAR
8	presentment_currency	VARCHAR
9	total_discounts_set	VARCHAR
10	location_id	INTEGER
11	source_url	VARCHAR
12	landing_site	VARCHAR
13	source_identifier	VARCHAR
14	reference	VARCHAR
15	number	INTEGER
16	checkout_id	INTEGER
17	checkout_token	VARCHAR
18	tax_lines	VARCHAR
19	current_total_discounts	DOUBLE
20	customer_locale	VARCHAR
21	id	INTEGER
22	app_id	INTEGER
23	subtotal_price	DOUBLE
24	closed_at	VARCHAR
25	order_status_url	VARCHAR
26	current_total_price_set	VARCHAR
27	device_id	VARCHAR
28	test	BOOLEAN
29	total_shipping_price_set	VARCHAR
30	subtotal_price_set	VARCHAR
31	payment_gateway_names	VARCHAR
32	total_tax	DOUBLE
33	discount_allocations	VARCHAR
34	tags	VARCHAR
35	current_subtotal_price_set	VARCHAR
36	processing_method	VARCHAR
37	current_total_tax	DOUBLE
38	shipping_lines	VARCHAR
39	phone	VARCHAR
40	user_id	DOUBLE
41	note_attributes	VARCHAR
42	name	VARCHAR
43	cart_token	VARCHAR
44	total_tax_set	VARCHAR
45	landing_site_ref	VARCHAR
46	discount_codes	VARCHAR
47	note	VARCHAR
48	current_subtotal_price	DOUBLE
49	current_total_tax_set	VARCHAR
50	payment_details	VARCHAR
51	total_outstanding	DOUBLE
52	order_number	INTEGER
53	discount_applications	VARCHAR
54	created_at	VARCHAR
55	total_line_items_price_set	VARCHAR
56	taxes_included	BOOLEAN
57	buyer_accepts_marketing	BOOLEAN
58	confirmed	BOOLEAN
59	total_weight	INTEGER
60	contact_email	VARCHAR
61	refunds	VARCHAR
62	total_discounts	DOUBLE
63	fulfillments	VARCHAR
64	client_details	VARCHAR
65	referring_site	VARCHAR
66	updated_at	VARCHAR	Incremental sync key
67	shop_url	VARCHAR
68	processed_at	VARCHAR
69	currency	VARCHAR
70	shipping_address	VARCHAR
71	browser_ip	VARCHAR
72	email	VARCHAR
73	source_name	VARCHAR
74	total_price_set	VARCHAR
75	current_total_duties_set	VARCHAR
76	total_price	DOUBLE
77	total_line_items_price	DOUBLE
78	total_tip_received	DOUBLE
79	token	VARCHAR
80	cancel_reason	VARCHAR
81	current_total_price	DOUBLE
82	admin_graphql_api_id	VARCHAR
83	financial_status	VARCHAR
84	gateway	VARCHAR
85	customer	VARCHAR

Table: metafield_shops

No	Column Name	Type	Notes
1	value_type	VARCHAR
2	owner_id	INTEGER
3	description	VARCHAR
4	created_at	VARCHAR
5	type	VARCHAR
6	updated_at	VARCHAR	Incremental sync key
7	shop_url	VARCHAR
8	admin_graphql_api_id	VARCHAR
9	namespace	VARCHAR
10	id	INTEGER
11	value	VARCHAR
12	owner_resource	VARCHAR
13	key	VARCHAR

Table: discount_codes

No	Column Name	Type	Notes
1	usage_count	INTEGER
2	code	VARCHAR
3	updated_at	VARCHAR	Incremental sync key
4	shop_url	VARCHAR
5	price_rule_id	INTEGER
6	created_at	VARCHAR
7	id	INTEGER

Table: articles

No	Column Name	Type	Notes
1	body_html	VARCHAR
2	blog_id	INTEGER
3	author	VARCHAR
4	created_at	VARCHAR
5	handle	VARCHAR
6	title	VARCHAR
7	tags	VARCHAR
8	template_suffix	VARCHAR
9	updated_at	VARCHAR	Incremental sync key
10	user_id	VARCHAR
11	shop_url	VARCHAR
12	admin_graphql_api_id	VARCHAR
13	id	INTEGER
14	published_at	VARCHAR
15	summary_html	VARCHAR

External Resources

• Shopify Rest Api
• Shopify Graphql Api
• Abandoned Checkouts
• Custom Collections
• Draft Orders
• Discount Codes
• Metafields
• Orders Refunds
• Orders Risks
• Products (graphql)
• Balance Transactions
• Price Rules
• Inventoryitems
• Inventorylevels
• Fulfillment Orders
• Smart Collections
• Product Images
• Product Variants
• Tender Transactions
• Rate Limit Restrictions

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.