ShipStation
Explore the interactive ERD
Table & Field Reference
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_intl_package_code | Unknown | FK |
default_intl_service_code | Unknown | FK |
default_package_code | Unknown | FK |
default_service_code | Unknown | FK |
sku | Unknown | FK |
active | Unknown | |
aliases | Unknown | |
create_date | LocalDateTime | |
customs_country_code | Unknown | |
customs_description | Unknown | |
customs_tariff_number | Unknown | |
customs_value | Unknown | |
default_confirmation | Unknown | |
default_cost | Unknown | |
default_intl_confirmation | Unknown | |
fulfillment_sku | Unknown | |
height | Unknown | |
internal_note | Unknown | |
length | Unknown | |
modify_date | LocalDateTime | |
name | Unknown | |
no_customs | Unknown | |
price | Unknown | |
product_category_category_id | Unknown | |
product_category_name | Unknown | |
product_type | Unknown | |
warehouse_location | Unknown | |
weight_oz | Unknown | |
width | Unknown |
package
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
shipping_provider_id | Unknown | FK |
carrier_code | Unknown | |
domestic | Unknown | |
international | Unknown | |
name | Unknown |
shipping_provider
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_number | Unknown | |
balance | Unknown | |
code | Unknown | |
is_primary | Unknown | |
name | Unknown | |
nickname | Unknown | |
requires_funded_account | Unknown |
shipment_item
| Column | Type | Keys |
|---|---|---|
order_item_id | Unknown | PKFK |
product_id | Unknown | FK |
shipment_id | Unknown | FK |
sku | Unknown | FK |
fulfillment_sku | Unknown | |
image_url | Unknown | |
line_item_key | Unknown | |
name | Unknown | |
options | Unknown | |
quantity | Unknown | |
unit_price | Unknown | |
warehouse_location | Unknown | |
weight | Unknown |
shipment_merged
| Column | Type | Keys |
|---|---|---|
merged_order_id | Unknown | PKFK |
shipment_id | Unknown | PKFK |
shipment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
package_code | Unknown | FK |
service_code | Unknown | FK |
user_id | Unknown | FK |
warehouse_id | Unknown | FK |
advanced_options_bill_to_account | Unknown | |
advanced_options_bill_to_country_code | Unknown | |
advanced_options_bill_to_my_other_account | Unknown | |
advanced_options_bill_to_party | Unknown | |
advanced_options_bill_to_postal_code | Unknown | |
advanced_options_contains_alcohol | Unknown | |
advanced_options_custom_field_1 | Unknown | |
advanced_options_custom_field_2 | Unknown | |
advanced_options_custom_field_3 | Unknown | |
advanced_options_merged_or_split | Unknown | |
advanced_options_non_machinable | Unknown | |
advanced_options_parent_id | Unknown | |
advanced_options_saturday_delivery | Unknown | |
advanced_options_source | Unknown | |
advanced_options_store_id | Unknown | |
advanced_options_warehouse_id | Unknown | |
batch_number | Unknown | |
confirmation | Unknown | |
create_date | LocalDateTime | |
dimensions_height | Unknown | |
dimensions_length | Unknown | |
dimensions_units | Unknown | |
dimensions_width | Unknown | |
form_data | Unknown | |
insurance_cost | Unknown | |
insurance_options_insure_shipment | Unknown | |
insurance_options_insured_value | Unknown | |
insurance_options_provider | Unknown | |
is_return_label | Unknown | |
label_data | Unknown | |
marketplace_notified | Unknown | |
notify_error_message | Unknown | |
order_key | Unknown | |
order_number | Unknown | |
ship_date | LocalDate | |
ship_to_city | Unknown | |
ship_to_company | Unknown | |
ship_to_country | Unknown | |
ship_to_name | Unknown | |
ship_to_phone | Unknown | |
ship_to_postal_code | Unknown | |
ship_to_residential | Unknown | |
ship_to_state | Unknown | |
ship_to_street_1 | Unknown | |
ship_to_street_2 | Unknown | |
ship_to_street_3 | Unknown | |
shipment_cost | Unknown | |
shipping_provider_code | Unknown | |
tracking_number | Unknown | |
void_date | Unknown | |
voided | Unknown | |
weight_units | Unknown | |
weight_value | Unknown |
marketplace
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
can_confirm_shipments | Unknown | |
can_refresh | Unknown | |
name | Unknown | |
supports_custom_mappings | Unknown | |
supports_custom_statuses | Unknown |
inventory_warehouse
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Instant | |
name | Unknown | |
updated_at | Instant |
store
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
marketplace_id | Unknown | FK |
account_name | Unknown | |
active | Unknown | |
auto_refresh | Unknown | |
company_name | Unknown | |
create_date | LocalDateTime | |
email | Unknown | |
integration_url | Unknown | |
last_refresh_attempt | LocalDateTime | |
marketplace_name | Unknown | |
modify_date | LocalDateTime | |
phone | Unknown | |
public_email | Unknown | |
refresh_date | LocalDateTime | |
store_name | Unknown | |
website | Unknown |
warehouse
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
create_date | LocalDateTime | |
ext_inventory_identity | Unknown | |
is_default | Unknown | |
origin_address_address_verified | Unknown | |
origin_address_city | Unknown | |
origin_address_company | Unknown | |
origin_address_country | Unknown | |
origin_address_name | Unknown | |
origin_address_phone | Unknown | |
origin_address_postal_code | Unknown | |
origin_address_residential | Unknown | |
origin_address_state | Unknown | |
origin_address_street_1 | Unknown | |
origin_address_street_2 | Unknown | |
origin_address_street_3 | Unknown | |
register_fedex_meter | Unknown | |
return_address_address_verified | Unknown | |
return_address_city | Unknown | |
return_address_company | Unknown | |
return_address_country | Unknown | |
return_address_name | Unknown | |
return_address_phone | Unknown | |
return_address_postal_code | Unknown | |
return_address_residential | Unknown | |
return_address_state | Unknown | |
return_address_street_1 | Unknown | |
return_address_street_2 | Unknown | |
return_address_street_3 | Unknown | |
seller_integration_id | Unknown | |
warehouse_name | Unknown |
inventory
| Column | Type | Keys |
|---|---|---|
sku | Unknown | PK |
inventory_location_id | Unknown | PKFK |
inventory_warehouse_id | Unknown | FK |
allocated | Unknown | |
available | Unknown | |
average_cost_amount | Unknown | |
average_cost_currency | Unknown | |
on_hand | Unknown |
inventory_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
inventory_warehouse_id | Unknown | FK |
barcode | Unknown | |
created_at | Instant | |
name | Unknown | |
updated_at | Instant |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
user_name | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
color | Unknown | |
name | Unknown |
service
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
shipping_provider_id | Unknown | FK |
carrier_code | Unknown | |
domestic | Unknown | |
international | Unknown | |
name | Unknown |
order_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
product_id | Unknown | FK |
sku | Unknown | FK |
adjustment | Unknown | |
create_date | LocalDateTime | |
fulfillment_sku | Unknown | |
image_url | Unknown | |
line_item_key | Unknown | |
modify_date | LocalDateTime | |
name | Unknown | |
options | Json | |
quantity | Unknown | |
shipping_amount | Unknown | |
tax_amount | Unknown | |
unit_price | Unknown | |
upc | Unknown | |
warehouse_location | Unknown |
order_tag
| Column | Type | Keys |
|---|---|---|
order_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
order_merged
| Column | Type | Keys |
|---|---|---|
merged_order_id | Unknown | PKFK |
order_id | Unknown | PKFK |
orders
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
advanced_options_store_id | Unknown | FK |
advanced_options_warehouse_id | Unknown | FK |
customer_id | Unknown | FK |
package_code | Unknown | FK |
service_code | Unknown | FK |
user_id | Unknown | FK |
advanced_options_bill_to_account | Unknown | |
advanced_options_bill_to_country_code | Unknown | |
advanced_options_bill_to_my_other_account | Unknown | |
advanced_options_bill_to_party | Unknown | |
advanced_options_bill_to_postal_code | Unknown | |
advanced_options_contains_alcohol | Unknown | |
advanced_options_custom_field_1 | Unknown | |
advanced_options_custom_field_2 | Unknown | |
advanced_options_custom_field_3 | Unknown | |
advanced_options_merged_or_split | Unknown | |
advanced_options_non_machinable | Unknown | |
advanced_options_parent_id | Unknown | |
advanced_options_saturday_delivery | Unknown | |
advanced_options_source | Unknown | |
amount_paid | Unknown | |
bill_to_address_verified | Unknown | |
bill_to_city | Unknown | |
bill_to_company | Unknown | |
bill_to_country | Unknown | |
bill_to_name | Unknown | |
bill_to_phone | Unknown | |
bill_to_postal_code | Unknown | |
bill_to_residential | Unknown | |
bill_to_state | Unknown | |
bill_to_street_1 | Unknown | |
bill_to_street_2 | Unknown | |
bill_to_street_3 | Unknown | |
confirmation | Unknown | |
create_date | LocalDateTime | |
customer_email | Unknown | |
customer_notes | Unknown | |
customer_username | Unknown | |
dimensions_height | Unknown | |
dimensions_length | Unknown | |
dimensions_units | Unknown | |
dimensions_width | Unknown | |
externally_fulfilled | Unknown | |
externally_fulfilled_by | Unknown | |
externally_fulfilled_by_id | Unknown | |
externally_fulfilled_by_name | Unknown | |
gift | Unknown | |
gift_message | Unknown | |
hold_until_date | Unknown | |
insurance_options_insure_shipment | Unknown | |
insurance_options_insured_value | Unknown | |
insurance_options_provider | Unknown | |
internal_notes | Unknown | |
international_options_contents | Unknown | |
international_options_customs_items | Unknown | |
international_options_non_delivery | Unknown | |
label_messages | Unknown | |
modify_date | LocalDateTime | |
order_date | LocalDateTime | |
order_key | Unknown | |
order_number | Unknown | |
order_status | Unknown | |
order_total | Unknown | |
payment_date | LocalDateTime | |
payment_method | Unknown | |
requested_shipping_service | Unknown | |
ship_by_date | LocalDateTime | |
ship_date | LocalDate | |
ship_to_address_verified | Unknown | |
ship_to_city | Unknown | |
ship_to_company | Unknown | |
ship_to_country | Unknown | |
ship_to_name | Unknown | |
ship_to_phone | Unknown | |
ship_to_postal_code | Unknown | |
ship_to_residential | Unknown | |
ship_to_state | Unknown | |
ship_to_street_1 | Unknown | |
ship_to_street_2 | Unknown | |
ship_to_street_3 | Unknown | |
shipping_amount | Unknown | |
shipping_provider_code | Unknown | |
tax_amount | Unknown | |
weight_units_of_measurement | Unknown | |
weight_value | Unknown | |
weight_weight_units | Unknown |
fulfillment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
user_id | Unknown | FK |
create_date | LocalDateTime | |
customer_email | Unknown | |
delivery_date | Unknown | |
fulfillment_fee | Unknown | |
fulfillment_provider_code | Unknown | |
fulfillment_service_code | Unknown | |
marketplace_notified | Unknown | |
notify_error_message | Unknown | |
order_number | Unknown | |
seller_fill_provider_id | Unknown | |
seller_fill_provider_name | Unknown | |
ship_date | LocalDateTime | |
ship_to_address_verified | Unknown | |
ship_to_city | Unknown | |
ship_to_company | Unknown | |
ship_to_country | Unknown | |
ship_to_name | Unknown | |
ship_to_phone | Unknown | |
ship_to_postal_code | Unknown | |
ship_to_residential | Unknown | |
ship_to_state | Unknown | |
ship_to_street_1 | Unknown | |
ship_to_street_2 | Unknown | |
ship_to_street_3 | Unknown | |
shipping_provider_code | Unknown | |
tracking_number | Unknown | |
void_date | Unknown | |
void_requested | Unknown | |
voided | Unknown |
customer_tag
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
customer_id | Unknown | FK |
tag_id | Unknown | FK |
name | Unknown |
marketplace_username
| Column | Type | Keys |
|---|---|---|
customer_user_id | Unknown | PK |
customer_id | Unknown | FK |
marketplace_id | Unknown | FK |
create_date | LocalDateTime | |
marketplace | Unknown | |
modify_date | LocalDateTime | |
username | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address_verified | Unknown | |
city | Unknown | |
company | Unknown | |
country_code | Unknown | |
create_date | LocalDateTime | |
email | Unknown | |
modify_date | LocalDateTime | |
name | Unknown | |
phone | Unknown | |
postal_code | Unknown | |
state | Unknown | |
street_1 | Unknown | |
street_2 | Unknown |