ERD for ShipHero

50 tables

Loading diagram…

expiration_lot

string

account_id

string

name

string

sku

string

created_at

date

updated_at

date

expires_at

date

received_at

date

is_active

boolean

_weld_synced

date

expiration_lot_location

location_id

string

lot_id

string

_weld_synced

date

order

string

wholesale_order_id

string

order_number

string

partner_order_id

string

shop_name

string

fulfillment_status

string

order_date

date

total_tax

string

subtotal

string

total_discounts

string

total_price

string

box_name

string

auto_print_return_label

boolean

custom_invoice_url

string

account_id

string

updated_at

date

created_at

date

string

profile

string

gift_note

string

packing_note

string

required_ship_date

date

flagged

boolean

saturday_delivery

boolean

ignore_address_validation_errors

boolean

skip_address_validation

boolean

priority_flag

boolean

allocation_priority

int

source

string

gift_invoice

boolean

allow_partial

boolean

require_signature

boolean

adult_signature_required

boolean

alcohol

boolean

expected_weight_in_oz

string

insurance

boolean

insurance_amount

string

currency

string

has_dry_ice

boolean

allow_split

boolean

hold_until_date

date

incoterms

string

tax_id

string

tax_type

string

dry_ice_weight_in_lbs

string

ftr_exemption

string

address_is_business

boolean

do_not_print_invoice

boolean

ignore_payment_capture_errors

boolean

holds_fraud_hold

boolean

holds_address_hold

boolean

holds_shipping_method_hold

boolean

holds_operator_hold

boolean

holds_payment_hold

boolean

holds_client_hold

boolean

third_party_shipper_account_number

string

third_party_shipper_zip

string

third_party_shipper_country

string

_weld_synced

date

order_shipping_line

order_id

string

title

string

carrier

string

method

string

price

string

_weld_synced

date

order_shipping_address

order_id

string

first_name

string

last_name

string

company

string

address1

string

address2

string

city

string

state

string

state_code

string

zip

string

country

string

country_code

string

phone

string

_weld_synced

date

order_billing_address

order_id

string

first_name

string

last_name

string

company

string

address1

string

address2

string

city

string

state

string

state_code

string

zip

string

country

string

country_code

string

phone

string

_weld_synced

date

order_tag

order_id

string

tag

string

_weld_synced

date

order_authorization

order_id

string

transaction_id

string

authorized_amount

string

postauthed_amount

string

refunded_amount

string

card_type

string

date

_weld_synced

date

order_rma_label

string

order_id

string

shipment_id

string

account_id

string

rma_id

string

shipping_name

string

tracking_number

string

status

string

carrier

string

shipping_method

string

cost

string

box_code

string

paper_pdf_location

string

thermal_pdf_location

string

pdf_location

string

image_location

string

delivered

boolean

picked_up

boolean

refunded

boolean

needs_refund

boolean

profile

string

full_size_to_print

string

partner_fulfillment_id

string

created_at

date

updated_at

date

dimensions_weight

string

dimensions_height

string

dimensions_width

string

dimensions_length

string

address_name

string

address_address1

string

address_address2

string

address_city

string

address_state

string

address_country

string

address_zip

string

address_phone

string

_weld_synced

date

order_allocation

order_id

string

allocation_reference

string

warehouse_id

string

allocated_at

date

ready_to_ship

boolean

is_locked

boolean

_weld_synced

date

order_allocation_line_item

order_id

string

allocation_reference

string

parent_allocation_reference

string

warehouse_id

string

line_item_id

string

allocated_at

date

sku

string

quantity_allocated

int

is_kit_component

boolean

_weld_synced

date

order_line_item

string

order_id

string

sku

string

partner_line_item_id

string

quantity

int

price

string

product_name

string

option_title

string

fulfillment_status

string

quantity_pending_fulfillment

int

quantity_shipped

int

warehouse

string

quantity_allocated

int

backorder_quantity

int

custom_options

string

custom_barcode

string

eligible_for_return

boolean

customs_value

string

locked_to_warehouse_id

string

subtotal

string

barcode

string

created_at

date

updated_at

date

promotion_discount

string

_weld_synced

date

order_line_item_shipped_line_item_lot

string

line_item_id

string

lot_id

string

lot_name

string

lot_expiration_date

date

_weld_synced

date

order_line_item_serial_number

string

line_item_id

string

sku

string

serial_number

string

scanned

boolean

created_at

date

updated_at

date

_weld_synced

date

order_line_item_tote_pick

string

location_id

string

line_item_id

string

sku

string

created_at

date

updated_at

date

tote_id

string

current

int

picked_quantity

int

quantity

int

inventory_bin

string

deducted

boolean

_weld_synced

date

order_history

string

order_id

string

user_id

string

account_id

string

username

string

order_number

string

information

string

created_at

date

_weld_synced

date

order_merged_order

order_id

string

parent_order_id

string

is_master

boolean

_weld_synced

date

order_attachment

string

order_id

string

account_id

string

description

string

url

string

filename

string

file_type

string

file_size

int

created_at

date

_weld_synced

