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:

• Returns

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
• Return Lines
• Exchange Lines

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