Customizing B2B pricing using catalogs

You can use catalogs to manage the products and pricing B2B customers have access to, and create multiple catalogs to tailor pricing and product availability to each of your B2B customers. After you create a B2B catalog, you can assign it to let B2B customers purchase the included products at the prices you set using catalogs. On the Basic, Grow, or Advanced plan, you assign catalogs to B2B markets. On the Shopify Plus plan, you can also assign catalogs directly to a company location.

In a blended store, adding a product to a B2B catalog doesn't automatically make it B2B-only. Region market catalogs control which products D2C customers can browse in each market.

To make a product available only to B2B customers, include it in your B2B catalogs and exclude it from every region market catalog. Keep it published to Online Store so B2B customers can browse it after they log in. Each D2C market needs an active region market catalog for these exclusions to take effect. Learn more about making products available only to B2B customers.

Before you begin

Before you create your catalog, decide which company locations should receive its products and prices. To use a B2B market, create or select a market that includes those locations. On the Shopify Plus plan, you can also assign the catalog directly to company locations after you create it.

For a walkthrough that includes company setup, market conditions, and catalog assignment, follow the B2B market and catalog setup steps.

Understanding price adjustments in catalogs

You can add overall price adjustments and fixed prices to products using catalogs. A catalog can contain both an overall adjustment and fixed prices for specific products. However, fixed prices override any overall adjustments that you set.

For example, your store sells candles with a base price of $10 USD each. You create a B2B catalog with a 20% price decrease, which sets the candle prices in that catalog to $8 USD. One candle costs more to produce, so you set a fixed price of $9 USD for that product. That candle's catalog price is $9 USD because its fixed price overrides the percentage decrease.

You can add quantity rules and volume pricing to products in a catalog to set certain quantity requirements or price breaks for B2B orders.

Create a catalog

You can add products and product variants to a catalog. You can also add gift cards to your catalog and allow B2B customers to add gift cards to their cart when placing orders.

To assign your catalog to a B2B market during creation, set up the market first. You can also assign the catalog after saving it.

If you want to schedule the catalog's status changes with a rollout, then assign the catalog to a B2B market. Catalogs assigned directly to company locations can't be added to a rollout.

Steps:

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Click Create catalog.

  3. In the Title field, enter a name for your catalog. This title isn't displayed to customers.

  4. Next to the Title field, select the catalog's status. Select Draft to prepare the catalog without applying its products and prices, or Active when you're ready to use it.

  5. Optional: To assign the catalog to a B2B market now, click Add a market, select the B2B market, and then click Done. You can also assign the catalog after saving.

  6. In the Pricing section, configure your pricing:

    • In Set prices in, select the currency for the catalog. Your market's currency settings determine the currency displayed to customers in your online store.
    • Optional: In Price adjustment, select Increase or Decrease, and then enter the percentage. To reduce your base prices for B2B customers, select Decrease.
  7. In the Products section, configure product availability and fixed prices:

    • By default, all products are included. To exclude products, select them, and then click Exclude from catalog.
    • Optional: To set a fixed price for all variants of a product, enter the price in the Price column for that product. A fixed price overrides the catalog's percentage adjustment for that product or variant.
    • Optional: To set fixed prices for specific product variants, do the following:
      1. Click the variant count under the product that you want to adjust.
      2. In the Price column, enter the price for each variant that you want to adjust.
  8. Optional: To include new products automatically, turn on Automatically include new products.

  9. Review the catalog's assignment and pricing, and then click Save.

When you're ready to use the catalog, make it Active and confirm that it's assigned to the company locations you want to sell to. If you use a B2B market, then make that market Active too. Then test the B2B and D2C pricing experiences.

Assigning a catalog to company locations

Each company location can have a maximum of 25 catalogs assigned to it. You can create a maximum of 10,000 total catalogs for your store.

You can assign catalogs to company locations from the Catalogs section of your Shopify admin, or in the company or locations profile.

Considerations for assigning multiple catalogs directly to companies

If you assign multiple catalogs to the same company location, then the following rules determine the price your B2B customers view on your online store:

  • If the catalogs include different products, then all products from each catalog are displayed.
  • If the catalogs assigned to the same company location include the same product at different prices, then your B2B store displays the lowest price for that item, not including quantity rules or volume pricing breaks. For example, you have a B2B customer with access to two catalogs. In one catalog, the price of a particular candle is set at $9 USD. In the other catalog, the price of that item is set to $7 USD. When the customer visits your store, they're offered that candle at a price of $7 USD.
  • Your store displays quantity rules and volume pricing from the catalog with the lowest price per variant.
  • If two catalogs have the same lowest price for a product, then the quantity rules and volume pricing from the first catalog that was created are displayed.

Considerations for assigning catalogs to a company location and to B2B markets

When you assign a catalog to a company location and the company location matches a B2B market that has a catalog assigned:

  • If the catalogs include different products, then all products from each catalog are displayed.
  • If the catalogs assigned to the company location and matching B2B markets include the same product at different prices, then your B2B store displays the most specific price for that item, and for the catalog assigned to the company location, including quantity rules or volume pricing breaks. For example, you have a B2B customer with access to two catalogs. In one catalog assigned to the company location, the price of a particular candle is $9 USD. In the other catalog assigned to the B2B market, the price of the candle is $7 USD. When the customer visits your store, the candle's displayed at $9 USD.

