Schema Information
This subtopic provides a structured reference to assist you in working with Daton's ShipBob connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Sprout Social connector:
Inventory
The Inventory API accesses real-time data and manages product inventory across multiple locations within ShipBob's fulfillment centers.
For more information, see Shipbob- Inventory.
Fields
| Field Name | Data Type |
|---|---|
id | NUMERIC |
name | STRING |
is_digital | BOOLEAN |
is_case_pick | BOOLEAN |
is_lot | BOOLEAN |
dimensions | RECORD |
total_fulfillable_quantity | NUMERIC |
total_onhand_quantity | NUMERIC |
total_committed_quantity | NUMERIC |
total_sellable_quantity | NUMERIC |
total_awaiting_quantity | NUMERIC |
total_exception_quantity | NUMERIC |
total_internal_transfer_quantity | NUMERIC |
total_backordered_quantity | NUMERIC |
is_active | BOOLEAN |
fulfillable_quantity_by_fulfillment_center | RECORD |
fulfillable_quantity_by_lot | RECORD |
packaging_attribute | STRING |
Orders
The Orders API creates, tracks, and manages orders, enabling efficient order fulfillment processes.
For more information, see Shipbob- Orders.
Fields
| Field Name | Data Type |
|---|---|
id | NUMERIC |
created_date | TIMESTAMP |
purchase_date | TIMESTAMP |
reference_id | STRING |
order_number | STRING |
status | STRING |
type | STRING |
channel | RECORD |
shipping_method | STRING |
recipient | RECORD |
shipments | RECORD |
financials | RECORD |
Products
The Products API provides programmatic control over your product catalog, allowing you to update and retrieve product information.
For more information, see Shipbob- Products.
Fields
| Field Name | Data Type |
|---|---|
id | NUMERIC |
reference_id | STRING |
created_date | TIMESTAMP |
channel | RECORD |
sku | STRING |
name | STRING |
total_fulfillable_quantity | NUMERIC |
total_onhand_quantity | NUMERIC |
total_committed_quantity | NUMERIC |
fulfillable_inventory_items | RECORD |
fulfillable_quantity_by_fulfillment_center | RECORD |
Return Orders
The Return Orders handles return-related operations, including creating, tracking, and processing return orders for a smoother customer experience.
For more information, see Shipbob- Return Orders.
Fields
| Field Name | Data Type |
|---|---|
id | NUMERIC |
channel | RECORD |
insert_date | TIMESTAMP |
status | STRING |
invoice_amount | NUMERIC |
transactions | RECORD |
fulfillment_center | RECORD |
reference_id | STRING |
tracking_number | STRING |
inventory | RECORD |
original_shipment_id | NUMERIC |
return_type | STRING |
completed_date | TIMESTAMP |
store_order_id | STRING |
Last updated