A wholesale price list is the single source for what each product costs a trade buyer, at each quantity. Build it once in a spreadsheet, then load it into Shopify so quotes and orders use the same numbers. This guide covers both steps.
Build the list in a spreadsheet first
Start outside Shopify. One row per variant keeps the list easy to check and easy to import later. Work out each price from your own unit cost, not from a discount you picked at random.
- SKU: One row per variant
- Unit cost: Product, packaging and handling
- Retail price: What the product sells for in your store
- Wholesale price: The base trade price
- Minimum: The smallest quantity you will accept
- Price breaks: The quantity and unit price for each tier
Choose how prices are set
In Shopify B2B, a catalog decides which products and prices your B2B customers can access. Shopify's catalog documentation describes two ways to set prices, and they can be combined.
| Method | How it behaves |
|---|---|
| Overall percentage adjustment | Raises or lowers every product price in the catalog by one percentage |
| Fixed prices | Set per product or variant, and override the overall adjustment |
A percentage is quick to set up. Fixed prices take longer but let you protect margin on products where a flat discount does not work.
Add minimums and volume pricing
Catalogs can also hold quantity rules and volume pricing. Shopify applies both per variant, so a buyer cannot combine variants to reach a minimum or a price break.
- Quantity rules: A minimum, a maximum and an increment for each variant
- Volume pricing: Up to 10 price breaks per product
- Fixed after breaks: Once a product has volume pricing its price is fixed, and the catalog's overall adjustment no longer applies to it
- Break quantities: Must be greater than the minimum order quantity
Shopify says you can add these in the catalog or by importing a CSV, which is where your spreadsheet pays off.
Assign the list to buyers
To use Shopify B2B, you set up your wholesale customers as companies. How a catalog reaches them depends on your plan, so check your plan before you design your price levels.
- Basic, Grow and Advanced: Shopify says catalogs are assigned to B2B markets, with up to 3 active catalogs across all B2B markets
- Plus: Shopify lists unlimited catalogs and direct assignment to a company or location
- Overlap: If a product has several prices from different catalogs, the lowest price displays to the customer
Keep one version
A price list fails when there are two of them. Decide which copy is the master and update the other from it.
- ✅ Date every version of the spreadsheet
- ✅ Recheck prices when your costs change
- ❌ Do not quote from memory once the list exists
- ❌ Do not leave an old price sheet in circulation with buyers
Doing this at scale
QuoteWeaver prices each line of a buyer's request against your B2B list, including volume breaks, MOQ and the next-break upsell. It builds the Shopify draft order and a drafted reply, and it never invents a SKU or price. See QuoteWeaver.