Steps:

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Click the catalog that you want to assign companies to.

  3. Under the Title, click Company location from the dropdown.

  4. Click Add a company location.

  5. Select the company locations that you want to add, and then click Done.

Update a catalog

You can update a catalog from your Shopify admin, or by using a CSV file to update a single catalog, or update catalogs in bulk.

Steps:

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Click the catalog that you want to edit.

  3. Make any necessary changes to your catalog.

  4. Click Save.

Add or remove products from your catalog

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Click the catalog that you want to edit.

  3. In the Products and pricing section, click Manage, and then click Manage products and pricing.

  4. Add or remove product from your catalog:

    • To remove products from your catalog, in the Included tab, select the products that you want to remove, click Exclude from catalog, and then click Exclude products.
    • To add new products to your catalog, in the Excluded tab, select the products that you want to add, click Include in catalog, and then click Include products.
  5. Optional: Adjust pricing for any of the products in your catalog, and then click Save.

Using catalog CSV files

After you create a catalog, you can export your pricing, publishing, and quantity rules data to a CSV file. You can then make changes to the CSV file and import the file to update the catalog.

For example, you have a catalog assigned to a company that opens a new location, so you create a new location for the company. Because the new location is farther and you include shipping in your prices, you need to increase your prices. You export your catalog for the original location and edit the prices using a spreadsheet program. You then create a new catalog, import the edited CSV, and assign the catalog to the new location.

Downloading a sample CSV file

You can download and view a sample catalog CSV file to use as a template.

The sample file contains example products and variants. If you use the sample file as a template, then make sure that you remove all the example products.

Description of the catalog CSV file

You can set compare-at prices in your catalog CSV file or in the Shopify admin. Learn more about creating catalogs.

This table lists the fields in the catalog CSV file.

The Catalog Title field must be filled. The Option1 Name and Option1 Value columns are required for all products, even those without variants. Products and variants in the catalog can also be identified with information in the SKU column. If the product doesn't have a SKU, then you must include the Handle in addition to the required option columns.

The Fixed Price field must be filled for the catalog import. If Fixed Price and Compare At are both blank, then the fixed price for that product or variant is removed from the catalog.

Description of columns in the catalog CSV file, including required fields and their purposes.
ColumnDescription
Catalog Title (required)The name of the catalog.
SKU

The SKU of the product or variant. The SKU is used to track inventory with inventory tracking services.

If the product you want to update has a SKU, then you can use it in place of other information in the CSV, such as Handle, Option1 Name, or Option1 Value.

Handle

Handles are unique names for each product. They can contain letters, dashes, and numbers, but no spaces, accents, or other characters, including periods. Handles are used in the URL for each product.

For example, the handle for a "Women's Snowboard" would be womens-snowboard, and the product's URL would be https://yourstore.myshopify.com/products/womens-snowboard.

Option1 Name (required)

Enter the name of the first option in this column. This field is required for all products, even those without variants. For products without variants, you can use Title as the option name. For products with variants, use the actual option name such as Color or Size.

Option1 Value (required)

Enter the value for the first option in this column. This field is required for all products, even those without variants. For products without variants, you can use Default Title as the option value. For products with variants, use the actual option value such as Black or Small.

Option2 NameIf a product has a second option, then enter its name in this column.
Option2 ValueIf a product has a second option, then enter its option value in this column.
Option3 NameIf a product has a third option, then enter its name in this column.
Option3 ValueIf a product has a third option, then enter its option value in this column.
Fixed Price

The price of the product or variant. Only include the price and don't include any currency symbols. For example, 9.99.

A blank field in both Fixed Price and Compare At removes the fixed price for that product or variant from the catalog.

Compare At

The Compare At price of the product or variant. Only include the price and don't include any currency symbols. For example, 9.99.

A blank field in both Fixed Price and Compare At removes the fixed price for that product or variant from the catalog.

You can use this field to display the product's original base price or MSRP (manufacturers suggested retail price) alongside the discounted price to highlight savings.

Published

To include a product in the catalog, enter TRUE in the Published column. To exclude a product from the catalog, enter FALSE.

You can only include or exclude products, and can't include or exclude specific product variants. Only the first row of the product variants are reviewed for this selection.

Quantity Increment

The number of items by which the variant can be purchased, when the variant only sells in multiples of a set quantity. This field restrict customers from buying a quantity that's not in multiples of the quantity increment.

To set quantity rules, you need to set a value of 1 or greater for both Quantity Increment and Minimum Order Quantity. The Maximum Order Quantity field is optional, and can be left blank.

If the values for Quantity Increment, Minimum Order Quantity, and Maximum Order Quantity are all blank for the same row, then the quantity rules for that product variant are removed.

Minimum Order Quantity

The fewest number of items of the variant that a customer can purchase at the same time.

