AgentSkillsCN

inventory-monitoring-and-alert-system

当用户需要监控产品库存水平，将库存数量与安全阈值进行比对，识别低库存商品，并触发自动化通知与文档更新时，此技能会因“库存水平”、“库存数量”、“安全阈值”、“低库存”、“采购申请”、“库存警报”等关键词而被触发，或在与WooCommerce等电商平台合作时。该技能具备以下能力：1）从电商系统中获取产品数据；2）根据可配置的阈值分析库存水平；3）识别需要补货的产品；4）将低库存商品更新至Google Sheets或其他文档系统；5）使用可定制的模板，向采购经理发送自动化邮件通知。

SKILL.md
--- frontmatter
name: inventory-monitoring-and-alert-system
description: When the user needs to monitor product inventory levels, check stock quantities against safety thresholds, identify low-stock items, and trigger automated notifications and documentation updates. This skill is triggered by keywords like 'inventory levels', 'stock quantity', 'safety threshold', 'low-stock', 'purchase requisition', 'stock alert', or when working with e-commerce platforms like WooCommerce. It provides capabilities to 1) Retrieve product data from e-commerce systems, 2) Analyze stock levels against configurable thresholds, 3) Identify products requiring replenishment, 4) Update Google Sheets or other documentation systems with low-stock items, and 5) Send automated email notifications to purchasing managers using customizable templates.

Inventory Monitoring and Alert System

Overview

This skill automates inventory monitoring by checking product stock levels against safety thresholds, updating purchase requisition lists, and sending email alerts.

Core Workflow

1. Initial Setup & Data Collection

  • •Retrieve Products: Fetch all products from WooCommerce using woocommerce-woo_products_list.
  • •Locate Resources:
    • •Find the Google Sheets purchase requisition list using google_sheet-list_spreadsheets.
    • •Read the purchasing manager's email address from purchasing_manager_email.txt.
    • •Load the email template from stock_alert_email_template.md.

2. Inventory Analysis

  • •For each product, compare stock_quantity against stock_threshold (stored in meta_data).
  • •Identify all products where stock_quantity < stock_threshold.
  • •Extract supplier information from product meta_data (name, contact, ID).

3. Documentation Update

  • •Access the Google Sheet using the spreadsheet ID.
  • •Check existing sheet structure using google_sheet-get_sheet_data.
  • •Update cells with low-stock product information:
    • •Product ID, Name, SKU
    • •Current Stock, Safety Threshold
    • •Supplier Name, Supplier ID, Supplier Contact
    • •Alert Time (current date), Suggested Order Quantity (threshold × 1.5)

4. Notification Delivery

  • •For each low-stock product, generate personalized email using the template.
  • •Send email to purchasing manager with:
    • •Product-specific details
    • •Stock vs. threshold comparison
    • •Supplier contact information
    • •Link to Google Sheets requisition list

Key Considerations

  • •Pagination: Handle large product lists by adjusting perPage parameter.
  • •Error Handling: Verify all required files exist before processing.
  • •Data Consistency: Ensure Google Sheets formatting matches expected columns.
  • •Email Personalization: Customize each email with specific product details.

Success Criteria

  • •All low-stock products identified and documented
  • •Google Sheets updated with complete product information
  • •Individual email alerts sent for each low-stock item
  • •Clear summary provided to user with counts and details