ShipHero

Explore the interactive ERD

Table & Field Reference

warehouse_product_inventory_metric

Column	Type	Keys
`id`	Unknown	PK
`warehouse_id`	Unknown	PKFK
`warehouse_product_product_id`	Unknown	PKFK
`account_id`	Unknown
`active`	Unknown
`allocated`	Unknown
`available`	Unknown
`backorder`	Unknown
`created_at`	Instant
`custom`	Unknown
`customs_value`	Unknown
`in_tote`	Unknown
`inventory_bin`	Unknown
`inventory_overstock_bin`	Unknown
`legacy_id`	Unknown
`non_sellable_quantity`	Unknown
`on_hand`	Unknown
`price`	Unknown
`reorder_amount`	Unknown
`reorder_level`	Unknown
`replenishment_level`	Unknown
`reserve_inventory`	Unknown
`sell_ahead`	Unknown
`sku`	Unknown
`updated_at`	Instant
`value`	Unknown
`value_currency`	Unknown
`warehouse_identifier`	Unknown

vendor

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown
`account_number`	Unknown
`address_address_1`	Unknown
`address_address_2`	Unknown
`address_city`	Unknown
`address_country`	Unknown
`address_name`	Unknown
`address_phone`	Unknown
`address_state`	Unknown
`address_zip`	Unknown
`created_at`	Unknown
`currency`	Unknown
`default_po_note`	Unknown
`email`	Unknown
`internal_note`	Unknown
`legacy_id`	Unknown
`logo`	Unknown
`name`	Unknown
`partner_vendor_id`	Unknown

