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