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

• Orders

• Products

• Return Orders

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