Obsolete stock notification and clearance workflows

Purpose

1.1. Identify and flag obsolete alternator stock based on age, movement rate, or demand forecasts.
1.2. Initiate automated notifications and clearance processes to expedite the sale or disposal of such inventory.
1.3. Ensure synchronized stock status with sales platforms and accounting.
1.4. Minimize financial loss by prompt decision-makings for underperforming SKUs.

Trigger Conditions

2.1. Stock item remains unsold for >X months (configurable threshold).
2.2. Movement rate falls below Y units/month.
2.3. Item flagged as discontinued or supplier feedback indicates obsolescence.
2.4. Regular scheduled inventory review (e.g., weekly cron job or scheduled function).
2.5. Manual override or tagging by warehouse manager.

Platform Variants

3.1. Twilio SMS
- Feature: API-triggered outbound message
- Config: POST /Messages with manager's mobile, item SKU, link to clearance action portal
3.2. SendGrid
- Feature: Automated transactional email
- Config: POST /mail/send with dynamic sections for SKU, stock age, price reduction
3.3. Slack
- Feature: Channel alert on obsolete items
- Config: chat.postMessage webhook to #inventory-ops with actionable button
3.4. Microsoft Power Automate
- Feature: Scheduled inventory audits and Teams notification
- Config: Recurrence trigger, "Get Items" from SharePoint, send adaptive card to Teams
3.5. Google Sheets
- Feature: Conditional formatting, notification via Apps Script
- Config: OnEdit trigger, sendEmail on obsolescence condition
3.6. Shopify
- Feature: Marking product “clearance” via Product Update API
- Config: PUT /admin/api/2021-10/products/{id}.json { "tags": ["Obsolete"] }
3.7. Salesforce
- Feature: Task record for sales rep follow-up
- Config: REST API createTask, subject: "Clearance required", related SKU
3.8. HubSpot
- Feature: Automated workflow to move obsolete SKU to special deal pipeline
- Config: Trigger: Custom property, Action: Create deal in "Obsolete Stock" pipeline
3.9. Zapier
- Feature: Multi-platform action chains
- Config: Trigger: Google Sheet row meets criteria, Actions: Email + Slack + Shopify
3.10. Mailgun
- Feature: Automated clearance campaign emails
- Config: POST /messages, list: dealer bulk, message: items flagged
3.11. WooCommerce
- Feature: Product status update, initiate sale event
- Config: PUT /wp-json/wc/v3/products/{id}, set status “clearance”
3.12. NetSuite
- Feature: Saved Search for obsolete items, workflow trigger
- Config: Schedule Saved Search, workflow to update item status/notification
3.13. Odoo
- Feature: Automated procurement/inventory rule
- Config: Reordering Rules, automated movement to “clearance” location
3.14. Trello
- Feature: Auto-create cards for warehouse action
- Config: POST /1/cards, list: “Clearance Required”, desc: SKU details
3.15. QuickBooks Online
- Feature: Automated write-offs or adjustments
- Config: POST /v3/company/inventoryadjustment, obsolete flag
3.16. Airtable
- Feature: Automation on stock age field
- Config: Automation to send email/change record color
3.17. SAP Business One
- Feature: Alert management system – obsolete material alert
- Config: Alert setup, user-defined query on last sale date
3.18. Monday.com
- Feature: Board automation, status change triggers email
- Config: When “stock status” set to “obsolete”, send notification
3.19. Magento
- Feature: Mark products as clearance via API
- Config: PUT /V1/products, set custom_attribute[clearance]=true
3.20. Oracle Fusion
- Feature: Automated workflow for inventory management
- Config: ORCL BPM workflow on item attribute change, notification to procurement

Benefits

4.1. Prevents working capital from being locked in unsellable stock.
4.2. Accelerates clearance actions and minimizes storage costs.
4.3. Reduces manual oversight and human error in obsolete stock handling.
4.4. Provides real-time, multi-channel notifications for prompt action.
4.5. Ensures all business systems and teams are instantly aligned on stock status changes.