Shopify — data contract (typed Shopify order between stages; not affiliated with Shopify)
Typed Shopify order between stages: money as a number and ordered_at in UTC. Not affiliated with Shopify.
This contract is one boundary in the Shopify orders pipeline chain. Validate the payload at that boundary, then follow the neighbors.
Also available: ODCS v3.1.0 YAML. “Use this contract” forks it into your org, then opens the validation playground so you can upload the client file.
Contract family
Shopify orders pipeline
Shopify orders as they move from the admin CSV export, through a typed order stage, to a warehouse fulfillment notice. Not affiliated with Shopify. Sample order names are fake.
- Ingest
- Between stages2shopify_orders_stagedThis contract
Derived from shopify_orders_raw
- Egress
Derived from shopify_orders_staged
Fields
| Name | Type | Required | Rule | Description |
|---|---|---|---|---|
| order_name | string | required | pattern /^#?[A-Za-z_-]{0,20}[0-9]{1,12}[A-Za-z0-9_-]{0,20}$/ | — |
| string | required | email format | — | |
| financial_status | string | required | one of: pending, authorized, paid, partially_paid, refunded, voided, partially_refunded, expired | — |
| currency | string | required | pattern /^[A-Z]{3}$/ | — |
| total | number | required | ≥ 0 | Order total in major currency units, parsed from the CSV decimal string. |
| ordered_at | string | required | pattern /^[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}Z$/ | Order created time in UTC. |
Sample rows
One synthetic row we wrote. It validates against this contract with zero violations. No real customer data.
[
{
"currency": "USD",
"email": "shopper@example.com",
"financial_status": "paid",
"order_name": "#1001",
"ordered_at": "2026-01-15T14:30:00Z",
"total": 50.36
}
]Provenance
- Verified against
- https://help.shopify.com/en/manual/orders/export-orders
- Checked
- 2026-11-14
- Version
- v1.0
- Author
- DataContractGate
- License
- MIT
Spotted a mismatch with the vendor’s current schema? Report an issue.
Stripe, Shopify, QuickBooks, Xero, HubSpot, Salesforce, Google Analytics and Square are trademarks of their respective owners. DataContractGate is not affiliated with or endorsed by them. These contracts describe data shaped like these vendors’ documented schemas; they are not official and are not certified by any vendor.