Wholesale Line Sheet template reference
The wholesale line sheet is the document you send retail buyers before a season. It opens with a cover page (logo, title, season, terms, contact), then prints every style with its photo, variant grid, wholesale price, MSRP and ordering rules, grouped into collections.
You make it with Line sheet on the Products list or on a catalog under Listings › Catalogs, by choosing PDF line sheet. See Make a wholesale line sheet. You edit its layout under Settings → PDF Templates, where its type is Wholesale Line Sheet. The Excel order form doesn't use this template.
What makes it different
It's built from a list, not one record. The line sheet prints whichever products you chose in the dialog: your selection, the current filters, a saved view or a catalog. One sheet carries up to 1,000 styles and 5,000 variants.
It has three levels of loops. Collections hold styles, and each style holds its variants. A collection is a category, a brand, or a catalog's category rule, depending on Group products by. With No grouping there's one collection with no name, so wrap the heading in Has Name.
Prices are formatted, with the currency symbol. A price prints as $14.00, or with the currency code in front for currencies without a symbol. A missing price prints —. At style level, a price prints as a range, such as $12.00 – $14.00, when the variants differ.
One template prints both layouts. The dialog's Layout choice turns on List Layout or Grid Layout, and the stock template has a block for each.
What you can print
Store
Under Store: Store Name, Store Logo (HTML img) and Store Address, as a ready-made block or in parts. The store is your default store.
Cover page
Under Cover page, the sheet-level fields. Most come from the Cover page section of the dialog:
| Field | What it prints |
|---|---|
| Title | The dialog's Title. Left empty, it's your store name followed by "Wholesale Line Sheet". |
| Season | The dialog's Season, for example SS27. |
| Prepared For (customer) | The company name, or else the name, of the customer picked in For customer (optional). |
| Date | The day the sheet was made, for example Nov 17, 2026. |
| Currency | The currency code of every price, for example USD. |
| Payment Terms | The dialog's Payment terms, or else the chosen customer's payment terms. |
| Order Minimum | The dialog's Order minimum. |
| Availability / Ship Window | The dialog's Ship window. |
| Terms (plain text) | The dialog's Terms, on one line. |
| Terms (with line breaks) | The same terms, keeping the line breaks you typed. |
| Contact | The dialog's Contact, or else your store's contact details. |
| Paper Size (letter / a4) | The dialog's Paper. The stock template feeds it to the paper-size tag, so the PDF prints on the size you picked. |
| Style Count | How many styles are on the sheet. |
| Variant Count | How many variants are on the sheet. |
Collections
Under Collections, inside the collection loop:
| Field | What it prints |
|---|---|
| Collection Name | The category, brand or catalog rule name. Products that fit no group go in Other. |
| Styles in Collection | How many styles the collection holds. |
And the switch Has Name.
Styles
Under Styles, inside each collection:
| Field | What it prints |
|---|---|
| Style SKU | The SKU of the matrix product, or of the standalone product. |
| Style Name | Its name. |
| Brand | Its brand. |
| Short Description | Its portal description, or else its description, as plain text cut at 300 characters. |
| Image URL | The address of its main image, or else its first image, or else its first variant's main image. |
| Wholesale Price (or range) | Its wholesale price, or the range across its variants. |
| MSRP (or range) | Its MSRP, or the range across its variants. |
| Ordering Rules (MOQ, increment, case pack) | For example MOQ 6 · Increments of 6 · Case pack 12, when every variant has the same rules. Blank when none is set or they differ. |
| Variants in one line | Every variant's options in one line, for example Black · White. |
| Variant Count | How many variants the style has on the sheet. |
| Units Available (all variants) | Units available across its variants. |
Per-style switches: Has Image, Has Description, Has Wholesale Price, Has MSRP (and MSRP shown), Has Shared Ordering Rules, Rules Differ Per Variant, Has Option Columns, Has Variant Grid, Show Units Available and Is Out of Stock (every variant).
Option Columns is a loop inside the style, with one Option Name per option, for example Color, then Size. Use it for the variant grid's headings.
Variants
Under Variants, inside each style:
| Field | What it prints |
|---|---|
| SKU | The variant's SKU. |
| Name | Its name. |
| Options (Black / M) | Its option values joined with /, or its name when it has no options. |
| Wholesale Price | Its wholesale price. |
| MSRP | Its MSRP. |
| Units Available | Units available to sell, across all warehouses. |
| Ordering Rules | Its own MOQ, increment and case pack, only when the style's variants disagree. |
Option Values is a loop inside the variant, with one Option Value per option column, in the same order as Option Columns. And the switch Is Out of Stock.
The sheet-level switches
Under Conditional Flags:
| Switch | What it's for |
|---|---|
| Has Products | Whether the sheet has any collections. The stock template prints No products on this line sheet. in the inverted branch. |
| Has Season, Has Customer, Has Payment Terms, Has Order Minimum, Has Availability Note, Has Terms, Has Contact | Whether that cover field has a value. Wrap each cover line in its switch, so an empty field doesn't print a bare label. |
| Show MSRP | Whether Show MSRP was checked in the dialog. |
| Show Units Available | Whether Show units available was checked. |
| List Layout / Grid Layout | Which Layout was picked. |
What the stock template contains
- Cover page: the store logo, or the store name when there's no logo, then the title, the season, and "Prepared for customer · date" (or the date alone). Then a table with Prices in (the currency, and "with suggested retail" when MSRP is shown), Payment terms, Order minimum, Availability and Styles (N styles · N SKUs), then Orders & questions with the contact, then the terms. The cover is a page of its own.
- List layout: a heading per collection, then one style per row: the photo (or a No photo box) on the left, and the name, SKU, description, Wholesale and MSRP prices, ordering rules and the variant grid on the right. The grid has one column per option (or Variant), then SKU, Wholesale, MSRP, Available and Ordering when they apply.
- Grid layout: three compact cards per row under each collection heading, with the photo, name, SKU, prices, variants and stock.
- Stock: with units shown, a sold-out variant prints Out of stock instead of a number.
- Page breaks: a style never splits across two pages, and a collection heading never sits alone at the bottom of a page.
The AI assistant in the editor offers starter prompts for this type, such as adding a "how to order" block with the order minimum and payment terms, starting each category on a new page, or showing the wholesale price large with the MSRP beside it.
When you preview the template, it uses a sample product as a one-style sheet.
Which template prints
The line sheet uses the Wholesale Line Sheet template of your default store: that store's own version if it has one, otherwise the global template. See How PDF templates work.
If there's no Wholesale Line Sheet template at all, the line sheet fails with "No wholesale line sheet template is configured. Add one under Settings → PDF Templates." Every account starts with one, so this only happens when it has been deleted.
Next steps
- Make a wholesale line sheet: build the sheet and send it to buyers.
- Edit a template: change the layout.
- Closeout Linesheet template reference: the photo grid for clearing discontinued stock.
- Variables reference: how to read the Variables list.