Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Entity Relationship Diagram (ERD)
  • Orders
  • Order Checkout Data
  • Order Metadata
  • Order Discount List
  • Order Notes
  • Order Items
  • Order Items Variation List
  • Order Shipments

Was this helpful?

  1. Extract
  2. All Integrations
  3. Order Desk

Integration Specifications

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

PreviousIntegration SetupNextWorkflow Configuration Setup

Last updated 1 year ago

Was this helpful?

Integration Overview

Order Desk automates and streamlines order management workflow with integrations to hundreds of e-commerce services.

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:

  • Enterprise

API Endpoints

The Daasity Order Desk extractor is built based on this . The following endpoint is used by Daasity to replicate data from Order Desk:

Entity Relationship Diagram (ERD)

illustrating the different tables and keys to join across tables.

Order Desk Schema

The Daasity Order Desk 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.

Orders

  • Update Method: UPSERT

  • Table Name: [order_desk.orders]

JSON Element
Database Column

id

id

email

email

shipping_method

shipping_method

quantity_total

quantity_total

weight_total

weight_total

product_total

product_total

shipping_total

shipping_total

handling_total

handling_total

tax_total

tax_total

discount_total

discount_total

order_total

order_total

cc_number_masked

cc_number_masked

cc_exp

cc_exp

processor_response

processor_response

payment_type, limit: 64

payment_type

payment_status, limit: 18

payment_status

processor_balance

processor_balance

refund_total

refund_total

customer_id

customer_id

email_count

email_count

ip_address

ip_address

source_name, limit: 64

source_name

fulfillment_name

fulfillment_name

fulfillment_id

fulfillment_id

folder_id

folder_id

date_added

date_added

date_updated

date_updated

shipping::first_name, limit: 64

shipping_first_name

shipping::last_name, limit: 64

shipping_last_name

shipping::company, limit: 64

shipping_company

shipping::address1

shipping_address1

shipping::address2

shipping_address2

shipping::address3

shipping_address3

shipping::address4

shipping_address4

shipping::city, limit: 64

shipping_city

shipping::state, limit: 2

shipping_state

shipping::postal_code, limit: 64

shipping_postal_code

shipping::country, limit: 64

shipping_country

shipping::phone, limit: 64

shipping_phone

customer::first_name, limit: 64

customer_first_name

customer::last_name, limit: 64

customer_last_name

customer::company, limit: 64

customer_company

customer::address1

customer_address1

customer::address2

customer_address2

customer::city

customer_city

customer::state, limit: 2

customer_state

customer::postal_code, limit: 64

customer_postal_code

customer::country, limit: 64

customer_country

customer::phone, limit: 64

customer_phone

return_address::title, limit: 64

return_address_title

return_address::name, limit: 64

return_address_name

return_address::company, limit: 64

return_address_company

return_address::address1

return_address_address1

return_address::address2

return_address_address2

return_address::city

return_address_city

return_address::state, limit: 2

return_address_state

return_address::postal_code, limit: 64

return_address_postal_code

return_address::country, limit: 64

return_address_country

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + source_id)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Checkout Data

  • Update Method: UPSERT

  • Table Name: [order_desk.order_checkout_data]

JSON Element
Database Column

MD5(id + checkout_data::first)

order_checkout_data_id

id

order_id

custom_data::first, limit: 4095

order_checkout_data_custom_key

custom_data::last, limit: 4095

order_checkout_data_custom_value

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + checkout_data::first)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Metadata

  • Update Method: UPSERT

  • Table Name: [order_desk.order_metadata]

JSON Element
Database Column

MD5(id + custom_data.first)

order_metadata_id

id

order_id

custom_data::first, limit: 4095

order_metadata_custom_key

custom_data::last, limit: 4095

order_metadata_custom_value

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + checkout_data::first)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Discount List

  • Update Method: UPSERT

  • Table Name: [order_desk.order_discount_list]

JSON Element
Database Column

MD5(id + discount::name + discount::amount)

order_discount_id

id

order_id

discount::name, limit: 64

name

discount::code, limit: 64

code

discount::amount

amount

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + discount::name + discount::amount)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Notes

  • Update Method: UPSERT

  • Table Name: [order_desk.order_notes]

JSON Element
Database Column

MD5(id + note::date_added + note::user_name + note::content)

order_note_id

id

order_id

note::date_added

date_added

note::user_name, limit: 64

user_name

note::content, limit: 64

content

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + note::date_added + note::user_name + note::content)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Items

  • Update Method: UPSERT

  • Table Name: [order_desk.order_items]

JSON Element
Database Column

MD5(id + item::id)

order_item_id

id

order_id

item::id

id

item::name

name

item::price

price

item::quantity

quantity

item::weight

weight

item::code, limit: 64

code

item::delivery_type, limit: 64

delivery_type

item::category_code, limit:64

category_code

item::metadata

metadata

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + item::id)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Items Variation List

  • Update Method: UPSERT

  • Table Name: [order_desk.order_items_variation_list]

JSON Element
Database Column

MD5(id + custom_data.first)

order_item_variation_id

id

order_id

custom_data::first, limit: 4095

order_item_variation_custom_key

custom_data::last, limit: 4095

order_item_variation_custom_value

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + custom_data.first)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Order Shipments

  • Update Method: UPSERT

  • Table Name: [order_desk.order_shipments]

JSON Element
Database Column

MD5(id + shipping::tracking_number + shipping::carrier_code)

order_shipment_id

id

order_id

shipping::tracking_number

tracking_number

shipping::carrier_code

carrier_code

shipping::shipment_method

shipment_method

shipping::weight

weight

shipping::cost

cost

shipping::status, limit: 32

status

shipping::tracking_url, limit: 4095

tracking_url

shipping::label_format, limit: 64

label_format

shipping::label_image

label_image

shipping::print_status, limit: 64

print_status

shipping::order_items

order_items

shipping::source, limit: 64

source

shipping::cart_shipment_id, limit: 64

cart_shipment_id

shipping::label_shipment_id, limit: 64

label_shipment_id

shipping::date_shipped

date_shipped

shipping::date_added

date_added

source_id, limit: 64

__source_id

Daasity: shop_id

__shop_id

seller_id

seller_id

marketplace_id

marketplace_id

Daasity: account_id

_account_id

Daasity: MD5(id + shipping::tracking_number + shipping::carrier_code)

__sync_key

Daasity: timestamp when loaded into DB

__synced_at

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

🔌
Order Desk API documentation
Orders
Click here to view the ERD for the Daasity Order Desk integration
Orders
Orders
Orders
Orders
Orders
Orders
Orders
Orders
Orders
Order Checkout Data
Order Metadata
Order Discount List
Order Notes
Order Items
Order Items Variation List
Order Shipments