Skip to main content

A free wholesale order form template.

A wholesale order form template and a matching price list with customer price tiers. Download both as CSV files for Excel or Google Sheets, or print a blank form for customers who still order on paper. Free, no sign-up.

What should a wholesale order form include?

A wholesale order form needs the customer and account number, order date, requested delivery date and PO number, then one line per item with SKU, product, pack size, unit price, quantity and line total. Using the customer's own tier price on every line is what prevents most invoice disputes.

What is in the price list template?

ColumnWhat it is for
SKUYour item code. Keep it short and never reuse one.
ProductThe name customers use when they order.
Pack size and unitWhat one unit means: a bag, a case of 12, a pallet.
List priceYour standard wholesale price.
Tier A, B and C pricesPrices for each customer tier. The examples use 15%, 10% and 5% off list.
Minimum orderThe smallest quantity you will ship.
AvailableYes or no, so customers do not order what you cannot ship.

How do you use the templates?

  • Replace the example rows in the price list with your products and set your tier prices.
  • Give each customer a tier, and keep that list somewhere everyone who takes orders can see it.
  • Send each customer the order form with their tier's prices filled in, so they only see what they pay.
  • When a form comes back, check the prices against the price list before you confirm.

Questions, plainly answered.

How do I open the CSV files?
Open them in Excel, Numbers or Google Sheets (File, Import). The order form's line totals and order total are formulas that calculate once the file is open.
Should every customer see every tier?
No. Send each customer a copy with only their own tier's prices, or give them a portal that shows only their prices.
Is the template free to use?
Yes. Use it, change it and share it. No sign-up.
When should I move past a spreadsheet order form?
When orders arrive faster than one person can enter them, or the same mistakes keep repeating. Our guide on when spreadsheets stop working covers the signs.

Related.

Outgrown the order form?

Wholesail builds a branded portal where each customer sees their own prices, and turns emailed and texted orders into priced drafts your team approves. You get a fixed-price proposal after the call.

Book a call