Comparisons
Wholesale order forms: paper, Excel or a B2B platform, and what each method really costs
Carbon-copy order book, Excel file or order-taking platform: the wholesale order form decides what happens after the trade show. The three methods are compared from entry in front of the buyer to handover to the factory, with one benchmark: the point at which the tool you started with costs more than it brings in.
6 min read ·
Key takeaways
- A paper order book is quick to pick up, but every order has to be re-keyed, and every re-keying is a source of error.
- A shared spreadsheet centralises the figures, but it neither enforces your trading rules nor works comfortably on a stand.
- An order-taking platform applies your rules at the moment of sale, reports figures live and passes quantities on without re-keying.
- The right choice depends on the number of SKUs, the number of sales reps and the share of export, not on the size of the brand alone.
On the Monday after a trade show, a brand’s sales team often finds itself facing a stack of order forms to reread, decipher and re-key before production can start. At a trade show, in a showroom or on a round of stockist visits, order-taking is the moment the season is decided. Yet many designer brands still run it with the tools they started out with: a book of paper order forms, then an Excel file sent to each sales rep.
These methods are not bad in themselves. They become costly as the collection, the team and the number of countries grow.
The paper order form: simple on the stand, costly afterwards
The carbon-copy order book has a real advantage: everyone knows how to use it, it never crashes and it needs no network.
Its limits show up after the appointment. Every form has to be reread, deciphered and then re-keyed into a spreadsheet or an ERP. A miscopied reference, a forgotten colourway or a swapped size only comes to light on delivery, when it is too late. During the appointment, the sales rep has neither the stock, nor the customer’s history, nor the country’s prices in front of them. They work from memory.
- Systematic re-keying, hence delays and errors between the sale and production.
- No visibility on the day’s sales until the order book comes back.
- Trading rules (minimums, discounts, deposits) applied from memory, and therefore unevenly.
- Signatures and terms that are hard to track down in the event of a dispute.
The Excel order form: centralised, but fragile
The spreadsheet is often the second step. The brand keeps one file per season, with references, prices and a column per size. It lets you consolidate orders and calculate totals, which is clear progress compared with paper.
A spreadsheet, however, was never designed for selling in front of a customer. On a tablet, filling in a size-by-colourway grid remains laborious. Versions multiply from one sales rep to the next, an overwritten formula skews a total (an older study by Raymond Panko, published in 2008, already highlighted how common such spreadsheet errors are), and nothing stops an order going through below the minimum order or a discount being granted outside policy. Product photos, essential for selling a collection, are rarely included.
- Several versions of the same file, hard to reconcile at the end of the show.
- No automatic check of minimums, discounts or currencies.
- An uninspiring experience for the buyer, with no visuals and no clear summary.
- Production data that has to be rebuilt by hand for the factory.
A B2B order-taking platform applies the rules at the moment of sale
A B2B order-taking platform brings the visual collection, customers, price lists and trading rules together in a single tool. It is used on a tablet during the appointment. The sales rep selects the customer, fills in the grid, and the order automatically complies with minimums, country prices and payment terms.
The difference is felt above all after the show. Figures are consolidated appointment by appointment, quantities go to production without re-keying, and every order keeps a record of who placed it, when and on what terms. The main investment is the set-up: importing the catalogue, customers and price lists for the first time.
Wholesale order forms: the comparison, criterion by criterion
| Criterion | Paper form | Excel file | B2B platform |
|---|---|---|---|
| Learning curve | Immediate | Quick | Quick if the tool is designed for the field |
| Re-keying after the show | Complete | Partial | None |
| Enforcement of trading rules | From memory | Manual | Automatic |
| Collection visuals | Separate printed catalogue | Rarely included | Built into the order |
| Season figures | When the order book comes back | After consolidation | Live |
| Multi-currency and export | Calculated by hand | Formulas to maintain | Prices by country and currency |
| Proof of customer agreement | Signature on the form | Email exchange | Time-stamped signature and history |
| Handover to production | Re-keying | File reworking | Direct export |
The “proof of customer agreement” row deserves a closer look. An order signed on a tablet only carries weight if the tool records who signed, what and when: our guide to the legal value of an e-signature on a purchase order details what needs to be recorded.
The hidden costs of re-keying
Paper and spreadsheets look free. Their cost lies elsewhere: in the hours spent re-keying order forms after every show, in reference errors discovered on delivery, in the credit notes they lead to and in the sales lost for lack of the right information at the right time.
A less visible cost comes on top. Without reliable data during the campaign, the brand struggles to adjust production quantities before the launch date. This is one of the trends transforming wholesale: sales data now drives production. To measure what ending re-keying actually frees up, see our analysis of the time saved by digitising wholesale.
When should you drop paper or Excel order forms?
Five signs indicate that it is time to move to a platform.
- Several sales reps, agents or showrooms take orders at the same time.
- You sell in several currencies or with different prices by country.
- Re-keying after each show takes your team several days.
- You discover order errors at the time of delivery.
- You want to track sales during the campaign, not after it.
These signs often appear together, as the team grows and export picks up. When they do, the order of play is simple: list your trading rules (minimums, discounts, prices by country), then compare solutions with our checklist of 12 criteria for choosing order-taking software, checking offline operation and handover to production first.
Frequently asked questions
Does an order-taking platform replace my ERP?
No. It comes in upstream, at the moment of sale: catalogue, customers, orders and trading rules. Confirmed orders then flow into the ERP, which remains the tool for managing stock, invoicing and accounting.
Does moving to a platform mean training the sales reps?
A tool designed for the field is mastered within a few appointments. Most of the work happens beforehand, when the catalogue, customers and price lists are imported.
What happens if the network goes down during a trade show?
That depends on the tool. A good order-taking platform keeps working offline and syncs orders once the connection is back. It is a criterion to check before you choose.
Is an Excel order form enough for a small brand?
It will get you started, but the spreadsheet quickly shows its limits: no automatic checks on minimums and discounts, versions of the file to reconcile and production data to rebuild by hand.
Sources
- SME Digital Adoption Taskforce: final report — Department for Business and Trade (GOV.UK)
- Spreadsheet Errors: What We Know. What We Think We Can Do (2008) — arXiv — Raymond R. Panko, University of Hawaii
- Pourquoi et comment mettre en place un ERP pour les TPE — France Num