Skip to content

Guide

How to create a wholesale order form (with a filled-in example)

Build a wholesale order form step by step: the fields to include, spreadsheet formulas for totals, a filled-in example and how it differs from a PO.

CatalogKite TeamUpdated 7 min read

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

DocumentWho writes itWhenWhat it says
Order formYou. The buyer fills it inBefore the orderHere is what you can order, and at what price
Purchase order (PO)The buyer, from their own systemWhen they orderWe want these items at these prices
Order confirmationYouWhen you accept the orderWe will ship these items on this date
InvoiceYouWhen you ship, or earlier if payment is due up frontPlease 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

BlockFieldsWhy it is there
Your detailsLogo, business name, email, phone, and the date or season of the formThe buyer can see the form is current and where to send it
Buyer detailsStore name, contact person, email, phone, billing address, shipping addressYou cannot invoice or ship without them
Order detailsOrder date, PO number, requested ship dateTells you when the store wants the goods
Product linesItem code, product name, case pack, price, quantity, line totalOne row for each thing that can be ordered
TotalsSubtotal, shipping, tax where it applies, order totalThe buyer sees the full amount before sending
TermsMinimum order, payment terms, lead time, returnsNobody has to look them up
Sign-offName, signature or typed name, dateShows 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.

  1. Put your details at the top. Business name, contact details and the form's date in rows 1 to 3.
  2. 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.
  3. State the minimum in row 12. Type "Opening order minimum" in A12 and the amount, 250, in B12.
  4. Start the product table in row 13. Type the headers: Item code, Product, Case pack, Price per case, Cases, Line total.
  5. 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.
  6. Add the line total. In F14 enter =D14*E14 and copy it down the column.
  7. 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.
  8. Add a minimum check. In F45 enter =IF(F41>=B12,"Minimum met","Below minimum"). The buyer sees at once whether the order qualifies.
  9. Add the terms and the sign-off below the totals: payment terms, lead time and returns, then name, signature and date.
  10. 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.
  11. 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 codeProductCase packPrice per caseCasesLine total
CN-101Cedar and Smoke candle, 8 oz6$84.002$168.00
CN-102Fig Leaf candle, 8 oz6$84.001$84.00
CN-201Travel tin, 4 oz, assorted12$72.001$72.00
MT-001Long matches24$60.000$0.00
TotalAmount
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?

FormatWorks well forWatch out for
Printed formTrade shows and store visitsHandwriting, and every order has to be typed in again
Spreadsheet fileStores that reorder by emailEach buyer needs their own copy
Fillable PDFBuyers who want a fixed layoutTotals need form calculations, which take time to set up and test
Google Forms or a similar survey toolShort product listsAt the time of writing it has no built-in order total, so you add up each order yourself
Order link from an online catalogBuyers who order on a phoneThe 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 form

When 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.

Your next catalog is ten minutes away.

Open the maker, add a few products and download a PDF. No signup, no credit card.