Connectors / Shopify / CSV / JSON API
Shopify → CSV / JSON API
Orders, sales, discounts and returns — revenue truth next to ad spend for real ROAS. Signed URLs over every extract — the universal escape hatch for Excel, Power BI web queries, or your own scripts.
How the sync works
- Create an API key in workspace settings.
- Every pipeline exposes a stable CSV and JSON endpoint.
- Pull it from anything that speaks HTTP.
What lands in CSV / API
1 dimensions: date
7 metrics: orders, gross_sales, discounts, returns, net_sales, average_order_value, new_customers
Restatement-aware: every sync re-pulls the trailing 7 days, so revised conversions overwrite cleanly in CSV / API — no duplicate rows, no stale numbers.
Why teams pick Yoker for this
- Hourly on every paid plan — most tools gate hourly refresh behind $99–199/mo tiers; here it starts at $29.
- Backfills are free and unlimited — pull years of Shopify history without it counting against anything.
- The guarantees: price-lock, one-click cancel, 30-day refunds, and a 99% sync SLA with automatic credit.
- Unified schema: blend Shopify with every other platform without renaming columns by hand.