Integration: Narvar

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

Key Topics

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

Integration Overview

Narvar is an e-commerce package tracking platform that allows you to keep customers up-to-date with timely order status notifications. With Narvar, you can track shipments around the world and provide estimated delivery dates your customers can rely on.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is available for:

  • Pro V2

NOTE: You are considered V2 if...

  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com

API Endpoints

The Daasity Narvar extractor is built based on this Narvar API documentation.  The following endpoints are used by Daasity to replicate data from Narvar:

Entity Relationship Diagram (ERD)

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

Narvar Schema

The Daasity Narvar 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: narvar.returns
JSON Element Database Column
MD5(rma::rma_number) __sync_key
rma::return_status return_status
rma::rma_number rma_number
rma::order_number order_number
rma::return_creation_date return_creation_date
rma::retailer_name retailer_name
rma::return_method return_method
rma::gift gift 
rma::email email
rma::locale locale
rma::origin_zip origin_zip
rma::origin_country origin_country
rma::estimated_refund estimated_refund
rma::restocking_fee restocking_fee
rma::refund_method refund_method
rma::shopify_order_id shopify_order_id
rma::original_shopify_order_id original_shopify_order_id
rma::currency currency
rma::shop_currency shop_currency
rma::charge_payment_id charge_payment_id
rma::transaction_id transaction_id
rma::package::tracking_number tracking_number
rma::package::carrier package_carrier
rma::package::carrier_service_method package_carrier_service_method
rma::package::destination_id package_destination_id
rma::package::destination_zip package_destination_zip
rma::package::destination_city package_destination_city
rma::package::destination_country package_destination_country
rma::package::estimated_actual_shipping_fee package_estimated_actual_shipping_fee
rma::package::shipping_fee package_shipping_fee
rma::policy::refund_at policy_refund_at
rma::policy::refund_automation_until policy_refund_automation_until
rma::policy::mark_as_paid_at policy_mark_as_paid_at
rma::policy::restock_at policy_restock_at
rma::policy::restock_automation_until policy_restock_automation_until
rma::policy::reserve_inventory_at policy_reserve_inventory_at
rma::policy::reserve_automation_id policy_reserve_automation_until

Items

  • Endpoint: Returns
  • Update Method: UPSERT
  • Table Name: narvar.items
JSON Element Database Column
MD5(rma::rma_number + item::sku + item::item_id) __sync_key
rma::rma_number rma_number
item::sku sku
item::item_id item_id
item::reason reason
item::reason_code reason_code
item::comment comment
item::unit_price unit_price
item::total_item_price total_item_price
item::transaction_type transaction_type
item::keep_the_item keep_the_item
item::child_reason child_reason
item::child_reason_code child_reason_code
item::unit_price_original_shop unit_price_original_shop
item::unit_discount_shop unit_discount_shop
item::unit_tax_shop unit_tax_shop
item::unit_final_shop unit_final_shop
item::unit_price_original_presentment unit_price_original_presentment
item::unit_discount_presentment unit_discount_presentment
item::unit_final_presentment unit_final_presentment
item::current_processing_state::status processing_state_status
item::current_processing_state::quantity processing_state_quantity
item::current_processing_state::timestamp processing_state_timestamp
item::exchange_item::variant_title exchange_item_variant_title
item::exchange_item::variant_id exchange_item_variant_id
item::exchange_item::variant_sku exchange_item_variant_sku
item::exchange_item::product_id exchange_item_product_id
item::exchange_item::exchange_quantity exchange_item_exchange_quantity

Exchange Options

  • Endpoint: Returns
  • Update Method: UPSERT
  • Table Name: narvar.exchange_options
JSON Element Database Column
MD5(rma::rma_number + exchange_option::sku + exchange_option::item_id + exchange_option::variant_id + exchange_option::name + exchange_option::value) __sync_key
rma::rma_number rma_number
sku sku
item_id item_id
variant_id variant_id
name name
value value

Transactions

  • Endpoint: Returns
  • Update Method: UPSERT
  • Table Name: narvar.transactions
JSON Element Database Column
MD5(rma::rma_number + transaction::id) __sync_key
rma::rma_number rma_number
transaction::id id
transaction::timestamp timestamp
transaction::source source
transaction::amount amount
transaction::currency currency
transaction::refund_method refund_method
transaction::giftcard_id giftcard_id
transaction::authorization auth
transaction::conversion_rate_to_shop conversion_rate_to_shop

Fee Breakdown

  • Endpoint: Returns
  • Update Method: UPSERT
  • Table Name: narvar.fee_breakdown
JSON Element Database Column
MD5(rma_number + transaction::id + breakdown::description) __sync_key
rma::rma_number rma_number
transaction::id transaction_id
breakdown::fee fee
breakdown::currency currency
breakdown::description description
breakdown::tax_code tax_code
breakdown::display_with_return_method display_with_return_method
breakdown::formatted_fee formatted_fee

 

Related Resources