A customer ordered a custom frame two weeks ago. You wrote the wood, the mat color, and her name on a sticky note and pressed it to the side of the register. Then a Saturday rush swallowed the morning, the note slid down behind the counter, and the finished frame has been sitting on your back shelf for four days while she wonders whether you forgot her.
That's the quiet cost of running special orders on paper. Nothing dramatic breaks. An order just drifts past its promise date, or sits done while the customer waits, or gets started twice because two of you read the same note and neither crossed it off. You usually find out when someone calls, a little cool in the voice, asking where their thing is.
Here's the good news: you don't need a system with a login for every employee and a monthly bill to match. You need three facts written in one place the whole counter can see, and one text that goes out the second an order is ready. Let's set that up without turning your shop into an IT project.
What every custom order actually needs to carry
Before you pick any tool, get clear on what a special order has to track. It's shorter than you'd think. Most shops get by with six fields.
- Who it's for. A name and a mobile number. The number is the one that makes the "it's ready" text possible, so get it at the counter when you take the order.
- What they ordered. Enough detail that anyone can pick up the job: "walnut frame, cream mat, 16x20" beats "Dana's frame."
- When you promised it. An actual date, not "end of the month." Vague dates are how things slip.
- Where it stands. A simple status: Taken, In progress, Ready, Picked up. Four words tell the whole story at a glance.
- Who's on it. So two people don't start the same bench, and so the right person knows to finish it.
- What they've paid. Deposit down, balance due. You'll thank yourself at pickup.
That's the entire thing. Six columns, one row per order. If a field doesn't earn its place on that list, leave it off.
One shared list instead of ten sticky notes
The fix for buried notes is a single list everyone opens on their phone. A plain shared spreadsheet does this for free. Google Sheets or Airtable both work, and both open in a browser, so nobody installs anything.
Make one row per order and those six columns across the top. Sort it by promise date so the next thing due is always at the top. Color the status cells if you like: red for taken, yellow for in progress, green for ready. Now the whole counter can answer "is Dana's frame done?" in five seconds without digging through the back room.
Be honest with yourself about what this is. It's a spreadsheet, not magic. It only helps if you actually update the status when a job moves, which takes about three seconds and has to become a habit, like wiping down the counter. The payoff is that the shoebox-of-notes problem just goes away, and anyone covering a shift can see exactly what's promised and when.
The "it's ready" text that ends the where-is-it calls
Here's where a little automation earns its keep. When you flip an order's status to Ready, a tool watching that list sends the customer a short text: "Hi Dana, your walnut frame is ready for pickup at the shop whenever you're in. Thanks." No phone call from you, no customer wondering, no finished piece aging on the shelf.
The piece that sends it is a small connector service (Zapier and Make are the common names) that watches your sheet and sends a text through a messaging service like Twilio when a row's status changes to Ready. That's the whole trick: it watches for one change and sends one message. Setup is an afternoon once, and the running cost is usually small, often under $50 a month for a shop doing a handful of orders a week.
Now the honest limits, because they matter. The text only knows what you tell it. You still decide a job is truly done and flip the status yourself; the automation handles the typing, not the judgment, so it will never text someone early unless you mark it ready early. Send the message from your shop's own number if you can, so a reply lands with you and not in a void. And keep the wording human, the way you'd actually say it, because a stiff robotic text makes a warm shop feel like a cable company.
Keep your promise dates honest
A list and a text won't build the bench for you, and they won't make a two-week job take one. The most common way custom orders go wrong isn't tracking, it's a promise date you never had a real shot at. So pad your estimates a touch and say the later date out loud when you take the order. Under-promising and finishing early is its own quiet marketing.
You can also have that same connector send you a nudge, not the customer, the morning an order's promise date lands or the day before. A quick "Dana's frame is due tomorrow" to your own phone catches the ones about to slip while there's still time to either finish them or call with an honest heads-up. A heads-up beats a cool voice at the counter every time.
One more habit worth building: when an order moves to Picked up, leave the row in the sheet instead of deleting it. Over a few months that quietly becomes a record of who ordered what, which is gold the next time that customer comes in or you want to remember what the wedding cake for the Alves party looked like.
Worth doing this week
You don't have to build the whole thing at once. Start with the list and add the text when the list is a habit.
- Make the spreadsheet today. Six columns: customer and number, what they ordered, promise date, status, who's on it, paid. One row per open order you have right now.
- Pin it where the counter lives. Bookmark it on the shop phone or tablet so opening it is one tap, and show whoever else works the counter how to update a status.
- Start collecting mobile numbers on every new custom order. No number, no "it's ready" text, so make it part of taking the order.
- Once the list feels natural, wire up the ready text. A connector service plus a messaging number, sending one message when a status hits Ready.
- Add the private due-date nudge to your own phone last. It's the cheap insurance that catches the orders about to drift past their date.
Set up right, this runs itself in the background and gives you back the mental space you've been spending on "wait, did I ever call that guy?" If wiring up the text and the nudge feels like one project too many on a busy week, that's the kind of small, practical automation we set up for Massachusetts shops all the time, and you can reach us at 617-398-0033.