Site & Stack Start a project
Start a project
All articles

Special order tracking for showrooms, deposits included

Special order tracking for showrooms: one record per order with the item, supplier, deposit, promised date and every customer update, so nothing goes missing.

Why special orders go missing on paper

A special order is an item you don’t keep in stock, ordered from a supplier for one customer. Think of a sofa in a chosen fabric, a light fixture in a certain finish, or tile for one kitchen. The customer usually pays a deposit today and the rest when it arrives. Weeks or months can pass in between.

On paper, that order lives in pieces. The signed slip sits in a binder, the supplier order in someone’s email, and the deposit in the till report. The promised date lives in the salesperson’s head. Each piece can be right and the order can still go wrong.

For example, a furniture showroom with three salespeople takes a deposit on a sectional in a custom fabric. The supplier moves the ship date back three weeks by email, and the message lands with someone on vacation. The customer calls the week they were promised delivery. Nobody can say where the sofa is, or how much is still owed.

Special orders tend to go wrong in the same few places:

  • The order never went to the supplier, or it sat for a week before anyone placed it.
  • The supplier’s confirmation didn’t match the order: a wrong fabric code, finish or size.
  • The supplier’s date moved, and the customer heard about it last.
  • The item arrived and sat in the back because nobody told the customer.
  • Nobody could say what the customer paid, how they paid, or what’s still owed.

How to track special orders: one record per order

The fix is simple to describe: one record per special order. It starts the moment the customer signs and closes when the item is delivered and paid for. Everyone works from the same record, whether it lives in a binder, a spreadsheet or software.

One order can hold several items from different suppliers. A living room set might come from two factories on two dates. Track each item on its own line, so a sofa that arrived doesn’t hide a chair that didn’t.

For each order, the record should hold:

  • The customer: name, phone, email, delivery address and how they like to hear from you.
  • The exact item: supplier, model or SKU, every option (fabric, finish, size, grade), quantity, and a photo or spec sheet.
  • The money: price, tax, delivery fee, each deposit with its date and payment method, and the balance due.
  • The supplier order: the date you placed it, your purchase order number and the supplier’s confirmation number.
  • The shipment: the carrier or freight company and its tracking number once the supplier ships.
  • The dates: the supplier’s confirmed ship date, the date you promised the customer, and any new date after a delay.
  • The status, with who changed it and when.
  • Every update to the customer: the date, what you told them and how you sent it.
  • The terms the customer signed: the deposit, cancellation, and how long you’ll hold an item once it arrives.

Statuses, and a weekly check of every open order

A status tells anyone on staff where an order stands without reading its whole history. Keep the list short and use the same words every time. For a showroom, seven cover most orders: Signed (deposit taken), Ordered, Confirmed, Delayed, Arrived, Delivered and Canceled.

Each change should carry a date and a name. When a customer calls, the status and the last update answer most questions on their own. Treat Arrived as checked, not just unloaded: no damage, and the right fabric, finish and size. If it fails that check, set the order back to Delayed, note the supplier or freight claim, and tell the customer.

Statuses also turn the weekly check into a quick sort instead of a read through the binder. Once a week, sort open orders by status and date, and look for:

  • Signed, but not yet placed with the supplier.
  • Ordered, but the supplier hasn’t confirmed the details or a date.
  • Confirmed, but the supplier’s details don’t match the customer’s order line by line.
  • Past the expected date, with no new date from the supplier.
  • Delayed, and the customer hasn’t heard the new date.
  • Arrived, but the customer hasn’t been told, or the item has sat past your hold period.
  • Canceled, with a refund not yet sent.
  • Open deposits: the total on your list should match what your books say you’re holding.

Special order deposits: what to record and put on the order form

There is no standard deposit for a special order. A sensible way to set one is to cover what you can’t get back if the customer walks away. That can mean freight, a supplier’s cancellation fee, or a made-to-order piece the supplier won’t take back. Ask each supplier what canceling costs you, and set your deposit with that in mind.

Record every payment against the order itself, not only in the till. A till report shows that $800 came in on a Tuesday. The order record shows it was the deposit on order 1042, a sectional, paid by card, with $1,450 still due. Those numbers are an example, not a suggested deposit.

Ask your accountant how deposits go in your books. The IRS says you generally report an advance payment for goods as income in the year you receive it. With an accrual method, you may be able to elect to put off the part you haven’t earned yet until the next year, but no later. That matters for a deposit taken in December for a February delivery. Ask, too, when sales tax is due on a deposit in your state. This isn’t tax advice.

If you call a deposit nonrefundable, have a lawyer check the wording against your state’s rules.

