Recharge

Prerequisites

• A Recharge account with permission to access data from accounts you want to sync.
• Recharge API Token

Tables in the Recharge connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	metafields	10				API Reference
2	addresses	18				API Reference
3	subscriptions	34	id	Full Refresh, Incremental	updated_at	API Reference
4	charges	42				API Reference
5	shop	2				API Reference
6	discounts	23				API Reference
7	collections	4				API Reference
8	orders	44				API Reference
9	customers	29				API Reference
10	onetimes	16				API Reference
11	products	21				API Reference

Table: metafields

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

Table: addresses

No	Column Name	Type	Notes
1	zip	VARCHAR
2	country	VARCHAR
3	shipping_lines_override	VARCHAR
4	address2	VARCHAR
5	city	VARCHAR
6	address1	VARCHAR
7	created_at	VARCHAR
8	last_name	VARCHAR
9	province	VARCHAR
10	updated_at	VARCHAR
11	phone	VARCHAR
12	note_attributes	VARCHAR
13	company	VARCHAR
14	id	INTEGER
15	customer_id	INTEGER
16	first_name	VARCHAR
17	cart_note	VARCHAR
18	discount_id	INTEGER

Table: subscriptions

No	Column Name	Type	Notes
1	cancelled_at	VARCHAR
2	variant_title	VARCHAR
3	max_retries_reached	INTEGER
4	shopify_product_id	INTEGER
5	charge_interval_frequency	VARCHAR
6	order_day_of_month	INTEGER
7	created_at	VARCHAR
8	expire_after_specific_number_of_charges	INTEGER
9	is_skippable	BOOLEAN
10	next_charge_scheduled_at	VARCHAR
11	updated_at	VARCHAR	Incremental sync key
12	price	DOUBLE
13	order_interval_frequency	VARCHAR
14	id	INTEGER	Primary Key
15	sku	VARCHAR
16	email	VARCHAR
17	sku_override	BOOLEAN
18	order_interval_unit	VARCHAR
19	quantity	INTEGER
20	analytics_data	VARCHAR
21	address_id	INTEGER
22	cancellation_reason_comments	VARCHAR
23	is_prepaid	BOOLEAN
24	cancellation_reason	VARCHAR
25	product_title	VARCHAR
26	commit_update	BOOLEAN
27	has_queued_charges	INTEGER
28	recharge_product_id	INTEGER
29	is_swappable	BOOLEAN
30	order_day_of_week	INTEGER
31	customer_id	INTEGER
32	properties	VARCHAR
33	shopify_variant_id	INTEGER
34	status	VARCHAR

Table: charges

No	Column Name	Type	Notes
1	shopify_variant_id_not_found	INTEGER
2	note	VARCHAR
3	retry_date	VARCHAR
4	created_at	VARCHAR
5	scheduled_at	VARCHAR
6	billing_address	VARCHAR
7	has_uncommited_changes	BOOLEAN
8	line_items	VARCHAR
9	error	VARCHAR
10	type	VARCHAR
11	total_weight	INTEGER
12	last_charge_attempt_date	VARCHAR
13	total_discounts	VARCHAR
14	client_details	VARCHAR
15	tax_lines	VARCHAR
16	updated_at	VARCHAR
17	shopify_order_id	VARCHAR
18	number_times_tried	INTEGER
19	error_type	VARCHAR
20	processed_at	VARCHAR
21	processor_name	VARCHAR
22	id	INTEGER
23	shipping_address	VARCHAR
24	first_name	VARCHAR
25	email	VARCHAR
26	transaction_id	VARCHAR
27	subtotal_price	VARCHAR
28	total_price	VARCHAR
29	analytics_data	VARCHAR
30	address_id	INTEGER
31	last_name	VARCHAR
32	total_line_items_price	VARCHAR
33	total_tax	VARCHAR
34	tags	VARCHAR
35	shipments_count	INTEGER
36	shipping_lines	VARCHAR
37	note_attributes	VARCHAR
38	customer_hash	VARCHAR
39	customer_id	INTEGER
40	discount_codes	VARCHAR
41	total_refunds	VARCHAR
42	status	VARCHAR

Table: shop

No	Column Name	Type	Notes
1	shop	VARCHAR
2	store	VARCHAR

Table: discounts

No	Column Name	Type	Notes
1	once_per_customer	BOOLEAN
2	starts_at	VARCHAR
3	usage_limit	DOUBLE
4	applies_to_id	INTEGER
5	code	VARCHAR
6	created_at	VARCHAR
7	channel_settings	VARCHAR
8	prerequisite_subtotal_min	DOUBLE
9	external_discount_source	VARCHAR
10	times_used	DOUBLE
11	discount_type	VARCHAR
12	duration	VARCHAR
13	external_discount_id	VARCHAR
14	applies_to_resource	VARCHAR
15	applies_to	VARCHAR
16	updated_at	VARCHAR
17	applies_to_product_type	VARCHAR
18	duration_usage_limit	INTEGER
19	id	INTEGER
20	ends_at	VARCHAR
21	first_time_customer_restriction	VARCHAR
22	value	DOUBLE
23	status	VARCHAR