date

product

string

sku

string

account_id

string

name

string

barcode

string

country_of_manufacture

string

tariff_code

string

kit

boolean

kit_build

boolean

no_air

boolean

final_sale

boolean

customs_value

string

customs_description

string

not_owned

boolean

dropship

boolean

needs_serial_number

boolean

thumbnail

string

large_thumbnail

string

created_at

date

updated_at

date

product_note

string

virtual

boolean

ignore_on_invoice

boolean

ignore_on_customs

boolean

needs_lot_tracking

boolean

packer_note

string

vendor_part_number

string

consumer_package_code

string

buyer_part_number

string

buyer_style_number

string

dimensions_weight

string

dimensions_height

string

dimensions_width

string

dimensions_length

string

_weld_synced

date

product_case

string

product_id

string

product_sku

string

case_barcode

string

case_quantity

int

_weld_synced

date

product_vendor

vendor_id

string

product_id

string

product_sku

string

vendor_sku

string

price

string

_weld_synced

date

product_image

product_id

string

src

string

product_sku

string

position

string

_weld_synced

date

product_fba_inventory

string

product_id

string

product_sku

string

quantity

int

marketplace_id

string

merchant_id

string

_weld_synced

date

product_kit_component

string

parent_product_id

string

parent_product_sku

string

account_id

string

sku

string

quantity

int

_weld_synced

date

product_tag

product_id

string

tag

string

product_sku

string

_weld_synced

date

purchase_order

string

vendor_id

string

po_number

string

account_id

string

warehouse_id

string

created_at

date

po_date

date

date_closed

date

arrived_at

date

packing_note

string

fulfillment_status

string

po_note

string

description

string

partner_order_number

string

subtotal

string

discount

string

total_price

string

tax

string

shipping_method

string

shipping_carrier

string

shipping_name

string

shipping_price

string

tracking_number

string

pdf

string

images

string

payment_method

string

payment_due_by

string

payment_note

string

locking

string

locked_by_user_id

string

origin_of_shipment

string

ship_date

date

_weld_synced

date

purchase_order_line_item

string

vendor_id

string

product_id

string

po_id

string

account_id

string

warehouse_id

string

po_number

string

sku

string

vendor_sku

string

variant_id

string

quantity

int

quantity_received

int

quantity_rejected

int

price

string

product_name

string

option_title

string

expected_weight_in_lbs

string

fulfillment_status

string

sell_ahead

int

note

string

partner_line_item_id

string

barcode

string

updated_at

date

created_at

date

_weld_synced

date

purchase_order_line_item_expiration_lot

lot_id

string

po_li_id

string

po_li_sku

string

_weld_synced

date

purchase_order_attachment

string

po_id

string

url

string

user_id

string

account_id

string

po_li_sku

string

description

string

filename

string

file_type

string

file_size

int

created_at

date

_weld_synced

date

purchase_order_tracking_number

string

po_id

string

carrier_id

string

carrier_value

string

tracking_number

string

_weld_synced

date

return

string

order_id

string

account_id

string

partner_id

string

reason

string

status

string

label_type

string

label_cost

string

cost_to_customer

string

shipping_carrier

string

shipping_method

string

total_items_expected

int

total_items_received

int

total_items_restocked

int

created_at

date

display_issue_refund

boolean

dimensions_weight

string

dimensions_height

string

dimensions_width

string

dimensions_length

string

address_name

string

address_address1

string

address_address2

string

address_city

string

address_state

string

address_country

string

address_zip

string

address_phone

string

_weld_synced

date

return_label

string

return_id

string

tracking_number

string

status

string

created_date

string

carrier

string

shipping_method

string

cost

string

to_name

string

address1

string

address2

string

address_city

string

address_state

string

address_zip

string

address_country

string

pdf_location

string

dimensions_weight

string

dimensions_height

string

dimensions_width

string

dimensions_length

string

_weld_synced

date

return_line_item

string

product_id

string

return_id

string

account_id

string

line_item_id

string

warehouse_id

string

quantity

int

quantity_received

int

restock

int

condition

string

is_component

boolean

type

string

reason

string

created_at

date

updated_at

date

_weld_synced

date

return_exchange

string

return_id

string

exchange_order_id

string

account_id

string

original_return_id

string

_weld_synced

date

return_exchange_item

string

return_exchange_id

string

return_item_id

string

sku

string

quantity

int

_weld_synced

date

return_history

string

return_id

string

account_id

string

user_id

string

created_at

date

body

string

_weld_synced

date

shipment

string

order_id

string

user_id

string

warehouse_id

string

pending_shipment_id

string

profile

string

picked_up

boolean

needs_refund

boolean

refunded

boolean

delivered

boolean

shipped_off_shiphero

boolean

dropshipment

boolean

completed

boolean

created_date

date

total_packages

int

address_name

string

address_address1

string

address_address2

string

address_city

string

address_state

string

address_country

string

address_zip

string

address_phone

string

_weld_synced

date

shipment_line_item

string

shipment_id

string

line_item_id

string

shipping_label_id

string

quantity

int

