Revenue Systems · The Journal

Build a wholesale line sheet in an afternoon

The document a buyer needs before she can order from you. Spreadsheet first, PDF second, five steps.

By Anne Reyes · · 7 min read

Wholesale is the revenue channel most direct-to-consumer brands never open, and the reason is almost always the same. A buyer says send me your line sheet, and there isn't one.

So the brand sends a lookbook, or a link to the website, or a folder of photos. All three get ignored, because none of them let the buyer do the one thing she opened the email to do, which is work out whether she can make money on your product and how small an order she can start with.

Below is a line sheet built end to end, with every prompt written so you can paste it and fill in your own product. It takes an afternoon, and the only file you need before you start is a folder of photos you almost certainly already have.

Finished wholesale line sheet page showing six womenswear looks in a three by two grid on white, each with style name, style number, fabric, colorway, size run, wholesale price and retail price

The finished sheetSix looks a page, wholesale price first, retail second.

What is inside What a buyer is actually looking for, in four questions. The five steps, each one a single message you can copy. The five prompts, with brackets to fill in for your own brand. And the check that catches pricing errors before a buyer does.

What do you need before you start?

Less than you think. Three things, and you probably have two of them already.

  1. One photo per style, in one folder. Full product, shot the same way every time, on a plain background. Your existing product page images are usually fine. They do not need reshooting.
  2. Your retail prices. The numbers already on your website.
  3. Your costs. Not for the sheet, but so you can tell whether you can survive selling at half.

You do not need a designer, a template, or a subscription to line sheet software. You need Claude and an afternoon.

One thing to sort out before anything else. Wholesale means a store buys your product at roughly half of what it sells for. That is the standard, it is called keystone, and it is not negotiable in most categories. If your margin cannot survive being halved, the line sheet is not your problem and building one will not help. Work that out first.


What is a buyer actually looking for?

Four things, in this order. She is not browsing. She is answering questions.

  1. Will this sell in my store? The photograph answers this, and only the photograph.
  2. What does it cost me and what do I make on it? Wholesale price and retail price, side by side.
  3. When does it land? A delivery window with real dates.
  4. How little can I commit to? Your opening order minimum.

Every element on the page earns its place by answering one of those four. If it does not, take it off. That single rule is what separates a line sheet that gets ordered from a deck that gets closed.


The five steps

In order. Each one is a single message to Claude.

Step oneHand over the photos and let Claude interview you

Do not start by describing what you want. Start by letting Claude find out what it is missing. The questions it asks are the fields a buyer would have asked you for anyway, and it is much cheaper to answer them now than to discover a blank column at the end.

Prompt one, the interview
I sell [what you sell] and I want to open wholesale for [season, for example Holiday 2026]. My look photos are in the folder I just gave you, one per style. Before you build anything, ask me every question you need answered to make a line sheet a buyer can order from. Ask a few at a time, not all at once. Do not guess a price, a fabric, or a size run. If I do not know an answer, leave that field blank and tell me it is blank.
Returns a short list of questions · about two minutes · costs nothing

Step twoBuild the spreadsheet, before any design exists

This is the step that decides whether the whole thing works, and it is the one people skip because a spreadsheet is not the exciting part. The spreadsheet is the record. The PDF is only a picture of it.

Prompt two, the spreadsheet
Build the spreadsheet first, before any design. One row per style, with these columns: style number, style name, fabric, composition, colorway, size run, wholesale price, retail price, markup. Set wholesale at half of retail. Work the math out yourself and recompute every row before you show me. Do not carry a number over from anything I typed. Add a totals row: number of styles, total wholesale, total retail. Save it as an .xlsx file I can open in Excel.
Returns one .xlsx file · under a minute · costs nothing

Ask for the math to be recomputed rather than copied. It sounds like a small distinction. It is the difference between a sheet with one wrong price on it and a sheet without one, and a buyer who finds a pricing error stops trusting every other number on the page.

Step threeAdd your terms, and have them argued with

Terms are where most first line sheets fall apart, usually because the numbers on them have never been tested against each other. An opening minimum of five thousand dollars means nothing if your smallest sensible order comes to two.

Prompt three, the terms
Now add my terms. Ask me for anything you do not already have, then put them in one block at the end of the sheet: opening order minimum, reorder minimum, minimum units per style, payment terms, where it ships from, order cutoff date, delivery window, and whether I give a store any territory protection. Then tell me plainly if any of these do not add up against each other. For example, if my smallest sensible order comes to less than my stated opening minimum, say so.
Returns an updated .xlsx and a list of anything inconsistent · two minutes · costs nothing
Line sheet cover page with the season name, collection totals for styles, wholesale value, retail value and markup, and a full length product photograph on the right

The coverSeason, totals, delivery window. A buyer knows the size of the decision before page two.

Line sheet final page showing four products in a row above an opening order table and a bordered terms block listing minimums, payment terms, shipping point, order cutoff and delivery window

The terms pageMinimums, payment, cutoff, delivery. Everything she needs to say yes.

Step fourTurn the spreadsheet into the PDF

Now, and only now, the design. Notice that the prompt tells Claude to read the numbers from the file rather than retype them. That instruction is doing real work.

