Posted on 19 August 2025
Wholesale Price List Template Excel, Word & Google Sheets
- Free wholesale price list template in Excel, Google Sheets and Word, with a filled sample and printable blank list
- Lists product photos, SKUs, case packs, minimum orders, prices and stock
- Supports 4 customer levels and 3 volume tiers, with buyer-specific lists that hide costs
- Checks prices against landed costs, minimum margins and retailer margins
A wholesale price list template is a reusable spreadsheet or document that suppliers, manufacturers and distributors send to business buyers, listing each product's SKU, case pack, wholesale unit price, case price, volume discounts, minimum order and suggested retail price, plus the payment and freight terms that apply to every order.
What is the wholesale price list template?
The wholesale price list template is the document a supplier, distributor or product brand uses to tell trade buyers what each item costs them, in what pack size, and on what terms. One row per orderable item. A buyer reads across the row, compares your wholesale price with the suggested retail price, and knows in seconds whether the item fits their shelf.
You will hear it called a wholesale price sheet, a wholesale pricing sheet, a trade price list, a supplier price list, a vendor price list or a distributor price list. In India, the same sheet is often called a rate list. The name changes. The job does not.
Here is what a wholesale price list is not. It is not a quotation, which prices one order for one buyer and expires. It is not a line sheet, which sells the collection with big photos and a story. And it is not your retail price list with "take 40% off" scribbled at the top. That looks improvised, and it invites every buyer to negotiate. If you sell to consumers or price services, our general price list template is the better fit, and it covers the classic price list format too.
What Does a Wholesale Price List Template Contain?
Most free wholesale price list templates online give you a product name, a price and a "notes" column. That is not enough. A buyer cannot order from it without emailing you three questions: how many come in a case, what is the minimum, and what can I sell it for. Here is every field our wholesale price list template uses, and why.
| Field | Why It Matters |
|---|---|
| Business name, contact for orders | Tells the buyer who to send the order to, and makes a forwarded file traceable. |
| Price list name and price level | Shows which list this is (retail store, distributor, key account), so nobody quotes the wrong one. |
| Effective date and valid until | Price lists get saved and forwarded. Six months later, the buyer must know if it is still current. |
| Currency | Essential the moment you sell across a border. |
| Photo | Buyers recognize a product faster than they read a SKU, and it cuts "which one is that?" emails. |
| SKU or item code | Buyers order by it, so it must match your order form and invoice exactly. |
| Product name and category | Short, consistent, with the variant in the name. Grouped by category for long lists. |
| Unit and case pack | "Each", "set" or "pack", and how many units sit in one case. The buyer orders in multiples of it. |
| Minimum order | The smallest order per item, in cases, that is worth shipping. |
| Wholesale unit price | The number the buyer pays per unit at their price level. |
| Case price | Unit price times case pack. Small shops think in units; distributors think in cases. |
| Volume tier prices | The lower unit price at each case break, for example 5+ and 20+ cases. |
| MSRP (suggested retail price) | Lets the buyer check their own margin instantly. Leave it out and many will not bother. |
| Stock status and lead time | In stock, low, pre-order, or "ships Dec 1". Stops orders you cannot fill. |
| Terms | Payment, freight, returns, advertised price and price change notice, at the foot of the list. |
| Tax and freight note | Says whether prices include sales tax, VAT or GST, and shipping. |
If you add only one field to the list you use today, make it the case pack. A buyer orders 30 tumblers, you ship cases of 24, and the very first invoice is already a dispute. Every other field is information. The case pack is the rule the order has to follow.
What Our Wholesale Price List Template Includes
Before building this one, I went through the wholesale price list templates, price sheet templates and pricing guides that rank for these searches. The templates gave you columns. The guides gave you formulas, then sent you to a calculator or an app. None of them put the math inside the sheet you send. So our wholesale price list template does the pricing and the checking, and prints a clean list for each buyer at the end.
Pictures on every row. The photo column works in Excel 365 (Insert, Pictures, Place in Cell) and in Google Sheets (Image in cell, or the IMAGE function). Place the picture once on the products sheet, and every buyer's list picks it up. That is the "wholesale price list template Excel with pictures" people search for, without retyping anything.

