Loop Returns Extractor

 

Loop_logo.png

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.

Integration overview

The Daasity integration with Loop Returns 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

This integration is available for:

  • Growth
  • Pro V1 & V2

ERD

 

Endpoint: Returns

Data is retrieved by accessing the api.loopreturns.com/api/v1/warehouse/return/list API endpoint.

RETURNS TABLE

Data Mapping

JSON Element  Database Colum 
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
 

 

Business Rules

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key return_id + __source_id
 

 

RETURN LINES TABLE

Data Mapping

JSON Element  Database Colum 
MD5(id ||’:’||line_item_id)  return_line_id 
id  return_id 
order_name order_code
provider_order_id shopify_order_id
line_item_id line_item_id 
provider_line_item_id shopify_line_item_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
exchange_variant exchange_variant
return_reason return_reason
parent_return_reason parent_return_reason
barcode barcode
 

Business Rules

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key return_id + line_item_id + __source_id
 

 

EXCHANGE LINES TABLE

Data Mapping

JSON Element  Database Colum 
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
 

Business Rules

Business Rule Value
Load Type UPSERT
Extraction Frequency Daily
Sync Key return_id + exchange_line_id + __source_id
 
All content © Daasity 2020. Do not copy, share or distribute.

 

Was this article helpful?
0 out of 0 found this helpful