Importing Catalogs

Updated on 20-October-2016 at 10:16 AM

Business Catalyst End of life announcement - find out more details.

This article describes how you can setup your CSV file to bulk import your Business Catalyst catalogs.

The first step is to download the Import Template file. To do this, select E-Commerce > Catalogs, and then click Import Catalogs.

Click Download Import Template.

Open the template file. There are two sheets available, an overview/introduction and the import sheet (sheet 1).

Note: Delete all the sample data content (rows 2-29), leaving the column headings (row 1) in place.

Populate the columns with your catalog information. Once you have finished populating the spreadsheet, Save the spreadsheet as a .csv or .tab file. Back on the Business Catalyst page, click the Browse button and select the .csv or .tab file on your computer, then click Import.

Below is a description of each field:

  • Catalog Name/Hierarchy
    Enter the parent catalog(s) separated by a forward slash followed by the sub-catalog name, e.g. /Shoes/Men's Shoes. If a catalog or sub-catalog does not exist it will automatically be created.
    On each line the catalog name on the right represents the current line, e.g. /Shoes/Men's is representing the catalog Men's which is a sub-catalog of Shoes.
    Your catalog hierarchy can be as many levels deep as you like. If a parent catalog does not exist it is automatically created, e.g. catalog Shoes is automatically created when the Men's catalog is created. If you make mistakes in the catalog name or hierarchy you can edit or delete it using the Administration interface
  • Description
    Catalog description. The content in this field can be displayed on the catalog layout using {tag_description}.
  • Image
    Path of the uploaded catalog image.
    Example format:
    /Images/MenShoes.jpg
  • Weighting
    By specifying a weighting in number format for each item, you can specify the order in which items are displayed on your website. A higher weight is displayed first.
  • Release Date
    When you set a release date for your catalog, it will not be visible to any customer until the release date is reached. At that time it will automatically appear on your website. This feature is useful for seasonal catalogs such as a Christmas catalog.
  • Expiry Date
    When you set an expiry date for your catalog, it will be automatically removed from your website when the expiry date is reached. This feature is useful for seasonal catalogs such as a Christmas catalog.
  • Template ID
    The default site-wide template is assigned to imported catalogs . Enter -1 to assign no site-wide template.
  • Enabled
    You can import a catalog but have it disabled so that it does not display on your site. Enter Y for enabled and N for disabled..
  • Enable XML Feed
    You can configure the system to include the products within this catalog in your site's Product XML feed. You can use this feed to add your products to 3rd party systems including affiliate networks.
    Enter Y to enable, and N to disable
  • Show Product Prices
    By default when a customer views the products in this catalog he will be able to see the product prices. You can however set to hide prices for any non-customers. The default value for this column is 1, you can set it to 2 to hide prices for non-customers. For more details, see Set up wholesale purchases on your online store .
  • Catalog Title
    If you leave this empty then the catalog name will be used as the title of the catalog page. Alternatively if you want to use a different title than the name of the catalog, enter it here.
  • Browse Panel Min Price
    The minimum price used for price brackets in the browse panel. You should set this price to be indicative of the lowest priced product in this catalog. See Displaying a catalog browse panel .
  • Browse Panel Max Price
    The maximum price used for price brackets in the browse panel. You should set this price to be indicative of the highest priced product in this catalog. See Displaying a catalog browse panel .
  • Browe Panel Slots
    The total number of price slots in the browse panel. For example if you set a minimum price of $10 and a maximum price of $110 with 10 slots, then the price brackets shown in the browse panel will be $10-$19, $20-$29, $29-$30 and so forth. Each slot will display the number of products in the catalog that fall within that price bracket. See Displaying a catalog browse panel .
  • SEO Friendly Name
    Mandatory column. Enter a SEO friendly name, i.e no special characters or spaces in the name.

Note: For the best experience using Business Catalyst we recommend creating a maximum of 20000 catalogs. For more details please see the Business Catalyst system limits .