Connect ShipHero to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Everything ShipHero exposes, modeled and queryable.
Extracts ShipHero fulfillment data for D2C brands, including orders, products and inventory, vendors, shipments (with labels and tracking), returns, and purchase orders. This enables analysis of order lifecycle and fulfillment performance, product and stock attributes, vendor management, returns trends and reasons, shipping SLAs, and procurement/PO tracking.
Tables & streams
Customer orders with statuses, dates, totals, and line items; enables analysis of revenue, AOV, order lifecycle/cycle times, cancellations, and SKU mix performance.
Master catalog of SKUs with attributes, dimensions, tags, and kit settings; supports product performance analysis, assortment segmentation, compliance, and attribution by product features.
Per-warehouse on-hand quantities and related stock attributes; enables stockout monitoring, days of cover, allocation vs. availability, and replenishment planning.
Outbound shipments with destination, items, labels, carrier/method, tracking, and costs; supports carrier performance, on-time delivery, shipping cost per order, and SLA adherence analysis.
Customer returns with reasons, status, labels, and returned line items; enables return rate analysis, reason codes, refund impact, and SKU-level defect or fit issues.
Supplier profiles with contacts and account details; supports vendor performance analysis including lead times, fill rates, and defect trends when joined to purchase orders.
Procurement orders with vendor and warehouse linkage, dates, status, and totals; enables PO cycle time, receive completeness/fill rate, COGS tracking, and inbound planning.
Uses your ShipHero refresh token to obtain a temporary access token, then authenticates requests with a Bearer token
Requires a ShipHero account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate ShipHero in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your ShipHero data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
