This integration is powered by Singer's recharge tap and certified by Stitch. Check out and contribute to the repo on GitHub.
For support, contact Support.
Recharge integration summary
Stitch’s Recharge integration replicates data using the Recharge Payments API. To access the Recharge API documentation, you will need your API key. Refer to the Schema section for a list of objects available for replication.
Recharge feature snapshot
A high-level look at Stitch's Recharge (v2) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status |
Released on August 30, 2022 |
Supported by |
[Stitch] (https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| Stitch plan |
Standard |
API availability |
Available |
| Singer GitHub repository | |||
| REPLICATION SETTINGS | |||
| Anchor Scheduling |
Supported |
Advanced Scheduling |
Supported |
| Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
| DATA SELECTION | |||
| Table selection |
Supported |
Column selection |
Supported |
| Select all |
Supported |
||
| TRANSPARENCY | |||
| Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting Recharge
Recharge setup requirements
To set up Recharge in Stitch, you need:
-
A Shopify Account. You need this to access your Recharge information.
Step 1: Obtain your Recharge access token
- Log into your Shopify account, select Apps, and then click on your Recharge application.
- In the application, click the EXPLORE Recharge located near the top right corner of the page.
- Click on the Integrations tab, and then click API tokens….
- Click on Create an API token.
- On the Create an API token page:
- In the Details section, enter a Nickname and Contact email into their respective fields.
- In the Permission section, select the
Read Accessscope for each permission.
- Click Save to create the Access Token.
Step 2: Add Recharge as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Recharge icon.
-
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Recharge” would create a schema called
stitch_rechargein the destination. Note: Schema names cannot be changed after you save the integration. - In the Access Token field, enter the access token you obtained in the previous step.
Step 3: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Recharge integration. This means that data equal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond Recharge’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.
Step 4: Create a replication schedule
In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Recharge integrations support the following replication scheduling methods:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Set objects to replicate
The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For Recharge integrations, you can select:
-
Individual tables and columns
-
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’s Tables to Replicate tab, locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
-
Click the Tables to Replicate tab.
- In the list of tables, click the box next to the Table Names column.
-
In the menu that displays, click Track all Tables and Fields:
- Click the Finalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up Recharge, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Recharge table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 2 of this integration.
This is the latest version of the Recharge integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.
addresses
The addresses table contains info about the addresses (shipping locations) a customer has. A subscription is tied to a given address, but a customer can have multiple addresses.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join addresses with | on |
|---|---|
| charges |
addresses.id = charges.address_id addresses.customer_id = charges.customer_id |
| onetimes |
addresses.id = onetimes.address_id addresses.customer_id = onetimes.customer_id |
| orders |
addresses.id = orders.address_id addresses.customer_id = orders.customer_id |
| subscriptions |
addresses.id = subscriptions.address_id addresses.customer_id = subscriptions.customer_id |
| customers |
addresses.customer_id = customers.id |
| discounts |
addresses.discount_id = discounts.id |
|
address1 STRING |
|||
|
address2 STRING |
|||
|
cart_attributes
ARRAY
|
|||
|
cart_note STRING |
|||
|
city STRING |
|||
|
company STRING |
|||
|
country STRING |
|||
|
country_code STRING |
|||
|
created_at DATE-TIME |
|||
|
customer_id INTEGER |
|||
|
discount_id INTEGER |
|||
|
discounts
ARRAY
|
|||
|
first_name STRING |
|||
|
id
INTEGER |
|||
|
last_name STRING |
|||
|
note_attributes
ARRAY
|
|||
|
order_attributes
ARRAY
|
|||
|
order_note STRING |
|||
|
original_shipping_lines
ARRAY
|
|||
|
payment_method_id INTEGER |
|||
|
phone STRING |
|||
|
presentment_currency STRING |
|||
|
province STRING |
|||
|
shipping_lines_override
ARRAY
|
|||
|
updated_at
DATE-TIME |
|||
|
zip STRING |
charges
The charges table contains info about charges. A charge is a placeholder for an upcoming charge once the charge is processed successfully.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join charges with | on |
|---|---|
| addresses |
charges.address_id = addresses.id charges.customer_id = addresses.customer_id |
| onetimes |
charges.address_id = onetimes.address_id charges.customer_id = onetimes.customer_id charges.line_items.shopify_product_id = onetimes.shopify_product_id |
| orders |
charges.address_id = orders.address_id charges.id = orders.charge_id charges.customer_id = orders.customer_id charges.line_items.shopify_product_id = orders.line_items.shopify_product_id charges.line_items.subscription_id = orders.line_items.subscription_id |
| subscriptions |
charges.address_id = subscriptions.address_id charges.customer_id = subscriptions.customer_id charges.line_items.shopify_product_id = subscriptions.shopify_product_id charges.line_items.subscription_id = subscriptions.id |
| customers |
charges.customer_id = customers.id |
| products |
charges.line_items.shopify_product_id = products.id |
|
address_id INTEGER |
|||||||||||||||||||||||||||||||||||
|
analytics_data OBJECT
|
|||||||||||||||||||||||||||||||||||
|
billing_address OBJECT
|
|||||||||||||||||||||||||||||||||||
|
browser_ip STRING |
|||||||||||||||||||||||||||||||||||
|
client_details OBJECT
|
|||||||||||||||||||||||||||||||||||
|
created_at DATE-TIME |
|||||||||||||||||||||||||||||||||||
|
currency STRING |
|||||||||||||||||||||||||||||||||||
|
customer OBJECT
|
|||||||||||||||||||||||||||||||||||
|
customer_hash STRING |
|||||||||||||||||||||||||||||||||||
|
customer_id INTEGER |
|||||||||||||||||||||||||||||||||||
|
discount_codes
ARRAY
|
|||||||||||||||||||||||||||||||||||
|
discounts
ARRAY
|
|||||||||||||||||||||||||||||||||||
|
STRING |
|||||||||||||||||||||||||||||||||||
|
external_order_id OBJECT
|
|||||||||||||||||||||||||||||||||||
|
external_transaction_id OBJECT
|
|||||||||||||||||||||||||||||||||||
|
first_name STRING |
|||||||||||||||||||||||||||||||||||
|
has_uncommited_changes BOOLEAN |
|||||||||||||||||||||||||||||||||||
|
id
INTEGER |
|||||||||||||||||||||||||||||||||||
|
last_name STRING |
|||||||||||||||||||||||||||||||||||
|
line_items
ARRAY
|
|||||||||||||||||||||||||||||||||||
|
note STRING |
|||||||||||||||||||||||||||||||||||
|
note_attributes
ARRAY
|
|||||||||||||||||||||||||||||||||||
|
order_attributes
ARRAY
|
|||||||||||||||||||||||||||||||||||
|
orders_count INTEGER |
|||||||||||||||||||||||||||||||||||
|
payment_processor STRING |
|||||||||||||||||||||||||||||||||||
|
processed_at DATE-TIME |
|||||||||||||||||||||||||||||||||||
|
processor_name STRING |
|||||||||||||||||||||||||||||||||||
|
retry_date DATE-TIME |
|||||||||||||||||||||||||||||||||||
|
scheduled_at DATE-TIME |
|||||||||||||||||||||||||||||||||||
|
shipments_count INTEGER |
|||||||||||||||||||||||||||||||||||
|
shipping_address OBJECT
|
|||||||||||||||||||||||||||||||||||
|
shipping_lines
ARRAY
|
|||||||||||||||||||||||||||||||||||
|
shopify_order_id STRING |
|||||||||||||||||||||||||||||||||||
|
status STRING |
|||||||||||||||||||||||||||||||||||
|
sub_total STRING |
|||||||||||||||||||||||||||||||||||
|
subtotal_price STRING |
|||||||||||||||||||||||||||||||||||
|
tags STRING |
|||||||||||||||||||||||||||||||||||
|
tax_lines
ARRAY
|
|||||||||||||||||||||||||||||||||||
|
taxable BOOLEAN |
|||||||||||||||||||||||||||||||||||
|
total_discounts STRING |
|||||||||||||||||||||||||||||||||||
|
total_line_items_price STRING |
|||||||||||||||||||||||||||||||||||
|
total_price STRING |
|||||||||||||||||||||||||||||||||||
|
total_refunds STRING |
|||||||||||||||||||||||||||||||||||
|
total_tax STRING |
|||||||||||||||||||||||||||||||||||
|
total_weight INTEGER |
|||||||||||||||||||||||||||||||||||
|
total_weight_grams INTEGER |
|||||||||||||||||||||||||||||||||||
|
transaction_id STRING |
|||||||||||||||||||||||||||||||||||
|
type STRING |
|||||||||||||||||||||||||||||||||||
|
updated_at
DATE-TIME |
collections
The collections table contains info about your collections.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join collections with | on |
|---|---|
| products |
collections.id = products.collection_id |
|
created_at DATE-TIME |
|
description STRING |
|
id
INTEGER |
|
name STRING |
|
sort_order STRING |
|
title STRING |
|
type STRING |
|
updated_at
DATE-TIME |
customers
The customers table contains info about customer accounts with a store.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join customers with | on |
|---|---|
| addresses |
customers.id = addresses.customer_id |
| charges |
customers.id = charges.customer_id |
| onetimes |
customers.id = onetimes.customer_id |
| orders |
customers.id = orders.customer_id |
| subscriptions |
customers.id = subscriptions.customer_id |
|
analytics_data OBJECT
|
||||||||
|
billing_address1 STRING |
||||||||
|
billing_address2 STRING |
||||||||
|
billing_city STRING |
||||||||
|
billing_company STRING |
||||||||
|
billing_country STRING |
||||||||
|
billing_phone STRING |
||||||||
|
billing_province STRING |
||||||||
|
billing_zip STRING |
||||||||
|
braintree_customer_token STRING |
||||||||
|
created_at DATE-TIME |
||||||||
|
STRING |
||||||||
|
external_customer_id OBJECT
|
||||||||
|
first_charge_processed_at DATE-TIME |
||||||||
|
first_name STRING |
||||||||
|
has_card_error_in_dunning BOOLEAN |
||||||||
|
has_payment_method_in_dunning BOOLEAN |
||||||||
|
has_valid_payment_method BOOLEAN |
||||||||
|
hash STRING |
||||||||
|
id
INTEGER |
||||||||
|
last_name STRING |
||||||||
|
number_active_subscriptions INTEGER |
||||||||
|
number_subscriptions INTEGER |
||||||||
|
paypal_customer_token STRING |
||||||||
|
processor_type STRING |
||||||||
|
reason_payment_method_not_valid STRING |
||||||||
|
status STRING |
||||||||
|
subscriptions_active_count INTEGER |
||||||||
|
subscriptions_total_count INTEGER |
||||||||
|
updated_at
DATE-TIME |
discounts
The discounts table contains info about discounts.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join discounts with | on |
|---|---|
| addresses |
discounts.id = addresses.discount_id |
|
applies_to OBJECT
|
||||||||
|
applies_to_id INTEGER |
||||||||
|
applies_to_product_type STRING |
||||||||
|
applies_to_resource STRING |
||||||||
|
channel_settings OBJECT
|
||||||||
|
code STRING |
||||||||
|
created_at DATE-TIME |
||||||||
|
duration STRING |
||||||||
|
duration_usage_limit INTEGER |
||||||||
|
ends_at DATE-TIME |
||||||||
|
external_discount_id OBJECT
|
||||||||
|
first_time_customer_restriction BOOLEAN |
||||||||
|
id
INTEGER |
||||||||
|
once_per_customer BOOLEAN |
||||||||
|
prerequisite_subtotal_min STRING |
||||||||
|
starts_at DATE-TIME |
||||||||
|
status STRING |
||||||||
|
times_used INTEGER |
||||||||
|
updated_at
DATE-TIME |
||||||||
|
usage_limit INTEGER |
||||||||
|
usage_limits OBJECT
|
||||||||
|
value STRING |
||||||||
|
value_type STRING |
metafields_customer
The metafields_customer table contains info about metafields related to customers.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
|
created_at DATE-TIME |
|
description STRING |
|
id
INTEGER |
|
key STRING |
|
namespace STRING |
|
owner_id STRING |
|
owner_resource STRING |
|
updated_at
DATE-TIME |
|
value STRING |
|
value_type STRING |
metafields_store
The metafields_store table contains info about metafields related to stores.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
|
created_at DATE-TIME |
|
description STRING |
|
id
INTEGER |
|
key STRING |
|
namespace STRING |
|
owner_id STRING |
|
owner_resource STRING |
|
updated_at
DATE-TIME |
|
value STRING |
|
value_type STRING |
metafields_subscription
The metafields_subscription table contains info about metafields related to subscriptions.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
|
created_at DATE-TIME |
|
description STRING |
|
id
INTEGER |
|
key STRING |
|
namespace STRING |
|
owner_id STRING |
|
owner_resource STRING |
|
updated_at
DATE-TIME |
|
value STRING |
|
value_type STRING |
onetimes
The onetimes table contains info about one time products.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join onetimes with | on |
|---|---|
| addresses |
onetimes.address_id = addresses.id onetimes.customer_id = addresses.customer_id |
| charges |
onetimes.address_id = charges.address_id onetimes.customer_id = charges.customer_id onetimes.shopify_product_id = charges.line_items.shopify_product_id |
| orders |
onetimes.address_id = orders.address_id onetimes.customer_id = orders.customer_id onetimes.shopify_product_id = orders.line_items.shopify_product_id |
| subscriptions |
onetimes.address_id = subscriptions.address_id onetimes.customer_id = subscriptions.customer_id onetimes.shopify_product_id = subscriptions.shopify_product_id |
| customers |
onetimes.customer_id = customers.id |
| products |
onetimes.shopify_product_id = products.id |
|
address_id INTEGER |
||
|
created_at DATE-TIME |
||
|
customer_id INTEGER |
||
|
external_product_id OBJECT
|
||
|
external_variant_id OBJECT
|
||
|
id
INTEGER |
||
|
next_charge_scheduled_at DATE-TIME |
||
|
price STRING |
||
|
product_title STRING |
||
|
properties
ARRAY
|
||
|
quantity INTEGER |
||
|
recharge_product_id INTEGER |
||
|
shopify_product_id INTEGER |
||
|
shopify_variant_id INTEGER |
||
|
sku STRING |
||
|
sku_override BOOLEAN |
||
|
status STRING |
||
|
updated_at
DATE-TIME |
||
|
variant_title STRING |
orders
The orders table contains info about orders. Orders are created after a charge is successfully processed.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join orders with | on |
|---|---|
| addresses |
orders.address_id = addresses.id orders.customer_id = addresses.customer_id |
| charges |
orders.address_id = charges.address_id orders.charge_id = charges.id orders.customer_id = charges.customer_id orders.line_items.shopify_product_id = charges.line_items.shopify_product_id orders.line_items.subscription_id = charges.line_items.subscription_id |
| onetimes |
orders.address_id = onetimes.address_id orders.customer_id = onetimes.customer_id orders.line_items.shopify_product_id = onetimes.shopify_product_id |
| subscriptions |
orders.address_id = subscriptions.address_id orders.customer_id = subscriptions.customer_id orders.line_items.shopify_product_id = subscriptions.shopify_product_id orders.line_items.subscription_id = subscriptions.id |
| customers |
orders.customer_id = customers.id |
| products |
orders.line_items.shopify_product_id = products.id |
|
address_id INTEGER |
||||||||||||||||||||||||||||||||||||
|
address_is_active INTEGER |
||||||||||||||||||||||||||||||||||||
|
billing_address OBJECT
|
||||||||||||||||||||||||||||||||||||
|
charge OBJECT
|
||||||||||||||||||||||||||||||||||||
|
charge_id INTEGER |
||||||||||||||||||||||||||||||||||||
|
charge_status STRING |
||||||||||||||||||||||||||||||||||||
|
client_details OBJECT
|
||||||||||||||||||||||||||||||||||||
|
created_at DATE-TIME |
||||||||||||||||||||||||||||||||||||
|
currency STRING |
||||||||||||||||||||||||||||||||||||
|
customer OBJECT
|
||||||||||||||||||||||||||||||||||||
|
customer_id INTEGER |
||||||||||||||||||||||||||||||||||||
|
discount_codes
ARRAY
|
||||||||||||||||||||||||||||||||||||
|
discounts
ARRAY
|
||||||||||||||||||||||||||||||||||||
|
STRING |
||||||||||||||||||||||||||||||||||||
|
external_cart_token STRING |
||||||||||||||||||||||||||||||||||||
|
external_order_id OBJECT
|
||||||||||||||||||||||||||||||||||||
|
external_order_number OBJECT
|
||||||||||||||||||||||||||||||||||||
|
first_name STRING |
||||||||||||||||||||||||||||||||||||
|
hash STRING |
||||||||||||||||||||||||||||||||||||
|
id
INTEGER |
||||||||||||||||||||||||||||||||||||
|
is_prepaid BOOLEAN |
||||||||||||||||||||||||||||||||||||
|
last_name STRING |
||||||||||||||||||||||||||||||||||||
|
line_items
ARRAY
|
||||||||||||||||||||||||||||||||||||
|
note STRING |
||||||||||||||||||||||||||||||||||||
|
note_attributes
ARRAY
|
||||||||||||||||||||||||||||||||||||
|
order_attributes
ARRAY
|
||||||||||||||||||||||||||||||||||||
|
payment_processor STRING |
||||||||||||||||||||||||||||||||||||
|
processed_at DATE-TIME |
||||||||||||||||||||||||||||||||||||
|
scheduled_at DATE-TIME |
||||||||||||||||||||||||||||||||||||
|
shipped_date DATE-TIME |
||||||||||||||||||||||||||||||||||||
|
shipping_address OBJECT
|
||||||||||||||||||||||||||||||||||||
|
shipping_date DATE-TIME |
||||||||||||||||||||||||||||||||||||
|
shipping_lines
ARRAY
|
||||||||||||||||||||||||||||||||||||
|
shopify_cart_token STRING |
||||||||||||||||||||||||||||||||||||
|
shopify_customer_id STRING |
||||||||||||||||||||||||||||||||||||
|
shopify_id STRING |
||||||||||||||||||||||||||||||||||||
|
shopify_order_id STRING |
||||||||||||||||||||||||||||||||||||
|
shopify_order_number INTEGER |
||||||||||||||||||||||||||||||||||||
|
status STRING |
||||||||||||||||||||||||||||||||||||
|
subtotal_price STRING |
||||||||||||||||||||||||||||||||||||
|
tags STRING |
||||||||||||||||||||||||||||||||||||
|
tax_lines
ARRAY
|
||||||||||||||||||||||||||||||||||||
|
taxable BOOLEAN |
||||||||||||||||||||||||||||||||||||
|
total_discounts STRING |
||||||||||||||||||||||||||||||||||||
|
total_line_items_price NUMBER |
||||||||||||||||||||||||||||||||||||
|
total_price STRING |
||||||||||||||||||||||||||||||||||||
|
total_refunds STRING |
||||||||||||||||||||||||||||||||||||
|
total_tax STRING |
||||||||||||||||||||||||||||||||||||
|
total_weight INTEGER |
||||||||||||||||||||||||||||||||||||
|
total_weight_grams INTEGER |
||||||||||||||||||||||||||||||||||||
|
transaction_id STRING |
||||||||||||||||||||||||||||||||||||
|
type STRING |
||||||||||||||||||||||||||||||||||||
|
updated_at
DATE-TIME |
products
The products table contains info about your products. This table uses the 2021-01 API version.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join products with | on |
|---|---|
| collections |
products.collection_id = collections.id |
| charges |
products.id = charges.line_items.shopify_product_id |
| onetimes |
products.id = onetimes.shopify_product_id |
| orders |
products.id = orders.line_items.shopify_product_id |
| subscriptions |
products.id = subscriptions.shopify_product_id |
|
collection_id INTEGER |
|||||||||||||
|
created_at DATE-TIME |
|||||||||||||
|
discount_amount NUMBER |
|||||||||||||
|
discount_type STRING |
|||||||||||||
|
handle STRING |
|||||||||||||
|
id
INTEGER |
|||||||||||||
|
images OBJECT
|
|||||||||||||
|
product_id INTEGER |
|||||||||||||
|
shopify_product_id INTEGER |
|||||||||||||
|
subscription_defaults OBJECT
|
|||||||||||||
|
title STRING |
|||||||||||||
|
updated_at
DATE-TIME |
store
The store table contains info about your store.
|
Full Table |
|
|
Primary Key |
id |
| Useful links |
|
checkout_logo_url STRING |
|||
|
checkout_platform STRING |
|||
|
created_at DATE-TIME |
|||
|
currency STRING |
|||
|
customer_portal_base_url STRING |
|||
|
default_api_version STRING |
|||
|
domain STRING |
|||
|
STRING |
|||
|
external_platform STRING |
|||
|
iana_timezone STRING |
|||
|
id
INTEGER |
|||
|
identifier STRING |
|||
|
merchant_portal_base_url STRING |
|||
|
my_shopify_domain STRING |
|||
|
name STRING |
|||
|
phone STRING |
|||
|
shop_email STRING |
|||
|
shop_phone STRING |
|||
|
timezone OBJECT
|
|||
|
updated_at DATE-TIME |
|||
|
weight_unit STRING |
subscriptions
The subscriptions table contains info about subscriptions. Subscriptions are individual items that customers receive on a recurring basis.
|
Key-based Incremental |
|
|
Primary Key |
id |
|
Replication Key |
updated_at |
| Useful links |
| Join subscriptions with | on |
|---|---|
| addresses |
subscriptions.address_id = addresses.id subscriptions.customer_id = addresses.customer_id |
| charges |
subscriptions.address_id = charges.address_id subscriptions.customer_id = charges.customer_id subscriptions.shopify_product_id = charges.line_items.shopify_product_id subscriptions.id = charges.line_items.subscription_id |
| onetimes |
subscriptions.address_id = onetimes.address_id subscriptions.customer_id = onetimes.customer_id subscriptions.shopify_product_id = onetimes.shopify_product_id |
| orders |
subscriptions.address_id = orders.address_id subscriptions.customer_id = orders.customer_id subscriptions.shopify_product_id = orders.line_items.shopify_product_id subscriptions.id = orders.line_items.subscription_id |
| customers |
subscriptions.customer_id = customers.id |
| products |
subscriptions.shopify_product_id = products.id |
|
address_id INTEGER |
||||||||
|
analytics_data OBJECT
|
||||||||
|
cancellation_reason STRING |
||||||||
|
cancellation_reason_comments STRING |
||||||||
|
cancelled_at DATE-TIME |
||||||||
|
charge_interval_frequency STRING |
||||||||
|
created_at DATE-TIME |
||||||||
|
customer_id INTEGER |
||||||||
|
expire_after_specific_number_of_charges INTEGER |
||||||||
|
external_product_id OBJECT
|
||||||||
|
external_variant_id OBJECT
|
||||||||
|
has_queued_charges BOOLEAN |
||||||||
|
id
INTEGER |
||||||||
|
is_prepaid BOOLEAN |
||||||||
|
is_skippable BOOLEAN |
||||||||
|
is_swappable BOOLEAN |
||||||||
|
max_retries_reached BOOLEAN |
||||||||
|
next_charge_scheduled_at DATE-TIME |
||||||||
|
order_day_of_month STRING |
||||||||
|
order_day_of_week STRING |
||||||||
|
order_interval_frequency STRING |
||||||||
|
order_interval_unit STRING |
||||||||
|
presentment_currency STRING |
||||||||
|
price STRING |
||||||||
|
product_title STRING |
||||||||
|
properties
ARRAY
|
||||||||
|
quantity INTEGER |
||||||||
|
recharge_product_id INTEGER |
||||||||
|
shopify_product_id INTEGER |
||||||||
|
shopify_variant_id INTEGER |
||||||||
|
sku STRING |
||||||||
|
sku_override BOOLEAN |
||||||||
|
status STRING |
||||||||
|
updated_at
DATE-TIME |
||||||||
|
variant_title STRING |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.