Expiry date tracking and notifications for suppressed SKUs

Purpose

1.1. Automatically monitor inventory for SKUs marked as ‘suppressed’ due to expiry or regulatory status.
1.2. Alert relevant stakeholders (procurement, sales, warehouse) ahead of expiry and after, ensuring timely removal or action on suppressed SKUs.
1.3. Eliminate manual SKU expiry checks, reduce compliance risk, prevent unintentional sales of expired goods.

Trigger Conditions

2.1. SKU status set to ‘suppressed’ in inventory database.
2.2. Approaching preset expiry threshold (e.g., 30, 15, 7, 1 days before expiry).
2.3. New SKU added with expiry flag enabled.
2.4. Manual override or admin update on SKU status.
2.5. Change in compliance rules detected in external database.

Platform Variants

3.1. Microsoft Power Automate
• Trigger: “When an item is modified” on SharePoint or Dataverse; Action: Send email/Teams notification.
3.2. Zapier
• Trigger: New/updated row in Google Sheets/Airtable; Action: Email, Slack, or SMS alert.
3.3. Integromat (Make)
• Scenario: Watch records in inventory app; Action: Aggregate, filter expiring SKUs, notify.
3.4. Salesforce
• Feature: Process Builder with custom object trigger; Action: Automated Chatter alert or email.
3.5. Oracle NetSuite
• Workflow: Saved search for expiring SKUs; Scheduled alert via email notification.
3.6. Shopify
• API: Webhook on product variant update; Custom app notification to admin dashboard.
3.7. Google Apps Script
• Trigger: Time-driven; Script scans sheet for expiry; Sends Gmail notifications.
3.8. Slack API
• Function: Incoming Webhooks; Post message to #inventory channel on suppression.
3.9. Twilio
• Function: SMS API; Send text alert to warehouse or procurement on expiring SKUs.
3.10. SendGrid
• Feature: Email API v3; Automated detailed alert to procurement group.
3.11. AWS Lambda
• Trigger: Scheduled event; Function scans DynamoDB or S3 for suppressed/expiring items and invokes SES for notifications.
3.12. Google Cloud Functions
• Trigger: Pub/Sub on inventory update; Check expiry, send email via Gmail or SMS via Twilio.
3.13. Airtable
• Automation: When expiry date is near, send Slack or email using Airtable Automations.
3.14. Monday.com
• Automation: Set deadline notification for item expiry, ping user group in platform.
3.15. HubSpot
• Workflow: Deal property trigger on ‘expiry date’; Automated alert/email task.
3.16. Trello
• Butler Automation: Due date command; Send card alert to board for suppressed SKU actions.
3.17. Zoho Creator
• Workflow: Scheduled script scans product expiry fields, sends notification to predefined email/SMS group.
3.18. Freshdesk
• Automations: Ticket or alert creation when expiry close, auto-assign to inventory manager.
3.19. Pipedrive
• Workflow Automation: Sends task/reminder when inventory item expiry nears.
3.20. Notion
• Automation: Linked with third-party service to trigger alert on expiry date property per database entry.
3.21. Asana
• Rule: “Due Date Approaching”; Auto-create task for staff action on suppressed SKU expiry.

Benefits

4.1. Ensures compliance by regularly tracking and alerting on expiry of restricted products.
4.2. Lowers risk of regulatory penalties or customer mishandling.
4.3. Saves manual labor, enables proactive SKU management, and keeps all departments informed.
4.4. Facilitates cleaner audit trails and operational accountability.