Bigcommerce

Tables in the Bigcommerce connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	order_products	0		Incremental, Full Refresh	id
2	channels	11		Incremental, Full Refresh	date_modified	API Reference
3	orders	62		Incremental, Full Refresh	date_modified	API Reference
4	categories	15		Incremental, Full Refresh	id	API Reference
5	store	38		Incremental, Full Refresh	store_id	API Reference
6	customers	16		Incremental, Full Refresh	date_modified	API Reference
7	transactions	22		Incremental, Full Refresh	id	API Reference
8	products	75		Incremental, Full Refresh	date_modified	API Reference

Table: order_products

| No | Column Name | Type | Notes || --- | ----------- | ---- | ----- |

Table: channels

No	Column Name	Type	Notes
1	is_listable_from_ui	BOOLEAN
2	icon_url	VARCHAR
3	is_visible	BOOLEAN
4	date_modified	VARCHAR	Incremental sync key
5	date_created	VARCHAR
6	name	VARCHAR
7	external_id	VARCHAR
8	id	INTEGER
9	type	VARCHAR
10	platform	VARCHAR
11	status	VARCHAR

Table: orders

No	Column Name	Type	Notes
1	date_shipped	VARCHAR
2	discount_amount	VARCHAR
3	handling_cost_ex_tax	VARCHAR
4	billing_address	VARCHAR
5	handling_cost_inc_tax	VARCHAR
6	shipping_addresses	VARCHAR
7	cart_id	VARCHAR
8	items_total	INTEGER
9	handling_cost_tax	VARCHAR
10	status_id	INTEGER
11	total_ex_tax	VARCHAR
12	store_credit_amount	VARCHAR
13	coupons	VARCHAR
14	base_handling_cost	VARCHAR
15	customer_locale	VARCHAR
16	shipping_cost_tax	VARCHAR
17	id	INTEGER
18	geoip_country_iso2	VARCHAR
19	ebay_order_id	VARCHAR
20	payment_method	VARCHAR
21	gift_certificate_amount	VARCHAR
22	default_currency_id	INTEGER
23	geoip_country	VARCHAR
24	customer_message	VARCHAR
25	base_shipping_cost	VARCHAR
26	currency_exchange_rate	VARCHAR
27	refunded_amount	VARCHAR
28	shipping_cost_ex_tax	VARCHAR
29	order_is_digital	BOOLEAN
30	channel_id	INTEGER
31	coupon_discount	VARCHAR
32	items_shipped	INTEGER
33	subtotal_ex_tax	VARCHAR
34	status	VARCHAR
35	total_inc_tax	VARCHAR
36	tax_provider_id	VARCHAR
37	external_id	VARCHAR
38	handling_cost_tax_class_id	INTEGER
39	currency_code	VARCHAR
40	subtotal_inc_tax	VARCHAR
41	products	VARCHAR
42	base_wrapping_cost	VARCHAR
43	is_deleted	BOOLEAN
44	shipping_cost_tax_class_id	INTEGER
45	wrapping_cost_ex_tax	VARCHAR
46	external_source	VARCHAR
47	staff_notes	VARCHAR
48	default_currency_code	VARCHAR
49	date_created	VARCHAR
50	payment_status	VARCHAR
51	ip_address	VARCHAR
52	shipping_cost_inc_tax	VARCHAR
53	wrapping_cost_tax	VARCHAR
54	wrapping_cost_tax_class_id	INTEGER
55	date_modified	VARCHAR	Incremental sync key
56	order_source	VARCHAR
57	subtotal_tax	VARCHAR
58	shipping_address_count	INTEGER
59	customer_id	INTEGER
60	is_email_opt_in	BOOLEAN
61	currency_id	INTEGER
62	wrapping_cost_inc_tax	VARCHAR

Table: categories

No	Column Name	Type	Notes
1	is_visible	BOOLEAN
2	page_title	VARCHAR
3	image_url	VARCHAR
4	description	VARCHAR
5	meta_keywords	VARCHAR
6	search_keywords	VARCHAR
7	default_product_sort	VARCHAR
8	url	VARCHAR
9	meta_description	VARCHAR
10	layout_file	VARCHAR
11	parent_id	INTEGER
12	name	VARCHAR
13	id	INTEGER	Incremental sync key
14	sort_order	INTEGER
15	views	INTEGER

Table: store

