Free price list template for Excel and CSV
A wholesale price list for B2B buyers and resellers: order unit, minimum order quantity, your net price, the VAT rate, the price including VAT as a formula, and the recommended retail price. Fill in your products and send it as Excel, CSV or PDF.
Download the template
Every column explained
| Column | Required | Imports into WISEPIM as | What goes in it |
|---|---|---|---|
SKU | Yes | SKU | Your own unique code for the product or variant. It is the key every import, update and channel uses to match rows, so never reuse one. |
Product name | Yes | Name | The product name your buyers search for. Keep it the same as in your shop so orders match. |
EAN | EAN | The 13-digit barcode number (GTIN). Marketplaces and Google use it to identify the product. The examples use the 200 prefix, which is for internal use only. | |
Order unit | Map by hand | What one ordered unit is: a piece, a pack of 6, a carton. Prices in the row are per order unit. | |
Minimum order quantity | Map by hand | The smallest number of order units a buyer can order (MOQ). | |
Wholesale price | Yes | Map by hand | Your net price per order unit, excluding VAT. Use a dot as the decimal separator in the CSV. |
VAT % | Map by hand | The VAT rate that applies to the product, as a number (20 for 20%). The example uses the standard rate of the country. | |
Wholesale incl. VAT | Map by hand | The wholesale price plus VAT. A formula in the Excel file, so it updates when you change the price or the rate. | |
Recommended retail price | Price | The consumer price you advise, including VAT. In WISEPIM it becomes the product's selling price. | |
Currency | Map by hand | Three-letter ISO 4217 code, such as EUR, GBP or USD. | |
Valid from | Map by hand | First day the price applies, as YYYY-MM-DD. Send a new list instead of editing an old one, so buyers can tell versions apart. |
How to use the template
- 1
Download and open
Take the Excel file to work in a spreadsheet with live formulas, or the CSV to import the file somewhere else.
- 2
Replace the example rows
Keep the header row as it is. Add one row per product or variant and give each a unique SKU.
- 3
Import or share
Save as .xlsx or .csv (UTF-8) and import it into WISEPIM, your shop or a marketplace, or send it to your team.
Import it into WISEPIM
The headers are the ones the WISEPIM CSV import recognizes in English, Dutch, German and French. Upload the file and the columns map themselves; you check the mapping before anything is imported.
More free templates
A template holds your catalog. WISEPIM keeps it right everywhere.
Import any of these files into WISEPIM and the columns map themselves. Then enrich, translate and check your products, and publish them to your shops, marketplaces and feeds from one place.
Related free tools
See all toolsFrequently asked questions
What belongs on a wholesale price list?
For each product: an article number, the name, the EAN, the order unit, the minimum order quantity, your net price and the VAT rate. Add the recommended retail price so resellers see their margin, and a start date so everyone knows which version applies.
Should prices include or exclude VAT?
Business buyers compare prices excluding VAT, so the net price is the main column. The template adds the price including VAT as a formula, and the recommended retail price is a consumer price, so it includes VAT.
How do I update prices without confusing buyers?
Send a new list with a new Valid from date instead of editing the old file. Buyers can then tell versions apart, and you keep a history of every price change.
Can I import the price list into WISEPIM?
Yes. Article number, name, EAN and recommended retail price map themselves on import; the recommended retail price becomes the product's selling price. Columns like order unit or minimum order quantity can be mapped by hand to your own attributes.
Powerful, but easy to use
Do this for every product, automatically
- No credit card
- Free to start
- Setup in minutes