Import Configured Product Templates
SmarterCommerce offers the option of importing content such as configured product templates 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 Configured Product Templates 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.
Template Information
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Configured Product Template UrlName | Internal unique key/ID for the template for a configured product. | Yes |
Must be lowercase, no spaces, no special characters except - ! ( ) @ ' _ Digits allowed. |
| Name | Template name for internal use. This will not be the name displayed on the website. | Yes | No more than 30 characters |
| Template Mode | Define whether images will be associated with the Component Headers or Component Values on the website. | Yes |
Select from dropdown: 1 - ComponentHeader = associate images with each component header. Have 1 image for each component header. Images will not change as you select different component values. 2 - ComponentValue = associate images with each component value. Have 1 image for each component value. |
Template Products
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Configured Product Template UrlName | Internal unique key/ID for the template. Used to associate the template with a configurable product. | Yes | Enter the exact Configured Product Template UrlName, as it appears in the SmarterCommerce Attribute Template Module in Sitefinity, for the Attribute Template that you’ll be associating configurable products to. |
| Product Number | Long product number from your ERP of the configurable product that you would like to use this template. | Yes | Enter the product number from your ERP of the product that will use this the Configured Product Template. To relate multiple products to the template, add them in separate rows. |
Component Header Images
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Configured Product Template UrlName | Internal unique key/ID for the template. Used to associate desired images with specific component headers. | Yes | Enter the exact Configured Product Template UrlName, as it appears in the SmarterCommerce Configured Product Templates Module in Sitefinity. |
| Component Header Identifier | Each component header has a unique identifier in your ERP. In your ERP this is the Segment Number + UDC Code. | Yes | Enter the identifier for the component header you would like to add an image to. The identifier = Segment Number + UDC Code from your ERP, with no spaces. It is typically 6 characters. |
| Language | The website translation that this image will appear for. | Yes | Use standard HTML language codes. (e.g., EN = English; ES = Spanish) |
| Sequence | Determine the sequence (ordering) of this image in relation to the other images. | Yes |
1 = 1st 2 = 2nd 3 = 3rd Etc. |
| Image Title | Define the image that you want associated with the component header. This image will appear on the webpage when the user selects this Component. | Yes |
Enter the exact image title as it appears in the Sitefinity image repository. Do not include the extension (e.g., .jpg, .png). Reminder: The Image must first be uploaded into Sitefinity before associating it to a configured product. When associating multiple images in one import, all the images must be saved in the same Library. |
| Alternative Text | Alt Text; Short description of image, used for accessibility and SEO. | No | Enter as plain text. |
Component Value Images
| Name | Explanation | Required | Requirements |
|---|---|---|---|
| Configured Product Template UrlName | Internal unique key/ID for the template. Used to associate desired images with specific component values. | Yes | Enter the exact Configured Product Template UrlName, as it appears in the SmarterCommerce Configured Product Templates Module in Sitefinity |
| Component Header Identifier | Unique identifier of the component header in your ERP. It is the Segment Number + UDC Code from your ERP. | Yes | Enter the identifier for the component header that contains the component values you would like to associate images to. Component Header Identifier = Segment Number + UDC Code from your ERP, with no spaces. It is typically 6 characters. |
| Component Value Identifier | The UDC Value in your ERP. | Yes | |
| Language | The website translation that this image will appear for. | Yes | Use standard HTML language codes. (e.g., EN = English; ES = Spanish) |
| Sequence | Determine the sequence (ordering) of this image in relation to the other images. | Yes |
1 = 1st 2 = 2nd 3 = 3rd Etc. |
| Image Title | Define the image that you want associated with the component value. This image will appear on the webpage when the user selects/clicks on that specific value. | Yes |
Enter the exact image title as it appears in the Sitefinity image repository. Do not include the extension (e.g., .jpg, .png). Reminder: The Image must first be uploaded into Sitefinity before associating it to a configured product. When associating multiple images in one import, all the images must be saved in the same Library. |
| Alternative Text | Alt Text; Short description of image, used for accessibility and SEO. | No | Enter as plain text. |