Wholesale order form template for B2B buyers
A free wholesale order form template for Google Sheets or Excel, the fields every B2B order form needs, and the signs that you've outgrown a form.
On this page
A wholesale order form is the sheet a store buyer fills in to tell you what they want: who is ordering, where it ships, their PO number, and one line per product with the SKU, price and quantity. A good form makes the buyer respect your case packs and minimums, and gives the office everything it needs to enter the order in Shopify without a follow-up email. Download the free order form template, add your products, and send it with your line sheet.
The Shopify steps below were checked against Shopify’s Help Center (B2B features by plan and Draft orders for B2B) on November 18, 2026. Menu names change, so follow your admin if it differs.
What every wholesale order form needs
An order form has two parts: the order details, filled in once, and the lines.
Order details
| Field | Why you need it |
|---|---|
| Company name | Matches the buyer to their company in Shopify. |
| Ship-to location | A company with three shops has three locations, possibly with different prices or terms. Ask which one. |
| Buyer name, email and phone | Who the invoice goes to and who you call with a question. |
| PO number | Many buyers can’t pay an invoice without their own purchase order number on it. |
| Requested ship date | “As soon as possible” and “not before March 1” are different orders. |
| Payment terms | Pre-filled by you (for example Net 30), not chosen by the buyer. |
| Notes | Delivery instructions, substitutions allowed or not. |
| Signature and date | Optional, but useful for orders written at a trade show. |
Lines
| Column | Why you need it |
|---|---|
| Style number (SKU) | The one field that identifies the product without doubt. |
| Product name and variant | So the buyer can check they picked the right thing. |
| Wholesale price | Pre-filled. Buyers shouldn’t type prices. |
| Case pack and minimum | So the buyer orders 12 or 18, not 10. |
| Quantity | In units. |
| Line total | Calculated, so the buyer sees the cost before sending. |
Rules that apply to the whole order go in the header, once: your opening order minimum if you have one, case packs, that shipping and taxes are added on the invoice, and how long prices are valid.
The free template
Download the wholesale order form template (CSV). It has a header row, four fictional sample lines from a made-up candle and homeware range, and a subtotal row.
| Column | What goes in it |
|---|---|
| Line | A line number, so you and the buyer can refer to “line 3”. |
| Style number (SKU) | The SKU from Shopify. |
| Product name, Variant | As on your line sheet. |
| Wholesale price (USD) | The buyer’s price, without a currency symbol. |
| Case pack (units) | The increment you sell in. |
| Minimum order (units) | The smallest quantity you accept for that product. |
| Quantity ordered (units) | The one column the buyer fills in. |
| Line total (USD) | A formula: price × quantity. |
| Requested ship date | Per line, for pre-orders that ship at different times. Leave it empty to ship with the rest. |
| Line notes | Anything the buyer wants to say about that line. |
The last row adds up the line totals. If you add lines, extend the SUM range in that row.
The CSV holds only the lines. Before you send it, insert about ten rows above the table for the order details listed earlier (company, ship-to location, buyer, PO number, ship date, payment terms, notes), and save it as a spreadsheet so the layout stays.
Opening it in Google Sheets
- Download the file.
- In Google Sheets, create a blank spreadsheet and choose File > Import.
- On the Upload tab, select the CSV.
- Choose Replace current sheet, keep Convert text to numbers, dates, and formulas ticked so the totals calculate, and click Import data.
To share it, use File > Make a copy for each buyer, or send it as an Excel file with File > Download > Microsoft Excel.
Opening it in Excel
Open the file with File > Open or by double-clicking it. Excel calculates the line totals. Save it as an Excel workbook (.xlsx) before adding the order details, because a CSV can’t keep formatting or extra rows reliably.
Two checks worth adding
- Case pack check. Add a column with
=IF(MOD(H2,F2)=0,"","Not a full case")and fill it down. It flags a quantity that isn’t a multiple of the case pack. - Minimum check.
=IF(AND(H2>0,H2<G2),"Below minimum","")flags a line under the product’s minimum.
Buyers fix these themselves when they see them, which saves you a reply.
Worked example: checking an order before you enter it
A buyer for a hypothetical gift shop returns the form with these lines:
| Line | SKU | Price | Case pack | Minimum | Quantity | Line total |
|---|---|---|---|---|---|---|
| 1 | EX-CAN-101 | $16.00 | 6 | 12 | 24 | $384.00 |
| 2 | EX-MUG-201 | $11.00 | 6 | 12 | 18 | $198.00 |
| 3 | EX-MUG-202 | $11.00 | 6 | 12 | 10 | $110.00 |
| 4 | EX-TEA-301 | $9.50 | 10 | 10 | 20 | $190.00 |
| Subtotal | $882.00 |
Line 3 is both below the minimum and not a full case. Rounding it up to 12 adds 2 × $11.00 = $22.00, so the corrected subtotal is $904.00, which is what the template’s sample data shows.
Suppose your opening order minimum is $750. The corrected order clears it. If the buyer had dropped line 1, the subtotal would be $520, and you would have to decide whether to accept it before you enter anything. Write that rule on the form so the decision isn’t made order by order.
From the form to Shopify
Someone has to turn the form into an order. On Shopify B2B, that is a draft order:
- In the Shopify admin, go to Orders > Drafts and click Create order.
- Select the B2B customer, then the company location from the form’s ship-to.
- Add the products. Shopify applies the location’s catalog prices, quantity rules and payment terms.
- Add the PO number and the buyer’s notes.
- Compare the total with the form. If they differ, the form had an old price or the buyer is in a different tier. Decide which price stands before you send anything.
- Send the invoice, or create the order on payment terms.
The comparison in step 5 is the reason forms cause trouble: the form says one thing, Shopify charges another, and the buyer only finds out on the invoice. Decide in advance who may accept a different price (order approval for sales reps has sample rules). When you must honor a price from the form, Shopify lets you set a custom price on a line of the draft order (Draft orders for B2B). The quote-to-order steps are covered in more detail in B2B quotes with Shopify draft orders.
Order forms vs. Shopify’s B2B storefront
Every Shopify plan that includes B2B gives buyers a way to order online: they sign in, see their own prices, use a quick order list, add a PO number and reorder past orders (B2B features by plan). You can also have a location’s online orders arrive as drafts for you to review before they become orders. For buyers who order online, that does the order form’s job with live prices.
A form still makes sense when:
- the buyer won’t create an account or prefers email;
- you take orders at a trade show or on a store visit with no laptop on the counter (taking orders at trade shows covers that routine);
- you’re testing wholesale with a few accounts before setting up companies and catalogs.
If you haven’t set up B2B yet, start with Shopify B2B without Plus and companies and locations.
When a form stops being enough
Forms work for a few orders a week from buyers you know. These are the signs you’ve outgrown one:
- Prices on returned forms are often out of date, because buyers keep last season’s file.
- Someone spends hours a week retyping forms into draft orders.
- Several reps send forms in different versions and you can’t tell which is current.
- Orders arrive without a PO number or ship-to, and you chase them by email.
- You can’t see which rep took an order, so commission becomes a debate.
At that point, move buyers who can order online to the B2B storefront, and give reps a way to order at live prices from their phone.
Common mistakes
- Letting buyers type prices. Pre-fill them and lock the cells if your spreadsheet allows it.
- Asking for “quantity” without saying units or cases.
- No version or date on the form. Old forms circulate for years.
- One form for every tier. A distributor’s form needs distributor prices.
- Promising totals that include shipping. Say clearly what the invoice adds.
Where Repvoy fits
Repvoy replaces the order form for orders your sales reps take. In the rep portal, a rep picks the customer and location, adds products by search, barcode or a pasted list of SKUs and quantities, and reviews the order at the prices Shopify will charge that location, with quantity rules enforced. The rep adds the PO number and a note, and the order arrives in Shopify as a draft order with the company, location and contact set. Buyers can also get a reorder link that shows their recent orders at today’s prices; what they send waits for your approval. Repvoy vs. spreadsheets and email compares the two ways of working line by line.