Pre-order list in Excel: answer pickup calls from it

July 29, 2026 · PhoneMyAgent Team

Bakeries, butchers, delis and caterers keep the same file: a pre-order list in Excel with a row per customer order and a pickup time. It answers almost every call you get, and an AI phone agent can read it out. The caller quotes their order number or name and hears when their order is ready and what is in it. Nobody has to come off the counter with flour on their hands, and the calls that do need you, a change to an order, a special request, still reach you as a message.

Fifty calls on the busiest week of the year

Pre-orders concentrate. A normal Tuesday is quiet, and then Christmas, Easter, a long weekend or a big catering week arrives and the same list produces dozens of calls a day, all of them variations of one question: is mine ready, and when can I collect it.

The counter is full at exactly the same time. So the phone rings while three people are waiting to be served, and whoever picks it up is doing two jobs badly. The order list is right there on the laptop in the back, complete and correct, and completely out of reach.

The calls are not complicated. They are repetitive, they cluster in the worst hour, and the answer is one row.

What the list needs before it goes on the phone

A pre-order list usually needs less tidying than people expect. What matters:

  • A reference customers can quote. An order number is ideal. Where you only have names, the agent can work with a name, but names collide, so a sheet with nothing else is the one case where the lookup has to refuse more often than you would like.
  • A pickup time or date column. This is the answer most callers want, and where it exists, lookups come back with the nearest first.
  • A clear status. Taken, in production, ready for collection. Shorthand you wrote for yourself does not translate on the phone.
  • A phone column, if you have it. Then a regular ringing from their own number is recognised without quoting anything.

Columns you do not map, your cost, a supplier note, a discount you gave, are stored but never spoken.

Setting it up in the quiet week, not the busy one

With PhoneMyAgent you upload the list (.xlsx, .csv or .json) on the Data page. The import asks which column callers give and what the agent should say back, in a sentence you approve: "Order 217, two trays of Vanillekipferl, ready for collection Friday from 8am." Then you point a number at it, one from us or your existing line forwarded to it, so customers keep dialling the number on your window. The 45 free minutes with no card cover a real test with a real list.

On the call the agent looks up exactly the reference given, reads back only what your sentence allows, and takes a message if nothing matches. It will not guess: a near match is somebody else's order, and on a holiday list with forty similar orders that matters more than usual. Where a customer has several orders open, it reads the five most recent and says there are more.

The practical rhythm is a re-upload when the list changes, or editing single rows in the dashboard as orders come in and go out. There is no live sync, which for a list that is finalised the evening before a busy day is the natural fit: you upload the version you have checked.

Voicemail Someone leaves the counter A note on the door Your order list on the phone
Customer gets an answer Never on the call Yes, slowly Generic only On the first ring
Cost to the queue at the counter None A served customer None None
Works at 7pm the night before Message only No Yes Yes
Says their own pickup time No Yes No Yes, exact match only
Setup None None None Minutes, from the list you keep

What it will and won't do

It reads back what the row says, takes messages, books collection slots when you allow booking, and transfers on request. It will not take a change to an order into your spreadsheet, will not invent a pickup time, will not guess between two similar orders, and does not give regulated advice or handle emergencies. Callers hear at the start that they are speaking with an AI assistant.

Allergens are worth a deliberate decision. If the information is in the row and you approved the sentence that says it, the agent reads exactly that and nothing more. Anything beyond what is written, a substitution, a "would that be safe for", is a question for a person, and the agent should be set to take a message or transfer rather than answer it.

Restaurants whose calls are mostly reservations rather than pre-orders will find the restaurant walkthrough closer to the mark, and the general order-tracking version of this article is order tracking in Excel.

Frequently asked questions

Can an AI phone agent answer pre-order pickup calls from an Excel list?

Yes. You import the pre-order list, choose the column customers quote, and approve the sentence the agent says back. On a call it looks up that exact order and reads the pickup time and contents, or takes a message when nothing matches.

What if customers only give their name?

The agent can look up by name where that is the only key in your sheet, but names are the weakest reference: when two rows share a name, nothing is read out and it asks for something else or takes a message. Adding an order number column to the list is the single biggest improvement you can make before importing.

We finalise the list the night before. Does that work?

That is the ideal case. You upload the version you have checked, and the agent answers from exactly that. There is no live sync, so nothing reaches a caller that you did not upload, and small changes on the day can be typed into the dashboard row by row.

Can it take a new pre-order over the phone?

It can take a message with all the details, and it can book when you switch booking on, but a new order is not written back into your Excel list. Nothing writes back into the imported sheet; you get the after-call email with what was said and add it to the list yourself.

Can it tell a customer about allergens?

Only what is written in the row and covered by the sentence you approved. It does not reason about ingredients, substitutions or whether something is safe for a particular person, and those calls should be set to reach you as a message or a transfer.

Is this worth it for a small bakery?

The value is not in the number of calls but in when they happen. Ten calls spread over the two busiest hours of your week each cost you a customer at the counter, and those are exactly the calls this answers. Outside the peak it costs you nothing to leave running.

Never miss another call

An AI agent answers your business phone, knows your documents, and emails you what happened after every call. 45 free minutes to try, no card required.

Try PhoneMyAgent free

← All posts