Prompt four, the PDF
Now build the PDF from that spreadsheet. Do not retype any number. Read every figure from the file. Pages: a cover with the season and the collection totals, then the styles at six per page maximum, then the terms block on the last page. Under each photo, in this order: style name, style number, fabric and colorway, size run, then wholesale price first and retail price second. White background, black type, no accent color, no borders around the photos. The products are the only color on the page. Give me the PDF and leave the spreadsheet exactly as it is.
Returns one PDF, spreadsheet untouched · two to three minutes · costs nothing

Wholesale price first and retail second is not a style preference. The buyer reads left to right and the first number she needs is her cost. Making her hunt for it is a small friction, and small frictions are what turn a maybe into a no reply.

Close view of two line sheet entries showing style name, style number, fabric and colorway, size run, and the wholesale price set larger and first with the retail price second in grey

The caption block, up closeWholesale in black and first. Retail in grey and second.

Step fiveHave it read back to you as the buyer

You cannot proofread your own line sheet, because you already know what everything means. So have it read cold, by someone with ninety seconds and no patience.

Prompt five, the buyer check
Read this PDF back to me as if you were a wholesale buyer with ninety seconds and forty other line sheets to get through. Answer these four in order, and tell me which ones my sheet fails: 1. Will this sell in my store 2. What does it cost me and what do I make on it 3. When does it land 4. How little can I commit to Then check three things and show me the results rather than telling me it passed: every wholesale price is exactly half its retail price, every style number matches its photo, and the delivery window falls after the order cutoff date.
Returns a pass or fail against each check · under a minute · costs nothing

Ask to be shown the results, not told they passed. It is a habit worth building into every prompt where a number matters.


What makes the difference?


What does this replace?

A freelance designer builds a line sheet for somewhere between a few hundred and a couple of thousand dollars, and the real cost is not the invoice. It is that you have to go back to them every time a price moves, a style sells out, or a season turns over. So most brands build one, let it go stale, and quietly stop pitching stores.

Owning the spreadsheet is what breaks that. Prices change, you edit a cell and regenerate. A buyer asks for a version without the eveningwear, you have it in a minute. The document stops being a project and becomes a file, which is the only form in which it stays current.

One honest limit. A line sheet gets you considered, it does not get you stocked. What gets you stocked is a product a buyer believes her customer will pay for, at a price that leaves her a margin. The sheet's whole job is to make that judgment easy to make. It cannot make the judgment come out in your favor.


What is a wholesale line sheet?

It is the order form a buyer works from. One page per group of products, each style shown with a photograph, a style number, the fabric, the colorway, the size run, what it costs her wholesale and what she sells it for. At the end sits a block of terms: your minimums, your payment terms, and when the goods land. It is not a lookbook and it is not a campaign. A lookbook makes a buyer want your brand. A line sheet lets her write the order without emailing you a single question.

What do you put on a wholesale line sheet?

Everything a buyer needs to answer four questions, and nothing else. Will this sell in my store, which the photograph answers. What does it cost me and what do I make on it, which the wholesale and retail prices answer. When does it land, which the delivery window answers. How little can I commit to, which the minimums answer. If an element on the page does not serve one of those four, take it off. Brand story, mission statements and lifestyle photography all belong somewhere else.

How do you price wholesale?

The apparel standard is keystone, which means the retailer doubles your price. Your wholesale price is half of the retail price, so a dress that sells for 348 dollars in a store is 174 dollars to the buyer. Some categories run higher multiples and some buyers ask for more than keystone, but half is the number to start from and the one a buyer expects to see. The important part is that you can still make money at half, because that is the price your business now runs on.

Should a line sheet be a PDF or a spreadsheet?

Both, and in that order. Build the spreadsheet first, because it is the record. It holds every style, price and size run, it is what you edit next season, and a buyer's operations team can filter and reorder from it. Then generate the PDF from that spreadsheet, because that is what actually gets emailed and looked at. If you design the PDF first you end up retyping numbers into a layout, and retyped numbers are where pricing errors come from.

How many products should go on one page of a line sheet?

Six, and never more than six. A buyer is looking at dozens of line sheets and gives yours about ninety seconds. Six looks to a page leaves enough white space that her eye keeps reading. At seven she stops reading and starts skimming, and a skimmed line sheet does not turn into an order. If you have thirty styles, that is five pages, and five clean pages beat three crowded ones every time.

The line sheet shown on this page was built as a demonstration using Reformation's publicly published product photography and retail prices. Reformation is not a client of mine and I am not affiliated with the brand. The wholesale prices, minimums and trade terms on the example are illustrative and are not Reformation's.

Anne Reyes, brand strategist and founder of Brandworks Studios
About the strategist

Anne Reyes

Brand & AI strategist · Founder, Brandworks Studios

17 years building brands, and I scaled my marketing agency to 7 figures within 2 years, with clients including Amazon, Pier 1, and Dressbarn. I now build AI marketing systems for e-commerce brands through BAIBE, the Brandworks AI Brand Engine. AI does the production. Taste directs it.

Keep going

Want the next build?

The Chic Strategist breaks down a new AI marketing system every week. Or bring your brand to a strategy call and we'll build it together.

← All the free guides