Dev GuideAPI Reference
Dev GuideAPI ReferenceUser GuideGitHubNuGetDev CommunitySubmit a ticketLog In
GitHubNuGetDev CommunitySubmit a ticket

Import products

Describes how to import products using the import template in Optimizely Configured Commerce.

Using the import template is a quick way to take existing product data and bring it into Optimizely Configured Commerce. The template is pre-populated with data columns which represent the many product fields in Configured Commerce.

📘

Note

The template spreadsheet must have the cells formatted as text in order to upload properly in Configured Commerce.

The template columns are broken down into the following groups:

  • Required - These fields is a product data point that is necessary within Configured Commerce
  • Recommended - These fields is recommended, but not necessary to create a viable product in Configured Commerce
  • Optional - These fields are optional based on the configuration of Configured Commerce features

The table below represents the columns in the template:

ColumnGroupDescription
Product NumberRequiredThis reflects the product number and also acts as the primary key for the product record
URL SegmentRequiredThis represents the URL used to reference the product detail page on the website
Product TitleRequiredThis is the shortened"web friendly" title of the product used in default search, and product list pages
CurrentDefaultContentRecommendedThis represents the longer, HTML friendly description of the product
Unit of MeasureRecommendedThis is the default unit of measure
Pack DescriptionOptionalUsed 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)
Manufacturer ItemOptionalThis field is rendered on product list and detail widgets and is also searchable
Rounding RuleOptionalThis field manages rounding and can be assigned a value of; Round, RoundUp, NoRounding, MultipleOnly, Truncate
Multiple Sale QtyOptionalThis field represents a product quantity needed to order to purchase
Quote RequiredOptionalThis 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.
Price CodeOptionalThis field is used for complex pricing models
Basic List PriceOptionalUsed for standard pricing when the price matrix is not used
Basic Sale PriceOptionalUsed for sale pricing during specific sale dates
Basic Sale Start DateOptionalUsed to indicate when a sale starts
Basic Sale End DateOptionalUsed to indicate when a sale ends
Activate OnRecommendedDate the product is available to order
Deactivate OnOptionalDate the product is no longer available to order
Tax Code 1OptionalTypically used to indicate the product is tax exempt
Small ImageOptionalThe relative path to the small image, used in the search thumbnail
Medium ImageOptionalThe relative path to the medium image, used in list pages
Large ImageRecommendedThe relative path to the large image, used in detail pages
Note:Image Path URLs In most cases, the image path URLs should be relative and begin with "/userfiles/..."
Image Alt TextRecommendedAlternate text used for accessibility and search engine optimization
Track InventoryOptionalUsed to reflect if this product inventory is tracked; 1=true, 0=false
ERP ManagedRecommended1=true if product is managed via integration framework. 0=false if product is managed within Configured Commerce
Shipping WeightOptionalThis field reflects the shipping weight for real time freight calculations
Variant TypeOptionalThis 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.
Variant ParentOptionalThis field is used to point variant children to the Product Number of the parent
VariantTrait.XOptionalThis column will assign the variant trait x. If the trait x doesn't exist, it will be created. To assign multiple variant traits to the product, create additional columns in the import spreadsheet.
CategoriesOptionalThis 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
Attribute.xOptionalThis 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.
RelatedProduct.CrossSellOptionalThis represents a comma separated list of product numbers of related products that show in a carousel on the product detail widget
RelatedProduct.AccessoryOptionalThis represents a comma separated list of product numbers of related products. To render these related products, custom coding needs to be done.
Specification1.xOptionalThis column represents the first specification tab, where x notes the name of the tab.
Specification1.CurrentDefaultContentOptionalThis column represent the content that appears in the corresponding specification tab