Working with the import template

The Admin Console provides a unique template for the various import record types, such as Products, Customers, and Categories. The Microsoft Excel based templates are used to create the respective records and then import the data into the Admin Console.

To access the Optimizely import template, go to Catalog > Products > Import > Download Template. You can also access this template from the Categories or Users import pages.

The spreadsheet has several rows of information:

  • The header row (color coded- see the requirements below) of each column in the template contains the field name associated with the corresponding field within the Admin Console.
  • The second row states whether the data is required.
    • Required (green)- This field is a category data point necessary within B2B Commerce
    • Recommended (yellow)- This field is recommended, but not necessary to create a viable record in B2B Commerce
    • Optional (white)- This field is optional based on the configuration of B2B Commerce features
  • The third row contains a brief description of the field and any necessary instruction.
  • The remaining 3-4 rows contain sample data.

Prior to performing an import with a template, there are two important steps to complete:

  1. All the cells in the template must be formatted as text in order to upload successfully.
  2. All informational/sample rows, with the exception of the top row (column headers), should be removed.

If importing the Name field of the Product is desired, the base values in the Application Dictionary need to be overridden.

  1. Go to Admin Console > System > Application Dictionary.
  2. Search for Product.
  3. Click the Properties finger tab.
  4. Search for Name.
  5. Select Yes for Can Edit.

Once overridden, the Name column can be added to the import spreadsheet and the values can be populated.

Including Multiple Product Images in an Import

The Product import template includes several image columns:

  • ProductImage1.Small Image - Optional
  • ProductImage1.Medium Image - Required
  • ProductImage1.Large Image - Optional
  • ProductImage1.Alt Text - Recommended
  • ProductImage1.Name - Optional

If the column names do not include the numeral 1 in the naming convention, the import will assume the unnumered image data is the first in the sequence. If there is both unnumbered image data and image data that has the number 1 association, the number 1 will overwrite the unnumbered image data.

To import more images, you would need to add additional columns maintaining the same naming conventions. These columns need to be in sequential order, however, they can omit numbers. For example, if you were wanting to replace images 1 and 3, and keep image 2 as is, you would just skip the image 2 data.

For information on the actual import/export process, refer to the Importing and Exporting Data article.