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 report

Required 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
[email protected]
LOW_STOCK_THRESHOLD=5

Configuration 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

shopify-order-management

Installation