Two kinds of discount in one sheet. Wholesale pricing has two levers that most sheets mix up. Price levels decide who you are selling to: a retail store pays list, a regional distributor gets 8% off, a key account 20%. Volume tiers decide how much they buy: 5+ cases takes another 4%, 20+ cases another 8%. You set both once, in Settings, and the template prices every product at every combination.
A floor your discounts cannot break. Every product row works out your deepest possible price, the biggest level discount plus the biggest tier discount, and checks it against your landed cost. If the margin drops under your floor, the row turns red. In the sample, the meal prep containers were cut to 6.50 for a promo. At the deepest level that is 4.78 against a landed cost of 3.80, a 20.5% margin, and it fails a 25% floor before any buyer ever sees it.
The retailer's margin, checked on every row. A wholesale price only works if the shop can make money at your suggested retail price. The template calculates the retailer's margin at your MSRP and flags any item that falls short of the target you set. The spray bottle in the sample sells to shops at 3.60 with a 6.99 MSRP. That is a 48.5% retailer margin, just under keystone, so it gets an amber flag.

One file, a different list for every buyer. Pick a price level on the Buyer Price List sheet and it shows only that level's prices, tier prices, MSRP, stock and your terms. Costs and margins live on a separate internal sheet that you never send. A distributor never sees what your key accounts pay.

Tiered or all-units, priced both ways. The Quick Quote prices the same order two ways and shows you the gap. On the sample distributor order, all-units pricing comes to 4,659.66 and tiered pricing to 4,806.54. That is 146.88, or 3.2%, decided by one line in your terms. It also flags lines that are not full cases or below the minimum, and shows your margin on the quote in a box that does not print.

A change log, so nobody orders at last month's price. Log every price change with its effective date. Any increase announced with less notice than your terms promise gets flagged, and so does any change you have not told buyers about yet.

A Word pack for buyers who print. A blank wholesale price list with a photo column, the filled sample, a wholesale terms and conditions sheet, a price change notice letter, and a one-page pricing cheat sheet. For buyers who still want paper, it works as a printable wholesale pricing sheet.

