Shiphero
Shiphero ETL connector for data replication
Snapshot
Features
Details
Release Status
Released
Source API Version
v2
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Shiphero username Shiprhero password
Replication Type
Incremental
Replication Key
NA
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Inventory_changes
Orders
Purchase_Orders
Returns
Shipments
Warehouse_products
Products
Integrate Shiphero with Daton
Signin to Daton
Select Shiphero from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your shiphero userId and password to authorize Daton to periodically extract data from shiphero.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Source API Documentation: https://developer.shiphero.com/wp-content/uploads/spectaql/#introduction
SHIPHERO Data
Inventory_changes
Replication Type: Key-Based
Replication Key: date
Fields
user_id
STRING
account_id
STRING
warehouse_id
STRING
sku
STRING
previous_on_hand
NUMERIC
change_in_on_hand
NUMERIC
reason
STRING
cycle_counted
BOOLEAN
location_id
STRING
created_at
DATETIME
product
RECORD
location
RECORD
Orders
Replication Type: Key-Based
Replication Key: updated date
Fields
id
STRING
legacy_id
NUMERIC
order_number
STRING
partner_order_id
STRING
shop_name
STRING
fulfillment_status
STRING
order_date
DATETIME
total_tax
STRING
subtotal
STRING
total_discounts
STRING
total_price
STRING
box_name
STRING
auto_print_return_label
BOOLEAN
account_id
STRING
updated_at
DATETIME
STRING
profile
STRING
required_ship_date
DATETIME
shipping_lines
RECORD
tags
STRING
authorizations
RECORD
shipments
RECORD
flagged
BOOLEAN
priority_flag
BOOLEAN
allocation_priority
NUMERIC
source
STRING
alcohol
BOOLEAN
expected_weight_in_oz
STRING
insurance
BOOLEAN
insurance_amount
STRING
currency
STRING
has_dry_ice
BOOLEAN
allow_split
BOOLEAN
returns
RECORD
allocations
RECORD
Purchase_orders
Replication Type: Key-Based
Replication Key: po_date
Fields
id
STRING
legacy_id
NUMERIC
po_number
STRING
account_id
STRING
warehouse_id
STRING
vendor_id
STRING
created_at
DATETIME
po_date
DATETIME
packing_note
STRING
fulfillment_status
STRING
po_note
STRING
subtotal
STRING
discount
STRING
total_price
STRING
tax
STRING
shipping_price
STRING
tracking_number
STRING
payment_due_by
STRING
vendor
RECORD
warehouse
RECORD
ship_date
DATETIME
date_closed
DATETIME
description
STRING
shipping_method
STRING
shipping_carrier
STRING
Returns
Replication Type: Key-Based
Replication Key: date
Fields
id
STRING
legacy_id
NUMERIC
account_id
STRING
order_id
STRING
reason
STRING
status
STRING
cost_to_customer
STRING
shipping_carrier
STRING
shipping_method
STRING
dimensions
RECORD
line_items
RECORD
total_items_expected
NUMERIC
total_items_received
NUMERIC
total_items_restocked
NUMERIC
created_at
DATETIME
display_issue_refund
BOOLEAN
order
RECORD
Shipments
Replication Type: Key-Based
Replication Key: date
Fields
id
STRING
legacy_id
NUMERIC
order_id
STRING
user_id
STRING
warehouse_id
STRING
profile
STRING
dropshipment
BOOLEAN
shipped_off_shiphero
BOOLEAN
completed
BOOLEAN
created_date
DATETIME
warehouse
RECORD
order
RECORD
total_packages
NUMERIC
Warehouse_products
Replication Type: Key-Based
Replication Key: updated_date
Fields
id
STRING
legacy_id
NUMERIC
account_id
STRING
sku
STRING
warehouse_id
STRING
warehouse_identifier
STRING
price
STRING
value
STRING
on_hand
NUMERIC
inventory_bin
STRING
inventory_overstock_bin
STRING
reserve_inventory
NUMERIC
replenishment_level
NUMERIC
reorder_amount
NUMERIC
reorder_level
NUMERIC
backorder
NUMERIC
allocated
NUMERIC
available
NUMERIC
non_sellable_quantity
NUMERIC
custom
BOOLEAN
customs_value
STRING
created_at
DATETIME
updated_at
DATETIME
sell_ahead
NUMERIC
active
BOOLEAN
warehouse
RECORD
product
RECORD
Products
Replication Type: Key-Based
Replication Key: updated_date
Fields
id
STRING
legacy_id
NUMERIC
account_id
STRING
name
STRING
sku
STRING
barcode
STRING
country_of_manufacture
STRING
dimensions
RECORD
tariff_code
STRING
kit
BOOLEAN
kit_build
BOOLEAN
no_air
BOOLEAN
final_sale
BOOLEAN
customs_value
STRING
not_owned
BOOLEAN
dropship
BOOLEAN
needs_serial_number
BOOLEAN
thumbnail
STRING
large_thumbnail
STRING
created_at
DATETIME
updated_at
DATETIME
product_note
STRING
virtual
BOOLEAN
ignore_on_invoice
BOOLEAN
ignore_on_customs
BOOLEAN
active
BOOLEAN
needs_lot_tracking
BOOLEAN
warehouse_products
RECORD
Last updated