Fields Reference · Flexport
Flexport Fields List
138 fields · 84 dimensions · 54 metrics · 8 groups
| Field name | Label | Category | Description |
|---|---|---|---|
flexport_disruption_reason | Disruption Reason | Fulfillment health | Why fulfillment was disrupted after ingestion. Empty when healthy. |
flexport_error_reason | Error Reason | Fulfillment health | Why the order failed, e.g. STOCKOUT_AT_INGESTION, BAD_ADDRESS, INVENTORY_ERR. Empty when healthy. |
flexport_has_tracking | Line Items With Tracking | Fulfillment health | 1 when a tracking number exists for the line. |
flexport_hours_since_last_scan | Hours Since Last Scan | Fulfillment health | Hours between the most recent scan and the end of the requested window. |
flexport_hours_since_ship | Hours Since Ship | Fulfillment health | Hours between the ship date and the end of the requested window. |
flexport_hours_to_reach_flexport | Hours To Reach Flexport | Fulfillment health | Hours between marketplace order creation and Flexport ingestion. |
flexport_is_awaiting_carrier | Awaiting Carrier Pickup | Fulfillment health | 1 when a label exists but the carrier has never scanned it. |
flexport_is_cancelled | Cancelled Orders | Fulfillment health | 1 when the order was cancelled. |
flexport_is_carrier_accepted | Carrier Accepted | Fulfillment health | 1 once the carrier has scanned the parcel past PRE_TRANSIT. |
flexport_is_carrier_accepted_event | Carrier Acceptance Events | Fulfillment health | 1 when the scan proves the carrier took possession — anything past PRE_TRANSIT. |
flexport_is_delivered | Delivered Orders | Fulfillment health | 1 when the order was delivered. |
flexport_is_delivered_late | Delivered Late | Fulfillment health | 1 when the order was delivered after its promised delivery time. |
flexport_is_delivery_overdue | Delivery Overdue | Fulfillment health | 1 when the promised delivery time has passed and no delivery has been recorded. Unlike a fixed 72-hour rule this is rela… |
flexport_is_error | Errored Orders | Fulfillment health | 1 when the order carries an error reason. |
flexport_is_fully_fulfilled | Fully Fulfilled Orders | Fulfillment health | 1 when every requested unit shipped. |
flexport_is_held | Held Orders | Fulfillment health | 1 when the order is stalled before fulfillment: still PROCESSING with an error or disruption reason. |
flexport_is_in_transit | In Transit | Fulfillment health | 1 when the parcel is moving and not yet delivered. |
flexport_is_item_delivered | Items Delivered | Fulfillment health | 1 when a delivery timestamp exists for the line. |
flexport_is_parcel_delivered | Parcels Delivered | Fulfillment health | 1 when the latest carrier status for this tracking number is DELIVERED. |
flexport_is_partially_fulfilled | Partially Fulfilled Orders | Fulfillment health | 1 when some — but not all — requested units shipped. |
flexport_is_ship_sla_at_risk | Ship SLA At Risk | Fulfillment health | 1 when Flexport's estimated ship time is later than the promised ship time and the order has not shipped. |
flexport_is_shipped | Shipped Orders | Fulfillment health | 1 when the order has shipped or been delivered. |
flexport_is_stalled_24h | Stalled 24h+ | Fulfillment health | 1 when the parcel is undelivered and has not been scanned for 24 hours or more. |
flexport_is_stalled_72h | Stalled 72h+ | Fulfillment health | 1 when the parcel is undelivered and has not been scanned for 72 hours or more. |
flexport_is_stocked_out | Stocked Out SKUs | Fulfillment health | 1 when no sellable units remain. |
flexport_is_stockout | Stocked Out Orders | Fulfillment health | 1 when the failure was a stockout (STOCKOUT or STOCKOUT_AT_INGESTION). |
flexport_is_undelivered_72h | Undelivered 72h+ | Fulfillment health | 1 when the line shipped at least 72 hours before the end of the window and has no delivery timestamp. |
flexport_is_unfulfilled | Unfulfilled Orders | Fulfillment health | 1 when no unit has shipped yet. |
flexport_reached_flexport | Reached Flexport | Fulfillment health | 1 when Flexport recorded an ingestion timestamp for the order, else 0. |
flexport_requires_manual_intervention | Orders Requiring Manual Intervention | Fulfillment health | 1 when an operator must act: an error or disruption reason on an order that is neither shipped nor cancelled. |
flexport_inbound_arrived_at | Inbound Arrived At | Inbound shipments | When the shipment reached the warehouse. |
flexport_inbound_completed_at | Inbound Completed At | Inbound shipments | When receiving finished. |
flexport_inbound_receiving_id | Receiving ID | Inbound shipments | Warehouse receiving id. |
flexport_inbound_shipment_id | Inbound Shipment ID | Inbound shipments | Flexport inbound shipment id. |
flexport_inbound_shipment_items | Inbound Shipment Items | Inbound shipments | Count of inbound line items. Always 1 per row. |
flexport_inbound_shipping_option | Inbound Shipping Option | Inbound shipments | How the shipment travelled, e.g. FREIGHT_EXTERNAL. |
flexport_inbound_status | Inbound Status | Inbound shipments | READY_TO_SHIP, PENDING, COMPLETED, … |
flexport_inbound_units_damaged | Inbound Units Damaged | Inbound shipments | Units received damaged. |
flexport_inbound_units_expected | Inbound Units Expected | Inbound shipments | Units the seller declared. |
flexport_inbound_units_sellable | Inbound Units Sellable | Inbound shipments | Units received in sellable condition. |
flexport_adjustment_date | Adjustment Date | Inventory adjustments | Date of the stock movement. |
flexport_adjustment_delta | Adjustment Delta | Inventory adjustments | Signed unit change applied to the bucket. |
flexport_adjustment_event_id | Adjustment Event ID | Inventory adjustments | Event ULID. |
flexport_adjustment_id | Adjustment ID | Inventory adjustments | Flexport's adjustment identifier. |
flexport_adjustment_reason | Adjustment Reason | Inventory adjustments | Why stock moved, e.g. RESERVE, ALLOCATION. |
flexport_adjustment_time | Adjustment Time | Inventory adjustments | Timestamp of the stock movement. |
flexport_adjustments | Adjustments | Inventory adjustments | Count of adjustments. Always 1 per row. |
flexport_inventory_state | Inventory State | Inventory adjustments | Bucket that changed: AVAILABLE, UNAVAILABLE, … |
flexport_expiration_date | Expiration Date | Order line items | Expiry of the picked lot. |
flexport_item_delivery_time | Item Delivery Time | Order line items | Timestamp the shipment carrying this line item was delivered. |
flexport_item_disruption_reason | Item Disruption Reason | Order line items | Why this line item was disrupted. |
flexport_item_name | Item Name | Order line items | Product name. |
flexport_line_items | Line Items | Order line items | Count of line items. Always 1 per row. |
flexport_lot_number | Lot Number | Order line items | Lot the units were picked from. |
flexport_quantity | Quantity | Order line items | Units of this SKU on the line. |
flexport_serial_numbers | Serial Numbers | Order line items | Serial numbers of the shipped units. |
flexport_total_units_requested | Units Requested | Order line items | Units the marketplace asked Flexport to ship. |
flexport_total_units_shipped | Units Shipped | Order line items | Units actually shipped so far. |
flexport_units_available | Units Available | Order line items | Units sellable right now. |
flexport_units_on_hand | Units On Hand | Order line items | Total units physically in the network. |
flexport_units_per_pack | Units Per Pack | Order line items | Units in one pack of this SKU. |
flexport_units_unavailable | Units Unavailable | Order line items | Units on hand but reserved or otherwise not sellable. |
flexport_units_unshipped | Units Unshipped | Order line items | total_units_requested minus total_units_shipped. |
flexport_delivery_time | Delivery Time | Orders | Timestamp the order was delivered. Empty until delivery. |
flexport_distinct_skus | Distinct SKUs | Orders | Number of distinct SKUs on the order. |
flexport_estimated_ship_time | Estimated Ship Time | Orders | Flexport's current estimate of when the order ships. |
flexport_flexport_order_id | Flexport Order ID | Orders | Flexport's internal fulfillment order id. |
flexport_flexport_shipment_id | Flexport Shipment ID | Orders | Shipment that caused the movement, when there is one. |
flexport_marketplace | Marketplace | Orders | Sales channel the order came from: SHOPIFY, TIKTOK, AMAZON, FACEBOOK, INSTAGRAM, WEBSITE. |
flexport_marketplace_order_id | Marketplace Order ID | Orders | Order id exactly as Flexport stores it, e.g. '#5227170DELIVERRSPLIT8216124784722'. |
flexport_marketplace_order_key | Marketplace Order Key | Orders | marketplace_order_id upper-cased. Always join on this: Flexport reports the same id in different cases across endpoints,… |
flexport_marketplace_order_ref | Marketplace Order Reference | Orders | The marketplace's own order name, e.g. '#5227170'. Several Flexport orders share one reference when a marketplace order … |
flexport_marketplace_split_id | Marketplace Split ID | Orders | The per-split identifier (Shopify's fulfillment order id) when an order was split across shipments; empty when it was no… |
flexport_order_cost | Order Cost | Orders | What Flexport charged for fulfilling the order. |
flexport_order_creation_time | Order Creation Time | Orders | Timestamp the order was created on the marketplace (Shopify, TikTok Shop, …). |
flexport_order_date | Order Date | Orders | Date the order was created on the marketplace. |
flexport_order_details_url | Order Details URL | Orders | Deep link into Flexport Seller Portal for this order. |
flexport_order_received_at_flexport_time | Order Received By Flexport Time | Orders | Timestamp Flexport ingested the order. The gap against order_creation_time is the marketplace-to-Flexport handoff. |
flexport_order_status | Order Status | Orders | Flexport lifecycle status: PROCESSING, SHIPPED, DELIVERED, CANCELLED, ERROR. |
flexport_orders | Orders | Orders | Count of orders. Always 1 per row; sum it. |
flexport_promised_delivery_time | Promised Delivery Time | Orders | SLA deadline Flexport committed to for delivery. |
flexport_promised_ship_time | Promised Ship Time | Orders | SLA deadline Flexport committed to for shipping. |
flexport_service_level_days | Service Level (Days) | Orders | Contracted delivery window in days. |
flexport_ship_date | Ship Date | Orders | Date the line item shipped. |
flexport_ship_to_city | Ship To City | Orders | Destination city. |
flexport_ship_to_country | Ship To Country | Orders | Destination country code. |
flexport_ship_to_name | Ship To Name | Orders | Recipient name. |
flexport_ship_to_state | Ship To State | Orders | Destination state or province. |
flexport_ship_to_zip | Ship To Zip | Orders | Destination postal code. |
flexport_shipments_tracked | Shipments Tracked | Orders | Count of tracking numbers. Always 1 per row. |
flexport_shipping_method | Shipping Method | Orders | Carrier service level, e.g. UPS.2ND.DAY.AIR or DHL.PARCEL.GROUND. |
flexport_shipping_origin | Shipping Origin | Orders | Warehouse the units shipped from. |
flexport_warehouse_id | Warehouse | Orders | Warehouse the movement happened in. |
flexport_carrier | Carrier | Parcel tracking | Carrier handling the parcel, as Flexport names it: ups, usps, dhl_ecommerce, uniuni, bettertrucks, fedex. |
flexport_carrier_event_time | Carrier Event Time | Parcel tracking | Timestamp the carrier itself reported for the scan. Earlier than tracking_event_time by the ingestion lag. |
flexport_carrier_message | Carrier Message | Parcel tracking | The carrier's own wording for the scan, e.g. 'Arrived at Facility'. |
flexport_current_carrier_message | Current Carrier Message | Parcel tracking | Wording of the most recent scan. |
flexport_current_city | Current City | Parcel tracking | City of the most recent scan. |
flexport_current_country | Current Country | Parcel tracking | Country of the most recent scan. |
flexport_current_state | Current State | Parcel tracking | State of the most recent scan. |
flexport_current_tracking_status | Current Tracking Status | Parcel tracking | Status reported by the most recent scan. |
flexport_first_scan_date | First Scan Date | Parcel tracking | Date of the first carrier scan for this tracking number. |
flexport_first_scan_time | First Scan Time | Parcel tracking | Timestamp of the first carrier scan. |
flexport_last_scan_time | Last Scan Time | Parcel tracking | Timestamp of the most recent carrier scan. |
flexport_scan_count | Scan Count | Parcel tracking | Number of carrier scans seen for this tracking number. |
flexport_tracking_city | Tracking City | Parcel tracking | City the scan happened in. |
flexport_tracking_country | Tracking Country | Parcel tracking | Country the scan happened in. |
flexport_tracking_event_date | Tracking Event Date | Parcel tracking | Date Flexport recorded the scan. |
flexport_tracking_event_id | Tracking Event ID | Parcel tracking | Event ULID. Sorts chronologically and is the tap's resume cursor. |
flexport_tracking_event_time | Tracking Event Time | Parcel tracking | Timestamp Flexport recorded the scan. |
flexport_tracking_events | Tracking Events | Parcel tracking | Count of scans. Always 1 per row. |
flexport_tracking_number | Tracking Number | Parcel tracking | Carrier tracking code. The join key between order_items and the tracking tables. |
flexport_tracking_received_at | Tracking Received At | Parcel tracking | Timestamp Flexport ingested the carrier update. |
flexport_tracking_state | Tracking State | Parcel tracking | State or province the scan happened in. |
flexport_tracking_status | Tracking Status | Parcel tracking | PRE_TRANSIT, IN_TRANSIT, OUT_FOR_DELIVERY, DELIVERED, FAILURE, RETURN_INITIATED, RETURN_COMPLETED, CANCELLED, UNKNOWN. |
flexport_tracking_zip | Tracking Zip | Parcel tracking | Postal code the scan happened in. |
flexport_barcode | Barcode | Products | Barcode scanned at the warehouse. |
flexport_logistics_sku | Logistics SKU | Products | Flexport's internal SKU, called DSKU in the Seller Portal. |
flexport_merchant_sku | Merchant SKU | Products | The seller's own SKU. |
flexport_product_barcodes | Barcodes | Products | Comma-separated barcodes registered for the SKU. |
flexport_product_created_at | Product Created At | Products | When the SKU was registered. |
flexport_product_name | Product Name | Products | Product name. |
flexport_product_updated_at | Product Updated At | Products | When the SKU was last changed. |
flexport_product_weight | Product Weight | Products | Unit weight. |
flexport_products | Products | Products | Count of SKUs. Always 1 per row. |
flexport_upc | UPC | Products | Universal product code. |
flexport_external_return_id | External Return ID | Returns | The seller's own return identifier. |
flexport_return_carrier | Return Carrier | Returns | Carrier on the return label. |
flexport_return_id | Return ID | Returns | Flexport return id. |
flexport_return_inspected_at | Return Inspected At | Returns | Timestamp inspection finished. |
flexport_return_received_at | Return Received At | Returns | Timestamp the warehouse received it. |
flexport_return_shipped_at | Return Shipped At | Returns | Timestamp the customer shipped the return. |
flexport_return_status | Return Status | Returns | CREATED, RECEIVED_FOR_PROCESSING, PROCESSED, … |
flexport_return_tracking_number | Return Tracking Number | Returns | Tracking code on the return label. |
flexport_return_tracking_status | Return Tracking Status | Returns | Carrier status of the return label. |
flexport_return_units_expected | Return Units Expected | Returns | Units the customer said they are returning. |
flexport_returns | Returns | Returns | Count of returns. Always 1 per row. |
flexport_rma | RMA | Returns | Return merchandise authorization. |