Price and inventory change notifications: how to set up alerts

Why are notifications about price and inventory changes needed?

The alert system solves critical business problems:

• Preventing deficiency: Instant notification of reaching the minimum balance threshold allows you to place an order with the supplier in a timely manner
• Pricing control: Monitoring sharp price increases or decreases helps avoid pricing errors and loss of margin.
• Competitive monitoring: Alerts about price reductions by competitors make it possible to quickly adjust your pricing strategy
• Detecting anomalies: Automatic detection of atypical fluctuations indicates technical failures or problems with suppliers
• Transparency of operations: Notifications ensure visibility of all changes for responsible employees

Research shows that companies with a configured alert system reduce lost sales due to stockouts by 35% and cut pricing errors by 42%.

Notification Types: Choosing the Right Channels

Modern systems support multiple alert delivery channels, each suited to specific scenarios:

Email notifications

Application: detailed daily reports, non-critical changes, analytical digests.

Advantages: The ability to send detailed data, tables, and graphs; easy archiving and searching.

Setup via SendGrid:

 { "personalizations": [{ "to": [{"email": "manager@company.com"} ], "subject": "Critical balance: Item #12345" }], "from":{"email": "alerts@yourstore.com"}, "content": [{ "type": "text/html", "value": "<p> The Wireless Keyboard Pro inventory has dropped to 5 units.</p> " }] }

SMS notifications

Application: critical alerts that require immediate response.

Advantages: High delivery speed (3-5 seconds), guaranteed reading, works without internet.

Example Twilio setup:

 // Sending SMS when the balance is critical const twilio = require('twilio')(accountSid, authToken); twilio.messages.create({ body: 'СРОЧНО: Остаток товара SKU-7890 = 0. Требуется заказ!', from: '+1234567890', to: '+49123456789' } );

Telegram bots

Application: operational notifications for the team, group alerts, interactive actions.

Advantages: Free, instant delivery, ability to create interactive buttons for quick actions.

Setting up a Telegram bot:

 // 1. Create a bot via @BotFather and get a token // 2. Get the chat_id of your chat const TelegramBot = require('node-telegram-bot-api'); const bot = new TelegramBot('YOUR_BOT_TOKEN',{polling: false} ); // Sending a notification with action buttons bot.sendMessage(chatId, '⚠️ The price of the product "Smartphone X12" has changed\nWas: €599\nNow: €549\n\nChange: -8.3%', { reply_markup: { inline_keyboard: } });

Slack integrations

Application: corporate environment, teamwork, integration with work processes.

Advantages: Centralized notifications in the workspace, the ability to discuss in a thread, and integration with other tools.

Webhook for Slack:

 { "channel": "#inventory-alerts", "username": "PriceBot", "icon_emoji": ":chart_with_downwards_trend:", "text": "Sharp price drop!", "attachments": [{ "color": "danger", "fields": [{"title": "Товар", "value": "Gaming Laptop Z15", "short": true},{"title": "Было", "value": "1299€", "short": true},{"title": "Стало", "value": "999€", "short": true},{"title": "Изменение", "value": "-23%", "short": true} ], "actions": [{ "type": "button", "text": "Проверить конкурентов", "url": "https://dashboard.com/competitor-analysis" } ] }] }

Push notifications

Application: mobile applications, web applications with PWA.

Advantages: High visibility, integration with mobile experience, personalization.

Thresholds and Triggers: When Alerts Are Triggered

An effective notification system is based on well-configured triggers:

Triggers for residues

Price triggers

Example of trigger configuration

 { "triggers": [ { "name": "critical_stock", "type": "stock", "condition": "current_stock<= min_threshold", "channels": ["sms", "telegram"], "priority": "critical", "throttle": "15m", "recipients": ["warehouse_manager", "procurement_manager"] }, { "name": "price_drop_anomaly", "type": "price", "condition": "price_change < -15 AND time_window = 1h", "channels": ["telegram", "email"], "priority": "high", "throttle": "1h", "recipients": ["pricing_manager", "ceo"], "auto_actions": ["pause_sync", "create_task"] } ] }

Smart Alerts: Anomalies and Trends

Modern systems go beyond simple thresholds, using machine learning to identify anomalies and predict problems:

