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:

• Addresses

• Charges

• Customers

• Orders

• Subscriptions

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
• Subscription Properties
• Customers
• Charges
• Charge Discount Codes
• Charge Line Items
• Charges Shipping Lines
• Orders
• Order Line Items

Subscriptions

• Endpoint: Subscriptions
• Update Method: UPSERT

• Table Name: [recharge.subscriptions]

JSON Element	Database Column
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]

JSON Element	Database Column
ID	Recharge_Subscription_ID
Name	Name
Value	Value

Customers

• Endpoint: Customers
• Update Method: UPSERT

• Table Name: [recharge.customers]

JSON Element	Database Column
ID	Recharge_Customer_ID
Hash	Hashed_Recharge_Customer_ID
Email	Email
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]

JSON Element	Database Column
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]

JSON Element	Database Column
ID	Recharge_Charge_ID
Code	Code
Amount	Amount
Type	Type

Charge Line Items

• Endpoint: Charges
• Update Method: UPSERT

• Table Name: [recharge.charge_line_items]

JSON Element	Database Column
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]

JSON Element	Database Column
ID	Recharge_Charge_ID
Code	Code
Price	Price
Title	Title

Orders

• Endpoint: Orders
• Update Method: UPSERT

• Table Name: [recharge.orders]

JSON Element	Database Column
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]

JSON Element	Database Column
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