Return rules vary by state, too. In California, a store that doesn’t give full cash or credit refunds, or equal exchanges, for at least seven days after purchase must display that policy. Its order form is one of the allowed places. The others are signs at each register and sales counter, signs at each public entrance, or tags on the item. The rule doesn’t apply to customized goods received as ordered, or to goods marked “all sales final” or similar. This is Civil Code section 1723. Not every special order is customized, so the order form is a sensible place to state your policy either way. This isn’t legal advice, and cities can add their own consumer rules, so confirm the wording with a lawyer.

Write these terms on the order form the customer signs, and keep a copy with the record:

  • The deposit amount, and whether any of it comes back if the customer cancels.
  • When the balance is due: when the item arrives, or at delivery.
  • What happens if the supplier is late, changes the item or stops making it.
  • How long you’ll hold an item once it arrives, and any storage fee after that.
  • Whether a special order can be returned once it’s delivered.

References: IRS: Publication 538, Accounting Periods and Methods (opens in a new tab) · California Legislative Information: Civil Code section 1723 (opens in a new tab)

Orders taken by phone or online: the FTC’s shipping rule

Some special orders never touch the showroom floor. A repeat customer calls to order a second chair, or orders through your website. The FTC’s Mail, Internet, or Telephone Order Merchandise Rule applies to most goods a customer orders by mail, phone, fax or online. It doesn’t matter how the customer pays.

In short, you need a reasonable basis for any shipping time you state, or for shipping within 30 days if you state none. The clock starts once you have a complete order and payment, and a deposit counts as payment. If you learn you can’t ship on time, you must ask the customer to agree to the delay, or cancel and refund. Unless you extend the credit yourself, a required refund is due within seven working days, and store credit doesn’t count.

For example, a customer phones in an order for a made-to-order sofa and pays a deposit. The supplier quotes 10 weeks, but nobody gives the customer a date. The 30-day default then applies, and you have no reasonable basis to meet it. Stating the lead time when you take the order, and logging that you did, avoids that.

The rule is written for mail, phone, fax and online orders. Ask a lawyer how it fits your business, and what your state adds for orders signed in person. This isn’t legal advice.

The FTC doesn’t require you to keep records, but it says good ones help show you comply. In a case to enforce the rule, if you can’t document how you comply, the burden of proving it falls on you. The dates it lists for each order are the same ones a good special order record already holds:

  • The date you received the order.
  • What each delay notice said, and the date you sent it.
  • The date the customer canceled, if they did.
  • The date you shipped, and what you shipped.
  • The date of any refund, and what it covered.

Reference: FTC: Business Guide to the FTC’s Mail, Internet, or Telephone Order Merchandise Rule (opens in a new tab)

Customer updates that stop the “where’s my order?” calls

Many “where’s my order?” calls come from customers who haven’t heard anything in a while. The fix is to tell them before they ask, at the same points for every order.

Give each customer an order number at signing, and use status words they’d understand. A link to a simple status page, if your tools offer one, answers the question before they call.

Give a week or a range, not a single day, until the supplier confirms one. Send updates from the record, by text or email, so the next person who answers the phone can see what was said. Once an item arrives, booking the delivery is its own step; booking showroom delivery days covers that part.

Plan these updates, and log each one in the record:

  • At signing: what they ordered with every option, the expected date as a range, the deposit paid and the balance due.
  • When the supplier confirms: the confirmed date, or the new one if it changed.
  • When a date slips: the new date and their options, sent the day you find out.
  • On arrival: the item is in, what’s still owed, and how to book delivery or pickup.
  • After delivery: a receipt that shows the order paid in full.

What the record needs in different showrooms

The core record stays the same wherever you sell. What changes is the one detail that causes trouble when it’s missing. These are examples to test against your own business:

  • Furniture and mattresses: many options per item, long supplier lead times and home delivery. Record the fabric and finish codes on every line, and check them against the supplier’s confirmation.
  • Lighting and plumbing fixtures: orders may come through a contractor or designer for a client’s project. Record who the order belongs to, who pays, and which job it’s for.
  • Flooring and tile: quantities by the box or square foot, and dye lots that need to match. Record the lot number on arrival, before anyone books the install.
  • Appliances: models change and get discontinued. Note the backup model the customer will accept, and record serial numbers at delivery for warranty questions.
  • Bike and outdoor shops: smaller items, but more of them. The status needs to be visible to whoever is at the counter when the customer walks in.

Can your point of sale handle special orders?

Start with what you already pay for, since some point-of-sale and billing tools cover part of this. Here is what three vendors’ own pages said when we checked in October 2026. Lightspeed Retail lists special orders among its features, including a flow that gathers special order items into a purchase order. It also lists deposits and laybys (layaway).

Shopify POS lets you mark an order as partially paid and collect the rest later. Its help page warns that if you refund or exchange an item on that order, or edit the order, you can’t take more payments on it. Square Invoices lets you request a deposit and set a separate due date for the remaining balance.