Anomaly detection

• Statistical analysis: The system studies historical data and identifies deviations from normal behavior. For example, if a product typically sells 50 units per day, but suddenly the stock drops by 200 units in an hour, that's an anomaly.
• Seasonal adjustment: The algorithm takes seasonal patterns into account, avoiding sending false alerts during expected peaks (holidays, sales)
• Contextual analysis: assessment of changes taking into account external factors (day of the week, weather, marketing activities)

Forecasting shortages

Instead of reacting to a problem that has already arisen, smart alerts warn you about it in advance:

 // Forecast: possible stockout in 3 days { "alert_type": "predictive_stockout", "product": "USB-C Cable 2m", "current_stock": 45, "avg_daily_sales": 15, "forecast":{ "stockout_date": "2025-10-24", "days_until_stockout": 3, "confidence": 0.87 }, "recommendation": "Order 200 units (lead time: 5 days)" }

Identifying price trends

The system analyzes not only absolute values, but also dynamics:

• Steady decline: The price has been falling for 5 days in a row by 2-3% - perhaps a competitor is preparing an aggressive strategy
• Volatility: Frequent price fluctuations indicate instability of the supplier or automation
• Correlation with competitors: synchronous price changes may indicate market trends

Setting up recipients and roles

Properly assigning notifications to roles prevents information overload and ensures a quick response:

Notification Distribution Matrix

Flexible subscription settings

 { "user_id": "manager_001", "name": "Anna Petrova", "role": "pricing_manager", "subscriptions": [ { "trigger_type": "price_change", "categories": ["electronics", "accessories"], "min_change_percent": 10, "channels": ["telegram", "email"], "quiet_hours":{"from": "22:00", "to": "08:00"}, "days": ["mon", "tue", "wed", "thu", "fri"] },{ "trigger_type": "margin_loss", "categories": ["all"], "channels": ["sms", "telegram"], "priority": "critical", "no_quiet_hours": true } ], "digest":{ "enabled": true, "frequency": "daily", "time": "09:00", "channel": "email" } }

Notification escalation

If the issue is not resolved within the specified time, the system automatically escalates the notification:

 // Escalation when ignoring an alert 1. 0 min: Telegram → Warehouse Manager 2. 15 min: SMS + Email → Warehouse Manager + Department Head 3. 30 min: SMS → Commercial Director 4. 60 min: Automatic task creation in CRM

Automatic actions on alerts

In addition to notifications, the system can perform automatic actions to minimize damage:

Automation of reactions to residues

• Automatic order from supplier: When the reorder point is reached, the system creates and sends an order via the supplier's API
• Redistribution between warehouses: Automatic creation of a request to move goods from a surplus warehouse to a shortage warehouse
• Change of status on the site: Automatically change "In stock" to "On order" or hide the product until restocked
• Advertising adjustments: Suspension of advertising campaigns for products with zero balance

Automation of price reactions

• Rollback changes: If a suspicious price is detected (0€ or abnormally high), the system rolls back the change and pauses synchronization.
• Dynamic Pricing: automatic price adjustments in response to competitors' actions (within established rules)
• Sales Block: If the price is below cost, the product is automatically removed from sale
• Creating tasks: Automatic task generation for a manager with a priority and deadline

Example of auto-action configuration

 { "auto_actions": [ { "trigger": "critical_stock", "actions": [{ "type": "create_purchase_order", "supplier_id": "SUP_001", "quantity_formula": "safety_stock * 2 - current_stock", "approval_required": false },{ "type": "update_website_status", "new_status": "out_of_stock", "delay": "24h" },{ "type": "pause_advertising", "platforms": ["google_ads", "facebook_ads"] } ] }, { "trigger": "price_below_cost", "actions": [{ "type": "revert_price_change", "immediate": true },{ "type": "pause_price_sync", "duration": "until_manual_review" },{ "type": "create_urgent_task", "assignee": "pricing_manager", "priority": "critical", "title": "Проверить цену ниже себестоимости" } ] } ] }

Notification templates and sending frequency

Effective templates

