Product Attributes Import

This article details the steps involved in importing product attributes. For information on the manual set-up of attributes, see Product Attributes (Style/Colour/Size).

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
       

   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. 
 

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

• Page:
  Settings and Functions Available in the PRONTO Order and Receipt Import Program
• Page:
  Import Users
• Page:
  Data Load Templates (end user)
• Page:
  Data Import and Export - Setting Up
• Page:
  Data Import and Export