Woocommerce

Tables in the Woocommerce connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	payment_gateways	9		Full Refresh
2	product_shipping_classes	5		Full Refresh
3	order_notes	7		Full Refresh
4	shipping_zone_methods	8		Full Refresh
5	product_attributes	6		Full Refresh
6	tax_classes	2		Full Refresh
7	shipping_zone_locations	2		Full Refresh
8	product_reviews	10		Full Refresh, Incremental
9	tax_rates	14		Full Refresh
10	products	65		Full Refresh, Incremental		API Reference
11	system_status_tools	7		Full Refresh
12	refunds	10		Full Refresh		API Reference
13	product_tags	5		Full Refresh
14	shipping_zones	3		Full Refresh
15	shipping_methods	3		Full Refresh
16	coupons	29		Full Refresh, Incremental		API Reference
17	product_categories	9		Full Refresh
18	product_variations	39		Full Refresh
19	orders	44		Full Refresh, Incremental		API Reference
20	customers	17		Full Refresh, Incremental		API Reference
21	product_attribute_terms	6		Full Refresh

Table: payment_gateways

No	Column Name	Type	Notes
1	method_supports	VARCHAR
2	settings	VARCHAR
3	method_description	VARCHAR
4	description	VARCHAR
5	id	VARCHAR
6	title	VARCHAR
7	enabled	BOOLEAN
8	method_title	VARCHAR
9	order	VARCHAR

Table: product_shipping_classes

No	Column Name	Type	Notes
1	name	VARCHAR
2	count	INTEGER
3	description	VARCHAR
4	id	INTEGER
5	slug	VARCHAR

Table: order_notes

No	Column Name	Type	Notes
1	note	VARCHAR
2	author	VARCHAR
3	date_created	VARCHAR
4	added_by_user	BOOLEAN
5	date_created_gmt	VARCHAR
6	custom_note	BOOLEAN
7	id	INTEGER

Table: shipping_zone_methods

No	Column Name	Type	Notes
1	settings	VARCHAR
2	instance_id	INTEGER
3	method_id	VARCHAR
4	method_description	VARCHAR
5	title	VARCHAR
6	enabled	BOOLEAN
7	method_title	VARCHAR
8	order	INTEGER

Table: product_attributes

No	Column Name	Type	Notes
1	name	VARCHAR
2	order_by	VARCHAR
3	id	INTEGER
4	type	VARCHAR
5	slug	VARCHAR
6	has_archives	BOOLEAN

Table: tax_classes

No	Column Name	Type	Notes
1	name	VARCHAR
2	slug	VARCHAR

Table: shipping_zone_locations

No	Column Name	Type	Notes
1	code	VARCHAR
2	type	VARCHAR

Table: product_reviews

No	Column Name	Type	Notes
1	date_created	VARCHAR
2	review	VARCHAR
3	product_id	INTEGER
4	rating	INTEGER
5	verified	BOOLEAN
6	date_created_gmt	VARCHAR
7	id	INTEGER
8	reviewer	VARCHAR
9	reviewer_email	VARCHAR
10	status	VARCHAR

Table: tax_rates

No	Column Name	Type	Notes
1	country	VARCHAR
2	cities	VARCHAR
3	city	VARCHAR
4	postcode	VARCHAR
5	priority	INTEGER
6	compound	BOOLEAN
7	shipping	BOOLEAN
8	rate	VARCHAR
9	name	VARCHAR
10	id	INTEGER
11	state	VARCHAR
12	class	VARCHAR
13	postcodes	VARCHAR
14	order	INTEGER

Table: products

