Handle e-commerce support, orders and inventory with Claude, Shopify and Slack

by Oneclick AI Squad ✓ · 301 views · created 2026-02-22 · Support Chatbot, AI Chatbot

What this workflow does

This workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Postgres.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Fetch order details from Shopify (HTTP Request): calls an HTTP API
2. Fetch inventory levels from Shopify (HTTP Request): calls an HTTP API
3. Merge: merges the data from its input branches
4. AI agent analyzes query and classifies intent (Code): runs custom JavaScript code
5. Route by customer intent (Switch): routes items into 3 branches
6. Process refund via Shopify API (HTTP Request): calls an HTTP API (POST)
7. Store interaction in PostgreSQL (Postgres): uses Postgres
8. Escalate complex cases to human agent (HTTP Request): calls an HTTP API (POST)
9. Send low stock alert to team (HTTP Request): calls an HTTP API (POST)
10. Build final customer response (Code): runs custom JavaScript code

…plus 4 more steps. See the full node list below.

Services it uses

Postgres

Before you upgrade to n8n 3.0

Nodes used (8)

• Webhookn8n-nodes-base.webhook
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch
• Postgresn8n-nodes-base.postgres
• Send Emailn8n-nodes-base.emailSend
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

Creates an AI-powered sales and support agent connected to live store data from Shopify/WooCommerce. MCP ensures controlled access to inventory and order systems. Automatically handles customer queries, stock alerts, and refund logic to reduce manual…

View the original on n8n.io → Check your own copy