Shiphero
Shiphero ETL connector for data replication
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 | |
- 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
- 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
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 |
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 |
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 |
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 |
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 |
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 |
Last modified 4mo ago