Free template

Free wholesale price list template for Excel

A ready-to-use trade price list with product photos, prices, RRP and stock. Add your products, then print it or send it to your customers.

Download the template

Excel file, 23 KB. No sign-up or email needed.

wholesale-price-list-template.xlsx
PhotoCodeNameSizesPriceRRPStock
Navy T-shirtSS-101Navy Crew Neck T-ShirtS-XXL£3.50£9.9948
White polo shirtSS-102White Polo ShirtS-XXL£5.00£14.9960
Grey knitted beanieSS-103Ribbed Knit BeanieOne size£2.00£6.9924

What you get in the template

Everything a trade buyer looks for, already laid out. It comes with 200 product lines ready to fill, and the first 3 are samples to show you how.

Product photos

A photo column, so buyers can see what they are ordering.

Codes and names

Product codes make orders quicker and mistakes rarer.

Departments and sizes

Group your range, then filter it by any column.

Trade price and RRP

Pound formatting is built in, so you only type the number.

Stock

Show how many you have, or leave it blank.

Ready to print

Fits A4 landscape, with headings and page numbers on every page.

How to use it

  1. Download it

    Open the file in Excel. A How to use tab is included.

  2. Add your products

    Type over the sample lines, then carry on below them.

  3. Add your name

    Choose Insert, then Header & Footer, and type your business name.

  4. Send it out

    Print it, or save it as a PDF to send to your customers.

What to include on a wholesale price list

A good price list answers a buyer's questions before they pick up the phone.

Your contact details

Business name, phone and email, so ordering is one step away.

The date

Say when the prices apply from, so nobody orders from an old list.

Product codes

One code per product, used on every order and invoice.

Clear photos

One clean photo per product, ideally on a plain background.

Pack sizes and minimum orders

If you sell by the pack or case, add it to the product name.

VAT

State whether your prices include or exclude VAT.

Stock

Show what is available now, so buyers can order with confidence.

Payment and delivery terms

Add your payment terms, delivery charges and any minimum spend.

When a spreadsheet isn't enough

A website that updates itself from your stock list.

A price list is out of date the moment new stock lands. Then you update it, email it round and answer the same questions on the phone.

CatalogueGen turns your stock list into a catalogue your buyers browse on their phone and tap to enquire. New stock in? Drop the sheet in. This template is already in the right format.

No card needed. Done-for-you set-up. Our team builds your catalogue. Free set-up for a limited number of new customers each month. Worth £149. To start, send your stock list to info@cataloguegen.com.

Frequently asked questions

Is the template really free?

Yes. Download it and use it as often as you like. There is no sign-up and we do not ask for your email address.

Can I add product photos in Excel?

Yes. Click a cell in the Photo column, choose Insert, then Pictures, and drag the photo into the cell.

What is the difference between trade price and RRP?

The trade price is what your wholesale customer pays you. The RRP, or recommended retail price, is what you suggest they charge their own customers.

Should a wholesale price list include VAT?

Say clearly either way. Trade prices are usually shown excluding VAT, and the template prints a line saying so at the bottom of every page. Change it if your prices include VAT.

Can I turn this price list into an online catalogue?

Yes. The headings match what CatalogueGen reads, so your finished sheet can become a catalogue your buyers browse on their phone, including the photos.

More free templates and guides