Библиотека / Мониторинг, эксплуатация и инциденты
Мониторинг, эксплуатация и инциденты
Отмечает товары Shopify с низким остатком и экспортирует оповещения в Google Sheets
Сверяет остатки Shopify с продажами за 7 и 30 дней и помечает товары статусами OUT, LOW, OK или NO_SALES с точками пополнения; результаты записываются в Google Sheets или CSV.
Что делает
## Low Stock Alerts for Shopify Stores v0.1 (free) · Stallkit Studio Periodically check inventory, flag OUT / LOW / OK / NO_SALES, and suggest a reorder point from the last 7 and 30 days of unit sales. Results go to a Google Sheet (or CSV on self-hosted n8n). No LLM / no Gemini — pure rules and math. Try it first (no keys, no store): leave mode: "mock" and output: "files", click Test workflow. Self-hosted writes CSVs under /home/node/.n8n-files/low-stock-alerts/. On n8n Cloud, open the Rows: nodes. Formulas - avg_daily_30 = sales_30d / 30 - reorder_point = ceil(avg_daily_30 × safetyDays) + lowStockExtraUnits (default safetyDays=14) - suggested_order_qty = max(0, reorder_point − inventory) - Status: OUT if tracked and qty≤0; LOW if qty>0 and qty≤reorder_point; NO_SALES if no sales and not OUT; OK otherwise; NOT_TRACKED if inventory tracking is off. Live Shopify (you connect): Header Auth credential — header name X-Shopify-Access-Token, value = Admin API token. Set shopDomain, mode: "shopify". Scopes typically needed: read_products, read_inventory, read_orders (confirm in current Shopify docs; 30d+ history may need read_all_orders). n8n Cloud is a paid n8n subscription; self-hosting needs your own computer or server. This is not inventory or accounting advice. Shopify and n8n are trademarks of their respective owners. Stallkit Studio is not affiliated with or endorsed by them.
Шаги
- Run
- Config
- Mode = mock?
- Mock inventory (fake data)
- Build products query
- Shopify products (GraphQL)
- Build orders query
- Shopify orders (GraphQL)
- Normalize Shopify data
- Compute alerts
- Rows: Alerts
- Alerts to sheet?
- Write 'Alerts' tab
- Alerts to CSV
Всего шагов: 20.
Похожие автоматизации
ИИ-агенты и ассистентыTriage Shopify refund and fraud requests with Gemini, Sightengine, Jira and SlackШагов: 19Электронная коммерция и платежиСоздание задач Onfleet для новых отгрузок ShopifyШагов: 3Электронная коммерция и платежиПолучение товаров из ShopifyШагов: 2Электронная коммерция и платежиСоздание задач доставки Onfleet из выполнения заказов ShopifyШагов: 2