Skip to content

How to make a wholesale line sheet (free template)

What to put on a wholesale line sheet, how to build one from your Shopify products and catalogs, and a free CSV template for Google Sheets or Excel.

By Cartwork ·

On this page
  1. What a line sheet is, and what it isn’t
  2. What to put on a line sheet
  3. The free template
  4. Building the sheet from your Shopify data
  5. Worked example: one product, three numbers that matter
  6. Turning the sheet into a PDF
  7. Keeping the sheet honest
  8. Common mistakes
  9. Where Repvoy fits

A wholesale line sheet is a short document that tells a store buyer everything they need to place an order: a photo of each product, its style number, wholesale price, suggested retail price, case pack, minimum and when it ships. The quickest way to make one is a spreadsheet with one row per variant, which you then lay out as a PDF. Download the free line sheet template and replace the sample rows with your products.

The Shopify steps below were checked against Shopify’s Help Center (Exporting products and Catalogs) on November 18, 2026. Menu names change, so follow your admin if it differs.

What a line sheet is, and what it isn’t

Buyers get several documents from a wholesale brand, and mixing them up is how prices end up wrong.

Document Its job Has prices?
Lookbook or catalog Shows the products in context, tells the story of the season Usually not
Line sheet Lists what can be ordered, with the commercial terms per product Yes: wholesale and suggested retail
Price list Prices only, often for a specific customer or tier Yes
Order form What one buyer wants, in what quantities Yes, plus quantities and totals

A line sheet is the reference. The order form is what the buyer fills in from it. Keep them separate: a line sheet is the same for every buyer in a price tier, while an order form belongs to one order.

What to put on a line sheet

Every row needs enough for a buyer to order without emailing you a question.

Must have:

  • Product photo. Buyers scan pictures first. One clear image per variant is better than a styled shot of the whole range.
  • Style number or SKU. This is what the buyer writes on the order form and what you search for when you enter the order. It should be the same SKU you use in Shopify.
  • Product name and variant. Color, size, scent or format, spelled the way it is in your store.
  • Wholesale price. In the buyer’s currency, with the currency stated once in the header.
  • Suggested retail price (MSRP). Store buyers work out their margin from it.
  • Case pack and minimum. If a product sells in sixes, say so. If the minimum is two cases, say 12 units, not “2 cases”: units are what the buyer types.

Good to have:

  • Price breaks for larger quantities.
  • Ship date or availability, especially for pre-orders and new collections.
  • Barcode (UPC or EAN), which many shops need to receive stock.
  • Short description with the facts a shop assistant repeats: size, material, care.
  • Collection or category, so the sheet can be grouped.

On the sheet, once, not per row: your brand name and contact, the price tier the sheet is for, the opening order minimum if you have one, payment terms, shipping terms, and a “prices valid until” date.

The free template

Download the wholesale line sheet template (CSV). It has a header row and five fictional sample rows for a made-up candle and homeware range. Replace them with your products.

Column What goes in it
Collection The group the product sits in on the sheet (Candles, Kitchen…). Sort by this column before you lay out the PDF.
Style number (SKU) The SKU from Shopify, exactly.
Product name The product title from Shopify.
Variant Size, color or other option.
Description One or two short sentences a buyer can repeat to a customer.
Image link A link to the product photo. In Google Sheets you can turn it into a picture (see below).
Wholesale price (USD) The price this tier pays, without a currency symbol, so the spreadsheet treats it as a number. Rename the column if you sell in another currency.
Suggested retail price (USD) Your MSRP.
Case pack (units) How many units are in a case, or the increment you sell in.
Minimum order (units) The smallest quantity you accept for that product, in units.
Price break The lower price and the quantity it starts at, in words. Leave it empty if there is none.
Barcode (UPC/EAN) The barcode on the product. The sample values are placeholders.
Ships from A date for pre-orders, or “In stock”.
Notes Anything else: “new”, “last chance”, “limited run”.

Opening it in Google Sheets

  1. Download the file to your computer.
  2. In Google Sheets, create a blank spreadsheet, then choose File > Import.
  3. Open the Upload tab and select the CSV.
  4. Choose Replace current sheet, leave the separator on automatic detection, and click Import data.

To show photos, add a column next to “Image link” and enter =IMAGE(F2) in the first row, then fill it down. The link must point to an image that anyone can open.

Opening it in Excel

Double-click the file, or use File > Open. Save it as an Excel workbook (.xlsx) before you add formatting or pictures, because a CSV keeps only the values.

Building the sheet from your Shopify data

