Integration: Loop

This article will help you learn about how Daasity replicates data from Loop, limitations to the data we can extract and where the data is stored in the Loop Returns schema.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

Integration Availability

This integration is available for:

  • Growth
  • Pro (V1 and V2)

Integration Overview

Loop 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 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 performance of the product with return data included.

API Endpoints

The Daasity Loop 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)

The embedded diagram houses the ERD for the Daasity Loop integration illustrating the different tables and keys to join across tables.  Hover over the embedded diagram to reveal controls to zoom and scroll.

 

Loop Returns Schema

The Daasity Loop 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.

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 email
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
 

 

Related Resources