No	Column Name	Type	Notes
1	upsell_ids	VARCHAR
2	purchasable	BOOLEAN
3	grouped_products	VARCHAR
4	tax_status	VARCHAR
5	catalog_visibility	VARCHAR
6	type	VARCHAR
7	features	BOOLEAN
8	external_url	VARCHAR
9	price	VARCHAR
10	meta_data	VARCHAR
11	id	INTEGER
12	sku	VARCHAR
13	slug	VARCHAR
14	date_on_sale_from	VARCHAR
15	shipping_required	BOOLEAN
16	date_modified_gmt	VARCHAR
17	images	VARCHAR
18	stock_status	VARCHAR
19	price_html	VARCHAR
20	download_expiry	INTEGER
21	backordered	BOOLEAN
22	weight	VARCHAR
23	rating_count	INTEGER
24	tags	VARCHAR
25	date_on_sale_to	VARCHAR
26	sold_individually	BOOLEAN
27	backorders	VARCHAR
28	shipping_taxable	BOOLEAN
29	parent_id	INTEGER
30	download_limit	INTEGER
31	name	VARCHAR
32	shipping_class	VARCHAR
33	button_text	VARCHAR
34	permalink	VARCHAR
35	status	VARCHAR
36	cross_sell_ids	VARCHAR
37	short_description	VARCHAR
38	virtual	BOOLEAN
39	downloadable	BOOLEAN
40	menu_order	INTEGER
41	description	VARCHAR
42	date_on_sale_to_gmt	VARCHAR
43	date_on_sale_from_gmt	VARCHAR
44	regular_price	VARCHAR
45	backorders_allowed	BOOLEAN
46	downloads	VARCHAR
47	reviews_allowed	BOOLEAN
48	variations	VARCHAR
49	categories	VARCHAR
50	total_sales	INTEGER
51	on_sale	BOOLEAN
52	manage_stock	BOOLEAN
53	default_attributes	VARCHAR
54	purchase_note	VARCHAR
55	date_created	VARCHAR
56	tax_class	VARCHAR
57	date_created_gmt	VARCHAR
58	average_rating	VARCHAR
59	stock_quantity	INTEGER
60	sale_price	VARCHAR
61	shipping_class_id	INTEGER
62	date_modified	VARCHAR
63	related_ids	VARCHAR
64	attributes	VARCHAR
65	dimensions	VARCHAR

Table: system_status_tools

No	Column Name	Type	Notes
1	confirm	BOOLEAN
2	success	BOOLEAN
3	name	VARCHAR
4	action	VARCHAR
5	description	VARCHAR
6	id	VARCHAR
7	message	VARCHAR

Table: refunds

No	Column Name	Type	Notes
1	refunded_by	INTEGER
2	reason	VARCHAR
3	amount	VARCHAR
4	date_created	VARCHAR
5	meta_data	VARCHAR
6	date_created_gmt	VARCHAR
7	api_refund	BOOLEAN
8	id	INTEGER
9	line_items	VARCHAR
10	refunded_payment	BOOLEAN

Table: product_tags

No	Column Name	Type	Notes
1	name	VARCHAR
2	count	INTEGER
3	description	VARCHAR
4	id	INTEGER
5	slug	VARCHAR

Table: shipping_zones

No	Column Name	Type	Notes
1	name	VARCHAR
2	id	INTEGER
3	order	INTEGER

Table: shipping_methods

No	Column Name	Type	Notes
1	description	VARCHAR
2	id	VARCHAR
3	title	VARCHAR

Table: coupons

No	Column Name	Type	Notes
1	usage_limit	INTEGER
2	code	VARCHAR
3	free_shipping	BOOLEAN
4	_links	VARCHAR
5	description	VARCHAR
6	minimum_amount	VARCHAR
7	email_restrictions	VARCHAR
8	exclude_sale_items	BOOLEAN
9	excluded_product_ids	VARCHAR
10	usage_count	INTEGER
11	individual_use	BOOLEAN
12	shop_url	VARCHAR
13	usage_limit_per_user	INTEGER
14	limit_usage_to_x_items	INTEGER
15	meta_data	VARCHAR
16	id	INTEGER
17	date_modified_gmt	VARCHAR
18	amount	VARCHAR
19	date_created	VARCHAR
20	date_created_gmt	VARCHAR
21	maximum_amount	VARCHAR
22	discount_type	VARCHAR
23	used_by	VARCHAR
24	date_modified	VARCHAR
25	product_ids	VARCHAR
26	product_categories	VARCHAR
27	date_expires	VARCHAR
28	excluded_product_categories	VARCHAR
29	date_expires_gmt	VARCHAR

Table: product_categories

