Import Attribute(s)
SmarterCommerce offers the option importing content such as attributes using an excel spreadsheet template. This allows the user to create or update many attributes and/or attribute values at once, as an alternative to making one-by-one updates in the SmarterCommerce modules in Sitefinity.
- Go to SmarterCommerce
- Click Attributes in the Products Management section
- Click Import
- Download the import template. This is a pre-formatted template that includes all the relevant information that can be captured in Sitefinity/SmarterCommerce.
- Once the template is populated, click Select Files to find the document on your computer and upload to SmarterCommerce
- Confirm the upload is complete and check for errors.
- Go to SmarterCommerce > Task Manager. Once the Task Status of your file upload is “Done”. Click on that task.
- Click on the "…” which will open a series of options – click Download. Open the downloaded file.
- Check the last two columns Import Status and Import Message to identify and address any errors. Edit and re-upload the file as needed.
Attribute Information
Use this sheet to define your attributes (e.g., size, color)
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Attribute UrlName | Internal unique key/ID for the attribute. | Yes |
Must be lowercase, no spaces, no special characters except - ! ( ) @ ' _ Digits allowed. |
| Name | Attribute name for internal use. This will not be the name displayed on the website | Yes | Cannot be more than 100 characters |
| Language | The website translation that this attribute will appear for | Yes | Use standard HTML language codes. (e.g., EN = English; ES = Spanish) |
| Display as Content | Determines whether the attribute will appear in the Specifications section of the Product Content widget and Product Compare widget when associated with a product
|
No |
Y = show this attribute in the Specifications section of the Product Content and Product Compare widgets N = hide this attribute from the Product Content and Product Compare widgets |
| Display As Filter | Determines whether the attribute will display as a filter option on the Catalog and Product Search Results widgets | No |
Y = show this attribute in navigation filter in the Catalog widget N = hide this attribute in navigation filter in the Catalog widget |
| Enable Multi Select | If you chose to display as filter, this field determines whether the user will be able to select 1 or multiple attribute values for this attribute when filtering product results | No |
Y = allow the user to select multiple values for this attribute in the catalog navigation filter N = only allow the user to select 1 value for this attribute in the catalog navigation filter |
| Index Search Field | Name that will be given to this attribute for Elastic App Search analytics. Tip: Enter a name that will be easy for you to recognize in App Search Dashboard and distinguish from other attributes. Tip: Once this field is created, it cannot be deleted or edited from App Search. |
No |
Enter the attribute name that you would like to be used by AppSearch/Elastic. Use the following naming conventions: 1. Must be lower case. 2. Cannot contain more than 64 characters. 3. Use underscores for combining words 4. Value cannot be changed once the value has been set. 5. Name cannot have a leading underscore. |
| Display Name (Frontend) | Public facing attribute name that will display on the website (e.g., Size, Color) | Yes | Cannot be more than 100 characters |
| Sequence | Determine the sequence (ordering) of the attribute | Yes |
1 = 1st 2 = 2nd 3 = 3rd Etc. |
| Display Mode | Determine how the attribute will appear in the Product Content widget, Compare Products widget, filtering of Catalog widget, etc.
|
Yes |
Select from drop-down options: 0- Description = Attribute Value Description appears as plain text 1- Image = small image tile for each value 2- Code = Attribute Value Code appears as plain text, inside a square tile. Attribute Value Description will display as a tooltip. 3- Color = small color swatch for each tile |
| Additional Information | Public-facing message that appears when you hover over the question-mark icon next to the attribute (in the form of a tooltip). This is typically used to provide additional information about or define the attribute. Appears in the Product Content widget and Compare Products widget |
No | Enter as plain text or HTML |
| Mode | Type of attribute being added, edited, or extend: SmarterCommerce attribute or Matrix attribute | Yes |
Select from drop-down options: 1- SmarterCommerce = SmarterCommerce attribute. Select if you want to add attributes to a product that are not matrix attributes in your ERP. 2- Matrix = Matrix attributes from your ERP. Select if you want to extend a matrix attribute from your ERP (e.g., add a color swatch, add an image) |
| Matrix Template | Define the Template associated with the Matrix attribute in your ERP | For Matrix Attributes Only. | Enter the Template name found in your ERP |
| Style Segment | Define the Style associated with the Matrix attribute in your ERP | For Matrix Attributes Only. |
Enter the Style Number found in your ERP. You can also enter “*” for the style if the attribute will be used for all products that have the same template, no matter the style. |
| Segment Number | Define the Segment Number associated with the Matrix attribute in your ERP | For Matrix Attributes Only. | Enter the Segment Number found in your ERP |
| Display As Dropdown | Determine if the Matrix Attribute values will display as a drop-down on the Product Content widget | For Matrix Attributes Only, with Display Mode of Color, Code, or Image. Matrix attributes with Description Display Mode will display as a dropdown by default. |
Y = Display the attribute values in a dropdown menu N = Display all the attribute values as tiles (without dropdown) |
| Display As Color Swatch | Determine if the Matrix Attribute values will display as a color swatches in all widgets that display a list of products: Catalog, Search Results, Finder, Wish List, Recently Viewed, etc. Allows user to have a color swatch appear for the attribute on the product listing while using an image for the same attribute on the product detail page. |
For Matrix Attributes Only, with Display Mode set to Image |
Y = Display the attribute values as color swatches in the product listing N = Display the attribute values as images in the product listing |
Values
Use this sheet to define your attribute values (e.g., small, red)
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Attribute UrlName | Internal unique key/ID for the attribute. Used to associate the attribute value being created (e.g., sky blue) with its attribute (e.g., color) | Yes | Enter the exact Attribute UrlName for the Attribute that this new attribute value will be associated with |
| Attribute Value Code | Internal unique key/ID for the attribute value. |
Yes | For Matrix values, this value comes from your ERP. |
| Language | The website translation that this attribute value will appear for |
Yes | Use standard HTML language codes. (e.g., EN = English; ES = Spanish) |
| Sequence | Determine the sequence (ordering) of the attribute value | Yes |
1 = 1st in order 2 = 2nd in order 3 = 3rd in order Etc. |
| Hexadecimal1 | Color for the attribute value color swatch. | For color attributes only |
Use HEX color codes (e.g., #FF0000) Available if Attribute’s Display Mode is Color, or if Attribute’s Display Mode is Image and Display as Color Swatch is selected. |
| Hexadecimal2 | Secondary color for the attribute value color swatch. Entering a value in Hexadecimal1 and Hexadecimal2 will make the color swatch appear half color 1 and half color 2 |
For color attributes only. |
Use HEX color codes (e.g., #FF0000) Available if Attribute’s Display Mode is Color, or if Attribute’s Display Mode is Image and Display as Color Swatch is selected. |
| Code Override Value | If you plan to use the code as a public-facing value for the attribute, this field allows you the option of overriding the code to the text you would like to appear on the website. Example: Attribute Value Code = “SMA” but the user wants code to appear as “S” on the website, the user can define this here. |
No | Enter as plain text |
| Description | Public-facing text for the attribute value. You can choose to have this appear as the value’s primary text or as a tooltip. | Yes | Cannot be more than 60 characters |
| Attribute Group UrlName | Internal unique key/ID for the attribute group. Used to associate the attribute value being created (e.g., sky blue) with an attribute group (e.g., ROYGBIV Color) for filtering purposes. | No | Enter the exact Attribute Group UrlName for the Attribute Group that this new attribute value will be associated with |
| Code for Attribute Value | Value within the Attribute Group. Used to associate the attribute value being created (e.g., sky blue) with an attribute group (e.g., blue) for filtering purposes. | No | Enter the value within the Attribute Group that you want this Attribute Value associated with |
Value Images
Optional - use this sheet to associate images with your attribute values. This would apply for an attribute with the Image Display Mode.
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Attribute UrlName | Internal unique key/ID for the attribute. Used to associate the image with its attribute (e.g., color) | Yes | Enter the exact Attribute UrlName for the Attribute that this image will be associated with |
| Attribute Value Code | Internal unique key/ID for the attribute value. Used to associate the image with its attribute value (e.g., sky blue) | Yes | Enter the exact Attribute Value Code for the Attribute Value that this image will be associated with |
| Image Title | Image that you want associated with the attribute value. This image will appear in the color swatch square in the Catalog widget, Product Content widget, etc. | Yes |
The image(s) you wish to associate must first be uploaded into Sitefinity before associating it to an attribute value. To associate multiple images at once, make sure the images are all saved in the same Library. In this field, Enter the exact image title as it appears in Sitefinity. Before uploading the completed excel, you’ll be asked to select which Library the images are saved in. |
| Language | The website translation that this attribute value image will appear for | Yes | Use standard HTML language codes. (e.g., EN = English; ES = Spanish) |
| Alternative Text | Alt Text; Short description of image, used for accessibility and SEO | No |