Free template · Spreadsheet (CSV)
Free trade order form template
An order form with the fields your team needs to key an order once: the customer’s account and PO number, delivery details, and lines with your SKUs, quantities and prices.
What’s inside
- Account number and the customer’s PO number
- Required-by date and delivery address
- SKU, description, quantity and unit
- Unit price and line total ex GST
- An example order to copy
Preview
| Account number | PO number | Required by | Delivery address | SKU | Description | Quantity | Unit | Unit price ex GST | Line total ex GST |
|---|---|---|---|---|---|---|---|---|---|
| CGL-1042 | PO-77412 | 2026-11-04 | 12 Wharf St, Brisbane QLD 4000 | PAP-A4-80-5 | A4 copy paper 80gsm | 40 | Carton | 41.58 | 1663.20 |
| CGL-1042 | PO-77412 | 2026-11-04 | 12 Wharf St, Brisbane QLD 4000 | HP-CF226A | Black toner 26A | 6 | Each | 112.10 | 672.60 |
| CGL-1042 | PO-77412 | 2026-11-04 | 12 Wharf St, Brisbane QLD 4000 | BND-2R-25-BK | 2 ring binder 25mm black | 12 | Box | 22.05 | 264.60 |
How to use it
-
1
Download and open it
The CSV opens in Excel, Google Sheets or Numbers.
-
2
Send it to your customers
Ask them to use your SKUs and their PO number, so orders are quicker to key.
-
3
Stop keying it at all
TierCommerce lets customers order online, and the Order Entry co-worker turns emailed order forms into ERP orders.
Trade order form questions
Why ask customers to use our SKUs?
Orders written with your SKUs are faster and safer to key, because nobody has to guess which product a customer meant.
Can customers send it back as a PDF?
Yes. It works as a spreadsheet or saved as a PDF, whichever your customers prefer.
Can this order go straight into our ERP?
With TierCommerce, yes. The Order Entry co-worker reads emailed order forms and purchase orders, matches each line to your catalogue and posts the sales order to your ERP. It’s in beta with our design partners.
More free templates
See TierCommerce running on your own products.
Bring a price list and a recent purchase order. We’ll show you both working in 30 minutes.