Creating and managing B2B catalogs

You can control the availability of products and their pricing with catalogs to provide a tailored buying experience to different companies you sell to. After you create a B2B catalog, you can assign it to a company location to let B2B customers purchase the included products at the prices you set using catalogs.

You can decide which products to include and exclude in a catalog. For example, if you operate a blended store, then you can include products that you sell only to B2B customers and exclude products that you sell only to D2C customers.

If you want to make certain products available only to B2B customers and not D2C customers, then you can unpublish your product from your online store and other sales channel. If your product is still included in a catlaog, then it will still display to your B2B customers.

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 at $10 USD each. You create a B2B catalog and enter -20% in the Overall adjustment field, which reduces the price of your candles to $8 USD for companies with access to the catalog. One candle costs slightly more to produce, so you set a fixed price of $9 USD for that product. When a customer with access to the catalog visits your store, they're offered your products at $8 USD ,except for the candle that you entered a fixed price for. The fixed priced candle isn't affected by the overall adjustment, and is offered at $9 USD.

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

Considerations for assigning multiple catalogs to a company location

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.

Create a catalog

Steps:

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

  2. Click Create catalog.

  3. Add products to your catalog

    1. To include all of your products in the catalog, select All products, and then click Continue.
    2. To include only some products in the catalog, select Specific products, and then click Continue.
  4. In the Title field, enter a title for your catalog. The title that you create isn't displayed to customers.

  5. Optional: In the Currency section, click Change to select a currency for your catalog.

  6. Optional: To automatically include new products to this catalog, select Automatically include new products in this catalog.

  7. Click Save.

  8. Optional: If you selected Specific products when you created your catalog, then do the following to add products to your catalog:

    1. In the Products and pricing section, click Manage, and then click Manage products and pricing.
    2. Select the products that you want to add to the catalog, and then click Include in catalog.
    3. Click Include products.
    4. Click Save, and then go back to your catalog.
  9. Set price adjustments for your products by doing any of the following:

    • To set price adjustment that applies to all products within a catalog, from the Overall adjustments drop-down menu, select Price increase or Price decrease to increase or decrease the product price, and then enter a percentage value.
    • To set a fixed price for all of the variants of a product, do the following:
      1. In the Products and pricing section, click Manage, and then click Manage products and pricing.
      2. In the Price column, enter the price that you want to charge for each product.
      3. Click Save, and then go back to your catalog.
    • To set a fixed price for specific product variants, do the following:
      1. In the Products and pricing section, click Manage, and then click Manage products and pricing.
      2. Click the variant link under the product that you want to adjust.
      3. In the Price column, enter the price that you want to charge for the specific variants.
      4. Click Save, and then go back to your catalog.
  10. In the Status drop-down menu, select Active.

Assign a catalog to company locations

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

Steps:

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

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

  3. In the Company location section click the Edit icon.

  4. 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 Products > 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 Products > 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

This table lists the fields in the catalog CSV file.

The Catalog Title field must be filled. Products and variants in the catalog can be identified with information in the SKU column. If the product doesn't have a SKU, then the product or variant must have identifying information such as Handle, Option1 Name, and Option1 Value.

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 the items in the catalog export CSV.
ColumnDescription
Catalog TitleThe 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 NameIf a product has an option, then the option name is listed in this column. For example, Color.
Option1 ValueIf a product has an option, then the option value is listed in this column. For example, Black.
Option2 NameIf a product has a second option, then the option name is listed in this column.
Option2 ValueIf a product has a second option, then the option value is listed in this column.
Option3 NameIf a product has a third option, then the option name is listed in this column.
Option3 ValueIf a product has a third option, then the option value is listed 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 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 Products > 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 Products > 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 Products > 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 Products > 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.

Can’t find the answers you’re looking for? We’re here to help.