Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Shiphero connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Shiphero connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Shiphero connector:
- Inventory_changes
- Purchase_Orders
- Shipments
- Products
- Orders
- Returns
- Warehouse_products
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 Type: Key-Based
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 |