Importing products using the import template

This reflects the product number and also acts as the primary key for the product record

This represents the URL used to reference the product detail page on the website

This is the short description or "web friendly" title of the product used in default search, and product list pages (if you include HTML entity codes in the title, for example for trademark and registration symbols, these will be decoded on import)

This represents the longer, HTML friendly description of the product

This is the default unit of measure

Used if utilizing the multiple unit of measure, this field reflects how many individual items are in the default unit of measure. (10 packs in 1 box)

This field is rendered on product list and detail widgets A pre-configured content holder ISC_Content user roles may use to add content to website pages without having to develop page elements. and is also searchable

This field manages rounding and can be assigned a value of; Round, RoundUp, NoRounding, MultipleOnly, Truncate

This field represents a product quantity needed to order to purchase

This field is used when the Request for Quote feature is enabled. 1/0 or Yes/No indicate if the product must be quoted. Default value is No.

This field is used for complex pricing models

Used for standard pricing when the price matrix is not used

Used for sale pricing during specific sale dates

Used to indicate when a sale starts

Used to indicate when a sale ends

Date the product is available to order

Date the product is no longer available to order

Typically used to indicate the product is tax exempt

The relative path to the small image, used in the search thumbnail

The relative path to the medium image, used in list pages

The relative path to the large image, used in detail pages

Alternate text used for accessibility and search engine optimization

Used to reflect if this product inventory is tracked; 1=true, 0=false

1=true if product is managed via integration framework. 0=false if product is managed within B2B Commerce

This field reflects the shipping weight for real time freight calculations

This field is used when the Variant Product feature is used for this product. Adding a value to this field will either; assign an existing variant type to the product, or create a new variant type and assign it to the product. This field is for the variant parent only.

This field is used to point variant children to the Product Number of the parent

This column will assign the variant trait x. If the trait x does not exist, it will be created. To assign multiple variant traits to the product, create additional columns in the import spreadsheet.

This field allows assigning the product record to a category. Multiple categories can be included and separated by commas. The schema is website:category1,website:category2:category2b

This column represents x as an attribute type. The corresponding field is for the attribute value assigned to the product. Multiple attribute types and values can be assigned by created by adding additional columns.

This represents a comma separated list of product numbers of related products that show in a carousel on the product detail widget

This represents a comma separated list of product numbers of related products. To render these related products, custom coding needs to be done.

This column represents the first specification tab, where x notes the name of the tab.