Shiphero
Shiphero is a cloud-based warehouse management solution.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | inventory_change, order, pack_per_day, pick_per_day, product, purchase_order, return, shipment, warehouse_product, wholesale_order, with their subtables |
| Custom data | False | |
| History | True | return_history, inventory_change, order_history |
| ReSync | False | |
| Templates | True |
Data Schema
Loading diagram…
expiration_lot
expiration_lot
id
stringaccount_id
stringname
stringsku
stringcreated_at
dateupdated_at
dateexpires_at
datereceived_at
dateis_active
boolean_weld_synced
dateexpiration_lot_location
location_id
stringlot_id
string_weld_synced
dateorder
order
id
stringwholesale_order_id
stringorder_number
stringpartner_order_id
stringshop_name
stringfulfillment_status
stringorder_date
datetotal_tax
stringsubtotal
stringtotal_discounts
stringtotal_price
stringbox_name
stringauto_print_return_label
booleancustom_invoice_url
stringaccount_id
stringupdated_at
datecreated_at
dateemail
stringprofile
stringgift_note
stringpacking_note
stringrequired_ship_date
dateflagged
booleansaturday_delivery
booleanignore_address_validation_errors
booleanskip_address_validation
booleanpriority_flag
booleanallocation_priority
intsource
stringgift_invoice
booleanallow_partial
booleanrequire_signature
booleanadult_signature_required
booleanalcohol
booleanexpected_weight_in_oz
stringinsurance
booleaninsurance_amount
stringcurrency
stringhas_dry_ice
booleanallow_split
booleanhold_until_date
dateincoterms
stringtax_id
stringtax_type
stringdry_ice_weight_in_lbs
stringftr_exemption
stringaddress_is_business
booleando_not_print_invoice
booleanignore_payment_capture_errors
booleanholds_fraud_hold
booleanholds_address_hold
booleanholds_shipping_method_hold
booleanholds_operator_hold
booleanholds_payment_hold
booleanholds_client_hold
booleanthird_party_shipper_account_number
stringthird_party_shipper_zip
stringthird_party_shipper_country
string_weld_synced
dateorder_shipping_line
order_id
stringtitle
stringcarrier
stringmethod
stringprice
string_weld_synced
dateorder_shipping_address
order_id
stringfirst_name
stringlast_name
stringcompany
stringaddress1
stringaddress2
stringcity
stringstate
stringstate_code
stringzip
stringcountry
stringcountry_code
stringemail
stringphone
string_weld_synced
dateorder_billing_address
order_id
stringfirst_name
stringlast_name
stringcompany
stringaddress1
stringaddress2
stringcity
stringstate
stringstate_code
stringzip
stringcountry
stringcountry_code
stringemail
stringphone
string_weld_synced
dateorder_tag
order_id
stringtag
string_weld_synced
dateorder_authorization
order_id
stringtransaction_id
stringauthorized_amount
stringpostauthed_amount
stringrefunded_amount
stringcard_type
stringdate
date_weld_synced
dateorder_rma_label
id
stringorder_id
stringshipment_id
stringaccount_id
stringrma_id
stringshipping_name
stringtracking_number
stringstatus
stringcarrier
stringshipping_method
stringcost
stringbox_code
stringpaper_pdf_location
stringthermal_pdf_location
stringpdf_location
stringimage_location
stringdelivered
booleanpicked_up
booleanrefunded
booleanneeds_refund
booleanprofile
stringfull_size_to_print
stringpartner_fulfillment_id
stringcreated_at
dateupdated_at
datedimensions_weight
stringdimensions_height
stringdimensions_width
stringdimensions_length
stringaddress_name
stringaddress_address1
stringaddress_address2
stringaddress_city
stringaddress_state
stringaddress_country
stringaddress_zip
stringaddress_phone
string_weld_synced
dateorder_allocation
order_id
stringallocation_reference
stringwarehouse_id
stringallocated_at
dateready_to_ship
booleanis_locked
boolean_weld_synced
dateorder_allocation_line_item
order_id
stringallocation_reference
stringparent_allocation_reference
stringwarehouse_id
stringline_item_id
stringallocated_at
datesku
stringquantity_allocated
intis_kit_component
boolean_weld_synced
dateorder_line_item
id
stringorder_id
stringsku
stringpartner_line_item_id
stringquantity
intprice
stringproduct_name
stringoption_title
stringfulfillment_status
stringquantity_pending_fulfillment
intquantity_shipped
intwarehouse
stringquantity_allocated
intbackorder_quantity
intcustom_options
stringcustom_barcode
stringeligible_for_return
booleancustoms_value
stringlocked_to_warehouse_id
stringsubtotal
stringbarcode
stringcreated_at
dateupdated_at
datepromotion_discount
string_weld_synced
dateorder_line_item_shipped_line_item_lot
id
stringline_item_id
stringlot_id
stringlot_name
stringlot_expiration_date
date_weld_synced
dateorder_line_item_serial_number
id
stringline_item_id
stringsku
stringserial_number
stringscanned
booleancreated_at
dateupdated_at
date_weld_synced
dateorder_line_item_tote_pick
id
stringlocation_id
stringline_item_id
stringsku
stringcreated_at
dateupdated_at
datetote_id
stringcurrent
intpicked_quantity
intquantity
intinventory_bin
stringdeducted
boolean_weld_synced
dateorder_history
id
stringorder_id
stringuser_id
stringaccount_id
stringusername
stringorder_number
stringinformation
stringcreated_at
date_weld_synced
dateorder_merged_order
order_id
stringparent_order_id
stringis_master
boolean_weld_synced
dateorder_attachment
id
stringorder_id
stringaccount_id
stringdescription
stringurl
stringfilename
stringfile_type
stringfile_size
intcreated_at
date_weld_synced
dateproduct
product
id
stringsku
stringaccount_id
stringname
stringbarcode
stringcountry_of_manufacture
stringtariff_code
stringkit
booleankit_build
booleanno_air
booleanfinal_sale
booleancustoms_value
stringcustoms_description
stringnot_owned
booleandropship
booleanneeds_serial_number
booleanthumbnail
stringlarge_thumbnail
stringcreated_at
dateupdated_at
dateproduct_note
stringvirtual
booleanignore_on_invoice
booleanignore_on_customs
booleanneeds_lot_tracking
booleanpacker_note
stringvendor_part_number
stringconsumer_package_code
stringbuyer_part_number
stringbuyer_style_number
stringdimensions_weight
stringdimensions_height
stringdimensions_width
stringdimensions_length
string_weld_synced
dateproduct_case
id
stringproduct_id
stringproduct_sku
stringcase_barcode
stringcase_quantity
int_weld_synced
dateproduct_vendor
vendor_id
stringproduct_id
stringproduct_sku
stringvendor_sku
stringprice
string_weld_synced
dateproduct_image
product_id
stringsrc
stringproduct_sku
stringposition
string_weld_synced
dateproduct_fba_inventory
id
stringproduct_id
stringproduct_sku
stringquantity
intmarketplace_id
stringmerchant_id
string_weld_synced
dateproduct_kit_component
id
stringparent_product_id
stringparent_product_sku
stringaccount_id
stringsku
stringquantity
int_weld_synced
dateproduct_tag
product_id
stringtag
stringproduct_sku
string_weld_synced
datepurchase_order
purchase_order
id
stringvendor_id
stringpo_number
stringaccount_id
stringwarehouse_id
stringcreated_at
datepo_date
datedate_closed
datearrived_at
datepacking_note
stringfulfillment_status
stringpo_note
stringdescription
stringpartner_order_number
stringsubtotal
stringdiscount
stringtotal_price
stringtax
stringshipping_method
stringshipping_carrier
stringshipping_name
stringshipping_price
stringtracking_number
stringpdf
stringimages
stringpayment_method
stringpayment_due_by
stringpayment_note
stringlocking
stringlocked_by_user_id
stringorigin_of_shipment
stringship_date
date_weld_synced
datepurchase_order_line_item
id
stringvendor_id
stringproduct_id
stringpo_id
stringaccount_id
stringwarehouse_id
stringpo_number
stringsku
stringvendor_sku
stringvariant_id
stringquantity
intquantity_received
intquantity_rejected
intprice
stringproduct_name
stringoption_title
stringexpected_weight_in_lbs
stringfulfillment_status
stringsell_ahead
intnote
stringpartner_line_item_id
stringbarcode
stringupdated_at
datecreated_at
date_weld_synced
datepurchase_order_line_item_expiration_lot
lot_id
stringpo_li_id
stringpo_li_sku
string_weld_synced
datepurchase_order_attachment
id
stringpo_id
stringurl
stringuser_id
stringaccount_id
stringpo_li_sku
stringdescription
stringfilename
stringfile_type
stringfile_size
intcreated_at
date_weld_synced
datepurchase_order_tracking_number
id
stringpo_id
stringcarrier_id
stringcarrier_value
stringtracking_number
string_weld_synced
datereturn
return
id
stringorder_id
stringaccount_id
stringpartner_id
stringreason
stringstatus
stringlabel_type
stringlabel_cost
stringcost_to_customer
stringshipping_carrier
stringshipping_method
stringtotal_items_expected
inttotal_items_received
inttotal_items_restocked
intcreated_at
datedisplay_issue_refund
booleandimensions_weight
stringdimensions_height
stringdimensions_width
stringdimensions_length
stringaddress_name
stringaddress_address1
stringaddress_address2
stringaddress_city
stringaddress_state
stringaddress_country
stringaddress_zip
stringaddress_phone
string_weld_synced
datereturn_label
id
stringreturn_id
stringtracking_number
stringstatus
stringcreated_date
stringcarrier
stringshipping_method
stringcost
stringto_name
stringaddress1
stringaddress2
stringaddress_city
stringaddress_state
stringaddress_zip
stringaddress_country
stringpdf_location
stringdimensions_weight
stringdimensions_height
stringdimensions_width
stringdimensions_length
string_weld_synced
datereturn_line_item
id
stringproduct_id
stringreturn_id
stringaccount_id
stringline_item_id
stringwarehouse_id
stringquantity
intquantity_received
intrestock
intcondition
stringis_component
booleantype
stringreason
stringcreated_at
dateupdated_at
date_weld_synced
datereturn_exchange
id
stringreturn_id
stringexchange_order_id
stringaccount_id
stringoriginal_return_id
string_weld_synced
datereturn_exchange_item
id
stringreturn_exchange_id
stringreturn_item_id
stringsku
stringquantity
int_weld_synced
datereturn_history
id
stringreturn_id
stringaccount_id
stringuser_id
stringcreated_at
datebody
string_weld_synced
dateshipment
shipment
id
stringorder_id
stringuser_id
stringwarehouse_id
stringpending_shipment_id
stringprofile
stringpicked_up
booleanneeds_refund
booleanrefunded
booleandelivered
booleanshipped_off_shiphero
booleandropshipment
booleancompleted
booleancreated_date
datetotal_packages
intaddress_name
stringaddress_address1
stringaddress_address2
stringaddress_city
stringaddress_state
stringaddress_country
stringaddress_zip
stringaddress_phone
string_weld_synced
dateshipment_line_item
id
stringshipment_id
stringline_item_id
stringshipping_label_id
stringquantity
int_weld_synced
dateshipment_shipping_label
id
stringshipment_id
stringorder_id
stringaccount_id
stringbox_id
stringbox_name
stringstatus
stringtracking_number
stringalternate_tracking_id
stringorder_number
stringorder_account_id
stringcarrier
stringshipping_name
stringshipping_method
stringcost
stringbox_code
stringdevice_id
stringdelivered
booleanpicked_up
booleanrefunded
booleanneeds_refund
booleanprofile
stringpartner_fulfillment_id
stringfull_size_to_print
stringpacking_slip
stringwarehouse
stringwarehouse_id
stringinsurance_amount
stringcarrier_account_id
stringsource
stringcreated_date
datetracking_url
stringpackage_number
intparcelview_url
booleantracking_status
stringin_shipping_container
booleanshipping_container_id
stringlabel_pdf_location
stringlabel_paper_pdf_location
stringlabel_thermal_pdf_location
stringlabel_image_location
stringlast_mile_labels_id
stringlast_mile_labels_shipping_carrier
stringlast_mile_labels_shipping_method
stringlast_mile_labels_tracking_number
stringlast_mile_labels_tracking_url
stringdimensions_weight
stringdimensions_height
stringdimensions_width
stringdimensions_length
stringaddress_name
stringaddress_address1
stringaddress_address2
stringaddress_city
stringaddress_state
stringaddress_country
stringaddress_zip
stringaddress_phone
string_weld_synced
datewarehouse_product
warehouse_product
id
stringsku
stringaccount_id
stringwarehouse_id
stringwarehouse_identifier
stringprice
stringvalue
stringvalue_currency
stringon_hand
intinventory_bin
stringinventory_overstock_bin
stringreserve_inventory
intreplenishment_level
intreorder_amount
intreorder_level
intbackorder
intallocated
intavailable
intnon_sellable_quantity
intin_tote
intcustom
booleancustoms_value
stringcreated_at
dateupdated_at
datesell_ahead
intactive
boolean_weld_synced
datewarehouse_product_inbound
id
stringpurchase_order_line_item_id
stringwp_id
stringwp_sku
stringsku
stringwarehouse_id
stringpo_id
stringpo_date
datequantity
intquantity_received
intquantity_rejected
intsell_ahead
intstatus
string_weld_synced
datewarehouse_location
location_id
stringwp_id
stringwp_sku
string_weld_synced
datewholesale_order
wholesale_order
id
stringvendor_id
stringorder_id
stringversion
stringfulfillment_flow
stringshipping_option
stringstaging_location_id
stringpicking_flow
stringoutbound_progress
stringpickup_date
datestatus
stringstatus_message
stringpreparation_date
datepacking_layout
stringorder_type
stringgs1_labels_required
booleantrading_partner_id
stringtrading_partner_name
stringstore_location_number
stringdistribution_center
stringvendor
stringrequested_delivery_date
dateship_not_before_date
dateship_no_later_than_date
datedepositor_order_number
stringdepartment
stringdivision
stringservice_level
stringinternal_supplier_number
stringterms_of_sale
stringretailer_notes
stringquote_number
stringsales_requirement_code
stringreference_fields
string_weld_synced
datewholesale_order_shipping_details
id
stringwholesale_order_id
stringaccount_number
stringscac
stringcarrier
stringshipping_method
stringbill_of_lading
stringcost
stringtrailer_number
stringpro_number
stringgs1_company_prefix
stringcourier
string_weld_synced
datewholesale_order_line_item
id
stringwholesale_order_id
stringline_item_id
stringunit_of_measure
string_weld_synced
dateinventory_change
id
stringlocation_id
stringproduct_id
stringuser_id
stringaccount_id
stringwarehouse_id
stringsku
stringprevious_on_hand
intchange_in_on_hand
intreason
stringcycle_counted
booleanlot_id
stringlot_name
stringlot_expiration
stringcreated_at
date_weld_synced
datelocation
id
stringaccount_id
stringwarehouse_id
stringname
stringzone
stringpickable
booleansellable
booleanis_cart
booleanpick_priority
inttemperature
stringlast_counted
datecreated_at
datetype_id
stringtype_legacy_id
stringtype_account_id
stringtype_name
stringtype_daily_storage_cost
stringtype_category
stringtype_is_lpn_allowed
booleandimensions_weight
stringdimensions_height
stringdimensions_width
stringdimensions_length
string_weld_synced
datepack_per_day
id
stringshipment_id
stringorder_id
stringwarehouse_id
stringorder_number
stringuser_id
stringuser_first_name
stringuser_last_name
stringtotal_items
intunique_items
intbarcodes_scanned
intcreated_at
date_weld_synced
datepick_per_day
id
stringlocation_id
stringorder_id
stringuser_id
stringtote_id
stringline_item_id
stringpending_shipment_line_item_id
stringwarehouse_id
stringorder_number
stringuser_first_name
stringuser_last_name
stringinventory_bin
stringsku
stringquantity
intpicked_quantity
intpick_type
stringbarcode_scanned
stringcreated_at
date_weld_synced
datevendor
id
stringname
stringemail
stringaccount_number
stringaccount_id
stringcurrency
stringinternal_note
stringdefault_po_note
stringlogo
stringpartner_vendor_id
stringcreated_at
dateaddress_name
stringaddress_address1
stringaddress_address2
stringaddress_city
stringaddress_state
stringaddress_country
stringaddress_zip
stringaddress_phone
string_weld_synced
dateTable
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Open full-page schema explorer
Setup Guide
Prerequisites
To connect your Shiphero account to Weld, you need:
- Obtain API Access and Refresh Token. For more information, see Shiphero's documentation.
Step 1 - Data Source
- In the connector setup form, enter the destination schema name of your choice.
- Enter the refresh token that you have obtained and click Connect.
Step 2 - Connection Settings
- Enable limit historical data, which allows you to only sync data after the selected date.
Step 3 - Data To sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure sync
- Select how often you would like the data to sync.
- Provide a unique destination schema name.
Weld will take over from here and commence syncing data from your Shiphero account. \
For additional knowledge check ShipHero's Software Support.