Schema Information
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's ShipBob connector and the associated fields and tables.
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 |
