Shopify New Order

What It Does

Full-service Shopify order intelligence. When a new order arrives, the AI checks inventory for every line item, flags VIP orders over $500 for sales team attention, creates restock alerts for low-stock products, and logs everything to your database for analytics.

Three automations in one webhook — inventory, VIP alerts, and order logging.

How It Works

1. Shopify fires an orders/create webhook
2. Inventory check — AI queries current stock via Shopify MCP for every line item. Products under 10 units trigger restock alerts
3. VIP detection — orders over $500 trigger a sales team notification on Slack with customer details
4. Database logging — complete order data is written to Supabase for your analytics and reporting

Example Scenario

A new order: 3 items, $780 total. Item A has 7 units left after this order. The AI: (1) creates a restock alert for Item A, (2) notifies #sales "VIP order: $780 from john@company.com — 3 items, new customer", (3) logs the full order to your analytics database.

Triggers

• orders/create — new order placed
• orders/updated — existing order modified