Special Order Parts Tracker and Pickup Texts

Turns your scribbled special order notes into a clean tracker sorted by what needs action, and writes a short text for each customer who needs to hear from you.

Bike shopRetail✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

ok its Oct 14. shop is Baywick Cycle Works, 7514 Wrenwell Ave, Swanhollow, 402-555-0108, open Tue-Sat 10 to 6. Stanley Bolton, Rohloff Speedhub 500/14, ordered 9/30, total 1150, deposit 200, came in today. Not texted yet. He has the hub install booked Thurs 10/16 at 10am with Steven Campbell, our mechanic. Sylvia Cole, Garbaruk 38t narrow wide chainring, ordered 10/7, paid in full 68, came in 10/10, I texted her 10/10 no answer. Stephanie Brooks, Paul Components Klamper brake caliper pair, ordered 10/2, total 240, deposit 50, still waiting. Supplier said it should ship 10/18. Send her an update. Susan Chapman, tubeless valve stem set, picked up 10/13 all paid.

AFTER · what the skill produced

Special order tracker, Oct 14

| Customer | Part | Ordered | Total | Deposit | Balance | Status |
|---|---|---|---|---|---|---|
| Stanley Bolton | Rohloff Speedhub 500/14 | 9/30 | $1,150 | $200 | $950 | Arrived, needs a text |
| Sylvia Cole | Garbaruk 38t narrow wide chainring | 10/7 | $68 | $68 | $0 | Arrived 10/10, texted, no pickup yet |
| Stephanie Brooks | Paul Components Klamper brake caliper pair | 10/2 | $240 | $50 | $190 | Waiting on supplier |
| Susan Chapman | Tubeless valve stem set | Not given | Not given | Not given | $0 | Picked up 10/13 |

Texts

Stanley Bolton (arrived, needs a text):
"Hi Stanley, this is Baywick Cycle Works. Your Rohloff Speedhub 500/14 is in. The balance at pickup is $950. Your hub install is booked Thursday 10/16 at 10am with Steven Campbell. We are open Tue-Sat 10 to 6. Questions? Call 402-555-0108."

Sylvia Cole (reminder):
"Hi Sylvia, Baywick Cycle Works here. Just a reminder that your Garbaruk 38t narrow wide chainring arrived on 10/10. It is paid in full. We are open Tue-Sat 10 to 6 at 7514 Wrenwell Ave. Call us at 402-555-0108 with any questions."

Stephanie Brooks (update, still waiting):
"Hi Stephanie, Baywick Cycle Works here. An update on your Paul Components Klamper brake caliper pair. The supplier told us it should ship 10/18. We will text you as soon as it arrives. Questions? Call 402-555-0108."

Susan Chapman: closed, no text needed.

Counts: 4 orders. 1 needs a text, 1 needs a reminder, 1 waiting on supplier, 1 picked up.

Questions for the owner

How long do you hold special orders after they arrive? I left it out of the texts.
What were the date ordered and the price for Susan Chapman's valve stem set? I left them blank in the tracker.

What it does

Turns your scribbled special order notes into a clean tracker sorted by what needs action, and writes a short text for each customer who needs to hear from you. It handles parts that arrived, parts still on the way, and orders that were picked up.

Use it when: Use when a bike shop needs to track special order parts and text customers when their order arrives, such as: 'update my special orders list,' 'text customers their parts are in,' 'who is still waiting on parts,' or 'order tracker.'