SLA for orders

We should be able to input a time, like 2:00 PM, and flag orders that haven't been actioned. These orders should be filtered into their own queue to highlight which ones need attention to meet deadlines. We should also be able to set SLAs for each customer and overall. Maybe we could have a feature where orders are highlighted in the system. For example, in the dispatch-ready queue, orders before the SLA could appear in a different colour. Orders before 2:00 PM could show as red, and those after as green. The system would update the colours daily, turning green orders to red if they're before the SLA deadline for that day. This would help easily identify which orders need attention each day. Feature Goals: Order SLA Tracking & Prioritization System To ensure all orders are processed before their SLA deadlines by providing a clear, visual, and automated prioritization system that updates dynamically based on the time of day. Goals & Outcomes Prioritize Orders to Meet Deadlines Efficiently Orders should be flagged and highlighted if they are close to missing their SLA deadlines. Orders past the SLA should be visually distinct for quick identification. Automate SLA-Based Color Coding Orders in the dispatch-ready queue should automatically change color based on their deadline status: Red: Orders before 2:00 PM (or the SLA cutoff) that still need attention. Green: Orders past the SLA cutoff, indicating lower urgency. Red Update: Green orders should turn red if they are still pending before their SLA deadline. Provide a Dedicated Queue for Late Orders Any order that misses the SLA deadline should move into a high-priority "Late Orders" queue for urgent action. This queue ensures that missed orders are not overlooked. Allow SLA Customization Per Customer & Globally Each customer should have a configurable SLA that determines their order processing deadline. There should also be an overall SLA setting that applies by default to all orders. SLA thresholds should be adjustable (e.g., 2:00 PM default, but some clients might have 12:00 PM or 3:00 PM cutoffs). Daily Automated Updates Orders should be evaluated and updated every day so that new orders start in the correct status. The system should automatically adjust colors at the end of the SLA period to reflect real-time urgency. Improve Order Management & Reduce Manual Checking Warehouse staff and dispatch teams should quickly identify priority orders without manually checking timestamps. Managers should be able to filter and sort orders based on SLA urgency and lateness. Future Expansion Possibilities Alerts & Notifications: Notify the dispatch team via Google Chat, Slack, or email when an order nears SLA. Dashboard Reports: Track how many orders met/missed their SLAs over time for performance monitoring. End Result: A visual and automated order tracking system that helps fulfillment teams: ✅ Identify urgent orders at a glance. ✅ Meet SLAs without manual tracking. ✅ Ensure no orders slip through the cracks. ✅ Customize SLA rules per client and overall. ✅ Improve efficiency and deadline adherence.