A wholesale order form is the page a store buyer fills in to tell you exactly what they want: which products, how many, where to ship and on what terms. You write it, the buyer completes it, and you invoice from it. This guide shows how to build one yourself in a spreadsheet, field by field, with the formulas for the totals and a filled-in example. It also explains how an order form differs from a purchase order and an invoice, because buyers use all three terms.
Order form, purchase order and invoice
| Document | Who writes it | When | What it says |
|---|---|---|---|
| Order form | You. The buyer fills it in | Before the order | Here is what you can order, and at what price |
| Purchase order (PO) | The buyer, from their own system | When they order | We want these items at these prices |
| Order confirmation | You | When you accept the order | We will ship these items on this date |
| Invoice | You | When you ship, or earlier if payment is due up front | Please pay this amount by this date |
Some accounting systems call the order confirmation a sales order.
Small independent stores usually order on your form or by email. Larger retailers send their own purchase order and expect to see its number on your invoice, so leave a box for a PO number even if most of your buyers never use it.
The parts of a wholesale order form
| Block | Fields | Why it is there |
|---|---|---|
| Your details | Logo, business name, email, phone, and the date or season of the form | The buyer can see the form is current and where to send it |
| Buyer details | Store name, contact person, email, phone, billing address, shipping address | You cannot invoice or ship without them |
| Order details | Order date, PO number, requested ship date | Tells you when the store wants the goods |
| Product lines | Item code, product name, case pack, price, quantity, line total | One row for each thing that can be ordered |
| Totals | Subtotal, shipping, tax where it applies, order total | The buyer sees the full amount before sending |
| Terms | Minimum order, payment terms, lead time, returns | Nobody has to look them up |
| Sign-off | Name, signature or typed name, date | Shows who placed the order and when |
A first order also needs account details that a reorder does not: the store's legal business name, and whatever tax paperwork applies where you sell. In the United States, a store buying for resale usually gives the seller a resale certificate so that no sales tax is charged, and each state has its own rules. In the UK and the EU, VAT-registered sellers show their VAT number on invoices, and a sale to a business in another EU country usually needs the buyer's VAT number too. Collect these on a separate new-account page, and check the rules with your accountant or your tax office.
Build the form in a spreadsheet
Excel and Google Sheets both work, and the steps are the same. This layout uses columns A to F.
- Put your details at the top. Business name, contact details and the form's date in rows 1 to 3.
- Add the buyer block in rows 4 to 11. One label per row with an empty cell beside it: store name, contact, email, phone, bill to, ship to, PO number, requested ship date.
- State the minimum in row 12. Type "Opening order minimum" in A12 and the amount, 250, in B12.
- Start the product table in row 13. Type the headers: Item code, Product, Case pack, Price per case, Cases, Line total.
- Paste in your products from row 14 down, one per row, grouped by category. Copy codes and prices from your line sheet or price list. Do not retype them.
- Add the line total. In F14 enter
=D14*E14and copy it down the column. - Add the totals. If your last product is in row 40, type Subtotal, Shipping, Tax and Order total in E41 to E44. In F41 enter
=SUM(F14:F40). Leave F42 for shipping and F43 for tax where it applies, and in F44 enter=F41+F42+F43. - Add a minimum check. In F45 enter
=IF(F41>=B12,"Minimum met","Below minimum"). The buyer sees at once whether the order qualifies. - Add the terms and the sign-off below the totals: payment terms, lead time and returns, then name, signature and date.
- Protect the prices and formulas. In Excel, unlock the cells the buyer fills in, then protect the sheet. In Google Sheets, select the price and formula cells, open Data > Protect sheets and ranges, and choose to show a warning when someone edits them.
- Set up printing. Repeat the header row on every page, add page numbers and fit the table to the page width. Save a PDF for buyers who prefer paper.
Send each buyer their own copy of the file. If you share one editable link with every store, they will overwrite each other's orders. The guide to making a price list in Excel covers print setup and PDF export in more detail.
A filled-in example
A candle maker sells by the case and has a $250 opening minimum. A gift shop returns the form like this.
| Item code | Product | Case pack | Price per case | Cases | Line total |
|---|---|---|---|---|---|
| CN-101 | Cedar and Smoke candle, 8 oz | 6 | $84.00 | 2 | $168.00 |
| CN-102 | Fig Leaf candle, 8 oz | 6 | $84.00 | 1 | $84.00 |
| CN-201 | Travel tin, 4 oz, assorted | 12 | $72.00 | 1 | $72.00 |
| MT-001 | Long matches | 24 | $60.00 | 0 | $0.00 |
| Total | Amount |
|---|---|
| Subtotal (four cases) | $324.00 |
| Shipping | $18.00 |
| Order total | $342.00 |
The lines add up to $324.00, which is above the $250 minimum, so the check cell reads "Minimum met". Because the quantity column is headed "Cases", nobody has to guess whether "2" means two candles or two cases of six. The matches row stays on the form at zero. Leave unordered rows in place, so that every form you receive has the same rows in the same order.
Case packs, price breaks and minimums
These three are behind many of the corrections that follow an order.
- Case packs. Use one unit for the quantity column and name it in the header: "Cases" or "Units", never just "Qty". If you price per unit but sell only in sixes, add "order in multiples of 6" to the header.
- Price breaks. If the price drops at a quantity, one price column will be wrong for some orders. Add a second column, such as "Price at 10+ cases", and say in the terms that the lower price is applied on the confirmation. The bulk discount calculator shows the margin you keep at each break.
- Minimums. Print the opening minimum and the reorder minimum above the product table, not only in the terms at the bottom. Buyers build an order to fit a minimum they can see.
Paper, spreadsheet, PDF or online form?
| Format | Works well for | Watch out for |
|---|---|---|
| Printed form | Trade shows and store visits | Handwriting, and every order has to be typed in again |
| Spreadsheet file | Stores that reorder by email | Each buyer needs their own copy |
| Fillable PDF | Buyers who want a fixed layout | Totals need form calculations, which take time to set up and test |
| Google Forms or a similar survey tool | Short product lists | At the time of writing it has no built-in order total, so you add up each order yourself |
| Order link from an online catalog | Buyers who order on a phone | The buyer needs a connection |
Whichever you choose, keep its codes and prices in step with your line sheet. If the form lives in its own spreadsheet, paste the prices in again every time they change. A form that has drifted from the line sheet is a common way for a buyer to order at last season's price.
CatalogKite's wholesale order form template builds the printable version from your product list, with blank quantity and total columns. A shared catalog link covers the last row of the table: the buyer picks quantities on a phone and sends you the order by WhatsApp or email.
Generate a printable order form from your product list.
Make an order formWhen the form comes back
A completed form is a request until you accept it. Check it against your stock and your minimum, then send an order confirmation that repeats the items, quantities, prices, ship date and payment terms. Invoice from the confirmation, not from memory.
Whether a signed order form is a binding contract depends on what it says and on the law where you trade. If you want the right to decline or adjust an order, say on the form that orders are subject to your written confirmation, and take advice before you rely on that for large orders.
Keep every completed form. When a store reorders, the last form tells you what they bought and what to suggest.
Common mistakes
- A quantity column with no unit. "2" could be two units or two cases.
- Prices typed by hand. One wrong digit and you either lose money or have to correct the buyer.
- No date on the form. Buyers keep old forms and order from them.
- Terms only in the email. The email gets lost and the form gets filed.
- No space for a PO number or a ship date. Larger stores need both.
- One shared file for all buyers. Each order overwrites the one before.
Wholesale order form checklist
- Your details and the form's date at the top
- Buyer block with billing and shipping addresses
- PO number and requested ship date
- Item codes and prices copied from the line sheet
- Quantity column headed with its unit
- Line totals, subtotal, shipping and order total
- Minimum printed above the table, with a check
- Payment terms, lead time and returns
- Name, signature and date
- Price and formula cells protected
- Printed and filled in once as a test
For what to put in the terms block, see wholesale terms explained.
Written by the CatalogKite Team. Last updated . Spotted something out of date? Tell us at the email address in the footer.