Typing the line sheet by hand is how SKUs and prices drift away from your store. Start from what Shopify already has.

  1. Export your products. In the Shopify admin, go to Products, click Export, choose the products (all, selected, or the ones that match your current search and filters) and the CSV format for spreadsheet programs. Depending on what you export, the file downloads in your browser or is emailed to you. Shopify’s page doesn’t list every column, so open the file and copy the ones you need (title, variant options, SKU, barcode, retail price) into the template.
  2. Get the wholesale prices. If your wholesale prices live in a B2B catalog with fixed prices, you can export the catalog from Markets > Catalogs: select it, click Export, then Export CSV. The file is emailed to you. Only products with fixed prices are included; products priced by a percentage adjustment are left out. (Catalogs.)
  3. Calculate percentage prices. If the catalog is “50% off retail”, calculate the wholesale price in the sheet from the retail price, then check a few products against a draft order for a company location in that tier.
  4. Make one sheet per tier. If you sell at more than one wholesale price, make a copy of the sheet for each tier and label it clearly. On plans below Plus you can have up to three active catalog assignments, so most brands end up with at most three line sheets (Shopify B2B without Plus). How to set those tiers up is covered in wholesale pricing on Shopify.

Worked example: one product, three numbers that matter

A hypothetical brand sells an 8 oz candle at $32 retail. Its standard wholesale tier is 50% of retail, sold in cases of 6, with a minimum of two cases.

Field Value How it’s worked out
Suggested retail price $32.00 Your MSRP
Wholesale price $16.00 $32.00 × 50%
Retailer’s margin 50% ($32.00 − $16.00) ÷ $32.00
Case pack 6
Minimum 12 units 2 cases × 6
Smallest possible line $192.00 12 × $16.00
Price break $15.00 from 48 units 48 × $15.00 = $720.00, instead of $768.00

That last row is what makes a buyer move up a size: the sheet shows that 48 candles cost $48 less than at the standard price. Put the break on the line sheet, not just in your catalog, or nobody will plan for it.

Check the arithmetic against Shopify before you send anything. If the catalog has quantity rules (minimum 12, increment 6) and a quantity price break at 48, a draft order for 48 units should come out at $720.00 before shipping and tax. If it doesn’t, fix the catalog or the sheet now. Minimums and pack sizes are covered in more depth in minimum order quantities for wholesale.

Turning the sheet into a PDF

Buyers often want a PDF they can file. A layout that prints well:

  • Landscape, with the header row repeated on every page.
  • One collection per page, or a page break between collections.
  • Photo on the left, then style number and name, then the numbers. Prices in their own columns so they line up.
  • The header block on page one: brand, tier, currency, payment terms, opening minimum, “prices valid until”, and who to contact.
  • A version or date in the footer. When a buyer phones with a question, you need to know which sheet they’re holding.

In Google Sheets, File > Download > PDF lets you choose landscape, fit to width and repeated frozen rows. In Excel, set the print titles and orientation before you export.

Keeping the sheet honest

A line sheet is a promise about prices. Shopify charges the price in the catalog, not the one on your PDF, so every difference becomes an awkward email after the invoice.

  • Change prices in Shopify first, then regenerate the sheet from an export.
  • Date every version and say how long prices hold. Thirty or ninety days is common for seasonal ranges.
  • Don’t send one-off prices on a line sheet. A special price for one buyer belongs on their quote or draft order. B2B quotes with Shopify draft orders shows how, and order approval for sales reps covers who may agree to it.
  • Remove what you can’t ship. A buyer who orders a discontinued item from an old sheet is a buyer you have to disappoint.

Common mistakes

  • Cases instead of units. “Min 2” means two units to one person and two cases to another.
  • SKUs that don’t match Shopify. Every mismatch is a manual lookup when you enter the order.
  • One sheet for every buyer. If a distributor pays less than an independent shop, they need different sheets.
  • No ship dates on pre-orders. Buyers plan their floor space around them.
  • Prices with currency symbols in the cells. They stop the spreadsheet from doing arithmetic.

Where Repvoy fits

Repvoy doesn’t make line sheets. If your reps carry one to show buyers what to order, Repvoy can replace the part they order from: in the rep portal, each rep sees the catalog of the company location they’re ordering for, with that location’s prices, quantity rules and payment terms as Shopify charges them. Reps search by name or SKU, scan a barcode, or paste a list of SKUs and quantities, and Save for offline keeps the catalogs on the phone for trips without a signal. The order arrives in Shopify as a draft order. See B2B order taking, or how to take orders at trade shows for the whole routine.

Put your sales reps inside Shopify B2B

Start on the free plan with one rep. Upgrade when the team grows.