Special Order Tracker with Customer Pickup Notices
Turns your messy special order notes into a clean tracker and writes a ready-to-send message for each customer, whether their order has arrived, is delayed, or has been waiting for pickup.
Before and after
Summary: 5 special orders. 2 arrived and ready for a pickup notice, 1 waiting for pickup and past the hold window, 1 still on order, 1 delayed.
Arrived, ready for pickup notice
- Regina Blanco: 2 sets hammered copper drawer pulls, 5 inch. Ordered Feb 24 (16 days ago), arrived Mar 10. Total $86.40, deposit $20.00, balance due $66.40.
- Rodney Foley: cast aluminum mailbox post, Dutch style. Ordered Mar 5 (7 days ago), arrived Mar 11. Total $112.00, no deposit, balance due $112.00.
Waiting for pickup
- Rita Corbin: amber glass globe for a barn style pendant. Arrived Feb 20, customer notified Feb 21 (19 days ago). Paid in full, $29.75, balance due $0.00. Past the 14 day hold window, which ended Mar 7.
Still on order
- Richard Chandler: reversible gate latch, black. Ordered Mar 3 (9 days ago). Supplier estimate Mar 17. Total $38.50, no deposit, balance due $38.50 on arrival.
Delayed
- Robin Edwards: 3 inch brushed pewter hinge set, quantity 8. Ordered Feb 28 (12 days ago). Supplier's date moved from Mar 10 to Mar 24. Total $54.20, deposit $15.00, balance due $39.20.
Pickup notice for Regina Blanco
Hi Regina, this is Rushwell Hardware. Your 2 sets of hammered copper drawer pulls (5 inch) have arrived. The balance due at pickup is $66.40, after your $20.00 deposit. We will hold them for you through Mar 26. You can find us at 4482 Reedwell St, Robinhollow, call 402-555-0100, or text 402-555-0101 with any questions.
Pickup notice for Rodney Foley
Hi Rodney, this is Rushwell Hardware. Your cast aluminum Dutch style mailbox post has arrived. The balance due at pickup is $112.00. We will hold it for you through Mar 26. You can find us at 4482 Reedwell St, Robinhollow, call 402-555-0100, or text 402-555-0101 with any questions.
Reminder for Rita Corbin
Hi Rita, this is Rushwell Hardware. Your amber glass globe for the barn style pendant has been here since Feb 20, and it is paid in full, so there is nothing more to pay. Our hold policy is 14 days after we notify you, and that date was Mar 7. Please call us at 402-555-0100 or text 402-555-0101 so we can arrange a pickup time with you.
Update for Robin Edwards
Hi Robin, this is Rushwell Hardware. We have an update on your 3 inch brushed pewter hinge set (quantity 8). The supplier now estimates it will arrive Mar 24, later than the Mar 10 date we first had. This is the supplier's estimate, not a promise. Your balance of $39.20 is due at pickup. Call 402-555-0100 or text 402-555-0101 with any questions.
Questions for the owner
- What are your store hours? They are not in the notices yet.
- How do you want to reach each customer (call, text, or email)? No contact method was given.
- What would you like to do with Rita Corbin's order, since it is past your hold window? We have only written a reminder, and nothing has been cancelled or changed.
- Does Richard Chandler need a notice now, or only once his latch arrives?
What it does
Turns your messy special order notes into a clean tracker and writes a ready-to-send message for each customer, whether their order has arrived, is delayed, or has been waiting for pickup.
Use it when: Use when a hardware store owner or counter staff needs to track special orders and write customer pickup notices, such as "what special orders are in," "write pickup notices," "who hasn't picked up," or "update the special order list."