This article 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.
KEY TOPICS
Click on the links below to take you to the section where you can learn more about this integration and where it is used and how it is created
Integration Availability
This integration is available for:
- Growth
- Pro (V1 and V2)
Integration Overview
Recharge is one of the key subscription platforms available for eCommerce. The platform not only allows you to stay connected to your users, but also 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.
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)
The embedded diagram houses the ERD for the Daasity Recharge integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.
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 |