Transactions with cost
Purchased labels with their cost, carrier, and tracking number.
Shippo
Polytomic connects Shippo to your data warehouse, databases, and SaaS tools for shipping ETL. Replicate shipments, parcels, and transactions into your data warehouse and other systems so shipping cost and carrier performance can be analyzed against orders, without writing code.
Rates on each shipment
The rate options quoted, so you can see what was not chosen.
Parcel dimensions
Size and weight data for analyzing dimensional cost drivers.
Example workflows
Replicate Shippo shipments and transactions into your data warehouse
What you can sync
Shippo is supported as a source. Read shipping data, then land it in your data warehouse, databases, or SaaS tools.
From Shippo
Shipments with their quoted rates
Transactions with cost, label, and tracking details
Parcels with dimensions and weight
Tracking number, status, and carrier URL on transactions
How it works
Connect Shippo and Polytomic reads three objects into your data warehouse: shipments, transactions, and parcels. Transactions are the ones carrying cost, since they represent labels actually purchased.
Rates arrive nested on each shipment, meaning you can see every option that was quoted rather than only the one chosen. That is what lets you check retrospectively whether cheaper carriers were available on routes you ship regularly.
- Connect Shippo with a live API token
- Read shipments along with their quoted rates
- Read transactions with cost, label, and tracking details
- Read parcels with dimensions and weight
- Join shipping cost back to orders in your data warehouse
- Monitor sync health, record volume, and failures from one interface
How to set up
Authentication is a Shippo API token, and a live token rather than a test one is required for real data. Once connected, the shipment, transaction, and parcel objects appear for selection.
How to get connected
- 1In Shippo, obtain a live API token
- 2In Polytomic, navigate to Connections, then Add Connection, then Shippo
- 3Paste the token
- 4Test the connection
- 5Select shipments, transactions, and parcels
- 6Choose a destination, set 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 Shippo in minutes
No credit card required. Free trial available.