ShipHero schema and ERD

50 tables

Loading diagram…

expiration_lot

order

product

purchase_order

return

shipment

warehouse_product

wholesale_order

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

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

location

string

account_id

string

warehouse_id

string

name

string

zone

string

pickable

boolean

sellable

boolean

is_cart

boolean

pick_priority

int

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

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

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

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

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

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

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

product

string

sku

string

account_id

string

name

string

barcode

string

country_of_manufacture

string

tariff_code

string

kit

boolean

kit_build

boolean

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

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

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

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

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

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

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

vendor

string

name

string

account_number

string

account_id

string

currency

string

internal_note

string

default_po_note

string

logo

string

warehouse_product

string

sku

string

account_id

string

warehouse_id

string

warehouse_identifier

string

price

string

value

string

value_currency

string

on_hand

int

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

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