Is your Inventory riddled with stockouts and causing potential revenue loss? Set up alerts to get notified when your items/SKUs reach reorder points or stock out.
Problem | Alert | Action | Impact |
Reorder Point | Inventory Managers or Merchants get an Alert when an SKU has breached its Reorder Point. | The Inventory Manager (or) Seller/Merchant can reorder the SKUs according to Projected demand. | Improves the product's availability and reduces lost business opportunities due to stockouts. |
Stockouts | Sellers/Managers get alerted when a product/SKU is facing an OOS or Stockout event. | Delist the Product (or) show stockout messages with replenishment dates to customers. Replenish the stockout Products/ SKUs. | Increased transparency by providing back-in-stock dates improves User reactivation/retention and decreases loss in revenue. |
Step-by-step guide:
Step 1: Choose an Alert type
Choose the SQL List based alert to trigger an alert to the Inventory Manager when any SKU reaches its reorder point.
Step 2: Write an SQL query to fetch a value
Sample Query: to fetch all the items which are OOS or have reached their re-order point.
SELECT items.id, items.name, items.quantity, items.reorder_quantity
FROM items
WHERE (items.quantity < items.reorder_point) OR (items.quantity = 0)
Step 3: Configure Alert Condition
Alert Frequency: 1 Hr
Unique value column: item_id
Step 4: Configure Team and Assignees
Team is responsible for this alert (optional) - Inventory Management
Person assigned to the incidents (optional) - Category Manager
Step 5: Configure Alert and Incident Details
Alert name: Item Stockouts
Configure Incident Tile: Item# {{items_id}} is stocked out. Please re-order it.
Default Incident Priority: High
Step 6: Setup Notifications
Channel: email
Escalation:
Duration: 1 Day
Member: Management
Channel: email: [email protected]
Blazing-fast operations minus all the constant firefighting👨🚒Learn how to set up a control tower for your operations in under 15 minutes ️🔥
...with Locale for modern ops teams |