Integration Specifications
This page will help you learn about how Daasity replicates data from Loop Returns, limitations to the data we can extract, and where the data is stored in the Loop Returns schema.
Integration Overview
Loop Returns is a Shopify SaaS platform that enables merchants to simplify the returns process and encourage customers to turn returns into exchanges by offering 4 ways to return: exchange, shop now, store credit, or refund.
The Daasity Loop Returns integration extracts returns, return lines, and exchange lines from Loop Returns which allows the merchant to link their Shopify data to their Return data and better analyze their returns and the performance of the product with return data included.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
The Daasity Loop Returns integration is built based on this Loop Returns API documentation. The following endpoints are used by Daasity to replicate data from Loop:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Loop Returns integration illustrating the different tables and keys to join across tables.
Loop Returns Schema
The Daasity Loop extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.
Returns
Endpoint: Returns
Update Method: UPSERT
Table Name: [
loop_returns.returns]
| JSON Element | Database Column |
|---|---|
id | return_id |
state | return_state |
created_at | created_at |
updated_at | updated_at |
total | total |
order_id | order_id |
order_name | order_code |
provider_order_id | shopify_order_id |
order_number | order_number |
customer | |
currency | currency |
return_product_total | return_product_total |
return_discount_total | return_discount_total |
return_tax_total | return_tax_total |
return_total | return_total |
return_credit_total | return_credit_total |
exchange_product_total | exchange_product_total |
exchange_discount_total | exchange_discount_total |
exchange_tax_total | exchange_tax_total |
exchange_total | exchange_total |
exchange_credit_total | exchange_credit_total |
gift_card | gift_card |
handling_fee | handling_fee |
refund | refund |
upsell | upsell |
carrier | carrier |
tracking_number | tracking_number |
label_status | label_status |
label_updated_at | label_updated_at |
MD5(id + __source_id) | __sync_key |
Return Lines
Endpoint: Returns
Update Method: UPSERT
Table Name: [
loop_returns.return_lines]
| JSON Element | Database Column |
|---|---|
MD5(id + ':' + line_item_id) | return_line_id |
id | return_id |
order_name | order_code |
provider_order_id | shopify_order_id |
product_id | product_id |
variant_id | variant_id |
sku | sku |
title | title |
price | price |
discount | discount |
tax | tax |
refund | refund |
returned_at | returned_at |
parent_return_reason | parent_return_reason |
barcode | barcode |
MD5(id + line_item_id + __source_id) | __sync_key |
Exchange Lines
Endpoint: Returns
Update Method: UPSERT
Table Name: [
loop_returns.exchange_lines]
| JSON Element | Database Column |
|---|---|
MD5(id + exchange_id) | exchange_line_id |
id | return_id |
exchange_id | exchange_id |
order_name | order_code |
product_id | product_id |
variant_id | variant_id |
sku | sku |
type | type |
title | title |
price | price |
discount | discount |
tax | tax |
total | total |
MD5(id + exchange_line_id + __source_id) | __sync_key |
Last updated