_weld_synced

date

shipment_shipping_label

string

shipment_id

string

order_id

string

account_id

string

box_id

string

box_name

string

status

string

tracking_number

string

alternate_tracking_id

string

order_number

string

order_account_id

string

carrier

string

shipping_name

string

shipping_method

string

cost

string

box_code

string

device_id

string

delivered

boolean

picked_up

boolean

refunded

boolean

needs_refund

boolean

profile

string

partner_fulfillment_id

string

full_size_to_print

string

packing_slip

string

warehouse

string

warehouse_id

string

insurance_amount

string

carrier_account_id

string

source

string

created_date

date

tracking_url

string

package_number

int

parcelview_url

boolean

tracking_status

string

in_shipping_container

boolean

shipping_container_id

string

label_pdf_location

string

label_paper_pdf_location

string

label_thermal_pdf_location

string

label_image_location

string

last_mile_labels_id

string

last_mile_labels_shipping_carrier

string

last_mile_labels_shipping_method

string

last_mile_labels_tracking_number

string

last_mile_labels_tracking_url

string

dimensions_weight

string

dimensions_height

string

dimensions_width

string

dimensions_length

string

address_name

string

address_address1

string

address_address2

string

address_city

string

address_state

string

address_country

string

address_zip

string

address_phone

string

_weld_synced

date

warehouse_product

string

sku

string

account_id

string

warehouse_id

string

warehouse_identifier

string

price

string

value

string

value_currency

string

on_hand

int

inventory_bin

string

inventory_overstock_bin

string

reserve_inventory

int

replenishment_level

int

reorder_amount

int

reorder_level

int

backorder

int

allocated

int

available

int

non_sellable_quantity

int

in_tote

int

custom

boolean

customs_value

string

created_at

date

updated_at

date

sell_ahead

int

active

boolean

_weld_synced

date

warehouse_product_inbound

string

purchase_order_line_item_id

string

wp_id

string

wp_sku

string

sku

string

warehouse_id

string

po_id

string

po_date

date

quantity

int

quantity_received

int

quantity_rejected

int

sell_ahead

int

status

string

_weld_synced

date

warehouse_location

location_id

string

wp_id

string

wp_sku

string

_weld_synced

date

wholesale_order

string

vendor_id

string

order_id

string

version

string

fulfillment_flow

string

shipping_option

string

staging_location_id

string

picking_flow

string

outbound_progress

string

pickup_date

date

status

string

status_message

string

preparation_date

date

packing_layout

string

order_type

string

gs1_labels_required

boolean

trading_partner_id

string

trading_partner_name

string

store_location_number

string

distribution_center

string

vendor

string

requested_delivery_date

date

ship_not_before_date

date

ship_no_later_than_date

date

depositor_order_number

string

department

string

division

string

service_level

string

internal_supplier_number

string

terms_of_sale

string

retailer_notes

string

quote_number

string

sales_requirement_code

string

reference_fields

string

_weld_synced

date

wholesale_order_shipping_details

string

wholesale_order_id

string

account_number

string

scac

string

carrier

string

shipping_method

string

bill_of_lading

string

cost

string

trailer_number

string

pro_number

string

gs1_company_prefix

string

courier

string

_weld_synced

date

wholesale_order_line_item

string

wholesale_order_id

string

line_item_id

string

unit_of_measure

string

_weld_synced

date

inventory_change

string

location_id

string

product_id

string

user_id

string

account_id

string

warehouse_id

string

sku

string

previous_on_hand

int

change_in_on_hand

int

reason

string

cycle_counted

boolean

lot_id

string

lot_name

string

lot_expiration

string

created_at

date

_weld_synced

date

location

string

account_id

string

warehouse_id

string

name

string

zone

string

pickable

boolean

sellable

boolean

is_cart

boolean

pick_priority

int

temperature

string

last_counted

date

created_at

date

type_id

string

type_legacy_id

string

type_account_id

string

type_name

string

type_daily_storage_cost

string

type_category

string

type_is_lpn_allowed

boolean

dimensions_weight

string

dimensions_height

string

dimensions_width

string

dimensions_length

string

_weld_synced

date

pack_per_day

string

shipment_id

string

order_id

string

warehouse_id

string

order_number

string

user_id

string

user_first_name

string

user_last_name

string

total_items

int

unique_items

int

barcodes_scanned

int

created_at

date

_weld_synced

date

pick_per_day

string

location_id

string

order_id

string

user_id

string

tote_id

string

line_item_id

string

pending_shipment_line_item_id

string

warehouse_id

string

order_number

string

user_first_name

string

user_last_name

string

inventory_bin

string

sku

string

quantity

int

picked_quantity

int

pick_type

string

barcode_scanned

string

created_at

date

_weld_synced

date

vendor

string

name

string

account_number

string

account_id

string

currency

string

internal_note

string

default_po_note

string

logo

string

partner_vendor_id

string

created_at

date

address_name

string

address_address1

string

address_address2

string

address_city

string

address_state

string

address_country

string

address_zip

string

address_phone

string

_weld_synced

date

Table

Sub table