To set quantity rules, you need to set a value of 1 or greater for both Quantity Increment and Minimum Order Quantity.

Maximum Order Quantity

The greatest number of items of the variant that a customer can purchase at the same time.

The Maximum Order Quantity field is optional, and can be left blank.

Quantity Break 1-10

The quantity threshold for volume pricing. You can add up to 10 quantity breaks, which need to match up with each related price break.

For example, if a customer orders 25 shirts (Quantity Break 1 value), then they pay 5.00 USD for each shirt (Price Break 1 value). If a customer orders 40 shirts (Quantity Break 2 value), then they would pay 3.50 USD for each shirt (Price Break 2 value).

To add volume pricing through a CSV, the Quantity Break value needs to be a whole number with a value of 1 or greater that's equal to or greater than the minimum order quantity, and you need to have a price break value in the same numbered Price Break field. Quantity breaks are optional, and can be left blank.

Price Break 1-10

The reduced price per unit that matches with each quantity break that you set up for volume pricing.

For example, if you want a customer to pay only $5.00 USD per shirt when they purchase 25 shirts or more, then the Quantity Break 1 value is 25, and the Price Break 1 value is 5.00.

When you enter the price in a Price Break field, only include the price. Don't include any currency symbols. For example, 9.99. Price breaks are optional, and can be left blank.

Export and import catalogs using CSV files

You can export and import catalogs individually or in bulk using CSV files.

Export a catalog

When the export is complete, the CSV files are sent to you in an email.

Only prices for products with fixed prices are included in the exported catalog. Prices for products with a percentage adjustment aren't included.

To update a product variant in a catalog by using a CSV upload, enter the new information in one of the following column options:

  • the SKU column
  • the options and values columns, such as Option1 Name and Option1 Value

The Published column doesn't affect individual variants.

Export a single catalog

Export a single catalog from your Shopify admin.

Steps:

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Click an existing catalog to export a list of your products with price adjustments applied.

  3. Click Manage, and then select Export CSV.

  4. Select one of the following to choose which products to export:

  • All products
  • Only included products
  • Only products with fixed prices
  • Only products with quantity rules
  1. Select the format of the CSV file.
  2. Click Export CSV.

Export multiple catalogs in bulk

Export multiple catalogs in bulk from your Shopify admin.

Steps:

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Select the catalogs that you want to export.

  3. Select one of the following to choose which catalogs to export:

  • Current page
  • Selected catalogs
  1. Select one of the following to choose which products to export:
  • All products
  • Only included products
  • Only products with fixed prices
  • Only products with quantity rules
  1. Select the format of the CSV files.
  2. Click Export CSV.

Import a catalog

Depending on the size of the catalog, importing might take some time to complete. A notification indicates when the import is complete. You can update a single catalog or update multiple catalogs in bulk.

Update a single catalog

Update an existing B2B catalog by importing a CSV file.

Steps:

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Click the existing catalog that you want to update.

  3. Click Adjust prices, and then select Import CSV.

  4. Click Add file, or drag and drop your files to the dialog to upload.

  5. Click Preview Import.

  6. Review the preview to verify that your columns and data are correct, and then click Import CSV.

Update multiple catalogs in bulk

Update multiple catalogs in bulk by importing a CSV file.

Steps:

  1. From your Shopify admin, go to Markets > Catalogs.

  2. Click Add file or drag and drop your file to the dialog box to upload.

  3. Click Preview import.

  4. Review the preview to verify that your columns and data are correct, and then click Import CSV.

  5. Optional: Click Close to continue working during the time the import is processing.

Make products available to B2B and not D2C in a blended store

In a blended store, you can make certain products available only to B2B customers in your online store.

First, make sure each D2C market where you sell has an active region market catalog, either assigned to that market or inherited from a parent market. Without an applicable region market catalog, the market uses the products published to Online Store by default. The products can therefore still be available to D2C customers in that market.

Then include the B2B-only products in your B2B catalogs and exclude them from all region market catalogs. Keep those products published to Online Store so that B2B customers can browse them after they log in.

Follow the B2B-only product publishing steps to check your region market catalogs and update product publishing. Afterward, test both the B2B and D2C experiences.

Example

Your blended store sells individual candles and cases of 24 candles as separate products. You want to offer individual candles to both B2B and D2C customers, but cases of 24 candles only to B2B customers.

Your store has active United States and Canada region markets. Both products are active and published to Online Store. You use the following active catalogs:

  • A region market catalog that includes individual candles and excludes the case of 24 candles. You assign this catalog to both the United States and Canada region markets.
  • A B2B catalog that includes both products. You assign this catalog to an active B2B market with a Company locations condition and Include all existing and future locations in all regions turned on.

A customer who logs in to shop for a company location included in the B2B market can browse both products. D2C customers in the United States and Canada can browse individual candles, but not the case of 24 candles.

If you later remove the region market catalog from the Canada market and that market doesn't inherit another region market catalog, then the candle case can become available to D2C customers in Canada. To keep the case available only to B2B customers, both D2C markets need a region market catalog that excludes it.