Cart

Tables in the Cart connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	addresses	19		Full Refresh, Incremental	updated_at
2	order_statuses	13		Full Refresh
3	order_payments	34		Full Refresh, Incremental	updated_at
4	orders	58		Full Refresh, Incremental	updated_at	API Reference
5	customers_cart	34		Full Refresh, Incremental	updated_at
6	order_items	27		Full Refresh, Incremental	updated_at
7	products	125		Full Refresh, Incremental	updated_at	API Reference

Table: addresses

No	Column Name	Type	Notes
1	country	VARCHAR
2	comments	VARCHAR
3	city	VARCHAR
4	created_at	VARCHAR
5	last_name	VARCHAR
6	is_default_billing_address	BOOLEAN
7	updated_at	VARCHAR	Incremental sync key
8	phone	VARCHAR
9	address_line_1	VARCHAR
10	is_default_shipping_address	BOOLEAN
11	company	VARCHAR
12	alternate_phone	VARCHAR
13	id	INTEGER
14	address_line_2	VARCHAR
15	state	VARCHAR
16	customer_id	INTEGER
17	postal_code	VARCHAR
18	fax	VARCHAR
19	first_name	VARCHAR

Table: order_statuses

No	Column Name	Type	Notes
1	color	VARCHAR
2	is_open	BOOLEAN
3	created_at	VARCHAR
4	is_declined	BOOLEAN
5	is_partially_refunded	BOOLEAN
6	is_shipped	BOOLEAN
7	updated_at	VARCHAR
8	is_quote_status	BOOLEAN
9	email_template_id	INTEGER
10	is_fully_refunded	BOOLEAN
11	name	VARCHAR
12	id	INTEGER
13	is_cancelled	BOOLEAN

Table: order_payments

No	Column Name	Type	Notes
1	cvv_response_code	VARCHAR
2	created_at	VARCHAR
3	sent_to_spark_pay	BOOLEAN
4	card_expiration_year	INTEGER
5	updated_at	VARCHAR	Incremental sync key
6	is_void	BOOLEAN
7	payment_note	VARCHAR
8	last_four	VARCHAR
9	approved_at	VARCHAR
10	authorization_code	VARCHAR
11	id	INTEGER
12	gift_certificate_id	INTEGER
13	transaction_id	VARCHAR
14	amount	DOUBLE
15	customer_payment_method_id	INTEGER
16	is_captured	BOOLEAN
17	reject_reason	VARCHAR
18	card_type	VARCHAR
19	cardholder_name	VARCHAR
20	payment_method_name	VARCHAR
21	transaction_type	VARCHAR
22	is_declined	BOOLEAN
23	token	VARCHAR
24	paid_at	VARCHAR
25	store_payment_method_id	INTEGER
26	payment_method_id	INTEGER
27	payment_type	VARCHAR
28	avs_code	VARCHAR
29	gateway_response_code	VARCHAR
30	card_expiration_month	INTEGER
31	is_approved	BOOLEAN
32	customer_id	INTEGER
33	order_id	INTEGER
34	payment_ref_num	VARCHAR

Table: orders

No	Column Name	Type	Notes
1	instructions	VARCHAR
2	affiliate_id	INTEGER
3	order_status_id	INTEGER
4	channel	VARCHAR
5	source	VARCHAR
6	search_phrase	VARCHAR
7	from_quote_id	INTEGER
8	selected_shipping_method	VARCHAR
9	cost_total	DOUBLE
10	from_subscription_id	INTEGER
11	entered_by	VARCHAR
12	id	INTEGER
13	order_type	VARCHAR
14	customer_type_id	INTEGER
15	special_instructions	VARCHAR
16	adcode	VARCHAR
17	ordered_at	VARCHAR
18	ppc_keyword	VARCHAR
19	adcode_id	INTEGER
20	reward_points_credited	BOOLEAN
21	public_comments	VARCHAR
22	is_gift	BOOLEAN
23	source_group	VARCHAR
24	additional_fees	DOUBLE
25	subtotal	DOUBLE
26	manufacturer_invoice_amount	DOUBLE
27	campaign_code	VARCHAR
28	device	VARCHAR
29	order_status_last_changed_at	VARCHAR
30	order_shipping_address_id	INTEGER
31	discount_total	DOUBLE
32	expires	BOOLEAN
33	tax_total	DOUBLE
34	order_number	VARCHAR
35	created_at	VARCHAR
36	manufacturer_invoice_number	VARCHAR
37	previous_order_status_id	INTEGER
38	admin_comments	VARCHAR
39	expires_at	VARCHAR
40	updated_at	VARCHAR	Incremental sync key
41	order_billing_address_id	INTEGER
42	grand_total	DOUBLE
43	is_ppc	BOOLEAN
44	store_id	INTEGER
45	shipping_total	DOUBLE
46	exported_to_accounting_system	INTEGER
47	coupon_code	VARCHAR
48	discounted_shipping_total	DOUBLE
49	selected_shipping_provider_service	VARCHAR
50	handling_total	DOUBLE
51	due_date	VARCHAR
52	session_id	INTEGER
53	ip_address	VARCHAR
54	referrer	VARCHAR
55	manufacturer_invoice_paid	BOOLEAN
56	customer_id	INTEGER
57	is_payment_order_only	BOOLEAN
58	gift_message	VARCHAR

