not had time to test but a colleague says the credentials now do not work.
Anyone know anything
I know nothing

Your colleague is pulling your leg bro.
Shopify connects to N8N using API, and it works by creating an custom app, but has a 250 row limit, so you need to pull stuff out in batches. Go accidentally drop your coffee on your colleagues laptop or something for making you look … silly.
# Complete Guide: Connect n8n to Shopify & Pull ALL Orders, Products, and Customers (November 11, 2025)
STEP 1: Create Shopify Custom App (API Credentials)
---------------------------------------------------
1. Go to: https://yourstore.myshopify.com/admin
2. Settings → Apps and sales channels → Develop apps
3. Click "Create a custom app" → Name: "n8n Integration"
4. Configuration → Admin API integration → Enable scopes:
read_orders, write_orders (optional)
read_products, write_products (optional)
read_customers, write_customers (optional)
read_inventory (optional)
5. Save → Install app → Confirm
6. API credentials tab → Reveal:
• Admin API access token (shpat_...)
• API secret key
→ COPY BOTH NOW (token shown only once!)
STEP 2: Add Credentials in n8n
-------------------------------
1. In n8n workflow → Add Shopify node
2. Credential → Create New → Shopify API
3. Fill:
Shop Subdomain: yourstore
Access Token: shpat_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
App Secret Key: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
4. Save → Test connection (should succeed)
STEP 3: Pull ALL Data (With Full Pagination)
--------------------------------------------
A. ALL ORDERS (Handles 250-limit, GraphQL, 10k+ orders)
Template: https://n8n.io/workflows/5098-fetch-all-shopify-orders-handles-250-limit-loop/
• Uses cursor + endCursor loop
• Flattens line items
• Add Wait node (1000ms) if rate-limited
B. ALL PRODUCTS (Cursor-based GraphQL)
Template: https://n8n.io/workflows/5663-paginate-shopify-products-with-graphql-cursor-based-navigation/
• Endpoint: https://yourstore.myshopify.com/admin/api/2025-01/graphql.json
• Batch size: 250
• Loops until hasNextPage = false
C. ALL CUSTOMERS (REST API + Link header pagination)
Template: https://n8n.io/workflows/3280-sync-shopify-customers-to-google-sheets-squarespace-compatible-csv/
HTTP Request node settings:
Method: GET
URL: https://yourstore.myshopify.com/admin/api/2025-01/customers.json
Authentication: Basic Auth
Username: yourstore
Password: shpat_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Query Params:
limit=250
fields=id,email,first_name,last_name,orders_count,created_at
• Loop uses Link header → page_info → next cursor
D. FULL SYNC (Orders + Products + Customers in one workflow)
Template: https://n8n.io/workflows/4069-complete-shopify-to-odoo-integration-sync-orders-products-and-customers/
→ Import & replace credentials → Done!
PRO TIPS & TROUBLESHOOTING
--------------------------
• Rate limits: 2 req/sec → add Wait node (1000ms) in every loop
• Test small: add created_at_min=2025-11-01 to avoid full pull
• Outputs: Google Sheets, Airtable, PostgreSQL, CSV, webhook, etc.
• Common errors:
- 401 → wrong/expired token → regenerate in Shopify
- 403 → missing scope → re-check app permissions
- Timeout → switch to GraphQL cursor templates above
You’re now set! Import any template, plug in your credentials, and n8n will automatically pull EVERY order, product, and customer — no matter how big your store is.
![]()