- name
- shopify-order-management
- description
- Shopify order lifecycle management with new order handling, status sync, low-stock alerts, abandoned cart recovery, and daily sales reports. 5 production-ready n8n workflows with Google Sheets tracking and Shopify Admin API integration.
- tags
- [shopify, ecommerce, orders, inventory, abandoned-cart, sales, automation, n8n]
- author
- mhmalvi
- version
- 1.2.0
- license
- CC BY-NC-SA 4.0
- metadata
- clawdbot
- emoji
- \F6D2
- requires
- n8nCredentials
- [google-sheets-oauth2, smtp]
- env
- [SHOPIFY_STORE_URL, SHOPIFY_ACCESS_TOKEN, SHOPIFY_WEBHOOK_SECRET, SHOPIFY_ADMIN_EMAIL, LOW_STOCK_THRESHOLD]
- os
- [linux, darwin, win32]
Shopify Order Management
Complete Shopify order lifecycle management built on n8n. Handles new orders, status sync, inventory alerts, abandoned cart recovery, and daily sales reporting.
Problem
Shopify's built-in tools are limited for operations management. Order status changes aren't logged centrally, low-stock alerts arrive too late, abandoned cart emails are basic, and daily sales data requires logging into the admin dashboard.
This system automates the full order lifecycle with real-time tracking and proactive alerts.
What It Does
- New Order Handling — Webhook captures new orders, logs to Google Sheets, emails admin
- Order Status Sync — Periodically syncs fulfillment/payment status from Shopify to Sheets
- Low Stock Alerts — Checks inventory every 6 hours, alerts on items below threshold
- Abandoned Cart Recovery — Sends recovery emails to customers who abandoned checkout
- Daily Sales Reports — Revenue, order count, AOV, fulfillment stats, and top products
Included Workflows
| # | File | Purpose |
|---|---|---|
| 01 | 01-new-order-handler.json | Webhook → parse order → log to Sheets → notify admin |
| 02 | 02-order-status-sync.json | Scheduled → check pending orders → sync from Shopify API |
| 03 | 03-low-stock-alert.json | Scheduled → inventory check → alert on low stock |
| 04 | 04-abandoned-cart-recovery.json | Scheduled → fetch abandoned carts → recovery email |
| 05 | 05-daily-sales-report.json | Daily → fetch orders → metrics → report email |
Architecture
Shopify Webhook (orders/create)
|
v
Workflow 01: New Order Handler
+-> Parse order data
+-> Log to Google Sheets (Orders tab)
+-> Email notification to admin
Scheduled (every 2 hours):
|
v
Workflow 02: Order Status Sync
+-> Read unfulfilled orders from Sheets
+-> Fetch current status from Shopify API
+-> Update Sheets with latest status
Scheduled (every 6 hours):
|
v
Workflow 03: Low Stock Alert
+-> Fetch all products from Shopify
+-> Check inventory vs threshold
+-> IF low stock -> email alert
Scheduled (every 3 hours):
|
v
Workflow 04: Abandoned Cart Recovery
+-> Fetch open checkouts from Shopify
+-> Filter: abandoned 1-24 hours ago
+-> Send recovery email with cart link
Daily:
|
v
Workflow 05: Daily Sales Report
+-> Fetch last 24h orders
+-> Calculate revenue, AOV, fulfillment stats
+-> Top products by quantity
+-> Email formatted reportRequired n8n Credentials
| Credential Type | Used For | Placeholder in JSON |
|---|---|---|
| Google Sheets OAuth2 | Order tracking and logging | YOUR_GOOGLE_SHEETS_CREDENTIAL_ID |
| SMTP | Notifications, recovery emails, reports | YOUR_SMTP_CREDENTIAL_ID |
Environment Variables
# Shopify (required)
SHOPIFY_STORE_URL=https://your-store.myshopify.com
SHOPIFY_ACCESS_TOKEN=shpat_xxxxxxxxxxxxx
SHOPIFY_WEBHOOK_SECRET=your-webhook-secret
# Google Sheets
SHOPIFY_ORDERS_SHEET_ID=your-sheet-id
# Alerts
SHOPIFY_ADMIN_EMAIL=admin@yourstore.com
LOW_STOCK_THRESHOLD=5Configuration Placeholders
| Placeholder | Description |
|---|---|
YOUR_SHOPIFY_ORDERS_SHEET_ID | Google Sheet ID for order tracking |
YOUR_GOOGLE_SHEETS_CREDENTIAL_ID | n8n Google Sheets credential ID |
YOUR_SMTP_CREDENTIAL_ID | n8n SMTP credential ID |
YOUR_NOTIFICATION_EMAIL | Admin email for reports and alerts |
Google Sheets Schema (Orders)
| Column | Type | Description |
|---|---|---|
| order_id | text | Shopify order ID (primary key) |
| order_number | text | Human-readable order number |
| customer_name | text | Customer full name |
| customer_email | text | Customer email |
| customer_phone | text | Customer phone |
| total_price | number | Order total |
| currency | text | Currency code (USD, EUR, etc.) |
| financial_status | text | pending / paid / refunded |
| fulfillment_status | text | unfulfilled / fulfilled / delivered |
| items_count | number | Number of line items |
| items_summary | text | Item names and quantities |
| shipping_address | text | Shipping address summary |
| created_at | datetime | Order creation timestamp |
| synced_at | datetime | Last sync timestamp |
Quick Start
1. Prerequisites
- n8n v2.4+ (self-hosted)
- Shopify store with Admin API access (custom app)
- Google Sheets OAuth2 credentials
- SMTP email credentials
2. Create Shopify Custom App
In Shopify Admin > Settings > Apps > Develop apps > Create app. Grant scopes: read_orders, read_products, read_checkouts.
3. Create Orders Sheet
Create a Google Sheet with the columns above. Name the tab "Orders".
4. Configure Shopify Webhook
In Shopify Admin > Settings > Notifications > Webhooks, add orders/create pointing to your n8n webhook URL.
5. Import & Configure
Import all 5 JSON files into n8n. Replace YOUR_* placeholders and set environment variables.
Use Cases
- DTC brands — Order tracking, inventory alerts, and automated cart recovery
- Print-on-demand — Monitor fulfillment status across products
- Dropshippers — Track orders and low-stock from suppliers
- Subscription boxes — Daily sales and fulfillment monitoring
- Agency operators — Multi-store management with centralized reporting
Requirements
- n8n v2.4+ (self-hosted recommended)
- Shopify store with Admin API custom app
- Google Sheets OAuth2 credentials
- SMTP email credentials