Skip to main content
Glama
wspotter

MCP Art Supply Store

by wspotter

compare_supplier_prices

Compare prices and terms across multiple suppliers for specific art supply products to identify cost-effective purchasing options.

Instructions

Compare prices and terms across suppliers for a specific product or category.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
productNameYesProduct name or category

Implementation Reference

  • Handler function for 'compare_supplier_prices' tool. Filters inventory by product name or category, groups products by supplier, and generates a price comparison report including lead times.
    case 'compare_supplier_prices': {
      const productName = String(args?.productName || '').toLowerCase();
      const products = storeData.inventory.filter(i =>
        i.name.toLowerCase().includes(productName) ||
        i.category.toLowerCase().includes(productName)
      );
      
      if (products.length === 0) {
        return { content: [{ type: 'text', text: `No products found matching "${args?.productName}"` }] };
      }
      
      const supplierMap = new Map();
      products.forEach(p => {
        if (!supplierMap.has(p.supplier)) {
          supplierMap.set(p.supplier, []);
        }
        supplierMap.get(p.supplier).push(p);
      });
      
      return {
        content: [{
          type: 'text',
          text: `šŸ’² Price Comparison for "${args?.productName}":\n\n${Array.from(supplierMap.entries()).map(([supplier, items]) => {
            const supplierInfo = storeData.suppliers.find(s => s.name === supplier);
            return `${supplier}:\n${items.map((item: any) => `• ${item.name} - $${item.price}`).join('\n')}\nLead Time: ${supplierInfo?.leadTime || 'N/A'}`;
          }).join('\n\n')}`
        }]
      };
    }
  • Tool schema definition including name, description, and input schema requiring 'productName' parameter.
    {
      name: 'compare_supplier_prices',
      description: 'Compare prices and terms across suppliers for a specific product or category.',
      inputSchema: {
        type: 'object',
        properties: {
          productName: { type: 'string', description: 'Product name or category' },
        },
        required: ['productName'],
      },
    },
  • src/index.ts:516-518 (registration)
    Registration of the ListToolsRequestHandler which returns the array of all tools including 'compare_supplier_prices'.
    server.setRequestHandler(ListToolsRequestSchema, async () => {
      return { tools };
    });
  • src/index.ts:521-1509 (registration)
    Registration of the CallToolRequestHandler which dispatches to specific tool handlers via switch, including the case for 'compare_supplier_prices'.
    server.setRequestHandler(CallToolRequestSchema, async (request) => {
      const { name, arguments: args } = request.params;
    
      try {
        switch (name) {
          // INVENTORY MANAGEMENT
          // VIP DATASET GENERATION TOOLS
          case 'vip_generate_dataset':
          case 'vip_check_status':
          case 'vip_list_datasets':
          case 'vip_get_dataset_info':
          case 'vip_stop_pipeline':
          case 'vip_validate_config':
          case 'vip_health_check': {
            const result = await handleVIPTool(name, args);
            return {
              content: [{
                type: 'text',
                text: result
              }]
            };
          }
    
    
          // UNIVERSAL DAILY TASK TOOLS
          case 'create_task':
          case 'list_tasks':
          case 'complete_task':
          case 'update_task':
          case 'get_daily_agenda':
          case 'schedule_event':
          case 'list_upcoming_events':
          case 'set_reminder':
          case 'get_today_schedule':
          case 'create_note':
          case 'search_notes':
          case 'tag_note':
          case 'log_expense':
          case 'get_expense_summary':
          case 'categorize_expenses':
          case 'generate_daily_summary':
          case 'export_data':
          case 'create_alert':
          case 'list_alerts': {
            const result = await handleUniversalTool(name, args);
            return {
              content: [{
                type: 'text',
                text: JSON.stringify(result, null, 2)
              }]
            };
          }
          case 'check_inventory': {
            const search = String(args?.search || '').toLowerCase();
            const results = storeData.inventory.filter(item =>
              item.name.toLowerCase().includes(search) ||
              item.id.toLowerCase().includes(search) ||
              item.category.toLowerCase().includes(search)
            );
            return {
              content: [{
                type: 'text',
                text: results.length > 0
                  ? `Found ${results.length} item(s):\n\n${results.map(item => 
                      `${item.name} (${item.id})\n- Category: ${item.category}\n- Stock: ${item.quantity} units${item.quantity <= item.reorderLevel ? ' āš ļø LOW STOCK' : ''}\n- Price: $${item.price}\n- Supplier: ${item.supplier}\n- Last Restocked: ${item.lastRestocked}`
                    ).join('\n\n')}`
                  : `No items found matching "${args?.search}"`
              }]
            };
          }
    
          case 'get_low_stock_items': {
            const category = args?.category ? String(args.category) : null;
            let lowStockItems = storeData.inventory.filter(item => item.quantity <= item.reorderLevel);
            if (category) {
              lowStockItems = lowStockItems.filter(item => item.category.toLowerCase() === category.toLowerCase());
            }
            return {
              content: [{
                type: 'text',
                text: lowStockItems.length > 0
                  ? `āš ļø ${lowStockItems.length} item(s) need reordering:\n\n${lowStockItems.map(item =>
                      `${item.name} (${item.id})\n- Current: ${item.quantity} | Reorder Level: ${item.reorderLevel}\n- Need to order: ${item.reorderLevel * 2 - item.quantity} units\n- Supplier: ${item.supplier}`
                    ).join('\n\n')}`
                  : 'āœ… All items are adequately stocked!'
              }]
            };
          }
    
          case 'update_stock': {
            const sku = String(args?.sku || '');
            const quantity = Number(args?.quantity || 0);
            const reason = String(args?.reason || 'manual update');
            const item = storeData.inventory.find(i => i.id === sku);
            
            if (!item) {
              return { content: [{ type: 'text', text: `āŒ Product ${sku} not found` }] };
            }
            
            const oldQty = item.quantity;
            item.quantity = quantity;
            const diff = quantity - oldQty;
            
            return {
              content: [{
                type: 'text',
                text: `āœ… Stock updated for ${item.name}\n- Previous: ${oldQty} units\n- New: ${quantity} units\n- Change: ${diff > 0 ? '+' : ''}${diff} units\n- Reason: ${reason}\n- ${quantity <= item.reorderLevel ? 'āš ļø Now below reorder level!' : 'Stock level OK'}`
              }]
            };
          }
    
          case 'search_products': {
            const query = String(args?.query || '').toLowerCase();
            const filterBy = args?.filterBy ? String(args.filterBy) : null;
            
            let results = storeData.inventory.filter(item =>
              item.name.toLowerCase().includes(query) ||
              item.category.toLowerCase().includes(query)
            );
            
            return {
              content: [{
                type: 'text',
                text: `Found ${results.length} product(s):\n\n${results.map(item =>
                  `šŸ“¦ ${item.name}\n- SKU: ${item.id} | Price: $${item.price}\n- Category: ${item.category} | Stock: ${item.quantity}\n- Supplier: ${item.supplier}`
                ).join('\n\n')}`
              }]
            };
          }
    
          // CUSTOMER MANAGEMENT
          case 'lookup_customer': {
            const identifier = String(args?.identifier || '').toLowerCase();
            const customer = storeData.customers.find(c =>
              c.name.toLowerCase().includes(identifier) ||
              c.email.toLowerCase().includes(identifier) ||
              c.phone.includes(identifier) ||
              c.id.toLowerCase() === identifier
            );
            
            if (!customer) {
              return { content: [{ type: 'text', text: `āŒ Customer not found: "${args?.identifier}"` }] };
            }
            
            return {
              content: [{
                type: 'text',
                text: `šŸ‘¤ ${customer.name} (${customer.id})\n\nšŸ“§ ${customer.email}\nšŸ“± ${customer.phone}\n\nšŸ’° Total Spent: $${customer.totalSpent.toFixed(2)}\n⭐ Loyalty Points: ${customer.loyaltyPoints} (ā‰ˆ $${(customer.loyaltyPoints / 10).toFixed(2)} credit)\nšŸ“… Last Visit: ${customer.lastVisit}\nšŸŽØ Preferences: ${customer.preferences.join(', ')}`
              }]
            };
          }
    
          case 'update_loyalty_points': {
            const customerId = String(args?.customerId || '');
            const points = Number(args?.points || 0);
            const reason = String(args?.reason || 'adjustment');
            const customer = storeData.customers.find(c => c.id === customerId);
            
            if (!customer) {
              return { content: [{ type: 'text', text: `āŒ Customer ${customerId} not found` }] };
            }
            
            const oldPoints = customer.loyaltyPoints;
            customer.loyaltyPoints += points;
            
            return {
              content: [{
                type: 'text',
                text: `āœ… Loyalty points updated for ${customer.name}\n- Previous: ${oldPoints} points\n- Change: ${points > 0 ? '+' : ''}${points} points\n- New Balance: ${customer.loyaltyPoints} points (ā‰ˆ $${(customer.loyaltyPoints / 10).toFixed(2)} credit)\n- Reason: ${reason}`
              }]
            };
          }
    
          case 'get_customer_recommendations': {
            const customerId = String(args?.customerId || '');
            const customer = storeData.customers.find(c => c.id === customerId);
            
            if (!customer) {
              return { content: [{ type: 'text', text: `āŒ Customer ${customerId} not found` }] };
            }
            
            const recommendations = storeData.inventory.filter(item =>
              customer.preferences.some(pref => 
                item.name.toLowerCase().includes(pref.toLowerCase()) ||
                item.category.toLowerCase().includes(pref.toLowerCase())
              )
            ).slice(0, 5);
            
            return {
              content: [{
                type: 'text',
                text: `šŸŽÆ Personalized recommendations for ${customer.name}:\n\nBased on preferences: ${customer.preferences.join(', ')}\n\n${recommendations.map(item =>
                  `• ${item.name} - $${item.price}\n  ${item.quantity} in stock`
                ).join('\n')}`
              }]
            };
          }
    
          case 'get_top_customers': {
            const sortBy = String(args?.sortBy || 'spending');
            const limit = Number(args?.limit || 10);
            
            const sorted = [...storeData.customers].sort((a, b) =>
              sortBy === 'loyalty_points' ? b.loyaltyPoints - a.loyaltyPoints : b.totalSpent - a.totalSpent
            ).slice(0, limit);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ† Top ${limit} Customers by ${sortBy === 'loyalty_points' ? 'Loyalty Points' : 'Total Spending'}:\n\n${sorted.map((c, i) =>
                  `${i + 1}. ${c.name}\n   ${sortBy === 'loyalty_points' ? `${c.loyaltyPoints} points` : `$${c.totalSpent.toFixed(2)} spent`} | Last visit: ${c.lastVisit}`
                ).join('\n\n')}`
              }]
            };
          }
    
          // SALES & ANALYTICS
          case 'get_daily_sales': {
            const date = String(args?.date || '2025-10-03');
            const salesData = storeData.sales.find(s => s.date === date);
            
            if (!salesData) {
              return { content: [{ type: 'text', text: `No sales data found for ${date}` }] };
            }
            
            return {
              content: [{
                type: 'text',
                text: `šŸ“Š Sales Report for ${salesData.date}\n\nšŸ’µ Revenue: $${salesData.revenue.toFixed(2)}\nšŸ›’ Transactions: ${salesData.transactions}\nšŸ“ˆ Avg Transaction: $${(salesData.revenue / salesData.transactions).toFixed(2)}\nšŸ† Top Seller: ${salesData.topItem}`
              }]
            };
          }
    
          case 'get_sales_report': {
            const startDate = String(args?.startDate || '');
            const endDate = String(args?.endDate || '');
            
            const periodSales = storeData.sales.filter(s => s.date >= startDate && s.date <= endDate);
            const totalRevenue = periodSales.reduce((sum, s) => sum + s.revenue, 0);
            const totalTransactions = periodSales.reduce((sum, s) => sum + s.transactions, 0);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ“Š Sales Report: ${startDate} to ${endDate}\n\nšŸ’° Total Revenue: $${totalRevenue.toFixed(2)}\nšŸ›’ Total Transactions: ${totalTransactions}\nšŸ“ˆ Average Transaction: $${(totalRevenue / totalTransactions).toFixed(2)}\nšŸ“… Days in Period: ${periodSales.length}\nšŸ“Š Daily Average: $${(totalRevenue / periodSales.length).toFixed(2)}`
              }]
            };
          }
    
          case 'get_best_sellers': {
            const category = args?.category ? String(args.category) : null;
            const period = String(args?.period || 'week');
            
            let items = storeData.inventory;
            if (category) {
              items = items.filter(i => i.category.toLowerCase() === category.toLowerCase());
            }
            
            const bestSellers = items.sort((a, b) => b.price - a.price).slice(0, 5);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ† Best Sellers${category ? ` in ${category}` : ''} (${period}):\n\n${bestSellers.map((item, i) =>
                  `${i + 1}. ${item.name}\n   Price: $${item.price} | In stock: ${item.quantity}`
                ).join('\n\n')}`
              }]
            };
          }
    
          case 'calculate_profit_margin': {
            const sku = String(args?.sku || '');
            const costPrice = Number(args?.costPrice || 0);
            const item = storeData.inventory.find(i => i.id === sku);
            
            if (!item) {
              return { content: [{ type: 'text', text: `āŒ Product ${sku} not found` }] };
            }
            
            const profit = item.price - costPrice;
            const margin = (profit / item.price) * 100;
            
            return {
              content: [{
                type: 'text',
                text: `šŸ’° Profit Analysis: ${item.name}\n\n- Selling Price: $${item.price}\n- Cost Price: $${costPrice.toFixed(2)}\n- Profit per Unit: $${profit.toFixed(2)}\n- Profit Margin: ${margin.toFixed(1)}%\n- Potential Revenue (current stock): $${(item.quantity * profit).toFixed(2)}`
              }]
            };
          }
    
          // SUPPLIER & ORDERING
          case 'get_supplier_info': {
            const supplierName = String(args?.supplierName || '').toLowerCase();
            const supplier = storeData.suppliers.find(s =>
              s.name.toLowerCase().includes(supplierName) ||
              s.id.toLowerCase() === supplierName
            );
            
            if (!supplier) {
              return { content: [{ type: 'text', text: `āŒ Supplier not found: "${args?.supplierName}"` }] };
            }
            
            const supplierProducts = storeData.inventory.filter(i => i.supplier === supplier.name);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ¢ ${supplier.name} (${supplier.id})\n\nšŸ“§ ${supplier.contact}\nšŸ“± ${supplier.phone}\nā±ļø Lead Time: ${supplier.leadTime}\nšŸ’µ Minimum Order: $${supplier.minOrder}\n\nšŸ“¦ Products from this supplier: ${supplierProducts.length}\n${supplierProducts.slice(0, 5).map(p => `• ${p.name}`).join('\n')}`
              }]
            };
          }
    
          case 'create_purchase_order': {
            const supplier = String(args?.supplier || '');
            const autoInclude = Boolean(args?.autoIncludeLowStock);
            
            const supplierInfo = storeData.suppliers.find(s => s.name.toLowerCase().includes(supplier.toLowerCase()));
            
            if (!supplierInfo) {
              return { content: [{ type: 'text', text: `āŒ Supplier not found: "${supplier}"` }] };
            }
            
            const supplierProducts = storeData.inventory.filter(i => i.supplier === supplierInfo.name);
            const lowStock = autoInclude ? supplierProducts.filter(i => i.quantity <= i.reorderLevel) : [];
            
            const orderTotal = lowStock.reduce((sum, item) => sum + (item.price * (item.reorderLevel * 2 - item.quantity)), 0);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ“ Purchase Order Created\n\nšŸ¢ Supplier: ${supplierInfo.name}\nšŸ“… Date: ${new Date().toISOString().split('T')[0]}\nā±ļø Expected Delivery: ${supplierInfo.leadTime}\n\n${lowStock.length > 0 ? `Items to Order:\n${lowStock.map(item =>
                  `• ${item.name} (${item.id})\n  Order Qty: ${item.reorderLevel * 2 - item.quantity} | Est. Cost: $${(item.price * (item.reorderLevel * 2 - item.quantity) * 0.6).toFixed(2)}`
                ).join('\n\n')}\n\nšŸ’° Estimated Total: $${(orderTotal * 0.6).toFixed(2)}` : 'No items below reorder level for this supplier.'}`
              }]
            };
          }
    
          case 'compare_supplier_prices': {
            const productName = String(args?.productName || '').toLowerCase();
            const products = storeData.inventory.filter(i =>
              i.name.toLowerCase().includes(productName) ||
              i.category.toLowerCase().includes(productName)
            );
            
            if (products.length === 0) {
              return { content: [{ type: 'text', text: `No products found matching "${args?.productName}"` }] };
            }
            
            const supplierMap = new Map();
            products.forEach(p => {
              if (!supplierMap.has(p.supplier)) {
                supplierMap.set(p.supplier, []);
              }
              supplierMap.get(p.supplier).push(p);
            });
            
            return {
              content: [{
                type: 'text',
                text: `šŸ’² Price Comparison for "${args?.productName}":\n\n${Array.from(supplierMap.entries()).map(([supplier, items]) => {
                  const supplierInfo = storeData.suppliers.find(s => s.name === supplier);
                  return `${supplier}:\n${items.map((item: any) => `• ${item.name} - $${item.price}`).join('\n')}\nLead Time: ${supplierInfo?.leadTime || 'N/A'}`;
                }).join('\n\n')}`
              }]
            };
          }
    
          // SCHEDULING & OPERATIONS
          case 'check_appointments': {
            const date = String(args?.date || new Date().toISOString().split('T')[0]);
            const appointments = storeData.appointments.filter(a => a.date === date);
            
            return {
              content: [{
                type: 'text',
                text: appointments.length > 0
                  ? `šŸ“… Appointments for ${date}:\n\n${appointments.map(apt =>
                      `ā° ${apt.time} - ${apt.service}\nšŸ‘¤ Customer: ${apt.customerName}\nā±ļø Duration: ${apt.duration}`
                    ).join('\n\n')}`
                  : `No appointments scheduled for ${date}`
              }]
            };
          }
    
          case 'book_appointment': {
            const customerName = String(args?.customerName || '');
            const service = String(args?.service || '');
            const date = String(args?.date || '');
            const time = String(args?.time || '');
            
            const newApt = {
              id: `APT${String(storeData.appointments.length + 1).padStart(3, '0')}`,
              customerName,
              service,
              date,
              time,
              duration: service.toLowerCase().includes('workshop') ? '2 hours' : '30 min'
            };
            
            storeData.appointments.push(newApt);
            
            return {
              content: [{
                type: 'text',
                text: `āœ… Appointment Booked!\n\nšŸ“… ${date} at ${time}\nšŸ‘¤ ${customerName}\nšŸŽØ Service: ${service}\nā±ļø Duration: ${newApt.duration}\nšŸŽ« Confirmation: ${newApt.id}`
              }]
            };
          }
    
          case 'get_employee_schedule': {
            const date = String(args?.date || new Date().toLocaleDateString('en-US', { weekday: 'long' }));
            
            return {
              content: [{
                type: 'text',
                text: `šŸ‘„ Employee Schedule:\n\n${storeData.employees.map(emp =>
                  `${emp.name} - ${emp.role}\nšŸ“… ${emp.shift}\nšŸ’µ Rate: $${emp.hourlyRate}/hr`
                ).join('\n\n')}`
              }]
            };
          }
    
          case 'calculate_labor_cost': {
            const startDate = String(args?.startDate || '');
            const endDate = String(args?.endDate || '');
            
            const days = Math.ceil((new Date(endDate).getTime() - new Date(startDate).getTime()) / (1000 * 60 * 60 * 24));
            const totalCost = storeData.employees.reduce((sum, emp) => sum + (emp.hourlyRate * 40 * days / 7), 0);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ’° Labor Cost Analysis\nšŸ“… Period: ${startDate} to ${endDate} (${days} days)\n\n${storeData.employees.map(emp =>
                  `${emp.name}: $${(emp.hourlyRate * 40 * days / 7).toFixed(2)}`
                ).join('\n')}\n\nšŸ’µ Total Labor Cost: $${totalCost.toFixed(2)}\nšŸ“Š Daily Average: $${(totalCost / days).toFixed(2)}`
              }]
            };
          }
    
          // PRICING & PROMOTIONS
          case 'calculate_discount': {
            const sku = String(args?.sku || '');
            const discountType = String(args?.discountType || 'percentage');
            const discountValue = Number(args?.discountValue || 0);
            const quantity = Number(args?.quantity || 1);
            
            const item = storeData.inventory.find(i => i.id === sku);
            if (!item) {
              return { content: [{ type: 'text', text: `āŒ Product ${sku} not found` }] };
            }
            
            let finalPrice = item.price;
            let discount = 0;
            
            switch (discountType) {
              case 'percentage':
                discount = item.price * (discountValue / 100);
                finalPrice = item.price - discount;
                break;
              case 'fixed':
                discount = discountValue;
                finalPrice = item.price - discount;
                break;
              case 'loyalty':
                discount = discountValue / 10;
                finalPrice = item.price - discount;
                break;
              case 'bulk':
                if (quantity >= 5) {
                  discount = item.price * 0.15;
                  finalPrice = item.price - discount;
                }
                break;
            }
            
            return {
              content: [{
                type: 'text',
                text: `šŸ’² Price Calculation: ${item.name}\n\n- Original Price: $${item.price}\n- Discount Type: ${discountType}\n- Discount Amount: $${discount.toFixed(2)}\n- Final Price: $${finalPrice.toFixed(2)}\n- Quantity: ${quantity}\n- Total: $${(finalPrice * quantity).toFixed(2)}`
              }]
            };
          }
    
          case 'suggest_bundle': {
            const baseSku = String(args?.baseSku || '');
            const baseItem = storeData.inventory.find(i => i.id === baseSku);
            
            if (!baseItem) {
              return { content: [{ type: 'text', text: `āŒ Product ${baseSku} not found` }] };
            }
            
            const complementary = storeData.inventory
              .filter(i => i.category === baseItem.category || i.id !== baseSku)
              .slice(0, 3);
            
            const bundlePrice = baseItem.price + complementary.reduce((sum, item) => sum + item.price, 0);
            const bundleDiscount = bundlePrice * 0.15;
            
            return {
              content: [{
                type: 'text',
                text: `šŸŽ Suggested Bundle:\n\nšŸ“¦ Base Item:\n• ${baseItem.name} - $${baseItem.price}\n\nāž• Add to Bundle:\n${complementary.map(item =>
                  `• ${item.name} - $${item.price}`
                ).join('\n')}\n\nšŸ’° Bundle Price:\n- Individual Total: $${bundlePrice.toFixed(2)}\n- Bundle Discount (15%): -$${bundleDiscount.toFixed(2)}\n- Bundle Price: $${(bundlePrice - bundleDiscount).toFixed(2)}\nšŸ’µ Customer Saves: $${bundleDiscount.toFixed(2)}`
              }]
            };
          }
    
          // REPORTING & INSIGHTS
          case 'generate_eod_report': {
            const date = String(args?.date || '2025-10-03');
            const salesData = storeData.sales.find(s => s.date === date);
            const lowStock = storeData.inventory.filter(i => i.quantity <= i.reorderLevel);
            const appointments = storeData.appointments.filter(a => a.date === date);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ“‹ End of Day Report - ${date}\n\nšŸ’° SALES SUMMARY:\n- Revenue: $${salesData?.revenue.toFixed(2) || '0.00'}\n- Transactions: ${salesData?.transactions || 0}\n- Avg Transaction: $${salesData ? (salesData.revenue / salesData.transactions).toFixed(2) : '0.00'}\n\nāš ļø ACTION ITEMS:\n- ${lowStock.length} items need reordering\n- ${appointments.length} appointments completed\n\nšŸ“Š KEY METRICS:\n- Top Seller: ${salesData?.topItem || 'N/A'}\n- Inventory Alerts: ${lowStock.length}\n\nāœ… CLOSING TASKS:\nā–” Count cash drawer\nā–” Review low stock report\nā–” Confirm tomorrow's appointments\nā–” Lock up and set alarm`
              }]
            };
          }
    
          case 'get_inventory_value': {
            const valueType = String(args?.valueType || 'retail');
            const category = args?.category ? String(args.category) : null;
            
            let items = storeData.inventory;
            if (category) {
              items = items.filter(i => i.category.toLowerCase() === category.toLowerCase());
            }
            
            const retailValue = items.reduce((sum, item) => sum + (item.price * item.quantity), 0);
            const costValue = retailValue * 0.6; // Assume 40% markup
            
            return {
              content: [{
                type: 'text',
                text: `šŸ’Ž Inventory Valuation${category ? ` - ${category}` : ''}\n\nšŸ“¦ Total Items: ${items.length}\nšŸ“Š Total Units: ${items.reduce((sum, i) => sum + i.quantity, 0)}\n\nšŸ’° Value at Cost: $${costValue.toFixed(2)}\nšŸ’µ Value at Retail: $${retailValue.toFixed(2)}\nšŸ“ˆ Potential Profit: $${(retailValue - costValue).toFixed(2)}`
              }]
            };
          }
    
          case 'forecast_demand': {
            const sku = String(args?.sku || '');
            const period = String(args?.period || 'month');
            const item = storeData.inventory.find(i => i.id === sku);
            
            if (!item) {
              return { content: [{ type: 'text', text: `āŒ Product ${sku} not found` }] };
            }
            
            const baselineSales = 50;
            const periodMultiplier = period === 'week' ? 0.25 : period === 'month' ? 1 : 3;
            const forecast = Math.round(baselineSales * periodMultiplier);
            
            return {
              content: [{
                type: 'text',
                text: `šŸ“ˆ Demand Forecast: ${item.name}\n\nšŸ“… Period: Next ${period}\nšŸ“Š Forecasted Sales: ~${forecast} units\nšŸ“¦ Current Stock: ${item.quantity} units\n\n${item.quantity < forecast ? `āš ļø WARNING: Current stock may not meet demand!\nšŸ’” Recommended order: ${forecast - item.quantity + item.reorderLevel} units` : 'āœ… Current stock sufficient for forecasted demand'}`
              }]
            };
          }
    
          // SOCIAL MEDIA MANAGEMENT
          case 'post_to_social_media': {
            if (!socialMediaManager.isConfigured()) {
              return {
                content: [{
                  type: 'text',
                  text: `āš ļø Social media not configured yet!\n\nTo use this feature:\n1. Create a Facebook Business account\n2. Create a Facebook App\n3. Get your access tokens\n4. Add them to your .env file\n\nSee FACEBOOK_INSTAGRAM_SETUP.md for detailed instructions.`
                }]
              };
            }
    
            const platforms = String(args?.platforms || 'facebook').toLowerCase().split(',').map(p => p.trim());
            const message = String(args?.message || '');
            const imageUrl = args?.imageUrl ? String(args.imageUrl) : undefined;
            const hashtags = args?.hashtags ? String(args.hashtags).split(',').map(h => h.trim()) : undefined;
            const scheduleTime = args?.scheduleTime ? String(args.scheduleTime) : undefined;
    
            const results = [];
            
            for (const platform of platforms) {
              if (platform === 'facebook' || platform === 'both') {
                const result = await socialMediaManager.postToFacebook({
                  platform: 'facebook',
                  message,
                  imageUrl,
                  scheduledTime: scheduleTime
                });
                results.push(result);
              }
              
              if (platform === 'instagram' || platform === 'both') {
                const result = await socialMediaManager.postToInstagram({
                  platform: 'instagram',
                  message,
                  imageUrl,
                  hashtags
                });
                results.push(result);
              }
            }
    
            const successCount = results.filter(r => r.success).length;
            const failedResults = results.filter(r => !r.success);
    
            return {
              content: [{
                type: 'text',
                text: `šŸ“± Social Media Post Results\n\nāœ… ${successCount}/${results.length} successful\n\n${results.map(r =>
                  r.success 
                    ? `āœ“ ${r.platform}: Posted${r.scheduledTime ? ` (scheduled for ${r.scheduledTime})` : ''}\n  Post ID: ${r.postId}`
                    : `āœ— ${r.platform}: Failed - ${r.error}`
                ).join('\n\n')}${failedResults.length > 0 ? '\n\nšŸ’” Tip: Check your API tokens and permissions if posts failed.' : ''}`
              }]
            };
          }
    
          case 'generate_post_ideas': {
            const theme = String(args?.theme || '');
            const productsArg = String(args?.products || '');
            const count = Number(args?.count || 5);
            
            const products = productsArg.split(',').map(p => p.trim());
            const ideas = socialMediaManager.generatePostIdeas(theme, products);
    
            return {
              content: [{
                type: 'text',
                text: `šŸ’” Post Ideas - ${theme}\n\n${ideas.slice(0, count).map((idea, i) =>
                  `${i + 1}. ${idea}`
                ).join('\n\n')}\n\n✨ Pro tip: Customize these ideas with your store's personality and current promotions!`
              }]
            };
          }
    
          case 'schedule_weekly_posts': {
            const startDate = String(args?.startDate || '');
            const postsPerDay = Number(args?.postsPerDay || 1);
            const focusProducts = String(args?.focusProducts || '');
            
            const products = focusProducts ? focusProducts.split(',').map(p => p.trim()) : ['Acrylic Paint', 'Brushes', 'Canvas'];
            const postTypes = ['product_feature', 'behind_the_scenes', 'customer_spotlight', 'tip_of_the_day', 'promotion'];
            
            const schedule = [];
            const start = new Date(startDate);
            
            for (let day = 0; day < 7; day++) {
              const currentDate = new Date(start);
              currentDate.setDate(start.getDate() + day);
              const dateStr = currentDate.toISOString().split('T')[0];
              const dayName = currentDate.toLocaleDateString('en-US', { weekday: 'long' });
              
              for (let post = 0; post < postsPerDay; post++) {
                const postType = postTypes[Math.floor(Math.random() * postTypes.length)];
                const product = products[Math.floor(Math.random() * products.length)];
                
                schedule.push({
                  date: dateStr,
                  day: dayName,
                  time: post === 0 ? '10:00 AM' : post === 1 ? '2:00 PM' : '6:00 PM',
                  type: postType,
                  suggestion: `${postType.replace('_', ' ').toUpperCase()}: Feature ${product}`
                });
              }
            }
    
            return {
              content: [{
                type: 'text',
                text: `šŸ“… Weekly Posting Schedule\nšŸ“ Week of ${startDate}\n\n${schedule.map(s =>
                  `${s.day}, ${s.date} @ ${s.time}\n  ${s.suggestion}`
                ).join('\n\n')}\n\nšŸ’” Use 'generate_post_ideas' for specific content, then 'post_to_social_media' to publish!`
              }]
            };
          }
    
          case 'get_social_analytics': {
            if (!socialMediaManager.isConfigured()) {
              return {
                content: [{
                  type: 'text',
                  text: `āš ļø Social media not configured. See FACEBOOK_INSTAGRAM_SETUP.md for setup instructions.`
                }]
              };
            }
    
            const platform = String(args?.platform || 'facebook');
            const period = Number(args?.period || 7);
    
            try {
              if (platform.toLowerCase() === 'facebook') {
                const analytics = await socialMediaManager.getFacebookAnalytics(period);
                
                return {
                  content: [{
                    type: 'text',
                    text: `šŸ“Š Facebook Analytics - ${analytics.period}\n\nšŸ“ˆ Performance Metrics:\n  šŸ‘„ Reach: ${analytics.metrics.reach.toLocaleString()}\n  šŸ‘ļø Impressions: ${analytics.metrics.impressions.toLocaleString()}\n  šŸ’¬ Engagement: ${analytics.metrics.engagement.toLocaleString()}\n  ⭐ Followers: ${analytics.metrics.followers.toLocaleString()}\n\nšŸ† Top Posts:\n${analytics.topPosts.map((post, i) =>
                      `${i + 1}. ${post.content}\n   ā¤ļø ${post.likes} | šŸ’¬ ${post.comments} | šŸ”„ ${post.shares}`
                    ).join('\n\n')}\n\nšŸ’” Insight: Post more content like your top performers to boost engagement!`
                  }]
                };
              } else {
                return {
                  content: [{
                    type: 'text',
                    text: `šŸ“Š Instagram Analytics coming soon! Currently only Facebook analytics are available.`
                  }]
                };
              }
            } catch (error: any) {
              return {
                content: [{
                  type: 'text',
                  text: `āŒ Failed to fetch analytics: ${error.message}`
                }]
              };
            }
          }
    
          case 'get_new_comments': {
            if (!socialMediaManager.isConfigured()) {
              return {
                content: [{
                  type: 'text',
                  text: `āš ļø Social media not configured. See FACEBOOK_INSTAGRAM_SETUP.md for setup instructions.`
                }]
              };
            }
    
            const sinceHours = Number(args?.sinceHours || 24);
            
            try {
              const comments = await socialMediaManager.getFacebookComments(sinceHours);
              
              if (comments.length === 0) {
                return {
                  content: [{
                    type: 'text',
                    text: `āœ… No new comments in the last ${sinceHours} hours. All caught up!`
                  }]
                };
              }
    
              return {
                content: [{
                  type: 'text',
                  text: `šŸ’¬ New Comments (Last ${sinceHours} hours)\n\n${comments.map((comment, i) =>
                    `${i + 1}. From ${comment.from} on ${comment.platform}\n   "${comment.text}"\n   šŸ• ${new Date(comment.timestamp).toLocaleString()}`
                  ).join('\n\n')}\n\nšŸ’” Use 'suggest_comment_reply' to get AI-powered reply suggestions!`
                }]
              };
            } catch (error: any) {
              return {
                content: [{
                  type: 'text',
                  text: `āŒ Failed to fetch comments: ${error.message}`
                }]
              };
            }
          }
    
          case 'suggest_comment_reply': {
            const commentText = String(args?.commentText || '');
            const tone = String(args?.tone || 'friendly');
            
            if (!commentText) {
              return {
                content: [{
                  type: 'text',
                  text: `āŒ Please provide the comment text to reply to.`
                }]
              };
            }
    
            const suggestions = socialMediaManager.generateCommentReplySuggestions(commentText);
    
            return {
              content: [{
                type: 'text',
                text: `šŸ’¬ Reply Suggestions (${tone} tone)\n\nOriginal comment: "${commentText}"\n\n${suggestions.map((suggestion, i) =>
                  `${i + 1}. ${suggestion}`
                ).join('\n\n')}\n\n✨ Feel free to customize these replies to match your store's voice!`
              }]
            };
          }
    
          case 'generate_hashtags': {
            const postTopic = String(args?.postTopic || '');
            const includeLocation = Boolean(args?.includeLocation ?? true);
            const count = Number(args?.count || 15);
            
            if (!postTopic) {
              return {
                content: [{
                  type: 'text',
                  text: `āŒ Please provide a post topic to generate hashtags.`
                }]
              };
            }
    
            const hashtags = socialMediaManager.generateHashtags(postTopic, includeLocation);
    
            return {
              content: [{
                type: 'text',
                text: `#ļøāƒ£ Hashtag Suggestions for "${postTopic}"\n\n${hashtags.slice(0, count).map(tag => `#${tag}`).join(' ')}\n\nšŸ“‹ Copy-paste ready: ${hashtags.slice(0, count).map(tag => `#${tag}`).join(' ')}\n\nšŸ’” Pro tip: Use 10-15 hashtags per post for maximum reach without looking spammy!`
              }]
            };
          }
    
          case 'get_instagram_story_ideas': {
            const occasion = String(args?.occasion || 'daily');
            const productsArg = args?.products ? String(args.products) : '';
            
            const storyIdeas = [
              `šŸ“ø Behind the counter: Show off new ${productsArg || 'art supplies'} that just arrived!`,
              `šŸŽØ Quick tip: Demo how to use ${productsArg || 'one of your products'} in 15 seconds`,
              `ā“ Poll: "What's your favorite art medium?" with product stickers`,
              `ā° Countdown sticker: "${occasion}" sale starts in...`,
              `🌟 Customer spotlight: Share a tagged photo of customer artwork (with permission)`,
              `šŸ’Æ This or That: Show two products and let followers vote`,
              `šŸŽÆ Link sticker: "New blog post: Top 5 ${productsArg || 'art supplies'} for beginners"`,
              `šŸ“¦ Unboxing: Quick reveal of what's in today's shipment`
            ];
    
            return {
              content: [{
                type: 'text',
                text: `šŸ“± Instagram Story Ideas - ${occasion}\n\n${storyIdeas.map((idea, i) =>
                  `${i + 1}. ${idea}`
                ).join('\n\n')}\n\n✨ Remember: Stories are temporary, so have fun and be authentic!`
              }]
            };
          }
    
          case 'create_product_campaign': {
            const productSku = String(args?.productSku || '');
            const duration = Number(args?.duration || 7);
            const platforms = String(args?.platforms || 'both');
            
            const product = storeData.inventory.find(p => p.id === productSku);
            
            if (!product) {
              return {
                content: [{
                  type: 'text',
                  text: `āŒ Product ${productSku} not found in inventory.`
                }]
              };
            }
    
            const campaignPosts = [
              {
                day: 1,
                type: 'Announcement',
                content: `šŸŽ‰ Introducing: ${product.name}! Perfect for ${product.category.toLowerCase()} artists. $${product.price} - Available now!`
              },
              {
                day: 3,
                type: 'Feature Highlight',
                content: `✨ Why ${product.name}? Let us show you what makes this ${product.category} essential for your creative toolkit!`
              },
              {
                day: 5,
                type: 'Customer Testimonial',
                content: `⭐ "Love the ${product.name}!" - Hear what our customers are saying about this amazing product!`
              },
              {
                day: duration,
                type: 'Last Chance',
                content: `ā° Don't miss out! Get your ${product.name} today while supplies last. Only ${product.quantity} in stock!`
              }
            ];
    
            return {
              content: [{
                type: 'text',
                text: `šŸŽÆ Product Campaign: ${product.name}\nšŸ“… Duration: ${duration} days\nšŸ“± Platforms: ${platforms}\nšŸ’° Price: $${product.price}\n\nšŸ“‹ Campaign Schedule:\n\n${campaignPosts.filter(p => p.day <= duration).map(post =>
                  `Day ${post.day} - ${post.type}\n${post.content}`
                ).join('\n\n')}\n\nšŸ’” Use 'post_to_social_media' to publish each post, and 'generate_hashtags' for maximum reach!`
              }]
            };
          }
    
          case 'analyze_post_performance': {
            const postId = String(args?.postId || '');
            const compareToAverage = Boolean(args?.compareToAverage ?? true);
            
            if (!postId) {
              return {
                content: [{
                  type: 'text',
                  text: `āŒ Please provide a post ID to analyze.`
                }]
              };
            }
    
            // Mock analysis (real implementation would call Meta Graph API)
            const mockAnalysis = {
              postId,
              reach: 2340,
              impressions: 3120,
              engagement: 187,
              likes: 156,
              comments: 23,
              shares: 8,
              engagementRate: 8.0,
              accountAverage: {
                reach: 1850,
                engagementRate: 5.5
              }
            };
    
            const performance = mockAnalysis.engagementRate > mockAnalysis.accountAverage.engagementRate ? 'šŸ“ˆ Above' : 'šŸ“‰ Below';
    
            return {
              content: [{
                type: 'text',
                text: `šŸ“Š Post Performance Analysis\nšŸ†” Post ID: ${postId}\n\nšŸ“ˆ Metrics:\n  šŸ‘„ Reach: ${mockAnalysis.reach.toLocaleString()}\n  šŸ‘ļø Impressions: ${mockAnalysis.impressions.toLocaleString()}\n  šŸ’¬ Engagement: ${mockAnalysis.engagement} (${mockAnalysis.engagementRate}%)\n  ā¤ļø Likes: ${mockAnalysis.likes}\n  šŸ’¬ Comments: ${mockAnalysis.comments}\n  šŸ”„ Shares: ${mockAnalysis.shares}\n\n${compareToAverage ? `šŸ“Š vs Account Average:\n  ${performance} average (${mockAnalysis.engagementRate}% vs ${mockAnalysis.accountAverage.engagementRate}%)\n  Reach ${mockAnalysis.reach > mockAnalysis.accountAverage.reach ? '+' : ''}${((mockAnalysis.reach / mockAnalysis.accountAverage.reach - 1) * 100).toFixed(1)}%\n\n` : ''}šŸ’” Insight: ${mockAnalysis.engagementRate > 7 ? 'Great post! Create more content like this.' : 'Try experimenting with different content types or posting times.'}`
              }]
            };
          }
    
          case 'auto_respond_common_questions': {
            const enable = Boolean(args?.enable ?? false);
            const questionTypes = String(args?.questionTypes || 'hours,location,stock');
            
            const types = questionTypes.split(',').map(t => t.trim());
    
            return {
              content: [{
                type: 'text',
                text: `šŸ¤– Auto-Response Settings ${enable ? 'ENABLED' : 'DISABLED'}\n\n${enable ? 'āœ… Will auto-respond to:\n' + types.map(type =>
                  `  • ${type.charAt(0).toUpperCase() + type.slice(1)} questions`
                ).join('\n') : 'āŒ Auto-responses are disabled'}\n\nāš™ļø Note: Auto-responses help provide quick answers, but always review and personalize when possible!\n\nšŸ’” This is a mock feature. In production, this would integrate with Facebook's Messenger API for automated responses.`
              }]
            };
          }
    
          case 'track_competitor_activity': {
            const competitors = String(args?.competitors || '');
            const metrics = String(args?.metrics || 'posts,engagement');
            
            if (!competitors) {
              return {
                content: [{
                  type: 'text',
                  text: `āŒ Please provide competitor page names to track.`
                }]
              };
            }
    
            const competitorList = competitors.split(',').map(c => c.trim());
            const metricsList = metrics.split(',').map(m => m.trim());
    
            // Mock competitor data
            const mockData = competitorList.map(comp => ({
              name: comp,
              postsThisWeek: Math.floor(Math.random() * 10) + 3,
              avgEngagement: Math.floor(Math.random() * 200) + 50,
              recentPromotion: Math.random() > 0.5 ? 'Yes - Sale on brushes' : 'No recent promotions'
            }));
    
            return {
              content: [{
                type: 'text',
                text: `šŸ” Competitor Activity Tracking\nšŸ“Š Metrics: ${metricsList.join(', ')}\n\n${mockData.map(comp =>
                  `šŸ“ ${comp.name}\n  šŸ“ Posts this week: ${comp.postsThisWeek}\n  šŸ’¬ Avg engagement: ${comp.avgEngagement}\n  šŸŽÆ Promotions: ${comp.recentPromotion}`
                ).join('\n\n')}\n\nšŸ’” Note: This is a demonstration feature. In production, this would track public competitor pages to help you stay competitive.`
              }]
            };
          }
    
          default:
            throw new Error(`Unknown tool: ${name}`);
        }
      } catch (error: any) {
        return {
          content: [{
            type: 'text',
            text: `āŒ Error executing ${name}: ${error.message}`
          }],
          isError: true,
        };
      }
    });
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It mentions comparing 'prices and terms' but does not specify how the comparison is performed (e.g., real-time vs. cached data), what the output format might be, or any limitations like rate limits or authentication needs. This leaves significant gaps in understanding the tool's behavior beyond its basic function.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose without any wasted words. It is appropriately sized for the tool's complexity, making it easy to parse and understand quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the lack of annotations and output schema, the description is incomplete for a tool that performs comparison operations. It does not explain what the comparison output includes (e.g., structured data, summary), how results are formatted, or any behavioral traits like data freshness or error handling. This leaves the agent with insufficient context to use the tool effectively beyond basic invocation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 100% description coverage, with 'productName' clearly documented as 'Product name or category'. The description adds no additional parameter semantics beyond what the schema provides, such as examples or constraints. Since the schema coverage is high, the baseline score of 3 is appropriate, as the description does not compensate but also does not detract.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with a specific verb ('compare') and resources ('prices and terms across suppliers for a specific product or category'), making it easy to understand what it does. However, it does not explicitly differentiate from sibling tools like 'get_supplier_info' or 'search_products', which might also involve supplier or product data, leaving some ambiguity about uniqueness.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives, such as 'get_supplier_info' for general supplier details or 'search_products' for product searches. It lacks explicit context, prerequisites, or exclusions, leaving the agent to infer usage based on the purpose alone without clear differentiation.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/wspotter/mcpart'

If you have feedback or need assistance with the MCP directory API, please join our Discord server