Price Change Alerts & Movement Reports

Stay on top of supplier price changes with automatic alerts, margin impact analysis, and historical price tracking.

Overview

When supplier prices change, Stogly automatically:

• Detects significant changes based on your configured threshold
• Calculates margin impact on affected products (including composite products using changed ingredients)
• Suggests new selling prices to maintain your target margins
• Sends notifications via the portal bell icon
• Shows price indicators on the product list

Setting Up Price Alerts

Configure Alert Threshold

1. Navigate to Settings > Organization Settings
2. Click the Price Alerts tab
3. Configure:
   - Enable Price Change Alerts — toggle on/off
   - Alert Threshold (%) — minimum percentage change to trigger alerts (default: 10%)
4. Click Save

For example, with a 10% threshold:

• A price change from 800 to 900 (+12.5%) will trigger an alert
• A price change from 800 to 850 (+6.25%) will not trigger an alert

How Alerts Are Triggered

Price alerts are triggered automatically when prices change via:

• Invoice Match "Update Price" — when you click "Update Price" on a price mismatch in Match Details
• Supplier Price List import — when a CSV import contains changed prices
• Manual price list edit — when you manually update a supplier price list entry

What Happens When an Alert Triggers

1. The system records the price change in the price history
2. It finds all affected products:
   - The directly changed product (if it has a selling price)
   - All composite products whose recipes use the changed ingredient
3. For each affected product, it calculates:
   - Old margin % vs New margin %
   - Suggested new selling price to maintain the original margin
4. A notification is created for all organization admins

Viewing Price Alerts

Notification Bell

The notification bell in the top navigation shows price change alerts:

• Red up arrow — price increased significantly
• Green down arrow — price decreased significantly
• Click a notification to see details
• Click the checkmark icon to mark all as read

Product List Indicators

On the Products page, products with recent significant price changes show a compact badge next to the cost price:

• 🔴 Red badge (e.g., ↑+15%) — cost increased above threshold
• 🟢 Green badge (e.g., ↓-8%) — cost decreased below threshold
• Hover over the badge to see: supplier name, old/new price, and how many days ago

Price Movement Reports

Accessing the Report

1. Navigate to Analytics > Price Movement in the sidebar

Tab 1: Price History

View price changes over time for any product:

1. Select a product from the dropdown
2. A line chart shows the price trend over time
3. Each data point includes the supplier and date

Tab 2: Price Comparison

Compare prices from different suppliers for the same product:

1. Select a product from the dropdown
2. A multi-line chart shows each supplier's price trajectory
3. Easily identify the most competitive supplier over time

Tab 3: Cost Impact Analysis

See how an ingredient's price change affects composite product costs:

1. Select an ingredient product from the dropdown
2. View a table of all composite products using that ingredient:

Tab 4: Margin Erosion Dashboard

Overview of products whose margins have decreased over a selected period:

• Cards sorted by margin delta (worst erosion first)
• Each card shows:

- Product name and SKU

- Earliest vs latest margin percentages

- Cost change percentage

- Current selling price

• Red badges for margin decreases, green for improvements

Example Scenario

1. You receive an invoice from your fish supplier
2. Lignje (squid) price increased from 800 to 920 RSD/kg (+15%)
3. You click "Update Price" on the mismatch row in Match Details
4. The system:
   - Updates the supplier price list: 800 → 920
   - Updates the product cost price: 800 → 920
   - Records the change in price history
   - Detects this exceeds your 10% threshold
   - Finds 3 composite products using Lignje (Lignjun box, Riblja torba, Lignjun tortilla)
   - Calculates that Lignjun box margin dropped from 35% to 28%
   - Suggests increasing Lignjun box selling price from 1130 to 1242 RSD
   - Creates a notification for you

Tips

• Set threshold wisely — too low (e.g., 2%) will create excessive alerts; too high (e.g., 25%) might miss important changes
• Review margin erosion monthly — use the Margin Erosion tab to spot products that need selling price adjustments
• Compare suppliers regularly — use the Price Comparison tab before placing large orders
• Act on alerts — price alerts are only useful if you adjust selling prices accordingly

Need help? Contact support at support@stogly.com