A good notice contains all the information necessary to make a decision:

 🔴 CRITICAL REMAINDER Product:{{product_name}} SKU:{{sku}} Current balance:{{current_stock}} pcs. Minimum threshold:{{min_threshold}} pcs. Average sales:{{avg_daily_sales}} pcs/day Deficit forecast:{{stockout_forecast}} days Recommended order:{{recommended_order}} pcs. Supplier:{{supplier_name}} (lead time:{{lead_time}} days) [Create order] [Sales history] [Ignore]

 ⚠️ ANOMALOUS PRICE CHANGE Product:{{product_name}} Category:{{category}} Was:{{old_price}} € Became:{{new_price}} € Change:{{change_percent}} % Time:{{change_time}} Source:{{price_source}} Margin: - Was:{{old_margin}} % - Became:{{new_margin}} % Competitors:{{competitors_prices}} [Undo] [Apply] [Analyze]

Managing the sending frequency

Preventing notification spam is critical to their effectiveness:

Throttling

 { "throttling_rules": [ { "trigger": "low_stock_warning", "max_frequency": "1_per_hour", "per_product": true, "escalation":{ "if_not_resolved_in": "24h", "then_notify": "supervisor", "channel": "sms" } },{ "trigger": "price_change", "max_frequency": "3_per_day", "per_product": true, "batch_similar": true, "batch_window": "15m" } ] }

Grouping notifications

Instead of 50 separate notifications about low balances, there is one consolidated one:

 📊 SUMMARY: Low stock (15 items) Critical (require immediate order): 1. Wireless Mouse Pro - 2 pcs. (min: 10) 2. USB-C Hub 7-port - 0 pcs. (min: 5) 3. HDMI Cable 3m - 1 pc. (min: 15) Warnings (order within 3 days): 4. Laptop Stand Aluminum - 8 pcs. (min: 5) 5. Webcam Full HD - 12 pcs. (min: 10)... 10 more items [Full report] [Create orders]

Quiet Hours

 { "quiet_hours": { "enabled": true, "weekdays":{"from": "20:00", "to": "08:00"}, "weekends":{"from": "18:00", "to": "10:00"}, "exceptions": ["critical", "margin_loss"], "action": "queue_for_morning_digest" } }

Spam and false positive filtering

Setting up filters helps you focus on the alerts that really matter:

Exceptions and whitelists

• Test products: Excluding products tagged "test" from the alert system
• Archived positions: Disabling notifications for discontinued products
• Seasonal products: special rules for goods with low seasonal demand

Smart filtering

 { "filters": [ { "name": "ignore_low_value_items", "condition": "product.price< 5 AND trigger.type = 'low_stock'", "action": "suppress" }, { "name": "ignore_expected_stockout", "condition": "product.status = 'discontinued' OR product.season!= current_season", "action": "suppress" }, { "name": "ignore_minor_price_changes", "condition": "price_change_percent < 3 AND product.category = 'commodities'", "action": "suppress" }, { "name": "combine_similar_alerts", "condition": "COUNT(alerts) > 10 AND time_window = '1h'", "action": "batch_and_summarize" } ] }

Feedback and training

The system is improved based on user actions:

• Mark "Not important": the algorithm remembers patterns of ignored alerts
• Quick response: Alerts that users respond to within 5 minutes are prioritized
• Threshold adjustment: Automatic suggestion to change thresholds based on history

Practical implementation of the notification system

Step 1: Audit of Current Processes

1. Identify critical points that require monitoring
2. Identify typical problems (shortages, pricing errors)
3. Estimate the team's response time to problems
4. Make a list of responsible persons and their areas of control

Step 2: Setting up Basic Triggers

Start with simple but critical rules:

• Zero stock for popular items → SMS to warehouse manager
• Price below cost → SMS to manager + price reduction
• Remainder< минимума → Email менеджеру закупок

Step 3: Selecting and Setting Up Channels

1. Create a Telegram bot for your team
2. Set up a Slack webhook for corporate notifications
3. Integrate an SMS gateway for critical alerts
4. Set up an email service for detailed reports

Step 4: Testing and Optimization

• Run the system in monitoring mode (without automatic actions)
• Analyze the quantity and relevance of notifications
• Adjust thresholds based on real data
• Collect feedback from the team

Step 5: Automate Actions

Once the system has stabilized, add automatic responses for routine scenarios.