Table: customers_cart

No	Column Name	Type	Notes
1	sub	VARCHAR
2	last_visit_at	VARCHAR
3	sales_person	VARCHAR
4	customer_number	VARCHAR
5	affiliate_id	INTEGER
6	created_at	VARCHAR
7	source	VARCHAR
8	search_string	VARCHAR
9	tax_rate	VARCHAR
10	updated_at	VARCHAR	Incremental sync key
11	alternate_phone_number	VARCHAR
12	sales_person_user_id	VARCHAR
13	company	VARCHAR
14	id	INTEGER
15	first_name	VARCHAR
16	email	VARCHAR
17	customer_type_id	INTEGER
18	store_id	INTEGER
19	comments	VARCHAR
20	registered_at	VARCHAR
21	adcode	VARCHAR
22	is_contact_information_only	BOOLEAN
23	customer_payment_methods_availability	VARCHAR
24	last_name	VARCHAR
25	is_no_tax_customer	BOOLEAN
26	adcode_id	INTEGER
27	store_payment_methods_enabled	VARCHAR
28	no_account	BOOLEAN
29	source_group	VARCHAR
30	is_affiliate_customer	BOOLEAN
31	phone_number	VARCHAR
32	tax_exemption_number	VARCHAR
33	reward_tier_id	VARCHAR
34	username	VARCHAR

Table: order_items

No	Column Name	Type	Notes
1	item_number	VARCHAR
2	created_at	VARCHAR
3	admin_comments	VARCHAR
4	do_not_discount	BOOLEAN
5	updated_at	VARCHAR	Incremental sync key
6	price	DOUBLE
7	product_id	INTEGER
8	id	INTEGER
9	size_unit	VARCHAR
10	height	DOUBLE
11	cost	DOUBLE
12	quantity	INTEGER
13	parent_order_item_id	INTEGER
14	length	DOUBLE
15	weight	DOUBLE
16	item_name	VARCHAR
17	weigh_unit	VARCHAR
18	is_quantity_bound_to_parent	BOOLEAN
19	line_item_note	VARCHAR
20	delivery_date	VARCHAR
21	width	DOUBLE
22	is_subscription_product	BOOLEAN
23	order_id	INTEGER
24	is_discount_item	BOOLEAN
25	is_taxable	BOOLEAN
26	gift_message	VARCHAR
27	warehouse_id	INTEGER

Table: products

