Shipments and status
Shipment records flattened out of orders, with status detail alongside.
ShipBob
Polytomic connects ShipBob to your data warehouse, databases, and SaaS tools for fulfillment ETL. Replicate orders, shipments, inventory, and fulfillment centers into your data warehouse and other systems so fulfillment performance and stock position can be analyzed against demand, without writing code.
Inventory by center and lot
Current stock broken down by fulfillment center and lot.
Channels and returns
Sales channel attribution plus returns, not just outbound orders.
Example workflows
Replicate ShipBob orders and shipments into your data warehouse
What you can sync
ShipBob is supported as a source. Read fulfillment data, then land it in your data warehouse, databases, or SaaS tools.
From ShipBob
Orders, order products, and order shipments
Shipment status details
Inventory and product fulfillable inventory items
Fulfillment centers and locations
Products, channels, returns, and webhooks
To your destinations
Data warehouses including Snowflake, BigQuery, and Databricks
Databases including PostgreSQL and MySQL
Cloud storage including Amazon S3 and Google Cloud Storage
SaaS tools including Salesforce, HubSpot, and spreadsheets
How it works
Connect ShipBob and Polytomic reads your fulfillment data into your data warehouse: orders with their products and shipments, shipment status detail, current inventory by fulfillment center and lot, plus products, channels, returns, and locations.
Shipments are flattened out of the orders they belong to rather than read from a separate endpoint, which means you get one row per shipment ready to analyze rather than having to unpack a nested structure yourself.
- Connect ShipBob with OAuth and the read scopes you need
- Read orders with their products and shipments
- Read shipment status details for fulfillment timing
- Read current inventory by fulfillment center and lot
- Read products, channels, returns, fulfillment centers, and locations
- Monitor sync health, record volume, and failures from one interface
How to set up
Authorize Polytomic against your ShipBob account through the browser OAuth flow. Once connected, the order, inventory, product, and location objects appear for selection.
How to get connected
- 1In Polytomic, navigate to Connections, then Add Connection, then ShipBob
- 2Authorize with OAuth and grant the read scopes you need
- 3Test the connection
- 4Select orders, shipments, inventory, and the other objects you want
- 5Choose a destination data warehouse or database
- 6Set a schedule and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with ShipBob in minutes
No credit card required. Free trial available.