# Shopify Order Management

> 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.

- Skill: `dvcrn/shopify-order-management` (Agent Skill, multi-file: 6 files)
- Install (CLI): `npx skillmds@latest add dvcrn/shopify-order-management`
- Raw SKILL.md: https://api.skillmd.com/api/skills/dvcrn/shopify-order-management/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: dvcrn (https://skillmd.com/u/dvcrn)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/dvcrn/shopify-order-management

---


# 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

1. **New Order Handling** — Webhook captures new orders, logs to Google Sheets, emails admin
2. **Order Status Sync** — Periodically syncs fulfillment/payment status from Shopify to Sheets
3. **Low Stock Alerts** — Checks inventory every 6 hours, alerts on items below threshold
4. **Abandoned Cart Recovery** — Sends recovery emails to customers who abandoned checkout
5. **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

```bash
# 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=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

1. **DTC brands** — Order tracking, inventory alerts, and automated cart recovery
2. **Print-on-demand** — Monitor fulfillment status across products
3. **Dropshippers** — Track orders and low-stock from suppliers
4. **Subscription boxes** — Daily sales and fulfillment monitoring
5. **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