No	Column Name	Type	Notes
1	parent	INTEGER
2	image	VARCHAR
3	menu_order	INTEGER
4	display	VARCHAR
5	name	VARCHAR
6	count	INTEGER
7	description	VARCHAR
8	id	INTEGER
9	slug	VARCHAR

Table: product_variations

No	Column Name	Type	Notes
1	purchasable	BOOLEAN
2	virtual	BOOLEAN
3	downloadable	BOOLEAN
4	menu_order	INTEGER
5	tax_status	VARCHAR
6	description	VARCHAR
7	date_on_sale_to_gmt	VARCHAR
8	date_on_sale_from_gmt	VARCHAR
9	regular_price	VARCHAR
10	backorders_allowed	BOOLEAN
11	downloads	VARCHAR
12	price	VARCHAR
13	meta_data	VARCHAR
14	id	INTEGER
15	sku	VARCHAR
16	date_on_sale_from	VARCHAR
17	on_sale	BOOLEAN
18	date_modified_gmt	VARCHAR
19	manage_stock	VARCHAR
20	image	VARCHAR
21	stock_status	VARCHAR
22	date_created	VARCHAR
23	tax_class	VARCHAR
24	download_expiry	INTEGER
25	backordered	BOOLEAN
26	weight	VARCHAR
27	date_created_gmt	VARCHAR
28	stock_quantity	INTEGER
29	sale_price	VARCHAR
30	shipping_class_id	INTEGER
31	date_on_sale_to	VARCHAR
32	date_modified	VARCHAR
33	backorders	VARCHAR
34	download_limit	INTEGER
35	shipping_class	VARCHAR
36	attributes	VARCHAR
37	permalink	VARCHAR
38	status	VARCHAR
39	dimensions	VARCHAR

Table: orders

No	Column Name	Type	Notes
1	discount_total	VARCHAR
2	order_key	VARCHAR
3	prices_include_tax	BOOLEAN
4	_links	VARCHAR
5	customer_note	VARCHAR
6	line_items	VARCHAR
7	coupon_lines	VARCHAR
8	billing	VARCHAR
9	refunds	VARCHAR
10	number	VARCHAR
11	total	VARCHAR
12	shipping	VARCHAR
13	date_paid_gmt	VARCHAR
14	tax_lines	VARCHAR
15	set_paid	BOOLEAN
16	date_paid	VARCHAR
17	customer_user_agent	VARCHAR
18	shop_url	VARCHAR
19	payment_method_title	VARCHAR
20	meta_data	VARCHAR
21	date_completed	VARCHAR
22	currency	VARCHAR
23	id	INTEGER
24	date_completed_gmt	VARCHAR
25	payment_method	VARCHAR
26	shipping_tax	VARCHAR
27	transaction_id	VARCHAR
28	date_modified_gmt	VARCHAR
29	cart_hash	VARCHAR
30	shipping_total	VARCHAR
31	cart_tax	VARCHAR
32	created_via	VARCHAR
33	date_created	VARCHAR
34	date_created_gmt	VARCHAR
35	discount_tax	VARCHAR
36	total_tax	VARCHAR
37	version	VARCHAR
38	customer_ip_address	VARCHAR
39	shipping_lines	VARCHAR
40	date_modified	VARCHAR
41	parent_id	INTEGER
42	fee_lines	VARCHAR
43	customer_id	INTEGER
44	status	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	date_modified_gmt	VARCHAR
2	role	VARCHAR
3	_links	VARCHAR
4	date_created	VARCHAR
5	last_name	VARCHAR
6	date_created_gmt	VARCHAR
7	billing	VARCHAR
8	date_modified	VARCHAR
9	shipping	VARCHAR
10	avatar_url	VARCHAR
11	shop_url	VARCHAR
12	meta_data	VARCHAR
13	id	INTEGER
14	first_name	VARCHAR
15	email	VARCHAR
16	is_paying_customer	BOOLEAN
17	username	VARCHAR

Table: product_attribute_terms

No	Column Name	Type	Notes
1	menu_order	INTEGER
2	name	VARCHAR
3	count	INTEGER
4	description	VARCHAR
5	id	INTEGER
6	slug	VARCHAR

External Resources

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.