Pending List Email — Dry-Run Test
Temporary page. Remove after mail is working.
Diagnostics
Schema ready: yes
Automation enabled: yes
Status filter: Pending
Departments: 7 configured
Workday today: yes
Already sent today: yes
Skip reason if run now: already_sent_today
Qualifying orders: 89
Last recorded run: 07/21/26 @ 12:12 AM (2026-07-21) — 91 orders, 13 recipients
Test actions
Primary test: open Tracking List or Create Schedule in a new tab (normal GET page load). The banner at the top shows dry-run / skip / error results from the real trigger. Use buttons below only for diagnostics or to clear today's daily run row.
Qualifying orders (89)
| Order # | Department | Finish date | Salesperson | Sold |
|---|---|---|---|---|
| 274852 | Upholstery | 2026-03-02 | 07/01/26 | |
| 278803 | Upholstery | 2026-05-04 | 07/01/26 | |
| 20322 | Custom Covers | 2026-05-13 | 05/11/26 | |
| 279856 | Wakeshade | 2026-05-13 | Emily Hofer | 05/11/26 |
| 279893 | Snow Shields | 2026-05-14 | Emily Hofer | 05/12/26 |
| 279906 | Wakeshade | 2026-05-14 | Emily Hofer | 05/12/26 |
| 279910 | Wakeshade | 2026-05-14 | Inside Sales Assistant | 05/12/26 |
| 280205 | Snow Shields | 2026-06-03 | Emily Hofer | 06/01/26 |
| 280442 | Boat Covers | 2026-06-19 | Courtney McBride | 06/17/26 |
| 280542 | Snow Shields | 2026-06-24 | Courtney McBride | 06/22/26 |
| 278971 | Awnings | 2026-07-06 | Project Coordination Team | 07/01/26 |
| 280740 | Snow Shields | 2026-07-07 | Tina Swalm | 07/02/26 |
| 20350 | Custom Covers | 2026-07-08 | 07/06/26 | |
| 279054 | Awnings | 2026-07-08 | Project Coordination Team | 07/06/26 |
| 280625 | Repairs | 2026-07-08 | Elise Tucker | 07/06/26 |
| 280748 | Repairs | 2026-07-08 | Nathan Price | 07/06/26 |
| 280751 | Repairs | 2026-07-08 | Nathan Price | 07/06/26 |
| 280757 | Repairs | 2026-07-08 | Elise Tucker | 07/06/26 |
| 280758 | Repairs | 2026-07-08 | Tanner Peterson | 07/06/26 |
| 280762 | Custom Covers | 2026-07-08 | Elise Tucker | 07/06/26 |
| 280767 | Repairs | 2026-07-08 | Tanner Peterson | 07/06/26 |
| 20351 | Custom Covers | 2026-07-09 | 07/07/26 | |
| 280772 | Repairs | 2026-07-09 | Tanner Peterson | 07/07/26 |
| 280778 | Repairs | 2026-07-09 | Elise Tucker | 07/07/26 |
| 280780 | Repairs | 2026-07-09 | Nathan Price | 07/07/26 |
| 280781 | Repairs | 2026-07-09 | Tanner Peterson | 07/07/26 |
| 280790 | Boat Covers | 2026-07-09 | Nathan Price | 07/07/26 |
| 280794 | Repairs | 2026-07-09 | Tanner Peterson | 07/07/26 |
| 280783 | Snow Shields | 2026-07-10 | Fred Weindorf | 07/08/26 |
| 280809 | Repairs | 2026-07-10 | Nathan Price | 07/08/26 |
| 280810 | Repairs | 2026-07-10 | Tanner Peterson | 07/08/26 |
| 280813 | Repairs | 2026-07-10 | Nathan Price | 07/08/26 |
| 280510 | Upholstery | 2026-07-14 | Elise Tucker | 07/13/26 |
| 280582 | Repairs | 2026-07-14 | Tanner Peterson | 07/10/26 |
| 280856 | Boat Covers | 2026-07-14 | Elise Tucker | 07/10/26 |
| 280857 | Repairs | 2026-07-14 | Tanner Peterson | 07/10/26 |
| 280869 | Repairs | 2026-07-14 | Tanner Peterson | 07/10/26 |
| 280871 | Repairs | 2026-07-14 | Tanner Peterson | 07/10/26 |
| 280873 | Upholstery | 2026-07-14 | Tanner Peterson | 07/11/26 |
| 280890 | Repairs | 2026-07-15 | Tanner Peterson | 07/13/26 |
| 280894 | Boat Covers | 2026-07-15 | Tanner Peterson | 07/13/26 |
| 280899 | Boat Covers | 2026-07-15 | Tanner Peterson | 07/13/26 |
| 280074 | Upholstery | 2026-07-16 | Tanner Peterson | 05/22/26 |
| 280227 | Boat Covers | 2026-07-16 | Tanner Peterson | 06/02/26 |
| 280555 | Boat Covers | 2026-07-16 | Courtney McBride | 06/23/26 |
| 280651 | Upholstery | 2026-07-16 | Nathan Price | 07/08/26 |
| 280793 | Boat Covers | 2026-07-16 | Nathan Price | 07/07/26 |
| 280906 | Custom Covers | 2026-07-16 | Nathan Price | 07/14/26 |
| 280909 | Repairs | 2026-07-16 | Tanner Peterson | 07/14/26 |
| 280916 | Boat Covers | 2026-07-16 | Nathan Price | 07/14/26 |
| 280925 | Repairs | 2026-07-16 | Nathan Price | 07/14/26 |
| 279820 | Awnings | 2026-07-17 | Dave Wallace | 06/29/26 |
| 279848 | Awnings | 2026-07-17 | Dave Wallace | 07/15/26 |
| 279879 | Repairs | 2026-07-17 | Project Coordination Team | 07/15/26 |
| 280136 | Awnings | 2026-07-17 | Blake Bennett | 06/24/26 |
| 280155 | Awnings | 2026-07-17 | Project Coordination Team | 07/15/26 |
| 280369 | Awnings | 2026-07-17 | Blake Bennett | 06/16/26 |
| 280554 | Boat Covers | 2026-07-17 | Elise Tucker | 06/23/26 |
| 280659 | Boat Covers | 2026-07-17 | Courtney McBride | 06/29/26 |
| 280736 | Awnings | 2026-07-17 | Project Coordination Team | 07/15/26 |
| 280744 | Awnings | 2026-07-17 | Blake Bennett | 07/15/26 |
| 280776 | Awnings | 2026-07-17 | Dave Wallace | 07/15/26 |
| 280801 | Awnings | 2026-07-17 | Dave Wallace | 07/15/26 |
| 280861 | Awnings | 2026-07-17 | Project Coordination Team | 07/15/26 |
| 280927 | Boat Covers | 2026-07-17 | Tanner Peterson | 07/15/26 |
| 280928 | Repairs | 2026-07-17 | Nathan Price | 07/15/26 |
| 280929 | Upholstery | 2026-07-17 | Courtney McBride | 07/15/26 |
| 280936 | Repairs | 2026-07-17 | Nathan Price | 07/15/26 |
| 280937 | Custom Covers | 2026-07-17 | Courtney McBride | 07/15/26 |
| 280938 | Boat Covers | 2026-07-17 | Tanner Peterson | 07/15/26 |
| 280940 | Custom Covers | 2026-07-17 | Nathan Price | 07/15/26 |
| 280943 | Repairs | 2026-07-17 | Courtney McBride | 07/15/26 |
| 280948 | Boat Covers | 2026-07-17 | Courtney McBride | 07/15/26 |
| 280562 | Repairs | 2026-07-20 | Nathan Price | 07/16/26 |
| 280577 | Boat Covers | 2026-07-20 | Courtney McBride | 06/24/26 |
| 280641 | Awnings | 2026-07-20 | Blake Bennett | 07/17/26 |
| 280689 | Awnings | 2026-07-20 | Project Coordination Team | 07/07/26 |
| 280754 | Boat Covers | 2026-07-20 | Nathan Price | 07/06/26 |
| 280798 | Awnings | 2026-07-20 | Nathan Price | 07/16/26 |
| 280815 | Repairs | 2026-07-20 | Elise Tucker | 07/08/26 |
| 280824 | Upholstery | 2026-07-20 | Nathan Price | 07/16/26 |
| 280866 | Awnings | 2026-07-20 | Blake Bennett | 07/17/26 |
| 280875 | Repairs | 2026-07-20 | Courtney McBride | 07/16/26 |
| 280903 | Awnings | 2026-07-20 | Dave Wallace | 07/15/26 |
| 280915 | Boat Covers | 2026-07-20 | Nathan Price | 07/14/26 |
| 280921 | Boat Covers | 2026-07-20 | Courtney McBride | 07/16/26 |
| 280935 | Awnings | 2026-07-20 | Dave Wallace | 07/16/26 |
| 280956 | Boat Covers | 2026-07-20 | Tanner Peterson | 07/16/26 |
| 280958 | Repairs | 2026-07-20 | Tanner Peterson | 07/16/26 |
Log tail (pending_list_email.log)
{"ts":"2026-07-21 12:58:29","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:34","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:39","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:40","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:42","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:42","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:43","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:43","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 12:58:44","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:01:37","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:01:38","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:01:38","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:01:39","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:01:45","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:02:34","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:02:35","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:02:36","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:02:37","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:02:53","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}
{"ts":"2026-07-21 13:44:34","ok":true,"sent":false,"skipped":true,"reason":"already_sent_today","order_count":0,"error":null,"trigger":"page_load"}