Content Comparison

This article details the steps involved in importing product attributes. For information on the manual set-up of attributes, see How To Set Up to set up Product Attributes.

Step-by-step guide

To Import Product Attributes:

1. Populate an Excel spreadsheet with Master codes and attribute data (no header row), as detailed below.
2. Enter data in a tab-delimited format in columns A-C as:
   1. ProductCode[tab] - Master product code from PRONTO
   2. HasAttributes[tab] - Y = Yes, N = No
   3. AttributeList - The list of attributes expressed as AttributeTitle(AttributeListType{D/R}):AttributeValue,AttributeValue;AttributeTitle(AttributeListType{D/R}):AttributeValue,AttributeValue
       

   Info
   title Attribute List Types
   D = Drop-down list R = Radio buttons

   

3. Save the file as 'Text (Tab delimited) (*.txt)'.
4. Login to Customer Self Service as an Administrator.
5. Navigate to 'Content' --> 'Product Attribute' (ProductAttributemaintenance.aspx)
6. Click the 'Attribute import' tab.
7. In the 'Product attributes' window, click the 'Choose File' button.
8. Browse to the saved .txt file.
9. Click 'Upload product attribute details'. A confirmation message will be displayed on screen after import.

...

Once the attributes have been imported, the product codes/SKUs for each available attribute combination need to be imported. 
 

Step-by-step guide

To Import Product Attribute Combination Codes:

1. Populate an Excel spreadsheet with Master codes and attribute combinations (no header row), as detailed below.
2. Enter data in a tab-delimited format in colums A-D as:
   1. ProductCode[tab] - Master product code from PRONTO
   2. AttributeTitleValueSeq[tab] - AttributeTitle:AttributeValue;AttributeTitle:AttributeValue
   3. AttributedProductCode[tab] - Final product code from PRONTO (this is what goes on the sales order and determines pricing and availability)
   4. CreateLineNote - Y/N - If no attributed product code has been set up, but the attribute combination is available, a 'Y' in this field will prompt the system to add the Master code to the sales order with a Line Note detailing attribute values.
3. Save the file as 'Text (Tab delimited) (*.txt)'.
4. Login to Customer Self Service as an Administrator.
5. Navigate to 'Content' --> 'Product Attribute' (ProductAttributemaintenance.aspx).
6. Click the 'Attribute import' tab.
7. In the 'Product attribute configuration / SKU' window, click the 'Choose File' button.
8. Browse to the saved .txt file.
9. Click 'Upload product attribute SKU details'. A confirmation message will be displayed on screen after import.

Related articles