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

CODEBLOCK0

Required n8n Credentials

Credential Type	Used For	Placeholder in JSON
Google Sheets OAuth2	Order tracking and logging	INLINECODE5
SMTP

Notifications, recovery emails, reports | YOUR_SMTP_CREDENTIAL_ID |

Environment Variables

CODEBLOCK1

Configuration Placeholders

Placeholder	Description
INLINECODE7	Google Sheet ID for order tracking
INLINECODE8

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
orderid	text	Shopify order ID (primary key)
ordernumber

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