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

1. Signin to Daton

2. Select Shiphero from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your shiphero userId and password to authorize Daton to periodically extract data from shiphero.

5. Post successful authentication you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. 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

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. 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

Name	Datatype
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

Name	Datatype
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
email	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

Name	Datatype
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

Name	Datatype
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

Name	Datatype
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

Name	Datatype
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

Name	Datatype
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