Import Attribute Group
SmarterCommerce offers the option of importing content such as attribute groups using an excel spreadsheet template. This allows you to create or update many records at once, as an alternative to making one-by-one updates in Sitefinity/SmarterCommerce.
- Go to SmarterCommerce
- Click Attribute Groups 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.
Group Information
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Attribute Group UrlName | Internal unique key/ID for the Attribute Group (e.g., size_shoes) | Yes |
Must be lowercase, no spaces, no special characters except - ! ( ) @ ' _ Digits allowed. |
| Name | Attribute Group name for internal use (e.g., Mens’ Size, Color). This will not be the name displayed on the website | Yes | Cannot be more than 255 characters. |
| Language | The website translation that this Attribute Group will appear for. | Yes | Use standard HTML language codes. (e.g., EN = English; ES = Spanish) |
| Display Mode | Determine how the attribute group will appear in product filters on the Product Listing page. |
Do not apply | |
| Sequence | Determine the sequence (ordering) of the attribute group in the product filters. | Yes |
1 = 1st 2 = 2nd 3 = 3rd Etc. |
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 Group UrlName | Internal unique key/ID for the attribute group. Used to associate the Attribute Group (color) with each child Value (e.g., blue) and any applicable images. | Yes | |
| Code for Attribute Group Value | Name of the attribute group value (e.g., blue, green, S, M) within the Attribute Group. | Yes | Enter the Code for Attribute Group Value exactly as it appears in the SmarterCommerce Attribute Group Module in Sitefinity. |
| Image Title | Image that you want associated with this value in the attribute group. This image will appear in a color swatch representing this value in the product filters. | Yes |
The image you wish to associate must first be uploaded into Sitefinity before associating it to a value. In this field, Enter the exact image title as it appears in the Sitefinity image repository. Do not include the extension (e.g., .jpg, .png). Before uploading the completed excel, you’ll be asked to select which Library the image are saved in. |
| Language | The website translation that this 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 | Enter as plain text. |
Attribute Values
Optional - Use this sheet to define attributes associated with a given product.
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Attribute Group UrlName | Internal unique key/ID for the Attribute Group (e.g., size_shoes) | Yes |
Must be lowercase, no spaces, no special characters except - ! ( ) @ ' _ Digits allowed. |
| Code for Attribute Group Value | Name of the attribute group value (e.g., blue, green, S, M) within the Attribute Group. This value might be blue, and be used to group attribute values that are different shades of blue. | Yes | Enter the name of the value as you would like it to appear on your website (e.g., Blue, Green, Small, S, L). |
| Language | The website translation that this value will appear for. | Yes | Use standard HTML language codes. (e.g., EN = English; ES = Spanish) |
| Hexadecimal 1 | Color that you would like to appear in a color swatch to represent this attribute group value. | For color attributes only. |
Use HEX color codes (e.g., #FF0000) Available if Attribute Group’s Display Mode is set to Color |
| Hexadecimal 2 | Secondary color that you would like to appear to represent this attribute group value. 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 Group’s Display Mode is set to Color |
| Description for Attribute Group Value | Public-facing text for the attribute group 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. |
| Sequence | Determine the sequence (ordering) of the values within the attribute group. | Yes |
1 = 1st 2 = 2nd 3 = 3rd Etc. |