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]
| 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 |
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 |
Last updated