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