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) - Classic sites.

This guide is aimed at administrators of classic CSS sites. For BPD websites, please see our Product Variants article for information on maintaining and importing product variant data in the CMS.


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

    Example Product Attribute Import file

  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.


Example Product Attribute SKU Details spreadsheet

Attribute Import - SKU Configuration - success message


© Copyright 2001-2023 Commerce Vision Pty Ltd. Use of this site signifies your acceptance of Commerce Vision’s Terms & Conditions. CV Connect, the Commerce Vision logos, and other Commerce Vision marks are assets of Commerce Vision Pty Ltd.