Pre-orders sort themselves into pickup schedules and production totals — even during the busiest week of the year.
Thanksgiving week alone brought in hundreds of pre-orders across every location — pies, cakes, special requests — and sorting them into pickup-day schedules and a single bake list was a multi-day manual job every year, right when there was the least time to spare.
A script takes every pre-order as it comes in, builds a pickup schedule sorted by store and date, and rolls everything up into a single production sheet — so the commissary knows exactly what to bake and when, no matter how far out the order was placed.
| Order # | Store | Item | Qty | Status | |
|---|---|---|---|---|---|
| 1 | 1042 | Hillcrest | Pumpkin Pie, 9" | 2 | Ready |
| 2 | 1043 | Riverside | Apple Pie, 9" | 1 | Pending |
| 3 | 1044 | Downtown | Pumpkin Pie, 9" | 4 | Ready |
| 4 | 1045 | Westgate | Pecan Pie, 9" | 2 | Pending |
| 5 | 1046 | Hillcrest | Dinner Rolls, dozen | 3 | Ready |
Sample pattern, not real data. Orders and store names are illustrative.
A customer submits a holiday order and picks a pickup date and store.
Apps Script logs it and slots it into that store's pickup-day schedule automatically.
Every order across every store rolls into one bake list, sorted by item and date.
Each location gets a day-of pickup list, so nothing's missed at the counter.