Low Stock

Trigger a workflow when a product reaches low stock threshold.

Overview

The Low Stock trigger fires when a product’s stock quantity falls to or below the low stock threshold. This is essential for inventory management and reordering.

When It Fires

  • Stock quantity reaches low stock threshold
  • After an order reduces stock to threshold
  • Manual stock adjustment triggers threshold

Configuration

FieldTypeRequiredDescription
CategoryselectNoFilter by product category
Minimum PricenumberNoOnly products above this price

Available Data

Stock Information

VariableTypeDescription
{{Trigger.stock_quantity}}integerCurrent stock level
{{Trigger.low_stock_threshold}}integerThreshold that triggered
{{Trigger.stock_status}}stringCurrent stock status

Product Information

VariableTypeDescription
{{Trigger.product_id}}integerProduct ID
{{Trigger.name}}stringProduct name
{{Trigger.sku}}stringSKU
{{Trigger.price}}stringProduct price
{{Trigger.url}}stringProduct URL

Example Workflows

Reorder Alert

Notify purchasing team:

  1. Trigger: Low Stock
  2. Action: Send Email
    • To: purchasing@yourstore.com
    • Subject: Low Stock Alert: {{Trigger.name}}
    • Body: SKU: {{Trigger.sku}}, Current: {{Trigger.stock_quantity}}

Supplier Notification

Auto-notify suppliers:

  1. Trigger: Low Stock
  2. Action: Send Email
    • To: Supplier email
    • Subject: Reorder Request: {{Trigger.sku}}
    • Body: Standard reorder quantity and details

Inventory Dashboard

Update tracking spreadsheet:

  1. Trigger: Low Stock
  2. Action: Airtable - Create Record
    • Table: Reorder Queue
    • Product: {{Trigger.name}}
    • SKU: {{Trigger.sku}}
    • Current Stock: {{Trigger.stock_quantity}}

Urgent Alert

Critical stock warnings:

  1. Trigger: Low Stock
  2. Condition: Stock quantity <= 5
  3. Action: Send SMS/Slack alert
    • Message: URGENT: {{Trigger.name}} nearly out of stock!

Low Stock vs Out of Stock

TriggerUse Case
Low StockReordering, purchasing alerts
Stock ChangedInventory tracking
Product UpdatedGeneral monitoring

Best Practices

  • Set appropriate thresholds per product
  • Integrate with purchasing systems
  • Create urgency tiers based on stock level
  • Track lead times for reordering