Inventory & Stock Monitoring with OpenClaw

# secrets.env — WooCommerce credentials
WOO_URL=https://yourstore.com
WOO_CONSUMER_KEY=ck_xxxxxxxxxxxxxxxxxxxx
WOO_CONSUMER_SECRET=cs_xxxxxxxxxxxxxxxxxxxx

# AGENTS.md — stock-monitor agent

agents:
  stock-monitor:
    description: "Check inventory levels and alert on low or out-of-stock products"
    tools:
      - shopify-admin-api   # swap for woocommerce-api if needed
    config:
      platform: shopify     # or: woocommerce
      credentials:
        store: "${SHOPIFY_STORE}"
        token: "${SHOPIFY_TOKEN}"
      thresholds:
        default: 10           # alert when stock ≤ 10 units
        tag_overrides:
          fast-mover: 25      # alert earlier for fast-moving products
          slow-mover: 3       # alert later for slow movers
          seasonal: 5
        out_of_stock: 0       # always flag at zero
      locations: all          # or list specific location IDs
      ignore_tags:
        - discontinued
        - bundle
    output:
      format: markdown
      sections:
        - out_of_stock        # zero stock — highest priority
        - below_threshold     # above zero but at/below threshold
        - reorder_suggested   # items at calculated reorder point
      sort_by: stock_qty      # lowest first
      include_fields:
        - sku
        - product_title
        - variant_title
        - stock_qty
        - threshold
        - avg_daily_sales
        - days_remaining      # stock_qty / avg_daily_sales

# Reorder point formula
# reorder_point = (avg_daily_sales × lead_time_days) + safety_stock
#
# Example:
#   avg_daily_sales = 4 units/day
#   lead_time = 7 days
#   safety_stock = 10 units (buffer for demand spikes)
#   reorder_point = (4 × 7) + 10 = 38 units
#
# When stock hits 38 → place new order immediately

# AGENTS.md — reorder-calculator agent

agents:
  reorder-calculator:
    description: "Calculate reorder points and identify SKUs that need ordering"
    tools:
      - shopify-admin-api
    config:
      platform: shopify
      credentials:
        store: "${SHOPIFY_STORE}"
        token: "${SHOPIFY_TOKEN}"
      sales_window_days: 30        # use last 30 days to calculate avg daily sales
      supplier_lead_times:         # days from order to delivery, by supplier tag
        default: 7
        overseas: 21
        local: 3
      safety_stock_multiplier: 1.5 # safety stock = avg_daily_sales × lead_time × 0.5
      ignore_tags:
        - discontinued
        - print-on-demand          # no inventory to manage
    output:
      format: markdown_table
      columns: [sku, product_title, current_stock, avg_daily_sales, lead_time, reorder_point, days_until_stockout, action]
      filter: reorder_point_reached  # only show SKUs needing action
      sort_by: days_until_stockout   # most urgent first

# AGENTS.md — dead-stock-finder agent

agents:
  dead-stock-finder:
    description: "Find products with stock on hand and no recent sales"
    tools:
      - shopify-admin-api
    config:
      platform: shopify
      credentials:
        store: "${SHOPIFY_STORE}"
        token: "${SHOPIFY_TOKEN}"
      no_sales_window_days: 60      # flag if no sales in last 60 days
      min_stock_qty: 1              # must have stock on hand to be flagged
      ignore_tags:
        - seasonal                  # seasonal items may be expected to be dormant
        - new-arrival               # new products get 30 days grace
      new_arrival_grace_days: 30
    output:
      format: markdown_table
      columns: [sku, product_title, stock_qty, cost_price, estimated_value, last_sale_date, days_dormant]
      sort_by: estimated_value      # highest capital tied up first
      include_summary:
        total_skus_flagged: true
        total_estimated_value: true
    schedule: weekly

# AGENTS.md — po-drafter agent

agents:
  po-drafter:
    description: "Draft supplier purchase order messages for SKUs at reorder point"
    tools:
      - shopify-admin-api
      - file-reader              # reads supplier_contacts.csv
    config:
      platform: shopify
      credentials:
        store: "${SHOPIFY_STORE}"
        token: "${SHOPIFY_TOKEN}"
      supplier_contacts_file: "supplier_contacts.csv"  # columns: supplier_tag, name, email
      order_quantity_multiplier: 3   # order 3× avg monthly sales by default
    prompt: |
      For each SKU at its reorder point, draft a professional purchase order email.
      Include:
      - Subject: "Purchase Order — [product name] — [date]"
      - Greeting to the supplier by name
      - The SKU, product name, and variant clearly stated
      - The quantity requested (calculated from order_quantity_multiplier)
      - A request for lead time confirmation and invoice
      - Your store name as the sender
      Keep the tone professional and concise.
      Output each draft as a separate section with a clear "DRAFT FOR [supplier name]" header.
      Do NOT send the email — output drafts only.

# HEARTBEAT.md — daily stock check

schedule:
  - name: "Morning Stock Check"
    cron: "0 7 * * *"           # every day at 7 AM
    agents:
      - stock-monitor
      - reorder-calculator
    output:
      file: "daily_stock_report.md"
      notify: true
    prompt: |
      Combine the low-stock alert and reorder calculator outputs into a single
      morning briefing. Format:
      1. URGENT — Out of stock (zero inventory): list with SKU and product name
      2. WARNING — Below threshold: list with current qty and days remaining
      3. ACTION NEEDED — At reorder point: list with suggested order quantity
      Keep it scannable. If everything is fine, output a single line:
      "✓ All stock levels healthy — no action needed."

# HEARTBEAT.md — weekly dead stock

schedule:
  - name: "Weekly Dead Stock Report"
    cron: "0 8 * * 1"           # Mondays at 8 AM
    agents:
      - dead-stock-finder
    output:
      file: "weekly_dead_stock.md"
      notify: true