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

Last updated