No	Column Name	Type	Notes
1	is_non_shipping_item	BOOLEAN
2	is_shipped_individually	INTEGER
3	exclude_parent_from_display	BOOLEAN
4	is_non_taxable	INTEGER
5	rate_adjustment_type	VARCHAR
6	use_pricing_from_parent	BOOLEAN
7	is_non_inventory	BOOLEAN
8	average_review_rating	DOUBLE
9	enable_low_stock_warning	BOOLEAN
10	price	DOUBLE
11	use_tabs	BOOLEAN
12	has_visible_variants	BOOLEAN
13	id	INTEGER
14	is_spotlight_item	INTEGER
15	height	VARCHAR
16	allowed_variable_subscription_types	VARCHAR
17	eta_date	VARCHAR
18	shipping_classification_code	VARCHAR
19	product_status_id	INTEGER
20	approval_required	BOOLEAN
21	quantity_on_order	INTEGER
22	related_name	VARCHAR
23	meta_description	VARCHAR
24	weight_unit	VARCHAR
25	manufacturer_part_number	VARCHAR
26	profile_id	INTEGER
27	handling_fee	DOUBLE
28	is_subscription_product	BOOLEAN
29	short_description	VARCHAR
30	e_product_email	VARCHAR
31	do_not_send_review_request	BOOLEAN
32	add_to_cart_message	VARCHAR
33	item_number	VARCHAR
34	is_hidden	INTEGER
35	e_product_allow_multiple_deliveries	INTEGER
36	created_at	VARCHAR
37	e_product_generic_password	VARCHAR
38	in_stock_notification_email_template_id	INTEGER
39	break_out_shipping	BOOLEAN
40	subscription_frequency	INTEGER
41	retail	DOUBLE
42	updated_at	VARCHAR	Incremental sync key
43	call_for_shipping	INTEGER
44	use_map_pricing	BOOLEAN
45	is_child_product	BOOLEAN
46	bullets	VARCHAR
47	bullets_external_url	VARCHAR
48	call_for_pricing	INTEGER
49	item_name	VARCHAR
50	quantity_on_hand	INTEGER
51	e_product_generic_username	VARCHAR
52	is_featured_item	BOOLEAN
53	long_description_external_url_1	VARCHAR
54	long_description_1	VARCHAR
55	tax_code	VARCHAR
56	long_description_4	VARCHAR
57	long_description_external_url_5	VARCHAR
58	quantity_increment	INTEGER
59	long_description_5	VARCHAR
60	long_description_external_url_4	VARCHAR
61	long_description_2	VARCHAR
62	long_description_external_url_3	VARCHAR
63	long_description_3	VARCHAR
64	long_description_external_url_2	VARCHAR
65	width	VARCHAR
66	warehouse_id	INTEGER
67	starting_quantity	INTEGER
68	keywords	VARCHAR
69	additional_points_earned	INTEGER
70	quickbooks_item_id	VARCHAR
71	page_title	VARCHAR
72	review_count	INTEGER
73	primary_category_id	INTEGER
74	custom_upsell_url	VARCHAR
75	exclude_children_from_display	BOOLEAN
76	do_not_discount	BOOLEAN
77	no_price_mask	VARCHAR
78	subscription_frequency_type	VARCHAR
79	last_item_number	VARCHAR
80	force_separate_order	BOOLEAN
81	size_unit	VARCHAR
82	vendor_store_id	INTEGER
83	manufacturer_id	INTEGER
84	e_product_delivery_action	VARCHAR
85	custom_flag_2	BOOLEAN
86	custom_flag_1	BOOLEAN
87	custom_flag_4	BOOLEAN
88	custom_flag_3	BOOLEAN
89	is_discontinued	BOOLEAN
90	weight	DOUBLE
91	shipping_override	DOUBLE
92	hide_variant_surcharges	BOOLEAN
93	custom_flag_5	BOOLEAN
94	master_product_id	INTEGER
95	low_stock_warning_threshold	INTEGER
96	e_product_type	VARCHAR
97	e_product_password	VARCHAR
98	use_variant_inventory	BOOLEAN
99	available_region_id	INTEGER
100	is_linked_product	BOOLEAN
101	insurance_cost	DOUBLE
102	e_product_serial_number_file_path	VARCHAR
103	earns_points	BOOLEAN
104	sort_order	INTEGER
105	days_until_reorder_allowed	INTEGER
106	gtin	VARCHAR
107	cost	DOUBLE
108	maximum_quantity	INTEGER
109	long_description_tab_name_4	VARCHAR
110	e_product_verification_link_expiration	INTEGER
111	long_description_tab_name_5	VARCHAR
112	length	VARCHAR
113	drop_ship	BOOLEAN
114	head_tags	VARCHAR
115	is_kit	BOOLEAN
116	call_for_shipping_on_whole_order	BOOLEAN
117	product_rating_dimension_group_override_id	VARCHAR
118	exclude_from_commissions	BOOLEAN
119	url_rewrite	VARCHAR
120	override_theme_use_tabs	BOOLEAN
121	long_description_tab_name_2	VARCHAR
122	long_description_tab_name_3	VARCHAR
123	long_description_tab_name_1	VARCHAR
124	minimum_quantity	INTEGER
125	e_product_url	VARCHAR

External Resources

• Cart.com Api
• Customerscart
• Orderpayments
• This
• Steps

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.