Table: collections

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	name	VARCHAR
3	created_at	VARCHAR
4	id	INTEGER

Table: orders

No	Column Name	Type	Notes
1	note	VARCHAR
2	redacted	BOOLEAN
3	created_at	VARCHAR
4	scheduled_at	VARCHAR
5	billing_address	VARCHAR
6	line_items	VARCHAR
7	type	VARCHAR
8	total_weight	INTEGER
9	total_discounts	DOUBLE
10	charge_status	VARCHAR
11	tax_lines	VARCHAR
12	updated_at	VARCHAR
13	address_is_active	INTEGER
14	shopify_order_id	VARCHAR
15	charge_id	INTEGER
16	processed_at	VARCHAR
17	shopify_cart_token	VARCHAR
18	currency	VARCHAR
19	id	INTEGER
20	shipping_address	VARCHAR
21	first_name	VARCHAR
22	browser_ip	VARCHAR
23	email	VARCHAR
24	transaction_id	VARCHAR
25	subtotal_price	DOUBLE
26	total_price	DOUBLE
27	address_id	INTEGER
28	is_prepaid	INTEGER
29	last_name	VARCHAR
30	total_line_items_price	DOUBLE
31	total_tax	VARCHAR
32	tags	VARCHAR
33	shipping_lines	VARCHAR
34	note_attributes	VARCHAR
35	shipped_date	VARCHAR
36	payment_processor	VARCHAR
37	customer_id	INTEGER
38	discount_codes	VARCHAR
39	shopify_order_number	INTEGER
40	total_refunds	VARCHAR
41	hash	VARCHAR
42	shopify_customer_id	VARCHAR
43	customer	VARCHAR
44	status	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	billing_last_name	VARCHAR
2	billing_phone	VARCHAR
3	processor_type	VARCHAR
4	first_charge_processed_at	VARCHAR
5	created_at	VARCHAR
6	number_active_subscriptions	INTEGER
7	has_valid_payment_method	BOOLEAN
8	billing_province	VARCHAR
9	number_subscriptions	INTEGER
10	updated_at	VARCHAR
11	accepts_marketing	INTEGER
12	billing_zip	VARCHAR
13	id	INTEGER
14	billing_first_name	VARCHAR
15	billing_address1	VARCHAR
16	first_name	VARCHAR
17	billing_address2	VARCHAR
18	email	VARCHAR
19	stripe_customer_token	VARCHAR
20	has_card_error_in_dunning	BOOLEAN
21	analytics_data	VARCHAR
22	billing_country	VARCHAR
23	last_name	VARCHAR
24	billing_city	VARCHAR
25	billing_company	VARCHAR
26	reason_payment_method_not_valid	VARCHAR
27	hash	VARCHAR
28	shopify_customer_id	VARCHAR
29	status	VARCHAR

Table: onetimes

No	Column Name	Type	Notes
1	variant_title	VARCHAR
2	quantity	INTEGER
3	shopify_product_id	INTEGER
4	address_id	VARCHAR
5	created_at	VARCHAR
6	product_title	VARCHAR
7	next_charge_scheduled_at	VARCHAR
8	recharge_product_id	INTEGER
9	updated_at	VARCHAR
10	price	VARCHAR
11	id	INTEGER
12	customer_id	VARCHAR
13	sku	VARCHAR
14	properties	VARCHAR
15	shopify_variant_id	INTEGER
16	status	VARCHAR

Table: products

No	Column Name	Type	Notes
1	order_interval_frequency_options	VARCHAR
2	order_interval_unit	VARCHAR
3	images	VARCHAR
4	shopify_product_id	INTEGER
5	cutoff_day_of_month	INTEGER
6	storefront_purchase_options	VARCHAR
7	charge_interval_frequency	INTEGER
8	discount_amount	DOUBLE
9	order_day_of_month	INTEGER
10	modifiable_properties	VARCHAR
11	created_at	VARCHAR
12	cutoff_day_of_week	INTEGER
13	handle	VARCHAR
14	expire_after_specific_number_of_charges	INTEGER
15	discount_type	VARCHAR
16	title	VARCHAR
17	subscription_defaults	VARCHAR
18	collection_id	INTEGER
19	updated_at	VARCHAR
20	order_day_of_week	INTEGER
21	id	INTEGER

External Resources

• Recharge Api
• How To Generate Your Api Token

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.