Integration Specifications
This page will help you learn about how Daasity replicates data from Recharge, limitations to the data we can extract and where the data is stored in the Recharge schema.
Integration Overview
Recharge is one of the key subscription platforms available for eCommerce. The platform allows you to stay connected to your users and can help bolster your recurring revenue and reduce churn. Out of the box, you can allow your users to have better control over their deliveries, understand their reasons for churning and improve payment conversions with automatic retries and dunning.
Daasity's Recharge extraction helps you understand your recharge data, pulling in key data points from charges, customers, orders, subscriptions, and subscribers to help you take action on the best (and worst) performing areas.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
The Daasity Recharge extractor is built based on this Recharge API documentation. The following endpoints are used by Daasity to replicate data from Recharge:
NOTE: Recharge Version 2021-01 uses API keys to authenticate requests. Each request contains an API token in the following header:
X-Recharge-Access-Token:store_api_token
Where store_api_token is the merchant API key. All requests must be made over HTTPS.
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Recharge integration illustrating the different tables and keys to join across tables.
Recharge Schema
The Daasity Recharge extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Subscriptions
Endpoint: Subscriptions
Update Method: UPSERT
Table Name: [
recharge.subscriptions]
ID
Recharge_Subscription_ID
Customer_ID
Recharge_Customer_ID
Next_Charge_Scheduled_At
Next_Charge_Scheduled_At
Cancelled_At
Cancelled_At
Product_Title
Product_Title
Variant_Title
Variant_Title
Price
Price
Quantity
Quantity
Status
Subscription_Status
Shopify_Product_ID
Shopify_Product_ID
Shopify_Variant_ID
Shopify_Variant_ID
SKU
SKU
Order_Interval_Unit
Order_Interval_Unit
Order_Interval_Frequency
Order_Interval_Frequency
Charge_Interval_Frequency
Charge_Interval_Frequency
Cancellation_Reason
Cancellation_Reason
Cancellation_Reason_Comments
Cancellation_Reason_Comments
Expire_After_Specific_Number_Of_Charges
Expire_After_Certain_Number_Of_Charges
Created_At
Created_At
Updated_At
Updated_At
Subscription Properties
Endpoint: Subscriptions
Update Method: UPSERT
Table Name: [
recharge.subscription_properties]
ID
Recharge_Subscription_ID
Name
Name
Value
Value
Customers
Endpoint: Customers
Update Method: UPSERT
Table Name: [
recharge.customers]
ID
Recharge_Customer_ID
Hash
Hashed_Recharge_Customer_ID
External_Customer_ID:Shopify
Shopify_Customer_ID
Created_At
Created_At
Updated_At
Updated_At
First_Name
Billing_First_Name
Last_Name
Billing_Last_Name
Status
Status
Has_Valid_Payment_Method
Has_Valid_Payment_Method
Number_Subscriptions
Number_Subscriptions
Number_Active_Subscriptions
Number_Active_Subscriptions
First_Charge_Processed_At
First_Charge_Processed_At
Charges
Endpoint: Charges
Update Method: UPSERT
Table Name: [
recharge.charges]
ID
Recharge_Charge_ID
Customer_ID
Recharge_Customer_ID
Shopify_Order_ID
Order_ID
Client_Details:Browser_IP
Browser_IP
Processed_At
Processed_At
Scheduled_At
Scheduled_At
Status
Status
Total_Discounts
Total_Discounts
Total_Line_Items_Price
Total_Line_Items_Price
Total_Price
Total_Price
Total_Refunds
Total_Refunds
Total_Tax
Total_Tax
Type
Type
Created_At
Created_At
Updated_At
Updated_At
Error
Error
Error_Type
Error_Type
Charge Discount Codes
Endpoint: Charges
Update Method: UPSERT
Table Name: [
recharge.charge_discount_codes]
ID
Recharge_Charge_ID
Code
Code
Amount
Amount
Type
Type
Charge Line Items
Endpoint: Charges
Update Method: UPSERT
Table Name: [
recharge.charge_line_items]
ID
Recharge_Charge_ID
Subscription_ID
Recharge_Subscription_ID
Shopify_Product_ID
Product_ID
Shopify_Variant_ID
Variant_ID
Price
Price
Quantity
Quantity
Charge Shipping Lines
Endpoint: Charges
Update Method: UPSERT
Table Name: [
recharge.charge_shipping_lines]
ID
Recharge_Charge_ID
Code
Code
Price
Price
Title
Title
Orders
Endpoint: Orders
Update Method: UPSERT
Table Name: [
recharge.orders]
ID
Recharge_Order_ID
Charge::ID
Recharge_Charge_ID
Customer_ID
Recharge_Customer_ID
Shopify_Order_ID
Order_ID
Address_Is_Active
Address_Is_Active
Is_Prepaid
Is_Prepaid
Order Line Items
Endpoint: Orders
Update Method: UPSERT
Table Name: [
recharge.order_line_items]
ID
Recharge_Order_ID
Charge::ID
Recharge_Charge_ID
Subscription_ID
Recharge_Subscription_ID
Shopify_Product_ID
Product_ID
Shopify_Variant_ID
Variant_ID
SKU
SKU
Title
Title
Quantity
Quantity
Price
Price
Last updated