purchase_order_line_item

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_line_item_id`	Unknown	PK
`vendor_id`	Unknown	FK
`warehouse_id`	Unknown	FK
`account_id`	Unknown
`barcode`	Unknown
`created_at`	Instant
`expected_weight_in_lbs`	Unknown
`fulfillment_status`	Unknown
`legacy_id`	Unknown
`node_id`	Unknown
`note`	Unknown
`option_title`	Unknown
`partner_line_item_id`	Unknown
`po_id`	Unknown
`po_number`	Unknown
`price`	Unknown
`product_id`	Unknown
`product_name`	Unknown
`quantity`	Unknown
`quantity_received`	Unknown
`quantity_rejected`	Unknown
`sell_ahead`	Unknown
`sku`	Unknown
`updated_at`	Instant
`variant_id`	Unknown
`vendor_sku`	Unknown

browse_order_history

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`account_id`	Unknown
`information`	Unknown
`order_email`	Unknown
`order_fulfillment_status`	Unknown
`order_number`	Unknown
`order_order_date`	Unknown
`order_packing_note`	Unknown
`order_profile`	Unknown
`order_required_ship_date`	Unknown
`order_shipping_address_address_1`	Unknown
`order_shipping_address_address_2`	Unknown
`order_shipping_address_city`	Unknown
`order_shipping_address_company`	Unknown
`order_shipping_address_country`	Unknown
`order_shipping_address_country_code`	Unknown
`order_shipping_address_email`	Unknown
`order_shipping_address_first_name`	Unknown
`order_shipping_address_last_name`	Unknown
`order_shipping_address_phone`	Unknown
`order_shipping_address_state`	Unknown
`order_shipping_address_state_code`	Unknown
`order_shipping_address_zip`	Unknown
`order_shop_name`	Unknown

warehouse_product

Column	Type	Keys
`warehouse_id`	Unknown	PK
`product_id`	Unknown	PKFK
`on_hand`	Unknown

product_image

Column	Type	Keys
`src`	Unknown	PK
`product_id`	Unknown	PKFK

product_kit_component

Column	Type	Keys
`sku`	Unknown	PK
`product_id`	Unknown	PKFK
`quantity`	Unknown

product_tag

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`tags`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown
`active`	Unknown
`barcode`	Unknown
`country_of_manufacture`	Unknown
`created_at`	Unknown
`customs_description`	Unknown
`customs_value`	Unknown
`dimensions_height`	Unknown
`dimensions_length`	Unknown
`dimensions_weight`	Unknown
`dimensions_width`	Unknown
`dropship`	Unknown
`final_sale`	Unknown
`ignore_on_customs`	Unknown
`ignore_on_invoice`	Unknown
`kit`	Unknown
`kit_build`	Unknown
`large_thumbnail`	Unknown
`legacy_id`	Unknown
`name`	Unknown
`needs_serial_number`	Unknown
`no_air`	Unknown
`not_owned`	Unknown
`product_note`	Unknown
`sku`	Unknown
`tariff_code`	Unknown
`thumbnail`	Unknown
`updated_at`	Unknown
`virtual`	Unknown

warehouse_product_detail

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`warehouse_id`	Unknown	FK
`account_id`	Unknown
`custom`	Unknown
`inventory_bin`	Unknown
`on_hand`	Unknown
`product_name`	Unknown
`product_sku`	Unknown
`reorder_amount`	Unknown
`reorder_level`	Unknown
`reserve_inventory`	Unknown
`warehouse_dynamic_slotting`	Unknown
`warehouse_profile`	Unknown

shipment_line_item

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	PKFK
`quantity`	Unknown

shipment_shipping_label

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	PKFK
`account_id`	Unknown
`carrier`	Unknown
`carrier_account_id`	Unknown
`cost`	Unknown
`created_date`	Unknown
`insurance_amount`	Unknown
`legacy_id`	Unknown
`packing_slip`	Unknown
`profile`	Unknown
`shipping_method`	Unknown
`shipping_name`	Unknown
`source`	Unknown
`status`	Unknown
`tracking_number`	Unknown
`warehouse`	Unknown

shipment

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`warehouse_id`	Unknown	FK
`address_address_1`	Unknown
`address_address_2`	Unknown
`address_city`	Unknown
`address_country`	Unknown
`address_name`	Unknown
`address_phone`	Unknown
`address_state`	Unknown
`address_zip`	Unknown
`created_date`	Unknown
`dropshipment`	Unknown
`legacy_id`	Unknown
`pending_shipment_id`	Unknown
`shipped_off_shiphero`	Unknown
`user_id`	Unknown

order_history

Column	Type	Keys
`_fivetran_id`	String	PK
`order_id`	Unknown	FK
`created_at`	Unknown
`information`	Unknown
`user_id`	Unknown

order_line_item

Column	Type	Keys
`sku`	Unknown	PK
`order_id`	Unknown	PKFK
`backorder_quantity`	Unknown
`price`	Unknown
`promotion_discount`	Unknown
`quantity`	Unknown
`quantity_allocated`	Unknown
`quantity_pending_fulfillment`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown
`adult_signature_required`	Unknown
`alcohol`	Unknown
`allocation_priority`	Unknown
`allow_partial`	Unknown
`allow_split`	Unknown
`auto_print_return_label`	Unknown
`currency`	Unknown
`custom_invoice_url`	Unknown
`email`	Unknown
`expected_weight_in_oz`	Unknown
`flagged`	Unknown
`fulfillment_status`	Unknown
`gift_invoice`	Unknown
`has_dry_ice`	Unknown
`ignore_address_validation_errors`	Unknown
`insurance`	Unknown
`insurance_amount`	Unknown
`legacy_id`	Unknown
`order_date`	Unknown
`order_number`	Unknown
`packing_note`	Unknown
`partner_order_id`	Unknown
`priority_flag`	Unknown
`profile`	Unknown
`require_signature`	Unknown
`required_ship_date`	Unknown
`saturday_delivery`	Unknown
`shop_name`	Unknown
`source`	Unknown
`subtotal`	Unknown
`third_party_shipper_account_number`	Unknown
`third_party_shipper_country`	Unknown
`third_party_shipper_zip`	Unknown
`total_discounts`	Unknown
`total_price`	Unknown
`total_tax`	Unknown

pack_per_day

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`shipment_id`	Unknown	FK
`warehouse_id`	Unknown	FK
`barcodes_scanned`	Unknown
`created_at`	Instant
`order_number`	Unknown
`total_items`	Unknown
`unique_items`	Unknown

shipping_plan

Column	Type	Keys
`id`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`warehouse_id`	Unknown	FK
`origin_of_shipment`	Unknown
`pdf_location`	Unknown
`vendor_po_number`	Unknown
`warehouse_note`	Unknown

purchase_order

Column	Type	Keys
`id`	Unknown	PKFK
`vendor_id`	Unknown	FK
`warehouse_id`	Unknown	FK
`account_id`	Unknown
`created_at`	Unknown
`date_closed`	Unknown
`description`	Unknown
`discount`	Unknown
`fulfillment_status`	Unknown
`images`	Unknown
`legacy_id`	Unknown
`locked_by_user_id`	Unknown
`locking`	Unknown
`packing_note`	Unknown
`payment_due_by`	Unknown
`payment_method`	Unknown
`payment_note`	Unknown
`pdf`	Unknown
`po_date`	Instant
`po_note`	Unknown
`po_number`	Unknown
`shipping_carrier`	Unknown
`shipping_method`	Unknown
`shipping_name`	Unknown
`shipping_price`	Unknown
`subtotal`	Unknown
`tax`	Unknown
`total_price`	Unknown
`tracking_number`	Unknown

shipping_plan_line_item

Column	Type	Keys
`id`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`warehouse_id`	Unknown	FK
`account_id`	Unknown
`barcode`	Unknown
`created_at`	Instant
`expected_weight_in_lbs`	Unknown
`fulfillment_status`	Unknown
`legacy_id`	Unknown
`note`	Unknown
`option_title`	Unknown
`partner_line_item_id`	Unknown
`price`	Unknown
`product_id`	Unknown
`product_name`	Unknown
`quantity`	Unknown
`quantity_received`	Unknown
`quantity_rejected`	Unknown
`sell_ahead`	Unknown
`sku`	Unknown
`updated_at`	Instant
`variant_id`	Unknown
`vendor_sku`	Unknown

inventory_change

Column	Type	Keys
`_fivetran_id`	String	PK
`warehouse_id`	Unknown	FK
`account_id`	Unknown
`change_in_on_hand`	Unknown
`created_at`	Instant
`cycle_counted`	Unknown
`location_account_id`	Unknown
`location_created_at`	Unknown
`location_id`	Unknown
`location_is_cart`	Unknown
`location_last_counted`	Unknown
`location_legacy_id`	Unknown
`location_name`	Unknown
`location_pickable`	Unknown
`location_sellable`	Unknown
`location_temperature`	Unknown
`location_warehouse_id`	Unknown
`location_zone`	Unknown
`previous_on_hand`	Unknown
`reason`	Unknown
`sku`	Unknown
`user_id`	Unknown

return_line_item_detail

Column	Type	Keys
`id`	Unknown	PK
`return_id`	Unknown	PKFK
`return_line_item_id`	Unknown	PKFK
`warehouse_id`	Unknown	FK
`backorder_quantity`	Unknown
`barcode`	Unknown
`created_at`	Unknown
`custom_barcode`	Unknown
`custom_options`	Unknown
`customs_value`	Unknown
`eligible_for_return`	Unknown
`fulfillment_status`	Unknown
`legacy_id`	Unknown
`locked_to_warehouse_id`	Unknown
`option_title`	Unknown
`partner_line_item_id`	Unknown
`price`	Unknown
`product_name`	Unknown
`quantity`	Unknown
`quantity_allocated`	Unknown
`quantity_pending_fulfillment`	Unknown
`quantity_shipped`	Unknown
`sku`	Unknown
`subtotal`	Unknown
`updated_at`	Unknown
`warehouse`	Unknown

return_line_item

Column	Type	Keys
`id`	Unknown	PK
`return_id`	Unknown	PKFK
`warehouse_id`	Unknown	FK
`account_id`	Unknown
`condition`	Unknown
`created_at`	Unknown
`is_component`	Unknown
`legacy_id`	Unknown
`line_item_id`	Unknown
`product_id`	Unknown
`quantity`	Unknown
`reason`	Unknown
`type`	Unknown
`updated_at`	Unknown

return

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`account_id`	Unknown
`cost_to_customer`	Unknown
`created_at`	Instant
`display_issue_refund`	Unknown
`label_cost`	Unknown
`label_type`	Unknown
`legacy_id`	Unknown
`partner_id`	Unknown
`reason`	Unknown
`shipping_carrier`	Unknown
`shipping_method`	Unknown
`status`	Unknown

line_item_pick

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`barcode_scanned`	Unknown
`created_at`	Instant
`inventory_bin`	Unknown
`line_item_id`	Unknown
`location_id`	Unknown
`order_number`	Unknown
`pick_type`	Unknown
`picked_quantity`	Unknown
`quantity`	Unknown
`sku`	Unknown
`tote_id`	Unknown
`user_first_name`	Unknown
`user_id`	Unknown
`user_last_name`	Unknown