Wholesale Price List Example
Here is a wholesale price list example from the filled sample: Harbor & Hearth Home Goods, a fictitious own-label importer in Columbus, Ohio, pricing for a regional distributor. Amounts are in US dollars, per unit.
| Product | Case pack | Unit price | Case price | 5+ cases | 20+ cases | MSRP |
|---|---|---|---|---|---|---|
| Cast Iron Skillet, 10 in | 6 | 17.66 | 105.96 | 16.95 | 16.25 | 39.99 |
| Chef's Knife, 8 in | 12 | 13.43 | 161.16 | 12.89 | 12.36 | 29.99 |
| Enameled Dutch Oven, 5.5 qt | 2 | 48.39 | 96.78 | 46.45 | 44.52 | 109.99 |
| Cellulose Sponges, 24 pk | 24 | 4.60 | 110.40 | 4.42 | 4.23 | 10.99 |
| Insulated Tumbler, 20 oz | 24 | 9.29 | 222.96 | 8.92 | 8.55 | 21.99 |
Read the skillet row the way a buyer does. Their price is 17.66, a case of 6 is 105.96, and the shelf price is 39.99. At 5 cases the unit price drops to 16.95. The same layout prints as a one-page wholesale price sheet. The buyer knows their margin before they open a calculator, and that is what gets a wholesale price list read instead of filed.
Wholesale Price List vs Distributor Price List vs Line Sheet vs Quotation
Buyers use these words loosely, so it pays to know which document you are actually sending.
| Wholesale Price List | Distributor Price List | Line Sheet | Quotation | |
|---|---|---|---|---|
| Who it is for | Every trade buyer | Businesses that hold stock and resell to shops | Retail buyers choosing a collection | One buyer, one order |
| Price shown | Wholesale list price and tiers | Net price after the distributor discount | Wholesale price and MSRP | Agreed price for this order |
| Typical gap below list | None | Deeper than retail stores get | None | Negotiated |
| Photos | Thumbnails | Rarely | Large, styled | No |
| Valid for | A season or quarter | A contract period | A season | Days or weeks |
| Main job | Set the rules for ordering | Protect channel margins | Sell the range | Close one deal |
Distributors sit one step below shops because they carry the stock, the credit and the delivery. The Montana Department of Agriculture's guide to selling to grocery stores puts typical distributor margins at 20% to 30%, brokers at 5% to 15%, and grocers at 33% to 50%. Your distributor price list has to leave room for that. Once a buyer accepts a price for one order, put it on a quotation instead. The rule is simple: a price list sets the rules for every buyer, a quote sets the deal for one.
How to Calculate Wholesale Price
The first rule of how to calculate wholesale price: start from landed cost, not from a competitor's list. Landed cost is everything it takes to get one unit onto your shelf: the unit cost, inbound freight, duty and packaging. The cast iron skillet in our sample costs 7.80, plus 0.90 freight, 0.55 duty and 0.35 packing, for a landed cost of 9.60. From there, there are three ways to set the wholesale price.
| Method | Formula | Skillet, landed cost 9.60 | Your margin |
|---|---|---|---|
| Margin on cost | Landed cost / (1 - target margin) | 9.60 / 0.50 = 19.20 | 50% |
| Markup on cost | Landed cost x (1 + markup) | 9.60 x 1.50 = 14.40 | 33% |
| Back from MSRP (keystone) | MSRP / 2 | 39.99 / 2 = 20.00 | 52% |
Look at the middle row. A 50% markup sounds like a 50% margin, and it is not. Markup is profit as a share of cost. Margin is profit as a share of the price. A 50% markup leaves you 33%. UVM Extension's markup and margin guide uses the same margin formula, cost divided by one minus the margin, and it is the one the template uses, because margin is what you actually keep.
So how do you calculate a 20% margin? Divide the cost by 0.80. A 10.00 cost at a 20% margin is 12.50, not 12.00. At 12.00 you have a 20% markup and only a 16.7% margin. Then check the answer from the buyer's side: keystone pricing means the retailer doubles your wholesale price, so your MSRP should sit near twice wholesale. If it cannot, your cost is too high or your MSRP too low. Our profit margin template runs the same numbers across your whole range.
How to Set Wholesale Price Tiers and Distributor Prices
Set your breaks in cases, not round numbers. If the knife ships 12 to a case, a break at "50 units" means every order at that tier includes a broken case. In the sample, Tier 2 starts at 5 cases and Tier 3 at 20, so every discount is tied to something that actually lowers your cost to serve: fewer picks, fuller pallets, one delivery instead of four.
Keep price levels to three or four, and tie each one to something measurable: annual volume, a signed commitment, or the role the account plays. "Regional distributor" means they hold stock and sell to shops. "Key account" means a signed annual volume. A level earned by negotiation alone becomes a reward for whoever argues longest.
Then decide how volume pricing works, and write it in your terms. Take 480 sponge packs, 20 cases, at the regional distributor level.
| Method | How it is charged | Total |
|---|---|---|
| All-units (volume) pricing | The order reaches 20 cases, so all 480 units get the Tier 3 price: 480 x 4.23 | 2,030.40 |
| Tiered (incremental) pricing | First 4 cases at 4.60, next 15 at 4.42, the last case at 4.23: 441.60 + 1,591.20 + 101.52 | 2,134.32 |
Same order, same breaks, a 103.92 difference. All-units pricing is simpler to quote and buyers love it. Tiered pricing keeps more margin on big orders. Neither is wrong. What is wrong is quoting one way and invoicing the other.
How to Use the Wholesale Price List Template?
1- Fill in Settings and Date the List
Open the wholesale price list template Excel file, or make your Google Sheets copy, and add your business details, currency, the price list name, and the effective and valid-until dates. Pick a pricing method, your margin floor and the margin a retailer needs at your MSRP. The dates print on every buyer's list, so a file forwarded six months from now still says whether it is current.
2- Build the Landed Cost for Every Product
Enter the unit cost, inbound freight, duty and packaging per unit. The template adds them up. Freight and duty are the costs people forget, and they are the ones that change most often for anyone importing.
3- Set the List Price
The template suggests a list price from your method. Accept it, or type your own in "Your list price" to override it. Either way, the row shows your margin at list and at the deepest discount.
4- Set Price Levels and Volume Tiers
Name up to four levels with a percentage off list, and up to three tiers by full cases. Check the floor column. If a row turns red, raise the list price, shrink the discount, or accept that this product does not belong in your deepest tier.
5- Add Case Packs and Minimum Orders
Enter how many units sit in a case and the smallest order in cases. The quote sheet uses both to catch "30 units" when you ship 24 to a case.
6- Add Pictures and Stock Status
Place a photo in each product's Photo cell, then set stock status and lead time. Low stock and pre-order items are highlighted on the buyer's list, so nobody orders something that ships in December expecting it this week.
7- Write Your Terms
Payment terms, freight, returns and damages, lead times, advertised price and price change notice. Net 30 is the most common starting point. Before you offer Net 60, read how long payments already take in our guide to accounts receivable.
8- Print Each Buyer's List and Log Every Change
Pick the buyer's level, save the list as a PDF for buyers who print, or send the sheet for buyers who paste it into their system. Keep the old version. When a price moves, log it with its effective date, send the notice letter from the Word pack, and send the new list as a wholesale price list PDF with the date in the file name.
Importance of the Wholesale Price List Template
Reduces Miscommunication
One document answers the questions every new buyer asks: price, pack, minimum, lead time and terms. You stop repeating them in email threads, and your sales reps stop quoting from memory.
Increases Order Accuracy
When the case pack and minimum are on the list, orders arrive in quantities you can actually ship. Fewer broken cases, fewer short shipments, fewer credit notes.
Protects Your Margin
A discount agreed in a meeting is easy to give and hard to take back. A published list with a floor behind it gives your team a rule to point at instead of a number to defend.
Keeps You on the Right Side of the Law
Charging competing buyers different prices without a cost reason is a legal risk in the US, as the country section below explains. A list with published levels and tiers is the simplest defense: the same rules for every buyer who qualifies.
Enables Smarter Sales Strategy
Once every product carries its margin at list and at the deepest price, you see which items carry the range and which ones you only sell at a loss in bulk.
Who Can Use the Wholesale Price List Template?
Distributors & Wholesalers
If you buy from several brands and sell to shops, you need the deepest margin math of anyone, because your own margin sits between the manufacturer's and the retailer's. Our supply chain page shows how that flow runs from purchase to delivery.
Manufacturers & Producers
Brands selling to shops and distributors at the same time need price levels more than anyone. One list price, a level for each channel, and an MSRP that protects the shops carrying your product.
E-commerce Sellers with Bulk Options
If you sell direct online and wholesale to stores, your MSRP has to match your own site's price. Otherwise your stockists compete with you at a disadvantage. Our online store page covers running both channels from one stock count.
Sales Teams & Agents
Reps carry one list per level, already priced, and use the quote sheet to price an order on the spot with the tier and the minimum checked.
Industry Suppliers
Pharmaceutical and medical suppliers sell by pack with batch and expiry tracking, so see our pharmaceutical companies page. Phone and accessories wholesalers live on thin margins and fast price changes, which our mobile shop page covers. Fashion brands usually send a line sheet first and the wholesale price list second, and our fashion store page shows the retail side they sell into.
Procurement Teams
Internal buyers can use the same format to line up vendor offers side by side: same columns, same units, same terms. That makes a vendor price list template comparison honest, because every supplier price list is read the same way.
How Enerpize Connects Your Wholesale Price List to Your Entire Operation
What happens after you send the list? A buyer orders at last week's price, someone types the invoice by hand, and the price list and the invoice disagree. That is where a spreadsheet stops helping.
Price Lists for Every Client, Branch and Period
In the Enerpize inventory module, you create as many price lists as you need: wholesale and retail, one per region, one per season. A price list can apply to one branch or several, or to a specific client. Assign a list to a client, activate price lists in invoices, and the invoice picks up that client's prices. You can import items into a list, bulk update it, clone it for a new season, deactivate an old one, and download any list as a PDF.
Units, Cases and Quantity Pricing
Unit templates let you sell the same product by the piece or by the case, each with its own buy and sell price. Quantity-based pricing applies the right price even when the same product is split across several lines of one invoice. Prices then flow straight into invoicing, so the price the buyer was quoted is the price they are billed.
Purchases That Keep Your Costs Real
Your margin is only as good as your cost. With purchase management, supplier invoices record what you actually paid, stock updates on delivery, and supplier statements show your balance with every vendor. When a supplier raises a price, you see it before your margin does.
Need to send a one-off invoice from your price list today? Try the free invoice maker.
Wholesale Price List Rules by Country
United States
In the US, charging two competing shops different prices for the same product is not just a commercial choice. It can be a federal case.
The Robinson-Patman Act applies to sales of goods of like grade and quality to competing buyers. The Federal Trade Commission explains that price differences are generally lawful when they reflect different costs of dealing with buyers, or are given in good faith to meet a competitor's price. On October 2, 2026, the FTC settled its case against Southern Glazer's Wine and Spirits, which it alleged charged independent retailers more than large chains for identical bottles. Under the six-year settlement, it can remedy a violation by paying the independent retailer 1.5 times the price gap.
What to add for US buyers:
- Price levels and tiers that any buyer who qualifies can reach, written down
- A note that prices exclude sales tax
- A requirement for a valid resale certificate on file before you skip sales tax, since rules vary by state
- An advertised price (MAP) note that limits advertising only, not what the shop may charge
Practical note for US suppliers: if a big account wants a deeper price, give it a published tier with a volume rule, not a private exception.
India
Indian buyers read a wholesale price list against one number first: the MRP printed on the pack.
Pre-packed goods sold at retail must carry the maximum retail price in rupees, inclusive of all taxes. The Ministry of Consumer Affairs also added a unit sale price on pre-packed commodities from April 1, 2022, so shoppers can compare prices per kilogram or litre. Since the MRP already includes tax, a dealer's margin is worked out against it, and your list should show the MRP next to the trade price on every row. That is why many Indian businesses still call this sheet a rate list.
What to add for Indian buyers:
- MRP inclusive of all taxes, next to the dealer or distributor price
- Whether the trade price includes or excludes GST, and the rate per item
- Your GSTIN, so the buyer can claim input tax credit on the invoice
- Case pack and minimum order, since distributors buy by the carton
Practical note for Indian suppliers: when the MRP changes, change the list on the same day. A dealer who receives new stock at a new MRP with an old rate list will price it wrong.
United Kingdom
UK trade buyers expect prices without VAT, and they expect to be paid on time, because late payment has become a political issue.
For business-to-business sales, you can claim statutory interest of 8% plus the Bank of England base rate on late payments, as GOV.UK sets out. In March 2026, the government said late payment costs the UK economy £11 billion a year and that 38 businesses shut every day, and announced plans for a 60-day maximum on payment terms when large firms pay smaller suppliers.
What to add for UK buyers:
- "Prices exclude VAT" at the top of the list, and the VAT rate on each item
- Your VAT registration number
- Payment terms in days, and a line saying you charge statutory interest on late payments
- Your returns window for damaged goods
Practical note for UK suppliers: put the statutory interest line on the price list and the invoice. You may never charge it, but buyers pay on time when they know you can.
Philippines
If you supply basic goods in the Philippines, your price list sits under a law that can freeze it overnight.
Under the Price Act, RA 7581 as amended by RA 10623, prices of basic necessities freeze automatically in areas hit by a calamity or emergency, for up to 60 days. The Department of Trade and Industry ran one such freeze for 60 days, from May 10 to July 9, 2021, after the African swine fever outbreak, then told businesses to follow its latest suggested retail prices for basic necessities and prime commodities.
What to add for Philippine buyers:
- Prices with and without 12% VAT, and your TIN
- The DTI suggested retail price next to your trade price, for goods that have one
- A line on how you handle a declared price freeze for those goods
- Payment terms and delivery charges per area, since freight varies widely between islands
Practical note for Philippine suppliers: check the DTI price bulletin before you set the season's list. If your trade price leaves a store no room under the SRP, it will not stock you.
Key Takeaways
- A wholesale price list needs the case pack, minimum order, unit and case price, tier prices and MSRP on every row, or buyers cannot order from it.
- Start from landed cost: unit cost, freight, duty and packaging.
- Price to a margin, not a markup. A 50% markup is only a 33% margin.
- Keep price levels (who buys) and volume tiers (how much) separate, and set tier breaks in full cases.
- Check your deepest price against a margin floor before you publish, not after a buyer finds it.
- Check that a retailer can make their margin at your MSRP, usually close to keystone.
- Send each buyer only their own level, and never send your costs.
- Date every list, log every change, and give the notice your terms promise.
FAQs
What is a wholesale price list?
A wholesale price list is the document a supplier sends business buyers showing what each product costs at wholesale, with the SKU, case pack, minimum order, unit and case price, volume discounts and suggested retail price. It also states the payment, freight and return terms that apply to every order.
How do I create a wholesale price list?
List one row per orderable item with its SKU, case pack and minimum order. Work out the landed cost, set a wholesale price that clears your margin, add volume tiers by case, and show the MSRP. Finish with your terms and an effective date, then save a PDF copy. Our wholesale price list template does each step for you.
How do you calculate wholesale price?
Divide your landed cost by one minus your target margin. A 9.60 landed cost at a 50% margin gives a 19.20 wholesale price. Then check it from the buyer's side: the retailer should be able to roughly double it to reach your suggested retail price.
How do I calculate a 20% margin?
Divide the cost by 0.80. A product that costs 10.00 sells at 12.50 for a 20% margin. Adding 20% to cost gives 12.00, which is a 20% markup and only a 16.7% margin.
What is the distributor price?
The distributor price is the net price a distributor pays after its discount off your wholesale list. It sits below what retail stores pay, because the distributor holds stock, extends credit and delivers to shops. Typical distributor margins run around 20% to 30%.
How much lower is wholesale than retail?
Under keystone pricing, the retail price is about double the wholesale price, so wholesale sits near half the MSRP. Margins vary by category: groceries run tighter, gifts and cosmetics wider. Always check the wholesale price still clears your own cost.
Can I add pictures to a wholesale price list in Excel?
Yes. In Excel 365, select a cell and use Insert, Pictures, Place in Cell. In Google Sheets, use Insert, Image, Image in cell, or the IMAGE function. In our template, a picture placed on the products sheet appears on every buyer's list automatically.
What is the difference between tiered pricing and volume pricing?
With volume (all-units) pricing, once an order reaches a tier, every unit gets that tier's price. With tiered pricing, each band of units keeps its own price. On the same order, all-units pricing always costs the buyer the same or less.
Should wholesale prices include tax and shipping?
Usually not. Most wholesale price lists quote prices before sales tax, VAT or GST and before freight, and say so clearly at the top. State your freight terms, for example free freight over a set order value, so buyers can work out their landed cost.
How often should I update a wholesale price list?
Review it at least twice a year and whenever your costs move. Give buyers written notice before an increase, usually 30 days, and let orders placed before the effective date keep the old price.
About the Author
Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.
Disclaimer
This wholesale price list template and guide are for general business use and are not legal, tax or pricing advice. The sample business is fictitious. Competition, consumer pricing and tax rules change and vary by country, so confirm them with the relevant authority or a professional adviser.