Test any of them with three real orders from last month, including one that was delayed and one with items from two suppliers. Check that the supplier date, the deposit and the balance show in one place. Then change an order and see whether the payment trail survives.

Our guides to inventory tracking software and keeping in-store and Shopify stock in one count cover the stock side of the same problem. If you’re weighing a build against an app, our comparison of custom and off-the-shelf software has a three-year cost check you can fill in.

For a handful of special orders a month, a point of sale plus a well-kept spreadsheet is often enough. The record needs a home of its own when two or three of these are true:

  • Staff keep a binder or spreadsheet beside the till because the point of sale can’t show supplier dates.
  • One order has items from several suppliers arriving on different dates.
  • Someone retypes the same order into the point of sale, a spreadsheet and QuickBooks Online.
  • Arrived items need to be held for one customer without showing as free to sell.
  • Customers, contractors or designers keep calling for updates you could send from the record.

References: Lightspeed: Retail POS features (opens in a new tab) · Shopify Help Center: Multiple and partial payments on Shopify POS (opens in a new tab) · Square: Invoices (opens in a new tab)

How we build special order tracking into a showroom system

We build custom business software where each special order is one record: the items, the supplier order, deposits, dates, customer updates and delivery. It connects to the apps you keep. We work with Square, Shopify, Stripe, QuickBooks Online, Google Calendar, and Gmail or Outlook; for anything else, we check before we quote. Updates to customers go out from the record and are logged there.

These are our typical prices as of October 4, 2026. A focused fix, like a special order form that feeds one shared list, is $750–$3,000 over 1–⁠2 weeks. One business system, like special orders and deposits connected to Square and QuickBooks Online, is $6,000–$18,000 over 6–⁠10 weeks. A full system with stock, delivery booking, invoices and payments is $18,000–$40,000 over 10–⁠16 weeks.

Every launch includes 30 days of fixes, and monthly care is priced in your quote. You own the code we write once it’s paid in full; hosting runs on our account, and you can take it over after payment. The first call is free, and you get a fixed price in writing within 48 hours of it. If your point of sale already does the job, we’ll tell you.

Want a system like this, built around how your business works?

See business systems & software
Back to all articles

Questions owners ask.

What is a special order in retail?

A special order is an item a shop doesn’t keep in stock and orders from a supplier for one customer. It’s often customized, with a fabric, finish, size or color the customer picks. The customer usually pays a deposit when ordering and the balance when the item arrives or is delivered. Because it’s ordered for one person, a special order often comes with stricter cancellation and return terms than stock items.

Can a customer return a special order?

That depends on the terms you set and on your state’s rules. California’s posted return-policy rule, for example, doesn’t cover customized goods received as ordered. Some shops mark special orders as non-returnable, because the supplier won’t take back an item made to one customer’s choices. If that’s your policy, put it on the order form the customer signs and on the receipt. A damaged or wrong item is different: check it on arrival and claim with the supplier or carrier quickly. This isn’t legal advice.

How much deposit should you take on a special order?

There’s no standard amount. Work out what you’d lose if this customer canceled tomorrow, using each supplier’s cancellation terms, and set the deposit with that in mind. Get those supplier terms in writing and keep them with the order, so you can show a customer why part of a deposit was kept. Whatever you choose, write it on the order form and say whether any of it comes back.

What should a special order form include?

Start with the customer’s contact details, the supplier, the model and every option, like fabric, finish and size. Then add the quantity, price, deposit, how it was paid, the balance due, and the expected date as a range. Add your terms on cancellation, delays, holding arrived items and returns. Have the customer sign it, give them a copy, and keep yours with the order’s record. Add the supplier’s confirmation number once you have it.

Can I track special orders in a spreadsheet?

Yes, if one or two people keep it up to date. Use one row per item, with columns for customer, supplier, options, deposit, balance, purchase order number, expected date, status and last update. Sort it by expected date every week. A spreadsheet struggles when several staff edit it at once, when an order splits across suppliers, or when payments live in a till that nobody copies across.

  • Read this ifYou sell furniture, appliances or other big items, and booking delivery days eats your phone time.

    Delivery scheduling software for showrooms, without phone tag

    Delivery scheduling software for showrooms: let customers pick a day from real truck room, checked against stock and the balance due, without phone tag.

    Delivery scheduling · 13 min read

  • Read this ifYou sell or use stock in a shop, showroom or parts room, and wonder if an inventory app is enough.

    Inventory tracking software: an app or your own system?

    Inventory tracking software for shops, showrooms and parts rooms: what Square, QuickBooks and Sortly charge, how to test one, and when you need your own system.

    Inventory software · 12 min read