Free Wholesale Order Form Template (Excel + Sheets)
Key takeaways
- A wholesale order form needs SKU, case pack, wholesale price, quantity, totals, minimum order quantity, and payment terms so orders can be fulfilled without email back-and-forth.
- The free template comes in Excel and Google Sheets versions with three tabs: the order form, a product list, and an order log.
- Tiered pricing works via a lookup table, and data validation on the quantity cell flags orders below your minimum.
- Spreadsheets cannot sync with inventory, tax, or accounts, so they suit low wholesale volume while a store platform with trade accounts removes re-entry work.
- Shopify has no built-in wholesale order form, so the native route typically means a paid B2B app at $10-50/mo on top of your plan.
This free wholesale order form template gives you a working Excel and Google Sheets file, plus field-by-field instructions to adapt it to your products, pricing tiers, and net terms. It also covers what changes when you outgrow the spreadsheet and want wholesale orders running through your store instead.
What Should a Wholesale Order Form Actually Include?
A wholesale order form needs to capture enough detail for a buyer to place an order and for you to fulfil it without a back-and-forth email chain. Here is what belongs on it.
The fields buyers expect
Start with your business name, contact details, and order form date. Then the product table: SKU or product code, product name, description, case pack quantity, wholesale unit price, and a quantity column the buyer fills in. Add a line for subtotal, any shipping or handling charge, and the order total. Buyers also expect your minimum order quantity and payment terms stated up front, whether that is net 30, credit card, or a purchase order number field for their accounts payable team.
Fields that protect you legally and financially
Include your tax ID or resale certificate requirement, so you know whether to charge sales tax. Add your terms: payment due date, late fee, return policy, and delivery window. A signature or approval line makes the form a record both sides can point to. If a dispute lands, this section is your paper trail.
Get these fields right once and the template below becomes something you reuse for every trade account, not a document you rebuild each season. And if you would rather wholesale orders flowed straight into your store with the catalogue and tax already attached, that is what UnifyCart handles as part of the subscription, instead of as an extra app.
Download the Free Wholesale Order Form Template (Excel and Google Sheets)
The template is free, no email wall, and comes in two formats. Both carry the same structure: a buyer details block, a line-item grid (SKU, description, quantity, unit wholesale price, line total), an order subtotal, a tax line, shipping, and a total with net terms and PO number fields at the bottom. Fill in your catalogue once, then send the file or a copy of the sheet to each trade buyer.
What's in the Excel version
Three tabs. Tab 1 is the order form itself, with formulas already wired so line totals, subtotal, tax, and grand total calculate as your buyer types. Tab 2 is your product list: SKUs, descriptions, wholesale and MSRP columns. Tab 3 is a plain log of orders received, so you can keep a running record without buying anything.
What's in the Google Sheets version
Same three tabs, same formulas, but built for sharing. Send a buyer a copy, they fill it in, and the totals come back to you. It also doubles as your order log in one file. If you later want orders flowing straight into your store instead of through email attachments, we covered what that handoff looks like when PM Press moved eighteen years of orders.
How to Create a Wholesale Order Form: Field-by-Field Customization
Set up your product and price list tab
Duplicate the "Products" tab and rename it to match your catalogue, e.g. "Spring 2026 Line". Replace the sample SKUs with your own, keeping one row per variant, not per product. Fill the wholesale price column with your list wholesale price; leave the MSRP column visible so buyers can see their margin. Freeze the header row so column labels stay put when buyers scroll.
Configure tiered pricing and minimums
Add a "Tier" column next to quantity and set your breaks in a small lookup table, for example:
| Quantity | Discount off list wholesale |
|---|---|
| 12–47 | 0% |
| 48–119 | 5% |
| 120+ | 10% |
Then use a lookup formula so the correct tier applies as the buyer types a quantity. Set your minimum order quantity with data validation on the quantity cell so anything below it flags red. Keep minimums per-order rather than per-SKU if buyers mix sizes.
Add net terms and PO numbering
Add three fields near the top of the form: PO number, terms (Net 30, Net 60, or prepaid), and requested ship date. Number your POs with a convention like YEAR-STORENAME-001 so duplicates are impossible across buyers. If you extend net terms, add a "terms accepted" checkbox line the buyer initials; a plain template cannot enforce anything, so make acceptance explicit on the document itself.
Make the form calculate totals and tax automatically
Multiply quantity by the tiered unit price for each line, then sum to a subtotal. Apply tax only if your state taxes wholesale resale differently; otherwise leave a resale certificate number field and keep tax at zero, since resale purchases are generally exempt with a valid certificate (see your state's rules, e.g. California CDTFA resale certificate guidance). Lock formula cells so buyers can only edit quantity and notes.
If your buyers want product imagery attached to line items, mockups help; we cover that with a free design mockup. And if the spreadsheet starts feeling fragile, note that Shopify's own B2B wholesale features live in its admin rather than a template (Shopify Help Center).
Excel, Google Sheets, or Your Store Platform: Which Should Hold Your Wholesale Order Form?
A spreadsheet template is enough when your wholesale volume is small, your price list rarely changes, and you are comfortable typing orders into your store by hand. If you take a handful of trade accounts and invoice monthly, the free wholesale order form template does the job with nothing to install or pay for.
Where spreadsheets break down is the moment the form has to stay in sync with everything else. A sheet does not know your current stock, so a buyer can order twelve units you already sold, and it does not apply your tax rules or shipping rates, so every order needs manual arithmetic before you can invoice it. It does not update your books either, so each purchase order becomes a re-entry job where typos in SKUs and quantities creep in quietly. It cannot gate pricing, meaning anyone who gets the file sees your trade rates, and it cannot stop two buyers from ordering the last of a run at the same time. None of these are spreadsheet flaws exactly; they are the cost of keeping your catalogue, checkout, and accounts in three separate places, and the more trade accounts you add, the more hours per week that separation costs you.
Running the same test against UnifyCart honestly: the template wins on cost and on speed for a first wholesale order, and if that is where you are, use it. UnifyCart's trade accounts keep the form connected to the catalogue and the accounts instead, which removes the re-entry work but also means your pricing lives on a paid platform rather than a file you control. That is the actual trade-off, and you can read more about the thinking behind it in why UnifyCart is open for business.
Wholesale Order Form on Shopify: What It Takes and What It Costs
The app route and its monthly bill
Shopify has no built-in wholesale order form. You add one through a paid app from the Shopify App Store, typically $10-50/mo for a B2B or wholesale app, on top of your plan and transaction fees. That is how "apps for basic stuff" becomes a $250-300/mo all-in bill. BigCommerce, by contrast, ships customer groups and price lists natively, which its help docs cover under B2B features. The sticker price of any platform is the wrong number; the all-in cost after apps is the one that matters.
Why checkout customization becomes a rabbit hole
Want the form to feed a custom checkout flow, minimum order quantities, or net terms? You end up editing theme code and untangling app conflicts, exactly the afternoon-destroying rabbit hole merchants describe. On UnifyCart, the catalogue, checkout, payments, and tax are built in (see every feature, searchable), so a wholesale order form is a configuration task, not an integration project.
What About a Squarespace Wholesale Order Form?
Squarespace doesn't offer a native wholesale purchase order form, so merchants there typically fall back on the same template workflow described above: a shared spreadsheet plus manual entry. That works at low volume, but nothing in the form ties into inventory, tax, or accounts.
The same applies to most of the Shopify alternatives you'll see in comparison threads. Wix eCommerce, Ecwid, and BigCommerce are general hosted store builders; WooCommerce is a WordPress plugin you host and maintain yourself. None of them ships with trade accounts, net terms, or a buyer-facing order form as a built-in feature, so a template remains the practical starting point. UnifyCart is built differently: wholesale buyers get their own trade accounts with net terms and purchase orders, and the order form, checkout, tax, and accounting are all included in the $79/mo Growth subscription rather than sold as paid apps on top.
How to Take Wholesale Orders Once the Form Is Filled In
A filled-in form is the start of the work, not the end of it. Here is what happens next, and where each step lives.
Approving and invoicing manually
With a spreadsheet or emailed form, you review the order, decide whether to approve the buyer, then build an invoice yourself. Net terms means you track who owes what and chase it when payment is due. The order enters your books only when you retype it, which is where typos in SKUs and quantities creep in.
This works fine at low volume. The cost is your afternoon, and the risk is a wholesale order that never makes it into your stock counts.
What changes when orders flow straight into the platform
When wholesale orders land in the same system as your retail ones, approval, invoicing, and net terms tracking happen against the same catalogue and inventory. Nothing gets retyped. That is the honest trade-off with UnifyCart: the template in this article is free, while the platform starts at $29/mo. Paying for built-in features only makes sense once order volume makes the manual steps the expensive part.
Common Mistakes With Wholesale Order Forms (and How the Template Avoids Them)
The four failure modes that sink wholesale forms are stale pricing, missing minimums, unclear net terms, and orders arriving without a real purchase order reference. Each one costs you an afternoon of email back-and-forth, or worse, an order shipped at last year's prices.
The template handles this by design. Prices live in one lookup table, so updating a rate updates every product row. Minimum order quantities sit in their own column and the subtotal formula flags orders below them. Net terms, purchase order number, and trade account details are fixed fields near the top, so no order goes out without them.
What the template cannot do is stop someone from emailing a spreadsheet with last quarter's numbers still in it. That is a version control problem, not a formatting one, and it is the honest limit of any file-based workflow. If you find yourself sending the same corrected sheet three times a month, that is the signal to move wholesale ordering into your store platform instead.
FAQ
Is the wholesale order form template really free, or is it gated behind an email signup?
It is genuinely free with no email wall. You download the Excel or Google Sheets file directly, fill in your catalogue once, and reuse it for every trade account. The only paid option mentioned is UnifyCart, which starts at $29/mo and only makes sense once manual order handling becomes the expensive part.
Can I use the Excel template for net terms and purchase orders from trade accounts?
Yes. The form includes fields for PO number, terms (Net 30, Net 60, or prepaid), and requested ship date near the top. Add a "terms accepted" line for the buyer to initial, since a plain spreadsheet cannot enforce anything. Number POs with a convention like YEAR-STORENAME-001 to prevent duplicates.
How do I stop wholesale customers from seeing retail prices on the form?
The MSRP column exists so buyers can see their margin, not their own retail pricing. If you would rather not show it, delete that column before sending. The real gap is that anyone holding the file sees your trade rates, which no spreadsheet can gate. That is a platform limitation, not a formatting one.
Do I need a paid app to accept wholesale orders on Shopify, or can a template do it?
A template works for low volume, but Shopify has no built-in wholesale order form, so the native route means a paid app, typically $10-50/mo on top of your plan and transaction fees. If you want the form tied to inventory, tax, and checkout instead of a spreadsheet, expect either app costs or theme code edits.
Can my wholesale rep fill in the Google Sheets version on a phone?
Yes, with caveats. Send them a copy of the sheet, they fill in quantities, and the wired formulas calculate line totals, subtotal, tax, and grand total automatically. Editing a spreadsheet on a small screen is awkward for long catalogues, so for large orders a desktop or the store platform route is smoother.