Free wholesale price list template (Excel, with pictures)

aiprice blog · practical notes for suppliers · updated September 2026

A ready-made Excel template for wholesalers, manufacturers and distributors: a photo column that keeps images tied to their row, case packs, minimum order and three volume price tiers. Download it, fill it in, send it to buyers.

Download the template (.xlsx, 14 KB)Free · no sign-up · works in Excel, Google Sheets and LibreOffice

What's inside the template

Column	What goes there	Why buyers need it
SKU	Your item code	Orders and re-orders without "the blue one from last time"
Photo	One picture per row, placed in the cell	Buyers choose with their eyes; no photo = no sale
Product name, Category	Short name with the key spec (size, volume, material)	Filtering and search in a long list
Unit, Case pack	pcs / kg / m; units per box	Retailers order in boxes, not in single units
Min. order	Smallest quantity you accept	Stops the 3-unit orders that cost more to pack than they earn
Price 1+ / 10+ / 50+ cases	Volume price tiers	The main reason to buy more from you in one go
Retail price (RRP)	Recommended shelf price	Retailers see their margin immediately
In stock	yes / no / on order (dropdown)	Fewer "is it available?" messages

The header row is frozen, the list has filters, rows are pre-sized for photos (about 90 px) and the second sheet has short instructions. Three example rows show the format — delete them when you start.

How to add pictures so they never drift

Excel 365: click the Photo cell → Insert → Pictures → Place in Cell. The image now belongs to the row, so sorting and filtering will not break it.
Older Excel: insert the picture over the cell, then right-click → Format Picture → Properties → "Move and size with cells".
Google Sheets: Insert → Image → Image in cell.
Resize first to 300–500 px on the long side. A phone photo of 4000 px adds nothing to a price list and makes the file fifty times heavier.

If your file is already past 20–30 MB, that's the signal: Excel stays your working copy, and customers should get a link instead of an attachment. More on that below.

Volume pricing: how to set the tiers

The template has three tiers because that's what most wholesale price lists settle on: a base price for one case, a better one for a meaningful order, and the best for a pallet-sized one. A few rules that save arguments later:

Tie tiers to cases, not units — "10+ cases" is easier to check than "120+ units".
Keep the step visible: 5–10% between tiers is enough to move an order up; 1–2% is noise.
One currency per file. If you sell in two, make two price columns with the currency in the header, never mixed in one column.
Write the "valid from" date in the header line. Buyers keep old price lists for months.

Sending it to buyers: file, PDF or link?

	Excel file	PDF	Catalog link
Opens on a phone	Slowly, photos tiny	Yes, but no search	In a second
Buyer can order from it	By retyping into a message	By voice or photo	Cart with your min. order
Price update	Send the file again	Re-export and resend	Same link, new prices
Order reaches you as	Chat message	Chat message	A spreadsheet in your inbox

Turn this template into a catalog with a cart

This template uses the same column layout aiprice reads automatically — photos included, straight from the cells. Upload the filled-in file and within one working day you get a link to an online B2B catalog: search, categories, full-size photos, a cart that respects case packs and minimum order, and orders delivered to your email as a spreadsheet ready for your accounting software. When prices change, you replace the file; the link stays the same. The first catalog is free for 30 days.

FAQ

Is the template really free?

Yes. No sign-up, no email required — it's a plain .xlsx file you can edit however you like.

Does it work in Google Sheets?

Yes. Open it with File → Import, or upload it to Google Drive and open with Google Sheets. Use Insert → Image → Image in cell for photos.

How many products can one price list hold?

The template is pre-formatted for 200 rows; add as many as you need. Past a few hundred products with photos, the file gets heavy to email — that's when a catalog link works better.

Can I use my own column names?

Of course. Rename, delete or add columns — just keep one product (or one size/color variant) per row and avoid merged cells.

See what a price list like this turns into. A live demo with cart, color variants and minimum order — try it from your phone.
Open the demo catalog →