Fetch All Shopify Orders (Handles 250-Limit Loop)
## Who Is This For?
E-commerce managers, data analysts, and n8n beginners who need a hands-off way to pull **all** Shopify orders—even stores with thousands of orders—into Google Sheets for reporting or BI.
## What Problem Does It Solve?
Shopify’s GraphQL API only returns up to 250 orders per call, forcing you to manually manage cursors and loops. This template handles the “get next 250” logic for you, so you never miss an order.
## What This Workflow Does
1. **Schedule Trigger** – Runs at your chosen cadence (daily, hourly, or manual).
2. **Set Date Range** – Defines `startDay` and `endDay` based on `$now`.
3. **GraphQL Loop** – Fetches orders 250 at a time, using `pageInfo.hasNextPage` and `endCursor` until complete.
4. **Code Node** – Flattens orders into line-item rows and summarizes by SKU/vendor.
5. **Google Sheets** – Appends results to your sheet for easy analysis.
