Free template · Spreadsheet (CSV)
Free wholesale price list template
A clean price list with trade prices, two quantity breaks, pack sizes, GST and RRP. Open it in Excel, Google Sheets or Numbers, replace the example rows with your products, and send it to your trade customers.
What’s inside
- SKU, product, unit and pack size
- Trade price ex GST
- Two quantity breaks with their prices
- GST rate and RRP inc GST
- Three example rows to copy
Preview
| SKU | Product | Unit | Pack size | Trade price ex GST | Break 1 min qty | Break 1 price ex GST | Break 2 min qty | Break 2 price ex GST | GST rate | RRP inc GST |
|---|---|---|---|---|---|---|---|---|---|---|
| PAP-A4-80-5 | A4 copy paper 80gsm | Carton | 5 reams | 46.20 | 10 | 43.89 | 25 | 41.58 | 10% | 60.45 |
| HP-CF226A | Black toner 26A | Each | 1 | 118.00 | 6 | 112.10 | 12 | 106.20 | 10% | 154.95 |
| BND-2R-25-BK | 2 ring binder 25mm black | Box | 10 | 24.50 | 5 | 23.28 | 10 | 22.05 | 10% | 32.95 |
How to use it
-
1
Download and open it
The CSV opens in Excel, Google Sheets or Numbers.
-
2
Add your products
Replace the example rows, and delete any columns you don’t use.
-
3
Send it, or put it online
Send it to trade customers, or let TierCommerce show each customer their own prices from your ERP instead.
Wholesale price list questions
Can I open it in Excel?
Yes. It’s a CSV file, so it opens in Excel, Google Sheets, Numbers and most accounting systems.
Should prices include GST?
Trade customers usually expect prices excluding GST, so the template lists trade prices ex GST and the RRP inc GST.
How should I set quantity breaks?
Set breaks at quantities that cut your handling cost, such as full cartons, and check each one still meets your target margin. Our quantity-break margin calculator works that out.
What happens when I have a price per customer?
A spreadsheet gets hard to manage once customers have their own prices. TierCommerce shows each customer their own contract price, price list and quantity breaks, straight from your ERP.
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.