No	Column Name	Type	Notes
1	country	VARCHAR
2	account_uuid	VARCHAR
3	favicon_url	VARCHAR
4	active_comparison_modules	VARCHAR
5	timezone	VARCHAR
6	language	VARCHAR
7	industry	VARCHAR
8	admin_email	VARCHAR
9	decimal_places	VARCHAR
10	currency_symbol_location	VARCHAR
11	features	VARCHAR
12	dimension_thousands_token	VARCHAR
13	plan_level	VARCHAR
14	logo	VARCHAR
15	currency	VARCHAR
16	id	VARCHAR
17	control_panel_base_url	VARCHAR
18	first_name	VARCHAR
19	decimal_separator	VARCHAR
20	thousands_separator	VARCHAR
21	store_id	INTEGER	Incremental sync key
22	address	VARCHAR
23	dimension_decimal_token	VARCHAR
24	dimension_units	VARCHAR
25	currency_symbol	VARCHAR
26	secure_url	VARCHAR
27	last_name	VARCHAR
28	weight_units	VARCHAR
29	is_price_entered_with_tax	BOOLEAN
30	default_site_id	INTEGER
31	plan_name	VARCHAR
32	dimension_decimal_places	VARCHAR
33	phone	VARCHAR
34	domain	VARCHAR
35	name	VARCHAR
36	default_channel_id	INTEGER
37	order_email	VARCHAR
38	status	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	addresses	VARCHAR
2	notes	VARCHAR
3	attribute_count	INTEGER
4	date_created	VARCHAR
5	last_name	VARCHAR
6	address_count	INTEGER
7	registration_ip_address	VARCHAR
8	date_modified	VARCHAR	Incremental sync key
9	phone	VARCHAR
10	company	VARCHAR
11	id	INTEGER
12	tax_exempt_category	VARCHAR
13	first_name	VARCHAR
14	customer_group_id	INTEGER
15	email	VARCHAR
16	authentication	VARCHAR

Table: transactions

No	Column Name	Type	Notes
1	amount	DOUBLE
2	cvv_result	VARCHAR
3	method	VARCHAR
4	test	BOOLEAN
5	date_created	VARCHAR
6	custom	VARCHAR
7	gateway_transaction_id	VARCHAR
8	offline	VARCHAR
9	payment_method_id	VARCHAR
10	credit_card	VARCHAR
11	reference_transaction_id	INTEGER
12	payment_instrument_token	VARCHAR
13	currency	VARCHAR
14	id	INTEGER	Incremental sync key
15	store_credit	VARCHAR
16	event	VARCHAR
17	fraud_review	BOOLEAN
18	order_id	VARCHAR
19	avs_result	VARCHAR
20	gateway	VARCHAR
21	status	VARCHAR
22	gift_certificate	VARCHAR

Table: products

No	Column Name	Type	Notes
1	calculated_price	DOUBLE
2	gift_wrapping_options_list	VARCHAR
3	page_title	VARCHAR
4	videos	VARCHAR
5	option_set_id	INTEGER
6	is_condition_shown	BOOLEAN
7	variants	VARCHAR
8	type	VARCHAR
9	map_price	DOUBLE
10	retail_price	DOUBLE
11	layout_file	VARCHAR
12	price	DOUBLE
13	inventory_warning_level	INTEGER
14	options	VARCHAR
15	warranty	VARCHAR
16	is_free_shipping	BOOLEAN
17	total_sold	INTEGER
18	id	INTEGER
19	sku	VARCHAR
20	height	DOUBLE
21	custom_url	VARCHAR
22	images	VARCHAR
23	open_graph_use_meta_description	BOOLEAN
24	custom_fields	VARCHAR
25	weight	DOUBLE
26	upc	VARCHAR
27	mpn	VARCHAR
28	open_graph_type	VARCHAR
29	open_graph_use_image	BOOLEAN
30	brand_id	INTEGER
31	meta_description	VARCHAR
32	condition	VARCHAR
33	inventory_level	INTEGER
34	name	VARCHAR
35	open_graph_description	VARCHAR
36	open_graph_use_product_name	BOOLEAN
37	reviews_rating_sum	INTEGER
38	reviews_count	INTEGER
39	inventory_tracking	VARCHAR
40	preorder_release_date	VARCHAR
41	description	VARCHAR
42	bin_picking_number	VARCHAR
43	availability	VARCHAR
44	search_keywords	VARCHAR
45	meta_keywords	VARCHAR
46	modifiers	VARCHAR
47	related_products	VARCHAR
48	is_price_hidden	BOOLEAN
49	order_quantity_minimum	INTEGER
50	availability_description	VARCHAR
51	fixed_cost_shipping_price	DOUBLE
52	categories	VARCHAR
53	base_variant_id	INTEGER
54	sort_order	INTEGER
55	cost_price	DOUBLE
56	order_quantity_maximum	INTEGER
57	gtin	VARCHAR
58	option_set_display	VARCHAR
59	is_visible	BOOLEAN
60	is_preorder_only	BOOLEAN
61	preorder_message	VARCHAR
62	date_created	VARCHAR
63	tax_class_id	INTEGER
64	bulk_pricing_rules	VARCHAR
65	open_graph_title	VARCHAR
66	sale_price	DOUBLE
67	product_tax_code	VARCHAR
68	depth	DOUBLE
69	date_modified	VARCHAR	Incremental sync key
70	gift_wrapping_options_type	VARCHAR
71	width	DOUBLE
72	brand_name or brand_id	VARCHAR
73	price_hidden_label	VARCHAR
74	is_featured	BOOLEAN
75	view_count	INTEGER

External Resources

• Bigcommerce Api
• Pages
• Orderproducts
• Brands
• 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.