Integration Specifications
This page will help you learn about how Daasity replicates data from ShipStation, limitations to the data we can extract and where the data is stored in the ShipStation schema
Integration Overview
ShipStation is a web-based shipping platform that helps businesses manage their small parcel shipping and e-commerce fulfillment.
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
Growth
NOTE: A code block exists to include shipping costs into Daasity data model (UOS) from ShipStation
API Endpoints
The Daasity integration with ShipStation extracts data from a number of endpoints from the ShipStation API.
The following endpoints are currently included in the Integration and currently refreshed on a daily basis:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Shipstation integration illustrating the different tables and keys to join across tables.
ShipStation Schema
The Daasity ShipStation 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.
Carriers
Endpoint: List Carriers
Update method: UPSERT
Table name: [
shipstation.carriers]
MD5(shippingProviderId + accountNumber)
id
name
name
code
code
accountNumber
account_number
requiresFundedAccount
requires_funded_account
balance
balance
shippingProviderId
shipping_provider_id
nickname
nickname
primary
is_primary
Carrier Packages
Endpoint: List Packages
Update method: UPSERT
Table name: [
shipstation.carrier_packages]
MD5(carrierCode + code)
id
carrierCode
carrier_code
code
code
name
name
domestic
domestic
international
international
Carrier Services
Endpoint: List Services
Update method: UPSERT
Table name: [
shipstation.carrier_services]
MD5(carrierCode + code)
id
carrierCode
carrier_code
code
code
name
name
domestic
domestic
international
international
Orders
Endpoint: List Orders
Update method: UPSERT
Table name: [
shipstation.orders]
orderId
id
orderId
order_id
orderNumber
order_number
orderKey
order_key
orderDate
order_date
createDate
create_date
modifyDate
modify_date
paymentDate
payment_date
shipByDate
ship_by_date
orderStatus
order_status
customerId
customer_id
customerUsername
customer_username
customerEmail
customer_email
shipTo::name
ship_to_name
shipTo::company
ship_to_company
shipTo::street1
ship_to_street1
shipTo::street2
ship_to_street2
shipTo::city
ship_to_city
shipTo::state
ship_to_state
shipTo::postalCode
ship_to_postal_code
shipTo::country
ship_to_country
shipTo::phone
ship_to_phone
orderTotal
order_total
amountPaid
amount_paid
taxAmount
tax_amount
shippingAmount
shipping_amount
paymentMethod
payment_method
carrierCode
carrier_code
serviceCode
service_code
packageCode
package_code
shipDate
ship_date
holdUntilDate
hold_until_date
advanced_options::warehouseId
warehouse_id
Order Items
Endpoint: List Orders
Update method: UPSERT
Table name: [
shipstation.order_items]
MD5(productId + orderId + orderItemId)
key
orderID
order_id
orderItemID
order_item_id
lineItemKey
line_item_key
sku
sku
name
name
quantity
quantity
unitPrice
unit_price
taxAmount
tax_amount
shippingAmount
shipping_amount
productID
product_id
fulfillmentSku
fulfillment_sku
upc
upc
modifyDate
modify_date
createDate
create_date
Shipments
Endpoint: List Shipments
Update method: UPSERT
Table name: [
shipstation.shipments]
shipmentId
id
shipmentId
shipment_id
orderId
order_id
orderKey
order_key
customerEmail
customer_email
orderNumber
order_number
createDate
create_date
shipDate
ship_date
shipmentCost
shipment_cost
insuranceCost
insurance_cost
trackingNumber
tracking_number
isReturnLabel
is_return_label
batchNumber
batch_number
carrierCode
carrier_code
serviceCode
service_code
packageCode
package_code
confirmation
confirmation
warehouseId
warehouse_id
voided
voided
voidDate
void_date
shipTo::name
ship_to_name
shipTo::company
ship_to_company
shipTo::street1
ship_to_street1
shipTo::street2
ship_to_steet2
shipTo::city
ship_to_city
shipTo::state
ship_to_state
shipTo::postalCode
ship_to_postal_code
shipTo::country
ship_to_country
userId
user_id
Shipment Line Items
Endpoint: List Shipments
Update method: UPSERT
Table name: [
shipstation.shipment_line_items]
MD5(productId + shipmentId + orderItemId)
key
shipmentId
shipment_id
orderItemId
order_item_id
LineItemKey
line_item_key
sku
sku
name
name
quantity
quantity
unitPrice
unit_price
taxAmount
tax_amount
shippingAmount
shipping_amount
warehouseLocation
warehouse_location
productId
product_id
fulfillmentSku
fulfillment_sku
upc
upc
SKUs
Endpoint: List Products
Update method: UPSERT
Table name: [
shipstation.skus]
productId
id
productId
product_id
sku
sku
name
name
price
price
defaultCost
default_cost
length
length
width
width
height
height
weightOz
weight_oz
fulfillmentSku
fulfillment_sku
createDate
created_at
modifyDate
modified_at
active
active
productType
product_type
warehouseLocation
warehouse_location
SKU Attributes
Endpoint: List Products
Update method: UPSERT
Table name: [
shipstation.sku_attributes]
MD5(productId + tag_id)
key
productId
product_id
tag_id
tag_id
name
name
Users
Endpoint: List Users
Update method: UPSERT
Table name: [
shipstation.user]
userId
id
userName
user_name
name
name
active
active
Warehouses
Endpoint: List Warehouses
Update method: UPSERT
Table name: [
shipstation.warehouses]
warehouseId
id
warehouseId
warehouse_id
warehouseName
name
Last updated