Page History

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

Step-by-step guide

To Import Product Attributes:

...

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